placeholder in query

sir_com · July 15th, 2010, 01:41 PM

Guys,

I need your help; In the query I am trying to pass the input from drop down box as

sqlcmd="select * from abc where xyz='dropdownlist1.selecteditem'"

but I am sure that, in this case "dropdownlist1.selecteditem" will be considered as plain string, so wanted to pass it in placeholder.

How can I achive this? Please help.

Thanks.

melvik · July 22nd, 2010, 08:30 AM

My friend:
First it depend what u r displaying & what u r valuing ur combo & also ur table

Code:

abc

well, simply u can use - text of ur drop down as:

Code:

sqlcmd="select * from abc where xyz='dropdownlist1.SelectedText'"

& value of ur drop down as:

Code:

sqlcmd="select * from abc where xyz='dropdownlist1.SelectedValue'"

u may convert ur selected value as below if ur using not string for value

Code:

Convert.ToInt32(comboBoxOffice.SelectedValue)

daccit · August 13th, 2010, 06:35 AM

Hi sir_com,
Do the fallowing change in sqlcmd
sqlcmd="select * from abc where xyz=’”+dropdownlist1.selecteditem.ToString()+”'"

Thanks