 |  |  |  |  |  |  |  |
logic of building a system where laods of people might be on at the same time.
Please support our C# advertiser: Intel Parallel Studio Home
Thread Solved |
Hello,
I'm building a web application which has Users and these Users have permission to access certain bits of the web app.
After a user logs on, according to it's permissions which will be read from permissions table, he will see the bits of the app that he can access.
But to prevent hacking and so on, I need to check if the user has access to that page whenever a page is called on the web server.
If someone goes to for example "a.aspx", I will check from the permissions table if that person has access or not.
But this means there will be a query to PErmissions table each time a page is called.
Will it cause a problem regarding the web app? Will it give errors if more than one query is made at the same time to permissions table?
What is the best way of achieving this goal?
Thank you.
I'm building a web application which has Users and these Users have permission to access certain bits of the web app.
After a user logs on, according to it's permissions which will be read from permissions table, he will see the bits of the app that he can access.
But to prevent hacking and so on, I need to check if the user has access to that page whenever a page is called on the web server.
If someone goes to for example "a.aspx", I will check from the permissions table if that person has access or not.
But this means there will be a query to PErmissions table each time a page is called.
Will it cause a problem regarding the web app? Will it give errors if more than one query is made at the same time to permissions table?
What is the best way of achieving this goal?
Thank you.
•
•
Join Date: Jun 2005
Posts: 2,044
Reputation: 
Solved Threads: 139
Re: logic of building a system where laods of people might be on at the same time.
0
#2 Jan 8th, 2009
If you have a bunch of processes or threads reading from a table without modifying the table, in a way that affects the others' results, you won't have any problems.
Re: logic of building a system where laods of people might be on at the same time.
0
#3 Jan 8th, 2009
Thank you for your fast and clear reply!
I got one more question regarding the issue;
What happens If both users try to change the datas of different rows in the same table at the same time?
Or, what happens if two people try to add new data to the same table at the same time?
Thank you!
I got one more question regarding the issue;
What happens If both users try to change the datas of different rows in the same table at the same time?
Or, what happens if two people try to add new data to the same table at the same time?
Thank you!
•
•
•
•
Originally Posted by Rashakil Fol 
If you have a bunch of processes or threads reading from a table without modifying the table, in a way that affects the others' results, you won't have any problems.
•
•
Join Date: Jun 2005
Posts: 2,044
Reputation:
Solved Threads: 139
Re: logic of building a system where laods of people might be on at the same time.
0
#4 Jan 9th, 2009
Your database API should have support for transactions; if you put your set of database actions in a transaction, it will see a consistent view of the database -- it will never put the database in some unpredictable state. You should want your transactions to be as short in time duration as possible.
Re: logic of building a system where laods of people might be on at the same time.
0
#5 Jan 9th, 2009
Well I'm using .NET and C# and working with an MsSQL 2008 database. Is it OK?
And can you explain where can I make use of DataSet thing of ASP.NET? I don't really understand it.
Thank you!
And can you explain where can I make use of DataSet thing of ASP.NET? I don't really understand it.
Thank you!
•
•
•
•
Originally Posted by Rashakil Fol
Your database API should have support for transactions; if you put your set of database actions in a transaction, it will see a consistent view of the database -- it will never put the database in some unpredictable state. You should want your transactions to be as short in time duration as possible.
Re: logic of building a system where laods of people might be on at the same time.
0
#6 Jan 9th, 2009
You might want to head over to the ASP.NET forum for your questions about ASP.NET
Did I just hear "You gotta help us, Doc. We've tried nothin' and we're all out of ideas" ? Is this you? Dont let this be you! I will put in as much effort as you seem to.
 |
Other Threads in the C# Forum
- Previous Thread: Drawing line in pictureBox
- Next Thread: C#, kbhit & getch
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest C# Posts
- Today's Posts
- Unanswered Threads
.net access algorithm array barchart bitmap box broadcast buttons c# check checkbox client combobox control conversion csharp custom cyclethruopenforms data database datagrid datagridview dataset date/time datetime degrees development draganddrop drawing encryption enum event excel file finalyearproject form format forms function gdi+ getoutlookcontactusinfcsvfile globalization httpwebrequest image index input install installer java label list listbox mandelbrot math mono mouseclick mysql operator panel path photoshop picturebox pixelinversion post programming radians regex remote remoting richtextbox save server silverlight sleep socket sql sql-server statistics stream string table text textbox thread time timer timespan update upload usercontrol users validate validation visualstudio webbrowser windows winforms wpf xml
