hisheeraz
Member
- Joined
- Oct 5, 2008
- Messages
- 11
- Programming Experience
- 1-3
hello friends
fellow i am having error in this querry, can any one help me with this please ?
and here is the error i am getting
The fields in my access database are
STime of Type Integer
eDate of Type Date/Time
CarNumber of Type Text
dName od Type Text
Any Help please...will be much appreciated.
Thanks
Shiraz
fellow i am having error in this querry, can any one help me with this please ?
VB.NET:
Dim myCommand As OleDb.OleDbCommand
Dim strInsterQuery As String = String.Empty
myCommand = New OleDb.OleDbCommand
strInsterQuery = "UPDATE tblPaying SET STime='" & STime.Text & "'"
strInsterQuery += " WHERE PayingDate='" & CDate(txtPayingDate.Text) & "'"
strInsterQuery += " AND CarNumber='" & txtTaxiNumber.Text & "'"
strInsterQuery += " AND dName='" & txtDriverName.Text & "'"
myCommand.CommandText = strInsterQuery
myCommand.Connection = con
myCommand.ExecuteNonQuery()
myCommand.Dispose()
and here is the error i am getting
VB.NET:
Data type mismatch in criteria expression.
The fields in my access database are
STime of Type Integer
eDate of Type Date/Time
CarNumber of Type Text
dName od Type Text
Any Help please...will be much appreciated.
Thanks
Shiraz