How to search multiple fields in sql database table and i will show in grid view

Question

Hi Friends any one knows how to search multiple fields insql database table . i have table like string str2 = select cld_idcld_namecld_adrscld_ctnocld_cmdtycld_tngcld_statecld_dstcld_dofcld_pbycld_moc from coldstorage; then i have checkbox list hear i have bind cld_name dropdownlist hear i bind cld state and dropdown i bind cld_dst... so now i want to select one or two ckeckboxes and i select state and distric then i click searchbutton i want to show searching values in gridview please give any idea how to search multiple fileds sqlquery please any one helpm.

Zoran Horvat · Answer

select cld_idcld_namecld_adrscld_ctnocld_cmdtycld_tngcld_statecld_dstcld_dofcld_pbycld_moc from coldstorage where cld_name='name' and cld_state='state'; This would search by name and state only. You can extend the query by adding and removing search fields as you wish. Zoran