how to write data from data set in dotnet to paradox database in c#
In this code from Archive Sql Server database, Table named:tmsarcdata
I want all the details from tmsarcdata table to move to paradox database
My paradox database path is: =@"D:\\ArchiveBase\\CDFilesa"
This is the code I tried,but did not work:
private void button1_Click(object sender, System.EventArgs e)
{
try
{
string pPath=@"D:\\ArchiveBase\\CDFilesa";
string strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source="+pPath+";Extended Properties=Paradox 5.x;";
string command="select * from tmsarcdata";
OleDbCommand mCommand = new OleDbCommand();
OleDbConnection mConnection=new OleDbConnection(strConnection);
mConnection.Open();
mCommand.CommandText=command;
mCommand.ExecuteNonQuery();
}
catch(System.Exception Ex)
{
//Ex.Message;
}
}
Please help.....