我的语句是这么写的:
private System.Data.SqlClient.SqlConnection nwindConn;
string Strcon = ConfigurationManager.ConnectionStrings["ShopConStr"].ToString();
nwindConn = new SqlConnection(Strcon);
nwindConn.Open();
web.config中的语句:
<add name ="ShopConStr" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\dbShop.mdb;user id=Admin;Password=;"/> 每次都出现上面的错误,请问是哪里出错?
private System.Data.SqlClient.SqlConnection nwindConn;
string Strcon = ConfigurationManager.ConnectionStrings["ShopConStr"].ToString();
nwindConn = new SqlConnection(Strcon);
nwindConn.Open();
web.config中的语句:
<add name ="ShopConStr" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\dbShop.mdb;user id=Admin;Password=;"/> 每次都出现上面的错误,请问是哪里出错?
解决方案 »
- onclick 事件
- repeater 嵌套 protected void repeater1_ItemDataBound(object sender, RepeaterItemEventArgs e) 无法将类型为“System.Data.Common.DbDataRecor
- 關於:Error 16:The type name 'CustomTextBox' does not exist in the type 'CustomControl.CustomControl'
- 数据提交过程的显示等待画面
- 哪位大哥给个更新的例子!
- 未处理SqlExection怎么处理啊!弄了半天都没有弄出来
- 数据绑定的小程序
- 兄弟们,学了一年多的asp.net。第一次遇到这样怪的问题。给100分。
- javascript设置Treeview中的checkbox问题.
- 点击链接下载的问题
- 求横向下拉菜单实例一个!!
- dataset中多表怎么绑定
ODBC
Standard Security:"Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Uid=Admin;Pwd=;" Workgroup:"Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;SystemDB=C:\mydatabase.mdw;" Exclusive:"Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Exclusive=1;Uid=admin;Pwd=" OLE DB, OleDbConnection (.NET)
Standard security:"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;User Id=admin;Password=;" Workgroup (system database):"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;Jet OLEDB:System Database=system.mdw;" With password:"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;Jet OLEDB:Database Password=MyDbPassword;"
命名空间是SqlClient OR OleDb????
DataSet ds = new DataSet();
nwindConn = new OleDbConnection(Strcon);
nwindConn.Open(); OleDbDataAdapter myDa = new OleDbDataAdapter();
OleDbCommand sqstr; sqstr = new OleDbCommand("select * from shoplist", nwindConn);
myDa.SelectCommand = sqstr;
myDa.Fill(ds, "稿件"); GDataList.DataSource = ds;
GDataList.DataBind();
ds.Dispose();
sqstr.Dispose();
myDa.Dispose();
nwindConn.Close();
nwindConn.Dispose();