connect to paradox db from sqlserver database table

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • =?Utf-8?B?dmlzaHJ1dGg=?=

    connect to paradox db from sqlserver database table

    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.....

Working...