Link to home
Start Free TrialLog in
Avatar of Nerdy_Girl88
Nerdy_Girl88

asked on

Desperately seeking Master Detail example.........PLEASEEE

Hi,

I am Having big problems with my master detail form.

When I add a new Parent record the Child datagrid does not fill with the foriegn keys!  Can anyone Help with examples of Master Detail Forms that use DataBinding Architecture  to Add, Edit Or Delete form the form.  The form uses a dataset with two tables that have a realtionship.  I can edit the Master and Detail, and the foriegn keys are present but I can not when im adding a new parent.

HELP  :(

Than you .
Avatar of RonaldBiemans
RonaldBiemans

Hi Nerdy_Girl88,

look at this article  (both for sql server and access)

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnadonet/html/manidcrisis.asp
By the way, there is a downloadable project in that link which you can try.
Hi Nerdy_Girl, This is a big drawback of the disconnected model ADO.net uses, Fortunately the new version  of ADO.net will again have a connected option, which will make this problem much easier to handle. I had to handle this problem for a many to many relation and than the real horror begins ;-)
Avatar of Nerdy_Girl88

ASKER

Is this problem really that difficult ? I thought that my databinds would take care of the relationships between tow datatables.  WIth the Forign already defined by the relationship.

Huhhhhhhhh.  

Still Looking for examples that show me how Master Deatil forms work with databinding manager.  That will demonstate how to add edit and delete records.

Very frustared
Yes it is, unless you can guaranty that no parent records are ever deleted.

About the examples have you tried the example that was in the link I send you ?
Arrrrrrrrrrr, I Finally understand, I didn;t realsie the problem was actuall with the autoincrements!!!!!  How frustrating.  

I have down loaded that example but can't get it to run I think im missing the database.  So I haven't been able to see you get around this problem.  Are we on the same page now?  The dataset is trying to update to the database but the Auto increments for the PK IDs are different, when i go back to update.

Nerdy_Girl88
Hi nerdy_girl,

In the code you only have to change the Sqlserver name and point to any database. The example will generate its own tables in the database.

you only have to change this line

cn = New SqlConnection("server=Yourservername;database=anydatabasename;integrated security=sspi")
At the moment my dataAdapters hold all the databse SQl Can I still Implement it this way or Do I need to specifiy my sql statements to cater for this problem......Just started reading throught the code,  can you give an little overview of what eaxactly I am doing?

thanks I will give it a go
I only have Access?  Do i replace the connection string with my Access connection?
ASKER CERTIFIED SOLUTION
Avatar of RonaldBiemans
RonaldBiemans

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
So, maybe on cell change I can refresh the dataSet with the data.!  I'll give it a go!

Thanks.