p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   C# (http://p2p.wrox.com/forumdisplay.php?f=22)
-   -   Need Help ASAP (http://p2p.wrox.com/showthread.php?t=58748)

coding June 5th, 2007 04:36 PM

Need Help ASAP
Hello everyone,

I would like to know how do we write the code in Visual C# to insert the records present in .mdb file into SQL Server 2000. I am very much in need of this. Can you please respond to me ASAP.

Thanks a lot for helping me.

zaghmout June 6th, 2007 12:41 AM

simple... two connections and two commands.. the first for the sql and the other for oledb (the provider is jet4.0 i think or something like that :)
create an oledbDataAdapter, fill a dataset with the data you want to transfer, and then use the sqlCommand to insert it into the sql database :)..

hope this will help

Nothing is impossible. The impossible only takes longer. "Digital Fortress, Dan Brown"

All times are GMT -4. The time now is 05:32 AM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.