C#连接VF数据库问题。

wangwang1103 2007-08-28 02:26:17

这是代码：

using System.Data.OleDb;
string str_conn="data source=E:\\Dbf库\\; provider=vfpoledb";
OleDbConnection oleconn_obj=new OleDbConnection();
oleconn_obj.ConnectionString=str_conn;
oleconn_obj.Open(); ----------此处有问题。报错事文件或者目录不对，当时我的dbf文件就放在此文件夹下

谢谢大家，看看到底是什么错误

...全文

147 6 打赏收藏转发到动态举报

写回复

用AI写文章

6 条回复

切换为时间正序

请发表友善的回复…

发表回复

开发者孙小聪 2011-06-21

打赏
举报



 //函数用于数据库中添加记录

        public static void DatasetAdd()

        {

            string strConn = @"Provider=vfpoledb;Data Source=E:\;Collating Sequence=machine;TABLEVALIDATE=0";

            using (OleDbConnection myConnection = new OleDbConnection(strConn))

            {

                myConnection.Open();

                OleDbDataAdapter adpt = new OleDbDataAdapter("select * from user_info.DBF", myConnection);

                OleDbCommandBuilder odcb = new OleDbCommandBuilder(adpt);

                DataSet mySet = new DataSet();

                adpt.Fill(mySet,"user_info");

                Console.WriteLine(mySet.Tables[0].Rows[0][1].ToString());

                DataRow myDataRow;

                DataTable myDataTable;

                myDataTable=mySet.Tables["user_info"];

                myDataRow = myDataTable.NewRow();

                myDataRow["number"]=2;

                myDataRow["user_name"] = "abc";

                myDataRow["user_password"] = "abc";

                myDataTable.Rows.Add(myDataRow);

                adpt.Update(mySet.GetChanges(),"user_info");

                mySet.Tables["user_info"].AcceptChanges();





                myConnection.Close();

                

                

            }

 

        }