最近手工添加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

            }
        }

posted on 2008-12-11 08:42  Shannon  阅读(787)  评论(0编辑  收藏  举报