sql-dbf.txt

来自「我在学习移动设备开发时」· 文本 代码 · 共 39 行

string mySelectQuery = "select *from t1"; 
        string connString = "Provider=Microsoft.Jet.OLEDB.4.0;
                             Data Source=D:\\t1.dbf;
                             Extended Properties=dBASE IV;
                             User ID=Admin;Password=";  
        



        OleDbConnection myConnection = new OleDbConnection(connString); 
        OleDbCommand myCommand = new OleDbCommand(mySelectQuery,myConnection); 
        myConnection.Open(); 
        OleDbDataAdapter Adapter = new OleDbDataAdapter(); 
        Adapter.SelectCommand=myCommand; 
        DataSet myDs = new DataSet(); 
        Adapter.Fill(myDs,"student"); 
        myConnection.Close(); 
        GridView1.DataSource = myDs.Tables[0].DefaultView; 
        GridView1.DataBind(); 

帮忙看看,为什么提示"'D:\t1.dbf'不是一个有效的路径。 确定路径名称拼写是否正确，以及是否连接到文件存放的服务器。"谢谢 (.net2.0) 



  Provider=Microsoft.Jet.OLEDB.4.0;
  User ID=Admin;
  Data Source=PrintDB.mdb;
  Mode=Share Deny None;
  Extended Properties="";
  Jet OLEDB:System database="";
  Jet OLEDB:Registry Path="";
  Jet OLEDB:Engine Type=5;
  Jet OLEDB:Database Locking Mode=1;
  Jet OLEDB:Global Partial Bulk Ops=2;
  Jet OLEDB:Global Bulk Transactions=1;
  Jet OLEDB:Create System Database=False;
  Jet OLEDB:Encrypt Database=False;
  Jet OLEDB:Don't Copy Locale on Compact=False;
  Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False