connelvalentine
asked on
VB.NET - Parent and Child tables to be displayed in textboxes and datagrid respectively
Hi,
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi Hatem72,
Nice hearing from you again...no i'm not using 2003, i'm using plain old VB.NET (MSDE 2002)
CV.
Nice hearing from you again...no i'm not using 2003, i'm using plain old VB.NET (MSDE 2002)
CV.
ASKER
I'll try out your post tomrrow anyway and see what happens. It's quittin' time in Dubai ;)
Ok will try to find somthing fit your needs
ASKER
Hi Hatem72,
I finally said "screw it" and upgraded to VB.NET 2005. :)
Thanks for the link. The videos will come in handy.
CV.
I finally said "screw it" and upgraded to VB.NET 2005. :)
Thanks for the link. The videos will come in handy.
CV.
OOPs ... are you using VB 2003 ???
if so hope my post work with you .