Thanks - Will try
From: Gary (test_at_nowhere.com)
Date: 04/20/04
- Next message: Raymond Chiu: "asc()"
- Previous message: William Ryan eMVP: "Re: Could not find Stored Procedure"
- In reply to: William Ryan eMVP: "Re: Respond to SqlCommandBuilder"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 20 Apr 2004 16:50:54 -0700
Bill,
Thanks for the info. I will try what you suggested after dinner and see if
it works. If I need more help, I'll be writing :-)
Thanks,
Gary
"William Ryan eMVP" <bill@NoSp4m.devbuzz.com> wrote in message
news:uyda3myJEHA.2624@TK2MSFTNGP09.phx.gbl...
>
> "Gary" <test@nowhere.com> wrote in message
> news:O3x42AyJEHA.3592@TK2MSFTNGP09.phx.gbl...
> > Bin,
> >
> > Thanks for the "heads up" on the updating command for the DA. I was
just
> > wondering how to do this after reading William Ryan's article. If I
have
> > two Data Adapters and fill the dataset with two tables, would I just
bind
> > the Contacts table to the fields on my form and then do the update?
>
> Yes, when you load the form ,load your data and create the datarelations.
> From there, set your databindings using a BindingContext. do your edits
and
> when you are done, update the parent table, then the child table.
>
> HTH,
>
> Bill
>
>
> Any
> > help and EXAMPLE code would be appreciated.
> >
> > Thanks,
> >
> > Gary
> >
> >
> > "Bin Song, MCP" <anonymous@discussions.microsoft.com> wrote in message
> > news:96C85643-58AF-4069-9A4C-095A00A62814@microsoft.com...
> > > Hi, Gary,
> > >
> > > The reason is that you use SqlCommandBuilder to automatically generate
> > command.
> > > 2 ways to solve this:
> > > 1. Write your own UpdateCommand, DeleteCommand and InsertCommand for
DA.
> > >
> >
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconUpdatingDatabaseWithDataAdapterDataSet.asp
> > > Or
> > > 2. Fill Contact into one table and Codes into another table. Add
> relation
> > between the 2 table.
> > >
> > > Bin Song, MCP
> >
> >
>
>
- Next message: Raymond Chiu: "asc()"
- Previous message: William Ryan eMVP: "Re: Could not find Stored Procedure"
- In reply to: William Ryan eMVP: "Re: Respond to SqlCommandBuilder"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|