Thanks - Will try

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Gary (test_at_nowhere.com)
Date: 04/20/04


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
> >
> >
>
>



Relevant Pages

  • Saving .csproj files
    ... I'm writing a ORM program. ... This causes Visual Studio to puke upon trying to load the ... XmlNode currentnode = doc.DocumentElement.FirstChild; ... If I remove the xmlns="" manually, ...
    (microsoft.public.dotnet.xml)
  • Re: Damn Road Hogs!!
    ... Tonight's dinner is just one click away ... And thus my hoped-for career as a surreal satirist takes a daily ... As truck oopsies go, though, the recordholder is probably still the ... It was carrying a full load of port-a- ...
    (rec.autos.driving)
  • Re: Windows/Office problem
    ... Champ secured a place in history by writing: ... > What a load of tosh. ... > That's the problem with newsgroups - anyone can stand up and pretend ...
    (uk.rec.motorcycles)
  • Re: Reference to a class that does not exist
    ... Specifically, I am writing a Java library and there is another library that has some very useful features, but I don't expect that other library to always be available. ... It should depend upon your main application source, but there should not be any opposite dependencies. ... To attempt to use the code, use Class.forName to load a root class, and create a single instance with Constructor.newInstance. ...
    (comp.lang.java.programmer)
  • Re: Invoke Java from Excel
    ... I'd never done it with Excel but with several other programs: ... First you must reach "native" code in your program (writing vb, ... load your main class, ... It seems to me that there is an activeX that launch the JVM, ...
    (comp.lang.java.programmer)