This is the gridview in which i will add marks of those students who are present for the date specified in the date textbox..
This is the attendance table in the database....
I want to select the data in to the attendance gridview of only those students who are present for the date which i wil specify in the textbox....
I jst want to knw how to write the select query with where clause for the above situation...
I knw the logical query query about how to write it in sql
for example
Select *from Att where Attendace==present AND date==textbox1.txt;
but this wld be useless in .net so plzzz can anyone tel me how to write this query in code behind in asp.net c#
back end: sql server 2005