[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

.dbf file convert in mysql database using asp.net

Posted on 2008-11-03
1
Medium Priority
?
574 Views
Last Modified: 2012-06-21
I need to convert the foxpro .dbf file to mysql
with the using of asp.net.( VB.net) can any one help me
regd this. like any code snip, or any useful links.
0
Comment
Question by:sudanshu
1 Comment
 
LVL 20

Accepted Solution

by:
Juan_Barrera earned 1500 total points
ID: 22874245
Hi,
It's very broad question. but I'll try to post some useful links:
To connect to both databases:
OleDbConnection class = http://msdn.microsoft.com/en-us/library/system.data.oledb.oledbconnection.aspx
The command class to work with the connection:
http://msdn.microsoft.com/en-us/library/system.data.oledb.oledbcommand.aspx
The OleDbDataReader, that you can use to read the whole source database, and create a temporary storage, like a DataSet:
http://msdn.microsoft.com/en-us/library/system.data.oledb.oledbdatareader.aspx
A data adapter would work too: http://msdn.microsoft.com/en-us/library/system.data.oledb.oledbdataadapter.aspx
Then, is up to you how you upload the data to MySql, there are many considerations to take in account, but, basically, you should be all right using the above classes.
 
 
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
The article shows the basic steps of integrating an HTML theme template into an ASP.NET MVC project
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses
Course of the Month20 days, 4 hours left to enroll

872 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question