Two different ways of Ado:sqldataadapter, and two different ways of SqlCommand

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