private void Connection()
        {
            server = "localhost";
            database = "dbf";
            uid = "root";
            password = "88888";
            string connectionString;
            connectionString = "SERVER=" + server + ";" + "DATABASE=" + database + ";" + "UID=" + uid + ";" + "PASSWORD=" + password + ";";
            mysql_connection = new MySqlConnection(connectionString);

            OleDbConnection DBFconn = new OleDbConnection(@"Provider=VFPOLEDB.1;data source=C:\\sisarm.dbf;");
           
            DataSet DBFds = new DataSet();
            DataSet MySQLds = new DataSet();

            DBFconn.Open();

           OleDbDataAdapter dbfAd = new OleDbDataAdapter("SELECT * FROM sisarm", DBFconn);
             dbfAd.Fill(DBFds, "sisarm");
           label1.Text = DBFds.Tables[ 0 ].Rows.Count.ToString();

            mysql_connection.Open();
            MySqlDataAdapter mysqlAd = new MySqlDataAdapter("SELECT * FROM sisarm",mysql_connection);
            mysqlAd.Fill(MySQLds, "sisarm");

            foreach (DataRow row in DBFds.Tables["sisarm"].Rows)
            {

                MySQLds.Tables[ 0 ].NewRow();

              MySQLds.Tables[ 0 ].Rows.Add(row.ItemArray);

            }

            MySqlCommandBuilder cmd = new MySqlCommandBuilder(mysqlAd);
            mysqlAd.Update(MySQLds, "sisarm");
            label2.Text += "<br />MySql myTables: " + MySQLds.Tables[ 0 ].Rows.Count.ToString() + " records found <hr />";

        
        }

OleDbDataAdapter dbfAd = new OleDbDataAdapter("SELECT * FROM S_NAM_PR where between(recno(),1000,2000)", DBFconn);