winform DataGridView双击修改单元格的值

最新推荐文章于 2024-05-08 16:17:53 发布

Jia_ShengJie

最新推荐文章于 2024-05-08 16:17:53 发布

阅读量6.8k

点赞数

分类专栏： DataGridView 文章标签： winform 修改单元格的值

本文链接：https://blog.csdn.net/u013816709/article/details/38374031

版权

DataGridView 专栏收录该内容

6 篇文章 0 订阅

订阅专栏

定义全局变量

string abcmycode = "";//当前行自编号

bool tf = false;//是否双击

//双击可编辑
private void dgvOutClassVerify_CellDoubleClick(object sender, DataGridViewCellEventArgs e) {
if (dgvOutClassVerify.Rows.Count > 0) {
abcmycode = dgvOutClassVerify.CurrentRow.Cells["MainTop_Mycode"].Value.ToString();
dgvOutClassVerify.CurrentRow.Cells["MainTop_Mycode"].ReadOnly = false;
tf = true;
}
}

private void dgvOutClassVerify_CellValidated(object sender, DataGridViewCellEventArgs e) {
try {
if (tf == true) {
tf = false;
if (dgvOutClassVerify.Rows.Count > 0) {
int abcid = Convert.ToInt32(dgvOutClassVerify.CurrentRow.Cells["MainTop_ID"].Value.ToString());
string mycodes = dgvOutClassVerify.CurrentRow.Cells["MainTop_Mycode"].Value.ToString();
if (abcmycode != mycodes) {
if (mycodes.Equals("")) {
PublicClass.ShowMessage("自编号不能为空！");
dgvOutClassVerify.CurrentRow.Cells["MainTop_Mycode"].Value = abcmycode;
return;
}
//验证语句

//----------------------------
//更新语句
string cbasql = "update T_OutIn_MainTop set MainTop_MyCode='" + mycodes + "' where MainTop_ID= " + abcid;
int nn = DataAccess.ExecuteNonQuery(cbasql, false, null);
if (nn > 0) {
dgvOutClassVerify.CurrentRow.Cells["MainTop_MyCode"].ReadOnly = true;
PublicClass.ShowMessage("自编号修改成功！");
return;
}
}
}
}
} catch (Exception ex) {
PublicClass.ShowMessage(ex.Message);
return;
}
}