⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 sql-dbf.txt

📁 我在学习移动设备开发时
💻 TXT
字号:
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

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -