在DataGridView里实现删除操作

private DataSet ds = new DataSet();

private SqlConnection con = null;
private SqlDataAdapter da = null;

private const string sql_select = "select * from T_at";

 

 

 private void btnDelete_Click(object sender, EventArgs e)
        {//删除
            if (this.DataDelete())
            {
                MessageBox.Show("删除成功");
            }
            else
            {
                MessageBox.Show("删除失败");
            }
        }

        private bool DataDelete()
        {
            SqlParameter sp = new SqlParameter();
            da.DeleteCommand = con.CreateCommand();
            da.DeleteCommand.CommandText = "delete  from T_at where id=@id";
            //id =Convert.ToInt32(this.dataGridView1.SelectedCells[0].Value);
            sp = da.DeleteCommand.Parameters.Add("@id",SqlDbType.Int,4,"id");
            sp.SourceVersion = DataRowVersion.Original;
            ds.Tables["table"].Rows[this.dataGridView1.CurrentRow.Index].Delete();
            int count = da.Update(ds);
            bool result = count > 0 ? true : false;
            return result;
        }