在datagridview中要选中一行数据修改或删除或添加的代码怎么写! datagridview.Remove(object);datagridview.RemoveAt(索引);datagridview.Add(); 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 private void toolStripButton3_Click(object sender, EventArgs e) { try { if (dataGridView1.Focus()) { if (MessageBox.Show("确定删除吗?", "提示", MessageBoxButtons.OKCancel) == DialogResult.OK) { int i = dataGridView1.CurrentCell.RowIndex; string uname = dataGridView1.Rows[i].Cells[0].Value.ToString(); string upnumber = dataGridView1.Rows[i].Cells[1].Value.ToString(); SqlConnection con = new SqlConnection(conString); con.Open(); string sql = "delete from suser where uname= '" + uname + "' and upnumber='" + upnumber + "'"; SqlCommand cmd = new SqlCommand(sql, con); cmd.ExecuteNonQuery(); string sql1 = "select uname,upnumber from suser"; DataSet ds = new DataSet(); SqlDataAdapter mydadapter = new SqlDataAdapter(sql1, con); mydadapter.Fill(ds, "list"); this.dataGridView1.DataSource = ds.Tables["list"]; con.Close(); } } else { MessageBox.Show("请选择数据"); } } catch { MessageBox.Show("请选择数据"); } } winfrom 如何实现vs2010伸缩框架结构 dataGridView导出数据到Execl 我用C#做了个登录界面,怎样把它和sql数据库连接起来? C#怎么创建虚拟串口 作业要交了, 急呀 如何获得程序运行所需要的时间 DataTable.Select查不出数据 各位進來看看! c# 中repeater分页问题 请推荐一本C#好书 优先级 怎么用鼠标键盘修改GRIDVIEW里选中行的值??
{
try
{
if (dataGridView1.Focus())
{
if (MessageBox.Show("确定删除吗?", "提示", MessageBoxButtons.OKCancel) == DialogResult.OK)
{
int i = dataGridView1.CurrentCell.RowIndex;
string uname = dataGridView1.Rows[i].Cells[0].Value.ToString();
string upnumber = dataGridView1.Rows[i].Cells[1].Value.ToString();
SqlConnection con = new SqlConnection(conString);
con.Open();
string sql = "delete from suser where uname= '" + uname + "' and upnumber='" + upnumber + "'";
SqlCommand cmd = new SqlCommand(sql, con);
cmd.ExecuteNonQuery();
string sql1 = "select uname,upnumber from suser";
DataSet ds = new DataSet();
SqlDataAdapter mydadapter = new SqlDataAdapter(sql1, con);
mydadapter.Fill(ds, "list"); this.dataGridView1.DataSource = ds.Tables["list"]; con.Close();
}
}
else
{
MessageBox.Show("请选择数据");
}
}
catch { MessageBox.Show("请选择数据"); }
}