How to query Access database

[chris86t]

I am using vb.net 2010 express to query an Access database. I understand how to query 1 item at a time.

My users may need to add additional filters to the query.

How would I query where 2 or more items are found.


Here is the code I now use for individual querries.

cmd = New OleDbCommand("select * from inventory where serial like '" & TextBox2.Text & "'", cn)

cmd = New OleDbCommand("select * from inventory where sku like '" & TextBox1.Text & "'", cn)

 

[SkipVought]

hi,

dim sSQL as string

sSQL =        "select * "
sSQL = sSQL & "from inventory "
sSQL = sSQL & "where serial like '*" & TextBox2.Text & "*'"
sSQL = sSQL & "  and sku    like '*" & TextBox1.Text & "*'"

cmd = New OleDbCommand(sSQL, cn)

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[Andrzejek]

I would modify Skip's statement a little:

dim sSQL as string

sSQL =        "select * "
sSQL = sSQL & "from inventory "
sSQL = sSQL & "where [blue]1 = 1 [/blue]"
[blue]
If Len(Trim(TextBox2.Text)) > 0 Then[/blue]
  sSQL = sSQL & " and serial like '*" & TextBox2.Text & "*'"[blue]
End If
If Len(Trim(TextBox1.Text)) > 0 Then[/blue]
  sSQL = sSQL & " and sku like '*" & TextBox1.Text & "*'"[blue]
End If[/blue]

cmd = New OleDbCommand(sSQL, cn)

[tt]
Len(Trim(...[/tt] is an old VB6 syntax, I am sure VB.NET has something better

Have fun.

---- Andy