任何人都可以帮我编写网格视图搜索代码。 [英] Can any one help me to write code for search from grid view.

问题描述

我使用左连接加入了两个表并在gridview中显示它。现在我想根据名称列搜索该视图中的特定行。



我尝试过：



我在sql中加入了两个表的查询：

  SELECT  HM.DELETED，HM.ISACTIVE，HM.ID  AS  ID，HM.NAME  as  NAME，HM.MOBILE  AS  MOBILE，HM.EMAIL  AS  EMAIL，HM.WEBSITE  AS 网站，STM.STATE_NAME  AS  STMSTATE  FROM  HOSPITAL_MASTER < span class =code-keyword> AS  HM  LEFT   JOIN  STATE_MASTER  AS  STM  ON  STM.ID = HM.STATE_ID  WHERE  HM .DELETED = 0 和 HM.IS ACTIVE = 1  ORDER   BY  NAME 

并且在代码后面，用于搜索特定内容在该视图中的行我在页面加载中执行以下操作

Search1.StrQry =select * from HOME_NURSE_REGISTRATION;

解决方案

当您使用时a DataSet ，您可以使用 .RowFilter ，参见：数据集表过滤：如何过滤列包含值的行。 [ ^

i have joined two tables using left join and displayed it in a gridview. Now I want to search a particular row in that view according to the column 'Name'.

What I have tried:

I did the query for joining the two tables in sql:

SELECT HM.DELETED,HM.ISACTIVE,HM.ID AS ID, HM.NAME as NAME,HM.MOBILE AS MOBILE,HM.EMAIL AS EMAIL,HM.WEBSITE AS WEBSITE,STM.STATE_NAME AS STMSTATE FROM HOSPITAL_MASTER AS HM LEFT JOIN STATE_MASTER AS STM ON STM.ID=HM.STATE_ID WHERE HM.DELETED=0 and HM.ISACTIVE=1 ORDER BY NAME

and in code behind, for searching the particular row in that view i did the following in page load
Search1.StrQry = "select * from HOME_NURSE_REGISTRATION ";

解决方案

When you use a DataSet, you can use .RowFilter, see: Dataset table filtering: How to filter for rows where column "contains" a value.[^]

这篇关于任何人都可以帮我编写网格视图搜索代码。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！