Query Strings - RESOLVED

[odamsr]

I am coming from a vb6 background so I am new to .net. I am trying to add the value of a combobox in my sql and I use to go

select * from tbl where id = '" & combobox.text & "'"

I tried doing this and it states:

Error 4 Operator '&' is not defined for types 'String' and 'System.Windows.Forms.ComboBox'. C:\Documents and Settings\sodam\My Documents\Visual Studio 2005\Projects\SC_Utility\SC_Utility\frmMain.vb 87 43 SC_Utility

Thanks for your help
Shannon

[conipto]

That code should work - but are you calling it EXACTLY Like that though? Because if you are, ComboBox is a type, not an instance of a combobox. usually you'd see something more like..

select * from tbl where id = '" & combobox[b]1[/b].text & "'"

Bill

[Shaggy Hiker]

That's the problem. You are attempting to concatenate a string and an object type, which doesn't work.

[odamsr]

Thanks. I made a stupid mistake. Forgot to use combobox.text. I just used me.cbobox

Thanks
Shannon