I am very new to ASP.NET (and html and all that goes with it), as well as SQL.
I would like to be able to use the currently logged in user as key for multiple tables, but in order to do that I need to access the ASPNETDB. (It is quite handy to use the logged in user as key for various purposes, right? I mean, it is a good way of handling things?) I have trouble figuring out how to set it all up correctly thought. I have been searching the web, and lately these forums, for answers, but so far, no luck.
I am using Visual Studio 2010 Professional and Microsoft SQL Server 2008. No IIS installed (as far as I know); the ASP.NET Development Server seems to be used.
I have an ASPNETDB.MDF in both "Data Connections" in the Server Explorer, as well as in the "App_Data" folder in the Solution Explorer. I have attached this database in SQL Server Management Studio.
In Visual Studio, when I click Tools->Connect to database and enter the server name, I get a list of the databases I have attached in Server Management Studio. If I select ASPNETDB there and press "Test Connection" I get a "Test connection succeeded.". I guess that means I can access it. Now, how do I go about configuring all this in the web.config?
Should I use the full path (I:\Programming\Projects\ASP.NET\Website6\App_Data\ASPNETDB"), or s
View Complete Post