Home     |     .Net Programming    |     cSharp Home    |     Sql Server Home    |     Javascript / Client Side Development     |     Ajax Programming

Ruby on Rails Development     |     Perl Programming     |     C Programming Language     |     C++ Programming     |     IT Jobs

Python Programming Language     |     Laptop Suggestions?    |     TCL Scripting     |     Fortran Programming     |     Scheme Programming Language


 
 
Cervo Technologies
The Right Source to Outsource

MS Dynamics CRM 3.0

C# Programming

C# : transfer data from one database to other


I had created an appication that serves as an address book

i used the SQL server 2000 as the database to store the contacts;
its only a single table that contains enitre details

now i thought of transferring the entire details from the table(name :
addressbook) in sql 2000 to the ms access table(table name :
addressbook)

i had provided the same column names and their types (all "varchar" in
SQL and all "text" in MS Access)

how to transfer the data table
i tried disconnected architecture, i do accpet connnected one also

the code that troubles me is :

            drs = sqlds.Tables["ab"].NewRow();
            drm = msads.Tables["ab"].NewRow();
            for (int i = 0; i < sqlds.Tables["ab"].Rows.Count; i++)
            {
                drs = sqlds.Tables["ab"].Rows[i];
                drm=drs;
                msads.Tables["ab"].Rows.Add(drm);
                msada.Update(msads, "ab"); //---------------> this
line is prob, it is saying that
                                           // this row already belongs
to other table

// i used two datasets each for SQL and MSA and same table name in
both
            }

Hi here,

Something wrong with your server's export data and the DTS?

--
cheers,
RL

"sravan_reddy001" <sravanganta2@gmail.com> wrote in message

news:1181137858.455849.256610@n15g2000prd.googlegroups.com...

On Jun 6, 7:34 pm, "Egghead" <robertlo@NO_SHAW.CA> wrote:

is this possible to transfer the data from one table to the other in
different databases(sql and msaccess)?

-----------------------------------------------Reply-----------------------------------------------
Of course.

--
cheers,
RL

"sravan_reddy001" <sravanganta2@gmail.com> wrote in message

news:1181147612.178391.321750@d30g2000prg.googlegroups.com...

Add to del.icio.us | Digg this | Stumble it | Powered by Megasolutions Inc