RE: how to insert record in a dataSet into another database table

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

hello Kerry,
thx for your response. but i need the code for the inser statement. is this
correct
dim comm AS New OdbcCommand("Insert Into table2 Select * from" + oDS.Tables(0)
with the above code i still get an error that operator + is not defined for
string and system.data.dataTable.

pls send the insert statement to me.

thx
Toyin

"Kerry Moorman" wrote:
Toyin,

Once you have the record in a datatable within a dataset:

Open a connection to database y
Use a command object to execute an SQL Insert statement
Insert a new row into table y in database y, using the data from the record
in the datatable within the dataset

Kerry Moorman


"Toyin" wrote:

hello,
thx for ur reply but it still can solve my problem.i have a record already
in a dataset (ds) i want to push the record in this ds into another table
(y) in database(y) without making any changes to it .
thx

"JIGNESH" wrote:

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

Relevant Pages

  • RE: datepicker and dateformat
    ... Thx for replying Damian, ... This date is read from the database and diplayed in a listview object ... The date format you display has nothing to do with how the date is ...
    (microsoft.public.access.formscoding)
  • RE: how to insert record in a dataSet into another database table
    ... "Toyin" wrote: ... thx for your response. ... Insert a new row into table y in database y, using the data from the record ... inserting from one db into another but its not working. ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: datepicker and dateformat
    ... thx for anyone reading my post ... This date is read from the database and diplayed in a listview object ... The date format you display has nothing to do with how the date is ... the field format should yield a date only, ...
    (microsoft.public.access.formscoding)
  • Unique Value from a DataTable/DataSet
    ... For example, I have a list of books, and I want to get a unique list of the ... AuthorCode column for some other work, without going to the database. ... Thx. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Editing and Deleting DB Records
    ... thx. ... didn't know it showed one how to edit a record once it ... "Tom Gahagan" wrote in message ... > Database Interface Wizard ...
    (microsoft.public.frontpage.client)