I would like help with aspnet database connection

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
 
A

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.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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,744
Messages
2,569,484
Members
44,903
Latest member
orderPeak8CBDGummies

Latest Threads

Top