The fifth day of the 10 day society asp.net

ASP.net learning Purpose: Learn to connect two kinds of databases

For ASPs, the database we use is nothing more than access and SQL Server, but for ASP.net, ASP.net has a special connection component for SQL Server and does not recommend Ole DB.

First look at Access's connection database and open it;

String strconnection= "Provider=Microsoft.Jet.OLEDB.4.0;Data source=";
Strconnection+=server.mappath ("*.mdb"); * is the name of the database
OleDbConnection objconnection=new OleDbConnection (strconnection);
Objconnection.open ();



--------------------------------------------------------------------------------

Dim objconnection As OleDbConnection
Objconnection=new OleDbConnection ("Provider=Microsoft.Jet.OLEDB.4.0;Data source=" +Server.MapPath ("*.mdb"))
Objconnection.open ()

Next look at the SQL Server connection database and open;

String strconnection= "server= database connection; uid= user name; pwd= password; database= database name";
Sqlconnediob objconnection=new SqlConnection (strconnection);
Objconnection.open ();



--------------------------------------------------------------------------------

Dim objconnection As Sqlconnectiom
Objconnection=new SqlConnection ("server= database connection; uid= username; pwd= password; database= database name")
Objconnection.open ()

In fact, in most places, the difference between SQL Server and access is the difference between SQLXX and oledbxx except for the connection statement.

Also, if you are an Access database, you need to include the following statements at the beginning of the ASPX file:
<% @Import namespace= "System.Data"%>
<% @Import namespace= "System.Data.OleDb"%>
If you are SQL Server, you need to include the following statement:
<% @Import namespace= "System.Data"%>
<% @Import namespace= "System.Data.SqlClient"%>

That's it for today. Read about the database tomorrow.