using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.OleDb;
using System.Data;
using System.Collections;
using System.IO;
 
namespace View_DBF_File.DAL
{
    public class DataAccessLayer
    {
        #region Properties
        private string ConnectionString
        {
            get
            {
                return View_DBF_File.Properties.Settings.Default.DBFConnStr;
            }
        }
        private OleDbConnection DBF_Connection
        {
            get
            {
                if (this.dbfConnection == null)
                {
                    this.dbfConnection = new OleDbConnection(this.ConnectionString);
                }
                return this.dbfConnection;
            }
        }
 
        #endregion
 
        #region Fields
        private OleDbConnection dbfConnection;
        private OleDbDataAdapter tableAdapter;  
        //private DataTable all_DBF_File;
        #endregion
 
 
        private OleDbDataAdapter DBF_Table
        {
            get
            {
                if (this.tableAdapter == null)
                {
                    this.tableAdapter = new OleDbDataAdapter();
 
                    OleDbCommand dbfCommand = new OleDbCommand();
                    dbfCommand.CommandText = " select * from @tableName";
                    dbfCommand.CommandType = CommandType.Text;
                    dbfCommand.Connection = this.DBF_Connection;
 
                    OleDbParameter mySqlParameter =
                        new OleDbParameter("@tableName", OleDbType.VarChar, 0);
                    //MySqlParameter.Direction = ParameterDirection.Input;
 
                    this.tableAdapter.SelectCommand = dbfCommand;
                }
                return this.tableAdapter;
            }
        }
 
        public DataTable GetDBF_Table(string tableName)
        {
            this.DBF_Table.SelectCommand.Parameters["@tableName"].Value = tableName;
 
            try
            {
                DataTable classes = new DataTable("Table");
                this.DBF_Table.Fill(classes);
                return classes;
            }
            catch
            {
                return null;
            }
        }
    }
}

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 View_DBF_File.DAL;
using System.Collections;
using System.IO;
 
namespace View_DBF_File
{
    public partial class MainForm : Form
    {
 
 
        public MainForm()
        {
            InitializeComponent();
        }
        public DataAccessLayer DataAccessLayer
        {
            get
            {
                if (this.DataAccessLayer == null)
                {
                    this.m_dataAccessLayer = new DataAccessLayer();
                }
                return this.m_dataAccessLayer;
            }
        }
        private DataAccessLayer m_dataAccessLayer;
        public DataTable DBF_Table
        {
            get
            {
                return this.DataAccessLayer.GetDBF_Table(Path.GetFileName(cb_Files.Text.Trim()));
            }
        }
        private void bt_Review_Click(object sender, EventArgs e)
        {
            this.dgv_Review.DataSource = this.DBF_Table;
 
        }
 
        private void cb_Files_Click(object sender, EventArgs e)
        {
 
            cb_Files.Items.Clear();
            foreach (string File in Directory.GetFiles("D:\\KVPLATA\\BAZA6"))
            {
                cb_Files.Items.Add(Path.GetFileName(File));
            }
        }
    }
}

public DataAccessLayer DataAccessLayer
        {
            get
            {
                if (this.DataAccessLayer == null)
                {
                    this.m_dataAccessLayer = new DataAccessLayer();
                }
                return this.m_dataAccessLayer;
            }
        }

public DataTable GetDBF_Table(string tableName)
        {
            if (this.tableAdapter == null)
            {
                this.tableAdapter = new OleDbDataAdapter();

                OleDbCommand dbfCommand = new OleDbCommand();
                dbfCommand.CommandText = String.Format(@" select * from {0}", tableName);// " select * from @tableName";
                dbfCommand.CommandType = CommandType.Text;
                dbfCommand.Connection = this.DBF_Connection;

                OleDbParameter dbfParameter =
                    new OleDbParameter("@tableName", OleDbType.VarChar, 0);
                //MySqlParameter.Direction = ParameterDirection.Input;

                this.tableAdapter.SelectCommand = dbfCommand;
                this.tableAdapter.SelectCommand.Parameters["@tableName"].Value = tableName;
                try
                {
                    DataTable classes = new DataTable("Table");
                    this.tableAdapter.Fill(classes);
                    return classes;
                }
                catch
                {
                    return null;
                }
            }
            return null;
        }