troubleshooting Question

VB.NET - Parent and Child tables to be displayed in textboxes and datagrid respectively

Avatar of connelvalentine
connelvalentine asked on
Visual Basic.NET
6 Comments1 Solution558 ViewsLast Modified:

Does anyone have any links explaining how parent/child tables can be displayed/modified, with the parent table fields being bound to text boxes, while the child table is bound to a datagrid?

I'm using VB.NET to code, and SQL server 2000 as DB. I've got a parent table "Offices", and a child table "Departments". In my main form, i've got a datagrid that's bound only to the "Offices" table. When i click on a "Details" button, a dialog form pops up with the fields from the "Offices" table in text boxes (of the selected record in the datagrid on the main form), and the feilds from the "Departments" table on a datagrid just below it.

I want to be able to add/delete/edit the rows in the "departments" table from this form.

Appreciate any help. CV.

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 6 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros