all code: DataTable dt=new DataTable("myTable"); dt.Columns.Add("theDateTime",System.Type.GetType("System.DateTime")); DataRow dr=dt.NewRow(); dr[0]=System.DateTime.Now; dt.Rows.Add(dr);OleDbDataAdapter adapter=new OleDbDataAdapter("select * from test",oleDbConnection1);//oleDbConnection is created to connect to my Access file OleDbCommandBuilder builder=new OleDbCommandBuilder(adapter); adapter.Update(dt);
the record inserted to the database has the column of 2004-7-4 23:56:01
Dim dr As DataRow = ds.Tables(0).Rows(0) dr("timer") = Now.ToLongTimeString Dim builder As New OleDbCommandBuilder(adpt) '你是不是把这句漏了,漏了就更新不了 adpt.Update(ds)
dt.Columns.Add("theDateTime",System.Type.GetType("System.DateTime"));
DataRow dr=dt.NewRow();
dr[0]=System.DateTime.Now;
dt.Rows.Add(dr);
DataTable dt=new DataTable("myTable");
dt.Columns.Add("theDateTime",System.Type.GetType("System.DateTime"));
DataRow dr=dt.NewRow();
dr[0]=System.DateTime.Now;
dt.Rows.Add(dr);OleDbDataAdapter adapter=new OleDbDataAdapter("select * from test",oleDbConnection1);//oleDbConnection is created to connect to my Access file
OleDbCommandBuilder builder=new OleDbCommandBuilder(adapter);
adapter.Update(dt);
dr["logfalsetime"]=System.DateTime.Now.ToLongTimeString();
// try
// {
oleDbDataAdapter3.Update(dataSet31);看看我的代码片断
数据库里是常规日期字段。
oleDbConnection1.Open();
oleDbCommand3.ExecuteNonQuery();
oleDbConnection1.Close();数据库字段属性是常规日期。
是不是常规日期中间的空格引起的?
我就是用这个语句给参数附值的呀!命令语句:
// oleDbCommand3
//
this.oleDbCommand3.CommandText = "UPDATE userlogin SET user_lastip = ?, user_lastlogin = ? WHERE (user_name = ?)";
this.oleDbCommand3.Connection = this.oleDbConnection1;
this.oleDbCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("user_lastip", System.Data.OleDb.OleDbType.VarWChar, 50, "user_lastip"));
this.oleDbCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("user_lastlogin", System.Data.OleDb.OleDbType.DBDate, 0, "user_lastlogin"));
this.oleDbCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("user_name", System.Data.OleDb.OleDbType.VarWChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "user_name", System.Data.DataRowVersion.Original, null));
dr("timer") = Now.ToLongTimeString
Dim builder As New OleDbCommandBuilder(adpt) '你是不是把这句漏了,漏了就更新不了
adpt.Update(ds)
插入时,再转换和DateTime
我使用的C#+asp.net
我不是更新不了,而是只写入了日期,却没有时间。应该是日期+时间的回答liujuanwh:
我的数据库是ACCESS,2003的软件,但是保存的是2000格式。这个字段属性就是常规时间型,也就是说包含日期和时间。例如2004-7-6 16:40:00
System.Data.OleDb.OleDbParameter("user_lastlogin", System.Data.OleDb.OleDbType.DBDate, 0, "user_lastlogin"));
里面的DBDate不对。不过还是要散分。