如何在sql数据库表中搜索多个字段,我将在网格视图中显示 [英] how to search multiple fields in sql database table and i will show in grid view
问题描述
朋友,
任何人都知道如何在sql数据库表中搜索多个字段.
我有像
这样的桌子
字符串str2 =从冷存储中选择cld_id,cld_name,cld_adrs,cld_ctno,cld_cmdty,cld_tng,cld_state,cld_dst,cld_dof,cld_pby,cld_moc";
然后我有复选框列表,听到我绑定了cld_name,dropdownlist,听到我绑定了cld状态,下拉列表,我绑定了cld_dst ...
所以现在我要选择一个或两个ckeckbox,然后选择state和distric
然后我单击搜索按钮,我想在gridview中显示搜索值
请给出如何搜索多个文件的sqlquery
Hi Friends,
any one knows how to search multiple fields insql database table .
i have table like
string str2 = "select cld_id,cld_name,cld_adrs,cld_ctno,cld_cmdty,cld_tng,cld_state,cld_dst,cld_dof,cld_pby,cld_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.
推荐答案
SELECT * FROM MyTable WHERE columnA = 'value 1' AND columnB = 'value 2'
阅读有关WHERE子句的信息:
http://www.w3schools.com/sql/sql_where.asp [
Read about WHERE clause:
http://www.w3schools.com/sql/sql_where.asp[^]
这篇关于如何在sql数据库表中搜索多个字段,我将在网格视图中显示的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!