C# Fail to save row to datatable from FoxPro DBF

Deal all:
Followings are my code for connect to Foxpro DBF file.
It show me "external data table is not right format expected."
Could any help!
I thank you in advance.

using System;
using System.Data;
using System.Data.OleDb;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace ConsoleApplication1
{
class Program
{
static void Main(string[] args)
    {
String m_database = "CO01M.dbf";
String m_sqlStr = "select * from " + m_database+" where row=100";
String m_otherStr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=J:\VISW; Extended Properties=dBASE IV; User ID=Admin; Password=;";

        DataTable myDataTable = new DataTable();
        OleDbConnection m_ConnectTo1M = new OleDbConnection();
        m_ConnectTo1M.ConnectionString = m_otherStr;                                                                                   
        try
        { m_ConnectTo1M.Open();
          
          OleDbDataAdapter mDataAdpter = new OleDbDataAdapter(m_sqlStr, m_ConnectTo1M);              
          Console.WriteLine(@"Connect to J:\VISW\successfully!");
          Console.WriteLine("m_ConnectTo1M.Provider= "+m_ConnectTo1M.Provider);
          Console.WriteLine("m_ConnectTo1M.Database= "+m_ConnectTo1M.Database);
          Console.WriteLine("m_ConnectTo1M.DataSource= " + m_ConnectTo1M.DataSource);
          Console.WriteLine("m_ConnectTo1M.State= " + m_ConnectTo1M.State);
          DataSet myDataSet = new DataSet();
          mDataAdpter.Fill(myDataSet); //<<====Here is point error occured.
          //myDataTable = myDataSet.Tables[0];
          m_ConnectTo1M.Close();
          Console.WriteLine("m_ConnectTo1M.State= " + m_ConnectTo1M.State);
        }
        catch (Exception ex)
        { Console.WriteLine(ex.Message); }
    }
}

}
Screen Shot

4 answers