how to write data from data set in dotnet to paradox database in c#
In this code from Archive Sql Server database, Table named:tmsarcdat a
I want all the details from tmsarcdata table to move to paradox database
My paradox database path is: =@"D:\\ArchiveB ase\\CDFilesa"
This is the code I tried,but did not work:
private void button1_Click(o bject sender, System.EventArg s e)
{
try
{
string pPath=@"D:\\Arc hiveBase\\CDFil esa";
string strConnection = "Provider=Micro soft.Jet.OLEDB. 4.0;Data
Source="+pPath+ ";Extended Properties=Para dox 5.x;";
string command="select * from tmsarcdata";
OleDbCommand mCommand = new OleDbCommand();
OleDbConnection mConnection=new OleDbConnection (strConnection) ;
mConnection.Ope n();
mCommand.Comman dText=command;
mCommand.Execut eNonQuery();
}
catch(System.Ex ception Ex)
{
//Ex.Message;
}
}
Please help.....
In this code from Archive Sql Server database, Table named:tmsarcdat a
I want all the details from tmsarcdata table to move to paradox database
My paradox database path is: =@"D:\\ArchiveB ase\\CDFilesa"
This is the code I tried,but did not work:
private void button1_Click(o bject sender, System.EventArg s e)
{
try
{
string pPath=@"D:\\Arc hiveBase\\CDFil esa";
string strConnection = "Provider=Micro soft.Jet.OLEDB. 4.0;Data
Source="+pPath+ ";Extended Properties=Para dox 5.x;";
string command="select * from tmsarcdata";
OleDbCommand mCommand = new OleDbCommand();
OleDbConnection mConnection=new OleDbConnection (strConnection) ;
mConnection.Ope n();
mCommand.Comman dText=command;
mCommand.Execut eNonQuery();
}
catch(System.Ex ception Ex)
{
//Ex.Message;
}
}
Please help.....