Ten days to learn ASP.net (5)

Day 5

Objective: To connect to two databases

For ASP, the common databases are ACCESS and SQL server, and ASP. NET. However, ASP. NET has dedicated connection components for SQL SERVER, and OLE DB is not recommended.

First, let's take a look at the ACCESS database connection and open it;

String strConnection = "Provider = Microsoft. Jet. OleDb.4.0; Data Source = ";
StrConnection + = Server. MapPath ("*. mdb"); // * indicates the database name.
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, let's take a look at how SQL SERVER connects to and opens the database;

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 cases, the difference between SQL server and ACCESS is not only the connection statement, but also the difference between other definition statements, namely SQL ×× and OLEDB ××.

In addition, if it is an ACCESS database, the following statements must be included at the beginning of the ASPX file:
<% @ Import Namespace = "System. Data" %>
<% @ Import Namespace = "System. Data. OleDb" %>
For SQL SERVER, the following statements are required:
<% @ Import Namespace = "System. Data" %>
<% @ Import Namespace = "System. Data. SqlClient" %>

Let's talk about database reading tomorrow.