Multiple Variables in One SQL select statement 1

[lance59]

I have 2 variables in one select statement. I can put one in at a time and the select works, both in and I end up with no errors but a blank datagridview. Using SQL 2005 and VB.Net (Visual Studio 2008)

TextBox1.Text = str_item_column
TextBox2.Text = str_item_type

Dim SQL As String = "select * from item_table where '" + str_item_column +'" = '" + str_item_type + "'"

Any help is appreciated.

TIA

 

[HarleyQuinn]

You don't need single quotes around the column name:

Dim SQL As String = "select * from item_table where " + str_item_column + " = '" + str_item_type + "'"

Hope this helps

HarleyQuinn
---------------------------------
Carter, hand me my thinking grenades!

You can hang outside in the sun all day tossing a ball around, or you can sit at your computer and do something that matters. - Eric Cartman

Get the most out of Tek-Tips, read FAQ222-2244: How to get the best answers before posting.

http://lessthandot.com

 

[lance59]

Thanks! That was it.

 

[HarleyQuinn]

Glad I could help, thanks for the star

HarleyQuinn
---------------------------------
Carter, hand me my thinking grenades!

You can hang outside in the sun all day tossing a ball around, or you can sit at your computer and do something that matters. - Eric Cartman

Get the most out of Tek-Tips, read FAQ222-2244: How to get the best answers before posting.

http://lessthandot.com

 

[Andrzejek]

The best way to spot problems like that, IMHO, is to see your SQL

Check this post


Have fun.

---- Andy