using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.Odbc;
namespace WorkDBF
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {

        }
        class WorkDBF
        {
            private OdbcConnection Conn = null;
            public DataTable Execute(string Command)
            {
                DataTable dt = null;
                if (Conn != null)
                {
                    try
                    {
                        Conn.Open();
                        dt = new DataTable();
                        System.Data.Odbc.OdbcCommand oCmd = Conn.CreateCommand();
                        oCmd.CommandText = Command;
                        dt.Load(oCmd.ExecuteReader());
                        Conn.Close();
                    }
                    catch (Exception e)
                    {
                        MessageBox.Show(e.Message);
                    }
                }
                return dt;
            }
            //string DB_path = "E:\\ANALIZ.DBF";
           
            public DataTable GetAll(string DB_path)
            {
                return Execute("SELECT * FROM " + DB_path);
            }

            public WorkDBF()
            {
                this.Conn = new System.Data.Odbc.OdbcConnection();
                Conn.ConnectionString = @"Driver={Microsoft dBase  Driver (*.dbf)};" +
                       "SourceType=DBF;Exclusive=No;" +
                       "Collate=Machine;NULL=NO;DELETED=NO;" +
                       "BACKGROUNDFETCH=NO;";
            }
        }

        private void button1_Click(object sender, EventArgs e)
        {
            WorkDBF WDBF = new WorkDBF();
            dataGridView1.DataSource = WDBF.GetAll("E:\\ANALIZ.DBF");
            dataGridView2.DataSource = WDBF.Execute("SELECT id, name FROM E:\\ANALIZ.DBF");
        }
    }
}

namespace WorkDBF
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            OdbcConnection conn = new OdbcConnection();

            conn.ConnectionString = @"Driver={Microsoft dBASE Driver (*.dbf)}";

            //объявляем команду создания новой таблички dbf
            OdbcCommand cmd_create = new OdbcCommand(@"CREATE TABLE [{0}] " + "(itemName Char(40), itemValue Numeric,  itemInfo Char(150))", conn);

            conn.Open(); //открываем соединение
            cmd_create.ExecuteNonQuery(); //выполняем команду
            conn.Close();//закрываем соединение
        }

System.Data.OleDb.OleDbConnection conn = new System.Data.OleDb.OleDbConnection("Provider=VFPOLEDB.1;Data Source=e:\\");
System.Data.OleDb.OleDbDataAdapter da = new System.Data.OleDb.OleDbDataAdapter("SELECT * FROM ANALIZ.DBF", conn);
conn.Open();
da.Fill(ds);