如何过滤特定用户的特定用户数据的数据。 [英] How to filter data for the particular user data for the particular user.

问题描述

我将Student_table绑定到gridview，它有像StudentId，Name，LastName，Department，Mark1，Mark2，Mark3，Mark4这样的列。对于这个我的Web应用程序，我已创建登录以在gridview中查看学生详细信息。如果登录suceessful将显示所有部门学生信息。在这里，我只需要为用户提供特定的设备。



例如，

如果Username = mca则在gridview中MCA部门必须是绑定。



请帮我完成这个.........

I have bind a Student_table into gridview and it has columns like StudentId,Name,LastName,Department,Mark1,Mark2,Mark3,Mark4. For this i web application i have create login for to view student details in gridview. If login suceessful all the department student info will be displayed. here i need only specific depeartment for the user.

For Example,
if Username=mca then in gridview MCA department only has to be bind.

Kindly help me to done this.........

推荐答案

首先你必须得到部门并传递它来选择查询条件，你得到了确切的结果

例如。从Student_table中选择*，其中Department ='MCA'

First you have to get department and pass that to select query for where condition and you got exact result
eg. select * from Student_table where Department ='MCA'

这篇关于如何过滤特定用户的特定用户数据的数据。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！