代码如下,执行完以后数据库里没有新增记录,程序也没报错,请问是怎么回事?
Private Sub AddUser(ByVal mUserID As Long)
Dim mAutoID As Long
Dim strsql, strConn As String
Dim mNowTime As Date
mNowTime = DateTime.Now strConn = ConfigurationSettings.AppSettings("OraOaDataNetString")
mAutoID = GetMaxID("User_OnLine", "AutoID", strConn) + 1
strsql = "insert into User_OnLine(AutoID,UserID,FreshTime) values(" & mAutoID & "," & mUserID & "," & mNowTime & ")" Dim conn As New OleDb.OleDbConnection(strConn)
conn.Open() Dim cmd As New OleDb.OleDbCommand(strsql, conn)
cmd.ExecuteNonQuery()
conn.Close()
End Sub
Private Sub AddUser(ByVal mUserID As Long)
Dim mAutoID As Long
Dim strsql, strConn As String
Dim mNowTime As Date
mNowTime = DateTime.Now strConn = ConfigurationSettings.AppSettings("OraOaDataNetString")
mAutoID = GetMaxID("User_OnLine", "AutoID", strConn) + 1
strsql = "insert into User_OnLine(AutoID,UserID,FreshTime) values(" & mAutoID & "," & mUserID & "," & mNowTime & ")" Dim conn As New OleDb.OleDbConnection(strConn)
conn.Open() Dim cmd As New OleDb.OleDbCommand(strsql, conn)
cmd.ExecuteNonQuery()
conn.Close()
End Sub
mNowTime.ToString()还有错你调试一下,跟踪下insert语句倒底是什么内容
strsql = "insert into User_OnLine(AutoID,UserID,FreshTime) values(" & mAutoID & "," & mUserID & "," & mNowTime.ToString("yyyy-MM-dd HH:mm:ss") & ")"
strsql = "insert into User_OnLine(AutoID,UserID,FreshTime) values(" & mAutoID & "," & mUserID & ",'" & mNowTime.ToString("yyyy-MM-dd HH:mm:ss") & "')"