private void btndelete_Click(object sender, EventArgs e)
{
//SQL中删除语句
string sqldelete = "Delete from PsInfo where Id= @Id";
//初始化deletecommand
sqlda.DeleteCommand = new SqlCommand(sqldelete, con);
//声明参数并制定数据库的列和版本
p = sqlda.DeleteCommand.Parameters.Add("@Id", SqlDbType.VarChar);
p.SourceColumn = "Id";
p.SourceVersion = DataRowVersion.Original;
//初始化DialogResult
dr = MessageBox.Show("您确定要删除当前记录吗?", "确定", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
//如果给出肯定的相应,则删除
if (dr == DialogResult.Yes)
{
try
{
//确定选定的行
ds.Tables[0].Rows[dataGridView1.CurrentRow.Index].Delete();
SqlCommandBuilder Builder = new SqlCommandBuilder(sqlda);
sqlda.Update(ds, "PsInfo");
MessageBox.Show("删除成功");
}
catch (SqlException ex)
{
//显示错误信息
MessageBox.Show(ex.Message);
}
}
else
{
return;
}
}
{
//SQL中删除语句
string sqldelete = "Delete from PsInfo where Id= @Id";
//初始化deletecommand
sqlda.DeleteCommand = new SqlCommand(sqldelete, con);
//声明参数并制定数据库的列和版本
p = sqlda.DeleteCommand.Parameters.Add("@Id", SqlDbType.VarChar);
p.SourceColumn = "Id";
p.SourceVersion = DataRowVersion.Original;
//初始化DialogResult
dr = MessageBox.Show("您确定要删除当前记录吗?", "确定", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
//如果给出肯定的相应,则删除
if (dr == DialogResult.Yes)
{
try
{
//确定选定的行
ds.Tables[0].Rows[dataGridView1.CurrentRow.Index].Delete();
SqlCommandBuilder Builder = new SqlCommandBuilder(sqlda);
sqlda.Update(ds, "PsInfo");
MessageBox.Show("删除成功");
}
catch (SqlException ex)
{
//显示错误信息
MessageBox.Show(ex.Message);
}
}
else
{
return;
}
}
SqlCommandBuilder Builder = new SqlCommandBuilder(sqlda);
Builder声明了没用吧?
p也没看出来是什么做什么用的。。
增删改没这么玩过。。这里用的方法不熟悉。。