Ado. NET Data access Technology

1. SqlConnection Object Connection Database

Write the following code in the node of the Web.config configuration file:







2. Execute database command using SqlCommand object: Add, update, delete, query

(1) Create command object

String strcnn=configurationmanager.connectionstrings["Studentcnnstring"]. ConnectionString;

SqlConnection cnn=new SqlConnection (STRCNN);//instantiation

Sqlcommand cmd=new Sqlcommand ();//Create Command object

(2) Set the data connection properties of the Command object

Cmd. CONNECTION=CNN;

(3) Assigning the SQL statement to the Command object

cmd.commandtext= "SQL statement";

(4) Open connection, execute SQL command

Cnn. Open ();

Cmd. ExecuteNonQuery ()//Execute SQL command

This article links http://www.cxybl.com/html/wlbc/Asp/20120613/29909.html