110,561
社区成员
发帖
与我相关
我的任务
分享
private void btn_ok_Click(object sender, EventArgs e)
{
for (int i = 0; i < dgv.Rows.Count; i++)
{
try
{
if (dgv.Rows[i].Cells[0].Value.ToString() == "" ||
dgv.Rows[i].Cells[1].Value.ToString() == "" ||
dgv.Rows[i].Cells[2].Value.ToString() == "" ||
dgv.Rows[i].Cells[3].Value.ToString() == "")
{
MessageBox.Show("请补全第" + i + 1 + "行信息");
break;
}
}
catch (Exception ee)
{
}
GlobleVariable.command = new MySqlCommand("insert into 菜单 values('" +
dgv.Rows[i].Cells[0].Value.ToString() + "', '" +
dgv.Rows[i].Cells[1].Value.ToString() + "', " +
Double.Parse(dgv.Rows[i].Cells[2].Value.ToString()) + ", '" +
dgv.Rows[i].Cells[3].Value.ToString() + "')",GlobleVariable.mycon);
if (dgv.Rows[i].Cells[2].Value.ToString() == "")
dgv.Rows[i].Cells[2].Value = "0";
GlobleVariable.command.ExecuteNonQuery();
}
}