DataGridViewCheckBoxColumn获得选中状态

[biao1]

WinForm中DataGridViewCheckBoxColumn这个列，我是通过他的选中然后点button来删除一个列的，这个代码怎么写呢？ 大家说说思路
我在网上找的，代码 不过不行
private void button2_Click(object sender, EventArgs e)
{

for (int i = 0; i < dataGridView1.RowCount; i++)
{
string re_value = dataGridView1.Rows[i].Cells[0].EditedFormattedValue.ToString();

if (re_value == "True")//判断勾选的
{

string strConnection = "Provider=Microsoft.Jet.OleDb.4.0;";
strConnection += "Data Source=";
strConnection += Application.StartupPath + (@"\CMT.mdb");
OleDbConnection conn = new OleDbConnection(strConnection);
conn.Open();

OleDbCommand cmd = new OleDbCommand("delete from foa_Personnel where.....", conn);


cmd.ExecuteNonQuery();
MessageBox.Show("成功！");

}
else
{
continue;
}
}

}
sql语句的where条件怎么写？

[QuinsonYue]

这样把 先update 再delete ..........where colume = true;

[QuinsonYue]

where colume =1;

[biao1]

大家有没有更详细的办法？

[biao1]

还没解决 继续!

[zheng616]

还没解决呀,晕.

[biao1]

是啊 从昨天到现在 但愿不是在将来 呵呵

[hgs5945]

你要获取被选中行的主键，然后再根据主键删除数据库的行。
下面的例子的数据库主键为t_id;



private void button2_Click(object sender, EventArgs e)
{

for (int i = 0; i < dataGridView1.RowCount; i++)
{
string re_value = dataGridView1.Rows[i].Cells[0].EditedFormattedValue.ToString();

if (re_value == "True")//判断勾选的
{
string id==dataGridView1.Rows[i].Cells["t_id"].Value.ToString().Trim();
string strConnection = "Provider=Microsoft.Jet.OleDb.4.0;";
strConnection += "Data Source=";
strConnection += Application.StartupPath + (@"\CMT.mdb");
OleDbConnection conn = new OleDbConnection(strConnection);
conn.Open();

OleDbCommand cmd = new OleDbCommand("delete from foa_Personnel where [t_id]='" + id + "'", conn);


cmd.ExecuteNonQuery();
MessageBox.Show("成功！");

}

}

}

[lypbingyue]

up