在gridControl中删除一条数据库记录(C#版)

如下两句代码就是解决问题的关键：

string dwmc = myDataRow.ItemArray[1].ToString();
string dwCode = myDataRow.ItemArray[2].ToString();

取得这两个值以后，可以根据这两个值来删除数据库中的该条记录。

 

下面是完整的模块代码，选中一行，单击删除按钮，就可以实现删除一行。

 

private void barButtonItem4_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
        {
            DataRow myDataRow = gridView1.GetDataRow(gridView1.FocusedRowHandle);           

            string dwmc = myDataRow.ItemArray[1].ToString();
            string dwCode = myDataRow.ItemArray[2].ToString();

            //Console.WriteLine("地物名称：" + dwmc);
            //Console.WriteLine("地物代码：" + dwCode);

            string sqlDel = "delete from sunz_dwdm where dw_mc='" + dwmc + "' and dw_code='" + dwCode + "'";

            try
            {
                DBConn.Open();

                comm = new MySQLCommand("set names gbk", DBConn);
                comm.ExecuteNonQuery();

                DBComm = new MySQLCommand(sqlDel, DBConn);
                int i = DBComm.ExecuteNonQuery();
                Console.WriteLine("您刚才删除了" + i + "条记录！");
            }
            catch (Exception ee)
            {
                Console.WriteLine("删除数据时出错！" + ee);
            }
            finally {
                DBConn.Close();
            }
            myDataRow.Delete();
        }