ASP. NET notes--Connect to database

Asp. NET connection Database

Connect to access:

OleDbConnection conn = new OleDbConnection ();
Conn. ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data source= file path";

Connect to SQL Server

SqlConnection conn1 = new SqlConnection ();
Conn1. ConnectionString = "Data source= server name; uid= user name; pwd= password; database= database name; integrated security=true";

Conn. Open ();//Open connection
Conn. Close ();//Closed connection

manipulating databases

OleDbCommand comm = new OleDbCommand ();
Comm.commandtext = "Database operation is the life of the present";
Comm. Connection = conn;
Comm. ExecuteNonQuery ();

ASP. NET notes--Connect to database