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));
            }
        }
    }
}