I would like help with aspnet database connection

  • Thread starter Thread starter gabby tary
  • Start date Start date
G

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
 
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.com/ado_net_performance.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
 
Back
Top