Bind Grid to SQL Tables

M

Matt J

Hello, I am fairly new to datagrids in general. Mainly using forms,
asp, etc..

Here is what I am trying to do.

I have 3 tables
Table 1 Scores columns -> scores_id, assessment_id, student_id, cat1,
cat2, cat3, cat4, cat5, cat6

Table 2 Assessment columns -> assessment_id, assessmentlong

Table 3 Student columsn -> student_id, studentlast, studentfirst


Display a grid with the following parematers.

Show a list of the students per class down the table(which obviously is
filtered per class, grade, etc.. ) the filtering is not an issue.

Across the table put cat1, cat2, etc...

Then you should be able to enter 6 scores per student.

the assessment_id that is programmed into each row is passed through a
variable.


Any help or point to a resource would be appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,755
Messages
2,569,536
Members
45,015
Latest member
AmbrosePal

Latest Threads

Top