C# Programming :: C# : transfer data from one database to other


	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... - Hide quoted text - >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 > } On Jun 6, 7:34 pm, "Egghead" <robertlo@NO_SHAW.CA> wrote: - Hide quoted text - > 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... > >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 > > } 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... - Hide quoted text - > On Jun 6, 7:34 pm, "Egghead" <robertlo@NO_SHAW.CA> wrote: >> 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... >> >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 >> > } > is this possible to transfer the data from one table to the other in > different databases(sql and msaccess)?