Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Database Design and Application Architecture
 Database Designing & Planning

Author  Topic 

Widz
Starting Member

11 Posts

Posted - 2009-10-15 : 08:22:23
I am trying to build a central SQL Database I am using (MS SQL management studio Express) and would like it to be accessed remotely using web browser (Client / Server relation things) so that users can access as long as they are online. Users will have to log in using their username and passwords will be authenticated and they will be granted or prohibited access to other secure sections. What I mean here is that they will be different access levels. (in this case 3)

When they logon there will be a menu that will be displayed and some of the options on the menu will be just to view data and some of them will be to create and populate some fields one of them will be using the auto increment. My Question is will I have to write this in SQL or that has to be done in Dot.Net and the SQL Database will be just sitting

I m trying to put up a project plan

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2009-10-15 : 08:55:11
All user interaction (the website) should be created using .net/php/html/css/javascript/flash/whatever, you data should be saved in a database. The interaction between the the website and the database can be done in several ways and the discussion on which option is the best is a huuuuge can of worms. I guess the people here will prefer the database-way using stored procedures, while application developers like our ol'friend Whitefang will prefer using .net.

- Lumbago
http://xkcd.com/327/
Go to Top of Page
   

- Advertisement -