i am creating a search function on my web. This is the result
"SELECT [ROUTE], [INST_KEY], [INST_TYPE], [ACCT_KEY], [STATUS], [DMZ], [CUST_NAME], [ADDRESS_LINE1], [ADDRESS_LINE3], [ADDRESS_LINE4], [ADDRESS_LINE5], [METER_KEY], [SIZE], [INSTALL_DATE], [X], [Y], [Z], [ADDRESS_LINE2], [MI_PRINX] FROM [DBCUSTOMER] WHERE ([CUST_NAME] LIKE '%' + @CUST_NAME + '%')"
This function just looking one field. I try for modify it to can the user choose category on dropdownlist, his will can get data which his choice.
How can i do build the search function like that?
The following picture is what I mean.
Regards, Kiki Wisaka