using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; namespace WindowsApplication4 { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void BindData(string table) { try { string str = table.Substring(0, table.LastIndexOf('\\')); using (System.Data.OleDb.OleDbConnection conn = new System.Data.OleDb.OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + str + ";Extended Properties=dBASE IV;User ID=Admin;Password=")) { conn.Open(); string sql = @"select * from " + table.Substring(table.LastIndexOf("\\")); System.Data.OleDb.OleDbDataAdapter da = new System.Data.OleDb.OleDbDataAdapter(sql, conn); DataTable dt = new DataTable(); da.Fill(dt); this.dataGridView1.DataSource = dt.DefaultView; } } catch (Exception ex) { MessageBox.Show(ex.Message); } } private void button1_Click(object sender, EventArgs e) { this.openFileDialog1.FileName = "*.DBF"; if (openFileDialog1.ShowDialog()== DialogResult.OK) { this.BindData(this.openFileDialog1.FileName); } } } }