110,538
社区成员
发帖
与我相关
我的任务
分享
string pid=dataGridView1.SelectedRows[0].Cells[0].Value.ToString();
string pname = dataGridView1.SelectedRows[0].Cells[1].Value.ToString();
string pprice = dataGridView1.SelectedRows[0].Cells[2].Value.ToString();
string pnote = dataGridView1.SelectedRows[0].Cells[3].Value.ToString();
DateTime ptime = DateTime.Parse(dataGridView1.SelectedRows[0].Cells[5].Value.ToString());
mc.GetCon();
string sql = "UPDATE user_product SET product_name = '"+pname+"', product_price = "+pprice+", product_note = '"+pnote+"', ptype_time = "+ptime+" WHERE (product_id = "+pid+")";
int n = mc.execNoQuery(sql);
if (n > 0)
{
MessageBox.Show("修改成功!");
}
else
{
MessageBox.Show("修改失败!");
}
UPDATE user_product
SET ptype_time = 2011-01-04
WHERE (product_id = 1)
可以正常修改,但是修改过后在SQL2005的数据却是1905/6/30 0:00:00
UPDATE user_product
SET ptype_time = CONVERT(DATETIME, '2011-01-01 00:00:00', 102)
WHERE (product_id = 1)