scom=new SqlCommand("insert into RS_JBXX (CSRQ)values(@csrq)",scon);
SqlParameter pcsrq=new SqlParameter ("@csrq",SqlDbType.DateTime,8);
pcsrq.Value =Convert.ToDateTime(cstime);
scom.Parameters .Add (pcsrq);
SqlParameter pcsrq=new SqlParameter ("@csrq",SqlDbType.DateTime,8);
pcsrq.Value =Convert.ToDateTime(cstime);
scom.Parameters .Add (pcsrq);
或者前面把表名加上去:
tblVanVisits.Date
SqlCommand cmd1=new SqlCommand("insert into test(time)values('01-01-2002')",conn1);
conn1.Open();
cmd1.ExecuteNonQuery();
conn1.Close();
这是在我的机器上调试成功的代码