在线请教各位大侠,datagridview数据无法更新!
我程序中有个datagridview控件,现在的问题是,如果我更新的是日期(就是下面代码中的rtime字段),则更新失败,无法对日期进行修改,请问各位大侠要怎么解决呢?谢谢!
private void dataGridView1_CellEndEdit(object sender, DataGridViewCellEventArgs e)
{
DataRowView drv = this.dataGridView1.CurrentRow.DataBoundItem as DataRowView;
string sqlupdate = "update record set PName='" + drv["PName"].ToString()
+ "',rtime='" + drv["rtime"].ToString()
+ "',area='" + drv["area"].ToString()
+ "',banci='" + drv["banci"].ToString()
+ "' where PName='" + drv["PName"].ToString()
+ "' and rtime='" + drv["rtime"].ToString()
+ " ' ";
try
{
int i = cmd.ExecuteNonQuery();
if (i > 0)
{
MessageBox.Show("更新成功!");
this.dataGridView1.Refresh();
}
else
{
MessageBox.Show("更新失败!");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
login.conn.Close();
}
}