Home All Groups Group Topic Archive Search About

Question about the data adaptor Fill method.

Author
3 May 2006 1:21 PM
Mark
Hi -

The da.Fill(ds, "TableName") method is a really nice way to bring data from
a database into your VB.Net application.

My question is this:

Is there an equally nice method to send data theopposite way - from a table
(or dataset) in VB.Net to table in a database?

Or if there is not a simple method, code samples would be appreciated.

Thanks, Mark

Author
3 May 2006 1:37 PM
vbnetdev
dataadapter1.Update

?

--
Get a powerful web, database, application, and email hosting with KJM
Solutions
http://www.kjmsolutions.com



Show quoteHide quote
"Mark" <M***@discussions.microsoft.com> wrote in message
news:8429172A-4448-45BC-97A6-705D21D4375F@microsoft.com...
> Hi -
>
> The da.Fill(ds, "TableName") method is a really nice way to bring data
> from
> a database into your VB.Net application.
>
> My question is this:
>
> Is there an equally nice method to send data theopposite way - from a
> table
> (or dataset) in VB.Net to table in a database?
>
> Or if there is not a simple method, code samples would be appreciated.
>
> Thanks, Mark
Author
3 May 2006 2:51 PM
Mark
I'd like to send the entire table at one time (as opposed to executing an SQL
INSERT statement for each record in the table) - does Update let me send
entire tables?

If so sample code would be helpful.

Thanks, Mark

Show quoteHide quote
"vbnetdev" wrote:

> dataadapter1.Update
>
> ?
>
> --
> Get a powerful web, database, application, and email hosting with KJM
> Solutions
> http://www.kjmsolutions.com
>
>
>
> "Mark" <M***@discussions.microsoft.com> wrote in message
> news:8429172A-4448-45BC-97A6-705D21D4375F@microsoft.com...
> > Hi -
> >
> > The da.Fill(ds, "TableName") method is a really nice way to bring data
> > from
> > a database into your VB.Net application.
> >
> > My question is this:
> >
> > Is there an equally nice method to send data theopposite way - from a
> > table
> > (or dataset) in VB.Net to table in a database?
> >
> > Or if there is not a simple method, code samples would be appreciated.
> >
> > Thanks, Mark
>
>
>
Author
3 May 2006 3:29 PM
vbnetdev
http://www.amazon.com/gp/product/0735612366/102-6188853-0928964?v=glance&n=283155

--
Get a powerful web, database, application, and email hosting with KJM
Solutions
http://www.kjmsolutions.com



Show quote Hide quote
"Mark" <M***@discussions.microsoft.com> wrote in message
news:40611E4B-1978-46CA-AE2F-2229A27EAFA1@microsoft.com...
> I'd like to send the entire table at one time (as opposed to executing an
> SQL
> INSERT statement for each record in the table) - does Update let me send
> entire tables?
>
> If so sample code would be helpful.
>
> Thanks, Mark
>
> "vbnetdev" wrote:
>
>> dataadapter1.Update
>>
>> ?
>>
>> --
>> Get a powerful web, database, application, and email hosting with KJM
>> Solutions
>> http://www.kjmsolutions.com
>>
>>
>>
>> "Mark" <M***@discussions.microsoft.com> wrote in message
>> news:8429172A-4448-45BC-97A6-705D21D4375F@microsoft.com...
>> > Hi -
>> >
>> > The da.Fill(ds, "TableName") method is a really nice way to bring data
>> > from
>> > a database into your VB.Net application.
>> >
>> > My question is this:
>> >
>> > Is there an equally nice method to send data theopposite way - from a
>> > table
>> > (or dataset) in VB.Net to table in a database?
>> >
>> > Or if there is not a simple method, code samples would be appreciated.
>> >
>> > Thanks, Mark
>>
>>
>>