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.........