regarding updation

[hygeena]

Hi,

I m having one table Leave_Mstr...Leave Mstr is having fields

Leave_Code Primary Key number
leave_Name text
Days number

I can insert data to the tbale successfully.But during the updation time...The follwing Error s coming:

Query:
Dim SelQueryText As String = String.Empty
SelQueryText = "update Holiday_Mstr set Holiday_Name='" + txtHolidyCrtnHolidyName.Text.Trim + "',Holiday_Date='" + txtHolidyCrtnNofDays.Text.Trim() + "' where Holiday_Code='" + TextBox1.Text + "'"
con = New OleDbConnection(constring)
cmd.Connection = con
cmd.CommandText = SelQueryText
con.Open()
cmd.ExecuteNonQuery() 'Here is the error showing
con.Close()

Error:
Data type mismatch in criteria expression
plz help me.....

[kenobewan]

Have you tried writing the values used in update? If Holiday_Date is a date type there wil be a problem trying to update it with text. How many fields are in Holiday_Mstr?

[Frinavale]

Hi,

I m having one table Leave_Mstr...Leave Mstr is having fields

Leave_Code Primary Key number
leave_Name text
Days number

I can insert data to the tbale successfully.But during the updation time...The follwing Error s coming:

Query:
Dim SelQueryText As String = String.Empty
SelQueryText = "update Holiday_Mstr set Holiday_Name='" + txtHolidyCrtnHolidyName.Text.Trim + "',Holiday_Date='" + txtHolidyCrtnNofDays.Text.Trim() + "' where Holiday_Code='" + TextBox1.Text + "'"
con = New OleDbConnection(constring)
cmd.Connection = con
cmd.CommandText = SelQueryText
con.Open()
cmd.ExecuteNonQuery() 'Here is the error showing
con.Close()

Error:
Data type mismatch in criteria expression
plz help me.....

What is the error message?