C# DataGridView使用SqlDataAdapter.Update删除和修改数据库

首先在DataGridView添加选择框（类型为DataGridViewCheckBoxColumn）。确保数据表设置主键。

//数据库操作变量
DataSet dstSql = new DataSet();
SqlDataAdapter dadstrSql= new SqlDataAdapter();
//数据库加载函数
private void DisplayData ()
{
    string strSql = "select * from info order by time desc";
    dadstrSql= new SqlDataAdapter(strSql, conConnect);
    dstSql.Clear();
    dadstrSql.Fill(dstSql, "info ");
    Dgv.DataSource = dstSql.Tables["info "];
 }
//窗体加载
private void frmData_Load(object sender, EventArgs e)
{
DisplayData ();//数据库加载
}

//删除事件
        private void btnDelete_Click(object sender, EventArgs e)
        {
            int i = 0;
            foreach (DataGridViewRow row in Dgv.Rows)
            {
                if (row.Cells["选择"]