最近手工添加N条记录到Dataset后,需要从Dataset删除某条数据
private void dataGridView2_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex != -1)
{
string discno = dataGridView2.Rows[e.RowIndex].Cells["DiscNo"].Value.ToString().Trim();
//注:datasetlist已经添加有表,有疑问请到前一篇随笔
foreach (DataRow myrow in datasetlist.Tables[0].Rows)
{
if (myrow[0].ToString().ToUpper().Trim() == discno.ToUpper().Trim())
{
myrow.Delete();
goto Labeld;
}
}
Labeld:
//重新绑定数据
DataView dv = datasetlist.Tables[0].DefaultView;
dataGridView2.DataSource = dv;
IntDataGridView2(); //初始化datagridview
}
}