不知道啊,,下参考:lj=new sqlconnection("server=aaa;uid=sa;pwd=aaa;database=bbb")//sql数据库
lj=new OleDbConnection("Provider=Microsoft.Jet.OleDb.4.0;Data Source=d:\\asp.net\\sbd\\ls.mdb");//access数据库如有密码,则使用:Jet OLEDB:Database Password=ccc
lj=new OleDbConnection("Provider=Microsoft.Jet.OleDb.4.0;Data Source=d:\\asp.net\\sbd\\ls.mdb;Jet OLEDB:Database Password=ccc");lj=new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\\asp.net\\dbo;Extended Properties=dBASE 5.0");//foxpro数据库OleDbDataAdapter cmd=new OleDbDataAdapter("select * from pyz",lj);
DataSet ds=new DataSet();
cmd.Fill(ds,"pyz");
DataGrid1.DataSource=ds.Tables["pyz"];
DataGrid1.DataBind();
lj=new OleDbConnection("Provider=Microsoft.Jet.OleDb.4.0;Data Source=d:\\asp.net\\sbd\\ls.mdb");//access数据库如有密码,则使用:Jet OLEDB:Database Password=ccc
lj=new OleDbConnection("Provider=Microsoft.Jet.OleDb.4.0;Data Source=d:\\asp.net\\sbd\\ls.mdb;Jet OLEDB:Database Password=ccc");lj=new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\\asp.net\\dbo;Extended Properties=dBASE 5.0");//foxpro数据库OleDbDataAdapter cmd=new OleDbDataAdapter("select * from pyz",lj);
DataSet ds=new DataSet();
cmd.Fill(ds,"pyz");
DataGrid1.DataSource=ds.Tables["pyz"];
DataGrid1.DataBind();
"Driver={Microsoft dBASE Driver (*.dbf)};DriverID=277;Dbq=c:\mydbpath;"
ODBC
Standard Security:
"Driver={Microsoft Access Driver (*.mdb)};Dbq=\somepath\mydb.mdb;Uid=Admin;Pwd=asdasd;"
Workgroup:
"Driver={Microsoft Access Driver (*.mdb)};Dbq=\somepath\mydb.mdb;SystemDB=\somepath\mydb.mdw;","admin",