RE: how to insert record in a dataSet into another database table
- From: JIGNESH <JIGNESH@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 25 Oct 2007 05:46:01 -0700
Your questiona bit confused me, but based on my understanding, you have
retrieved data into dataset from X database and now want to save the same in
Y database.
This is possible if you have right dataAdaptors for each database(X & Y)
eg.
dataAdaptor1 = new ("Select col1 , col2 from TableXDatabase1")
dataAdaptor2 = new ("Select col1 , col2 from TableYDatabase2")
dataAdaptor1.Fill(ds)
// Make Necessary Changes and
dataAdaptor2.Update(ds)
Regards
JIGNESH
"Toyin" wrote:
hi, pls can someone help me out. its very urgent i get the solution today. i.
have a webservice that i use to retrieve new record from a database, also
there is a client application (window form) that calls this service which
returns the record in a dataset. now i need to insert the record in this
dataset into another database table on a different server.how do i do these.i
've tried so many things and also implement a suggestion on a thread about
inserting from one db into another but its not working. am using MySql5.1
community edition,IIS 5.o and Visual studio.Net2003 to develop and test. pls
someone help me. i need a simple code to do this.
- Prev by Date: RE: "@p5 : Byte array truncation to a length of 8000."
- Next by Date: Jobsite for SALE
- Previous by thread: Re: datatable vs custom List<MyClass>
- Next by thread: RE: how to insert record in a dataSet into another database table
- Index(es):
Relevant Pages
|
