Hello, I have never worked with datagrid's before, and I have been asked to make a form that selects all students from the database that are in a certain class and pull their grades.

The easiest way to dynamically do that I figured would be the datagrid, but I have ran into a problem. I am using OLEDB to connect to the ORACLE database.

I don't have any idea on where to start. All I want to allow the user to do is to Update the Grade. The datagrid pulls from 2 tables, it gets the STUDENT_ID, and GRADE from one table then matches the STUDENT_ID with the FIRST_NAME and LAST_NAME fields in the Student table.

Can someone help me get started on writing an Update code to only update the GRADE, where the STUDENT_ID matches the FIRST_NAME and LAST_NAME.


----------DATAGRID EXAMPLE-----------
NAME GRADE
Last, First (null)
Last, First (null)
Last, First (null)
Last, First (null)
Last, First (null)

Thanks in advance.