C# 读取dbf文件中的数据到datatable中

最新推荐文章于 2022-04-07 08:54:12 发布

withdreams

最新推荐文章于 2022-04-07 08:54:12 发布

阅读量5k

点赞数

分类专栏： C# 数据库文章标签： dbf

本文链接：https://blog.csdn.net/withdreams/article/details/14120093

版权

C# 同时被 2 个专栏收录

11 篇文章 0 订阅

订阅专栏

数据库

7 篇文章 0 订阅

订阅专栏

方式一：通过ODBC读取代码如下

/// <summary>

/// 读取dbf文件中的数据如所在目录为E:\manman\aa.dbf
/// </summary>
/// <param name="tableName">要读取的表名（也就是文件名）aa</param>
/// <param name="defaultDir">文件所在的路径不包括文件名E:\manman</param>
/// <returns></returns>

private DataTable GetDbfDataByODBC(string tableName, string defaultDir)
        {
            OdbcConnection oConn = new System.Data.Odbc.OdbcConnection();
            oConn.ConnectionString = "Driver={Microsoft dBase Driver (*.dbf)};DefaultDir=" + defaultDir;
            oConn.Open();
            OdbcDataAdapter odbcDataAdapt = new OdbcDataAdapter("select * from " + tableName, oConn.ConnectionString);
            DataTable dtData = new DataTable();
            dtData.TableName = "gb";
            odbcDataAdapt.Fill(dtData);
            oConn.Close();
            return dtData;
        }

方式二：通过VFP读取，不过这需要装VFPOLEDB.1驱动代码如下

/// <summary>
        /// 读取dbf文件中的数据如所在目录为E:\manman\aa.dbf
        /// </summary>
        /// <param name="tableName">要读取的表名（也就是文件名）aa</param>
        /// <param name="tablePath">文件所在的路径不包括文件名E:\manman\aa.dbf</param>
        /// <returns></returns>

private OleDbDataReader DbfToDs(string tableName,string tablePath)
        {
            string my_StrSel = @"select * from " + tableName;
            OleDbConnection mycon = new OleDbConnection("Provider=VFPOLEDB.1;Data Source=" + tablePath + ";collating Sequence=MACHINE");
            OleDbCommand mycom = new OleDbCommand(my_StrSel, mycon);
            mycon.Open();
            OleDbDataReader myreader = mycom.ExecuteReader();

            return myreader;
        }
        private DataTable GetDbfData(string tableName,string tablePath)
        {

            OleDbDataReader myreader=null ;
            try
            {
                myreader   = DbfToDs(tableName,tablePath);
                DataTable tab = new DataTable() ;
                for (int i = 0; i < myreader.VisibleFieldCount;i++ )
                {
                    tab.Columns.Add(myreader.GetName(i),myreader.GetFieldType(i));
                }
                DataRow row;
                while (myreader .Read ())
                {
                    row = tab.NewRow();
                    for (int i = 0; i < tab.Columns.Count;i ++ )
                    {
                        row[i] = myreader.GetValue(i);
                    }
                    tab.Rows.Add(row );
                }
                return tab;
            }
            catch (Exception ex)
            {
                Message.Show(ex.Message);
                return null;
            }

        }