Question

C#用datagridview怎么删除sql中的记录?

{
SqlConnection conn = ConnectionFactory.getconnection();

SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "insert into GoodsTbl(商品名,商品编号) values(@商品名, @商品编号)";
cmd.Parameters.Add("@商品名", SqlDbType.VarChar, 10);
cmd.Parameters.Add("@商品编号", SqlDbType.VarChar, 10);
cmd.Parameters["@商品名"].Value = goodsTbx.Text;
cmd.Parameters["@商品编号"].Value = goodsnumTbx.Text;
cmd.ExecuteNonQuery();
cmd.Dispose();
this.readData();

}
public void readData()
{
SqlConnection conn = ConnectionFactory.getconnection();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "select * from GoodsTbl";
SqlDataReader dr = cmd.ExecuteReader();

while (dr.Read())
{

dataGridView1.Rows.Add();
dataGridView1.Rows[dataGridView1.Rows.Count - 2].Cells[0].Value = dr["商品编号"].ToString();
dataGridView1.Rows[dataGridView1.Rows.Count - 2].Cells[1].Value = dr["商品名"].ToString();

}
dr.Close();
dr.Dispose();
cmd.Dispose();
}
这是添加代码?怎么删除啊?求救高人.要代码的.谢谢!

Answer 1

行删除时
((DataTable) dataGridView1.DataSource).Rows[行号].Delete();

更新时把((DataTable)DataGridView.DataSource)作为DataTable去更新数据库就行。如下：
SqlConnection conn = ConnectionFactory.getconnection();
SqlDataAdapter dataAdapter = new SqlDataAdapter("select * from GoodsTbl", conn);
dataAdapter.Update((DataTable)dataGridView1.DataSource);

Answer 2

SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "delete GoodsTbl where id = @商品编号";
cmd.Parameters.Add("@商品编号", SqlDbType.VarChar, 10);
cmd.Parameters["@商品编号"].Value = goodsnumTbx.Text;
cmd.ExecuteNonQuery();
cmd.Dispose();

Answer 3

方法很多啊。。。