如何在gridview中使用where命令。 [英] How to use where command in gridview.

问题描述

我有一页用户详细信息，其中包括姓名，父亲姓名，母亲姓名，班级，名单。等等

我想在gridview中显示几个字段，比如我想显示用户名，类，滚动号..

我的第一页是登录页面。现在我想要，因为我用用户名登录。该用户名将通过gridview进行比较，并仅显示登录用户的详细信息。

当我登录时重定向到gridview的另一页，其中包含页面加载的详细信息。

解决方案

您需要在sql语句中使用where where;

  string  userName = lblUserName.Text; 
 SqlDataAdapter da =  new  SqlDataAdapter（  select *来自mastertable，其中username =' + userName +  '，con）; 

I have a page of user details in which name, father name, mother name, class, roll no. etc.
I want to show several fields in gridview like in which i want to show user name, class, roll no..
My first Page is login page. Now I Want, as i login with a user name. That user name will compare by gridview and show that detais of a login user only.
as i login redirect to another page of gridview with that details on page load.

解决方案

you need to use where condition in your sql statement, for example;

string userName =lblUserName.Text;
SqlDataAdapter da = new SqlDataAdapter("select * from mastertable where username ='"+ userName +"'", con);

这篇关于如何在gridview中使用where命令。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！