Data type mismatch in criteria expression on ASP.NET VB2010

Question

0.00/5 (No votes)

See more:

Hi everyone, i'am trying read the data from a table MS acces in a webforms ASP with visual basic 2010, but this show the following error. someone you maybe helpme.

Error Message "Data type mismatch in criteria expression."
here's the code:

Protected Sub btnbuscar1_Click(ByVal sender As Object, ByVal e As EventArgs) Handles btnbuscar1.Click
Try
Dim con As String = Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\luis.valdez\Documents\info.accdb
conConexion = New OleDb.OleDbConnection(con)
Catch ex As Exception
MsgBox("Error al conectarse")
End Try

Dim lista As Byte
Dim str As String

If txtIdcaso.Text Then
conConexion.Open()
str = SELECT * FROM Casos_Tbl WHERE (IDCaso = '" & txtIdcaso.Text & "')"
'Dim cmd As OleDbCommand = New OleDbCommand(str, conConexion)
adaptador = New OleDb.OleDbDataAdapter(str, conConexion)
registro = New DataSet
adaptador.Fill(registro, "Casos_Tbl")
lista = registro.Tables("Casos_Tbl").Rows.Count
Else
MsgBox("Debe Ingresar un codigo.", vbExclamation, "UTCtickets")
End If
If lista = 0 Then
lblidcase.Text = registro.Tables("Casos_Tbl").Rows(0).Item("IDCaso")
txtuser.Text = registro.Tables("Casos_Tbl").Rows(0).Item("Usuario")
txtarea.Text = registro.Tables("Casos_Tbl").Rows(0).Item("Area")
lblDate.Text = registro.Tables("Casos_Tbl").Rows(0).Item("FechayHora")
Dropcateg.Text = registro.Tables("Casos_Tbl").Rows(0).Item("Categoria")
LblSev1.Text = registro.Tables("Casos_Tbl").Rows(0).Item("Severidad")
dropstat.Text = registro.Tables("Casos_Tbl").Rows(0).Item("Status")
txtdescort.Text = registro.Tables("Casos_Tbl").Rows(0).Item("DescripcionCorta")
txtdescdetall.Text = registro.Tables("Casos_Tbl").Rows(0).Item("DescripcionDetallada")
End If
txtIdcaso.Focus()
End Sub

Posted 21-Apr-15 9:12am

Member 11607014

Add a Solution

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Bob@work · Answer 1 · 2015-04-21T09:51:00

Solution 1

It looks like IDCaso may be stored as an integer or other numeric type.

Try changing your select statement to not quote the value:

str = SELECT * FROM Casos_Tbl WHERE (IDCaso = " & txtIdcaso.Text & ")"

Posted 21-Apr-15 9:51am

Bob@work

Comments

Sascha Lefèvre 21-Apr-15 17:53pm

I voted 4 because it will most likely resolve his problem. But you should not suggest concatenating values into a SQL-string because it has several disadvantages; the most signifcant is that it allows for SQL-Injection.
Instead he (and you) should be using SQL-Parameters. Example here: http://www.dotnetperls.com/sqlparameter
I would suggest you to improve your solution and mention that.

Bob@work 21-Apr-15 18:05pm

I concur.

As an alternative (recommend limiting to simple queries), you can test the value of txtIdcaso.text for the proper format. An example would be

if cint(val(txtidcaso.text)=0, then don't accomplish the query.

However, if the datatable has a record with IDCaso=0 then, you'll need a different approach and SQL Parameters are much more secure.

Member 11607014 · Answer 2 · 2015-04-21T11:45:00

Solution 2

Afirmative, is a field autonumber and also is autoincrement the, what can i to do for read the data withou problems?

Posted 21-Apr-15 11:45am

Member 11607014

Comments

Sascha Lefèvre 21-Apr-15 17:54pm

This is not a solution. And Bob@work didn't get a notification about it.
Please delete this and post it as a comment instead with the "Have a Question or Comment?"-Button below his answer.
Please also see my comment to the answer.

Data type mismatch in criteria expression on ASP.NET VB2010

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Data type mismatch in criteria expression on ASP.NET VB2010

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us