📄 sql-dbf.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 + -