Displaying data from Access in VB custom DataGridView
Posted on 2006-11-09
I have two forms in my applications form Managing Employees and the Courses that participate.
The first from is the one in which i add a new employee in the database and associate the specific employee with available courses. On this form, a datagridview is responsible for binding the courses with the trainee. The datagridview has the following 5 columns.
1) Course Name - combobox - databound
2)Course Type - combobox -databound
3)From Date -DateTimePicker
4)To Date - DateTimePicker
5)Course Provider - Textbox
the above databound comboboxes get date from a dataset (dsCourses)
This form works fine, i can add a new trainee to the database and also i can enroll the specific employee to various courses.
So far so good.
I have a second form though, that i wish to use for editing the employee information such as enrolled courses e.t.c
What i have done so far, is to create the same custom datagridview as above, but my problem is that i don't know how to fill the datagrid with the courses that the specific employee is enrolled to.
My problem is not the SQL statement to retrieve the data, but rather the way that i will fill the datagridview.
Can you please provide me with some suggestions?
Thank you in advanced.