• C#如何打开DBF数据库文件


    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);
                }
            }
        }
    }
  • 相关阅读:
    记账本第二天
    记账本第一天
    HDU 1811
    Codeforces Round #246 (Div. 2) D. Prefixes and Suffixes
    KMP超强模板贴一份
    2014辽宁省赛总结
    Codeforces Round #244 (Div. 2)
    CodeForces 383D Antimatter
    NEU 1351 Goagain and xiaodao's romantic story I
    UVA 10692 Huge Mod
  • 原文地址:https://www.cnblogs.com/China3S/p/5185915.html
Copyright © 2020-2023  润新知