string connectionstring = "Data Source=CE5BC36663C4490\\SQLEXPRESS;Initial Catalog=sql;Integrated Security=True"; SqlConnection conn = new SqlConnection(connectionstring); string str = "select * from dept"; //SqlCommand cmd = new SqlCommand(str,conn ); SqlDataAdapter da = new SqlDataAdapter(); da.TableMappings.Add("Table","dept"); da.SelectCommand = new SqlCommand(str, conn); DataTable dt = new DataTable ("dept"); da.Fill(dt ); dt.AcceptChanges(); dt.Rows [1].Delete (); //dt.RejectChanges(); //da.Update(dt); dt.AcceptChanges(); GridView1.DataSource = dt; GridView1.DataBind();這樣做 只是內(nèi)存 刪除,數(shù)據(jù)庫中的數(shù)據(jù)仍然存在!如何給數(shù)據(jù)庫發(fā)請(qǐng)求刪除第一行呢
- 2 回答
- 0 關(guān)注
- 524 瀏覽
添加回答
舉報(bào)
0/150
提交
取消