The original Published time: 2008-08-01--from my Baidu article [imported by moving tools]
SqlDataAdapter: (It is automatically turned on and turned off automatically, so you can turn off the connection without showing it)
SqlConnection conn = new SqlConnection (configurationmanager.connectionstrings["Pusconn"]. ConnectionString);
SqlDataAdapter SDA = new SqlDataAdapter ("select * FROM authors", conn);//First notation
SqlDataAdapter SDA = new SqlDataAdapter ();//second notation
Sda. SelectCommand = new SqlCommand ("SELECT * FROM authors", Conn);
DataSet ds = new DataSet ();
Sda. Fill (ds, "T1");
----------------------------
SqlCommand:
SqlConnection conn = new SqlConnection (configurationmanager.connectionstrings["Pusconn"]. ConnectionString);
SqlCommand cmd=new SqlCommand ("delete from authors where au_id=2", conn);//The first method
SqlCommand cmd=new SqlCommand ();//The second method
Cmd.commandtext = "Delete from authors where au_id=2";
Cmd. Connection = conn;
Conn. Open ();
Cmd. ExecuteNonQuery ();
Conn. Close ();
Two different ways of Ado:sqldataadapter, and two different ways of SqlCommand