redcoder
asked on
System.Data.OleDb.OleDbException: Data type mismatch in criteria expression.
Hwy this code just don't work : I keep getting error of ( System.Data.OleDb.OleDbExc eption: Data type mismatch in criteria expression.):
Function UpdateCustomerDetail(ByVal userID As String, ByVal first As String, ByVal surname As String, ByVal birthdate As Date, ByVal address As String, ByVal postCode As String, ByVal phone As String, ByVal email As String) As Integer
Dim connectionString As String = "Provider=Microsoft.Jet.OL EDB.4.0; Ole DB Services=-4; Data Source=C:\Documents an"& _
"d Settings\Administrator\My Documents\ECommerceAssignm ent\ASPCod e\JEANS.md b"
Dim dbConnection As System.Data.IDbConnection = New System.Data.OleDb.OleDbCon nection(co nnectionSt ring)
Dim queryString As String = "UPDATE [customer] SET [First]=@First, [Surname]=@Surname, [Birthdate]=@Birthdate,"& _
" [Address]=@Address, [PostCode]=@PostCode, [Phone]=@Phone, [Email]=@Email WHERE "& _
"([customer].[userID] = @userID)"
Dim dbCommand As System.Data.IDbCommand = New System.Data.OleDb.OleDbCom mand
dbCommand.CommandText = queryString
dbCommand.Connection = dbConnection
Dim dbParam_userID As System.Data.IDataParameter = New System.Data.OleDb.OleDbPar ameter
dbParam_userID.ParameterNa me = "@userID"
dbParam_userID.Value = userID
dbParam_userID.DbType = System.Data.DbType.String
dbCommand.Parameters.Add(d bParam_use rID)
Dim dbParam_first As System.Data.IDataParameter = New System.Data.OleDb.OleDbPar ameter
dbParam_first.ParameterNam e = "@First"
dbParam_first.Value = first
dbParam_first.DbType = System.Data.DbType.String
dbCommand.Parameters.Add(d bParam_fir st)
Dim dbParam_surname As System.Data.IDataParameter = New System.Data.OleDb.OleDbPar ameter
dbParam_surname.ParameterN ame = "@Surname"
dbParam_surname.Value = surname
dbParam_surname.DbType = System.Data.DbType.String
dbCommand.Parameters.Add(d bParam_sur name)
Dim dbParam_birthdate As System.Data.IDataParameter = New System.Data.OleDb.OleDbPar ameter
dbParam_birthdate.Paramete rName = "@Birthdate"
dbParam_birthdate.Value = birthdate
dbParam_birthdate.DbType = System.Data.DbType.DateTim e
dbCommand.Parameters.Add(d bParam_bir thdate)
Dim dbParam_address As System.Data.IDataParameter = New System.Data.OleDb.OleDbPar ameter
dbParam_address.ParameterN ame = "@Address"
dbParam_address.Value = address
dbParam_address.DbType = System.Data.DbType.String
dbCommand.Parameters.Add(d bParam_add ress)
Dim dbParam_postCode As System.Data.IDataParameter = New System.Data.OleDb.OleDbPar ameter
dbParam_postCode.Parameter Name = "@PostCode"
dbParam_postCode.Value = postCode
dbParam_postCode.DbType = System.Data.DbType.String
dbCommand.Parameters.Add(d bParam_pos tCode)
Dim dbParam_phone As System.Data.IDataParameter = New System.Data.OleDb.OleDbPar ameter
dbParam_phone.ParameterNam e = "@Phone"
dbParam_phone.Value = phone
dbParam_phone.DbType = System.Data.DbType.String
dbCommand.Parameters.Add(d bParam_pho ne)
Dim dbParam_email As System.Data.IDataParameter = New System.Data.OleDb.OleDbPar ameter
dbParam_email.ParameterNam e = "@Email"
dbParam_email.Value = email
dbParam_email.DbType = System.Data.DbType.String
dbCommand.Parameters.Add(d bParam_ema il)
Dim rowsAffected As Integer = 0
dbConnection.Open
Try
rowsAffected = dbCommand.ExecuteNonQuery
Finally
dbConnection.Close
End Try
Return rowsAffected
End Function
Sub Button2_Click(sender As Object, e As EventArgs)
Dim fname as String,sname as String,add as String,pcode as String,phone as String,email as String
Dim bdate as Date
Dim userid as String
userid = Label2.text
fname = TextBox1.text
sname = TextBox2.text
bdate = TextBox3.text
add = TextBox4.text
pcode = TextBox5.text
phone = TextBox6.text
email = TextBox7.text
'response.write(userid & "," & fname & ",")
UpdateCustomerDetail(useri d,fname,sn ame,bdate, add,pcode, phone,emai l)
End Sub
Function UpdateCustomerDetail(ByVal
Dim connectionString As String = "Provider=Microsoft.Jet.OL
"d Settings\Administrator\My Documents\ECommerceAssignm
Dim dbConnection As System.Data.IDbConnection = New System.Data.OleDb.OleDbCon
Dim queryString As String = "UPDATE [customer] SET [First]=@First, [Surname]=@Surname, [Birthdate]=@Birthdate,"& _
" [Address]=@Address, [PostCode]=@PostCode, [Phone]=@Phone, [Email]=@Email WHERE "& _
"([customer].[userID] = @userID)"
Dim dbCommand As System.Data.IDbCommand = New System.Data.OleDb.OleDbCom
dbCommand.CommandText = queryString
dbCommand.Connection = dbConnection
Dim dbParam_userID As System.Data.IDataParameter
dbParam_userID.ParameterNa
dbParam_userID.Value = userID
dbParam_userID.DbType = System.Data.DbType.String
dbCommand.Parameters.Add(d
Dim dbParam_first As System.Data.IDataParameter
dbParam_first.ParameterNam
dbParam_first.Value = first
dbParam_first.DbType = System.Data.DbType.String
dbCommand.Parameters.Add(d
Dim dbParam_surname As System.Data.IDataParameter
dbParam_surname.ParameterN
dbParam_surname.Value = surname
dbParam_surname.DbType = System.Data.DbType.String
dbCommand.Parameters.Add(d
Dim dbParam_birthdate As System.Data.IDataParameter
dbParam_birthdate.Paramete
dbParam_birthdate.Value = birthdate
dbParam_birthdate.DbType = System.Data.DbType.DateTim
dbCommand.Parameters.Add(d
Dim dbParam_address As System.Data.IDataParameter
dbParam_address.ParameterN
dbParam_address.Value = address
dbParam_address.DbType = System.Data.DbType.String
dbCommand.Parameters.Add(d
Dim dbParam_postCode As System.Data.IDataParameter
dbParam_postCode.Parameter
dbParam_postCode.Value = postCode
dbParam_postCode.DbType = System.Data.DbType.String
dbCommand.Parameters.Add(d
Dim dbParam_phone As System.Data.IDataParameter
dbParam_phone.ParameterNam
dbParam_phone.Value = phone
dbParam_phone.DbType = System.Data.DbType.String
dbCommand.Parameters.Add(d
Dim dbParam_email As System.Data.IDataParameter
dbParam_email.ParameterNam
dbParam_email.Value = email
dbParam_email.DbType = System.Data.DbType.String
dbCommand.Parameters.Add(d
Dim rowsAffected As Integer = 0
dbConnection.Open
Try
rowsAffected = dbCommand.ExecuteNonQuery
Finally
dbConnection.Close
End Try
Return rowsAffected
End Function
Sub Button2_Click(sender As Object, e As EventArgs)
Dim fname as String,sname as String,add as String,pcode as String,phone as String,email as String
Dim bdate as Date
Dim userid as String
userid = Label2.text
fname = TextBox1.text
sname = TextBox2.text
bdate = TextBox3.text
add = TextBox4.text
pcode = TextBox5.text
phone = TextBox6.text
email = TextBox7.text
'response.write(userid & "," & fname & ",")
UpdateCustomerDetail(useri
End Sub
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER