I have a table in sql named Attendance with the following columns:
Agency,StudentID, Student Name, Activity, Hours, Date, Inactive
I would like to make a table in vb6 datagrid which will allow me to enter attendance in this format:
Student Activity        etc....
Sam Jacob Basketball 3 3 3 3 0 0 0
Bill Johnson Basketball 3 3 3 3 0 0 0
Then I would like to have the data from this grid input into the table. How can I accomplish this? The problem is listing the days of the month in the grid in a manner that will associate with the Date column of my table.