access 日期入库问题 要疯了!
asp.net 中 代码如下
StringBuilder sbUpdateSql = new StringBuilder();
int iKm = Convert.ToInt32(DropDLtKm.SelectedItem.Value.ToString());
DateTime dtNow = new DateTime();
dtNow = DateTime.Now;
for (int i = 0; i < GridView1.Rows.Count; i++)
{
string strxh = ((Label)GridView1.Rows[i].Cells[0].FindControl("Label1")).Text;
double dScore = Convert.ToDouble(((TextBox)GridView1.Rows[i].Cells[2].FindControl("TextBox1")).Text);
sbUpdateSql.Append("insert into cscj(xh,km_id,score,datetime) values('")
.Append(strxh).Append("',")
.Append(iKm).Append(",")
.Append(dScore).Append(",'#")
.Append(dtNow.ToString()).Append("#');");
..........
}
总是提示insert语法错误 ,要疯了!datetime 为日期类型!
如果sql语句写成如下形式:
sbUpdateSql.Append("insert into cscj(xh,km_id,score) values('")
.Append(strxh).Append("',")
.Append(iKm).Append(",")
.Append(dScore).Append(");");
入库成功!为啥呢??!!!