Thread: Asp.net code for database connection

Hi. I am new in development world. I want to connect my database in asp.net with SQL server 2005 or ms access 2007? Please anybody solve my query. If you are having any codes then reply me. It can helpful to me. Thanks in advanced.

Try out the following code which is helpful for you.

Code:

<%@ Import Namespace="System.Data.OleDb" %>
sub Page_Load
dim dbconn,sql,dbcomm
dbconn=New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;
data source=" & server.mappath("northwind.mdb"))
dbconn.Open()
sql="SELECT * FROM customers"
dbcomm=New OleDbCommand(sql,dbconn)
end sub

The following example instantiates and SqlConnection, sets some of its parameters in the connection string, and opens the connection.

Code:

SqlConnection myConn = new SqlConnection ( );
myConn.ConnectionString = "user id=sa; password=admin;" +
   "data source=myServer; initial catalog=northwind;"
myConn.Open ( );