I would like help with aspnet database connection

[gabby tary]

Hi- I am learning ASP.NET and I would like to know the best way to
connect to a database and also what would be the best database.
I am comfortable with ASP.NET and creating a database I just don't
know how to connect the two. Thank you. Gabby

[ajaymehra]

Hi,
The best database that I have come across so far seems to be SQ
Server.
heres link you can check out
http://www.sql-server-performance.co...erformance.asp

To connect from ASP.NET to SQL - you can either use a connectio
string.

[in your page load]
dim cnn as sqlconnection = new sqlconnection("server=[servername]
initial catalog=[databasename]; uid=sa; password=pwd)
cnn.open

OR

From the server explorer - you can drag and drop a connectio
object - then set its properties in the properties window

ajaymehr
-----------------------------------------------------------------------
Posted via http://www.mcse.m
-----------------------------------------------------------------------
View this thread: http://www.mcse.ms/message361877.htm