How to retrieve records from sql table

query = "select count(*) from table_name where user_id = user_id";
sqlcommand sql = new sqlcommand(query, connection);
datareader reader = sql.executescalar();
int number_of_records = reader.RowCount;



now if you have a column that stores d attendace, u can do this:
select column_name from table_name where user = user_name