我就一个页面用C#做的,为什么连接数据库会出错!
代码:
<% @ Page Language="C#" %>
<% @ Import Namespace="System.Data" %>
<% @ Import Namespace="System.Data.ADO" %>
<Script Language="C#" Runat="Server">
//联结语句
string MyConnString = "Driver={Microsoft Access Driver (*.mdb)};DB=C:/TEST.mdb;";
string strComm = "select * from UserList order by id";
//打开一个联结
ADOConnectionMyConnection = new ADOConnection(MyConnString);
//打开两个DataSetCommand
ADODataSetCommandMyComm = new ADODataSetCommand(strComm,MyConnection); DataSetMyDataSet = new DataSet(); //把UserList,BookList表存入DataSet
MyComm.FillDataSet(MyDataSet,"UserList"); DataGrid1.DataSource = MyDataSet.Tables["UserList"].DefaultView;
DataGrid1.DataBind();
</script>
错误代码:
行 7: string strComm = "select * from UserList order by id";
行 8: //打开一个联结
行 9: ADOConnectionMyConnection = new ADOConnection(MyConnString);
行 10:
行 11: //打开两个DataSetCommand 请各位帮忙!
代码:
<% @ Page Language="C#" %>
<% @ Import Namespace="System.Data" %>
<% @ Import Namespace="System.Data.ADO" %>
<Script Language="C#" Runat="Server">
//联结语句
string MyConnString = "Driver={Microsoft Access Driver (*.mdb)};DB=C:/TEST.mdb;";
string strComm = "select * from UserList order by id";
//打开一个联结
ADOConnectionMyConnection = new ADOConnection(MyConnString);
//打开两个DataSetCommand
ADODataSetCommandMyComm = new ADODataSetCommand(strComm,MyConnection); DataSetMyDataSet = new DataSet(); //把UserList,BookList表存入DataSet
MyComm.FillDataSet(MyDataSet,"UserList"); DataGrid1.DataSource = MyDataSet.Tables["UserList"].DefaultView;
DataGrid1.DataBind();
</script>
错误代码:
行 7: string strComm = "select * from UserList order by id";
行 8: //打开一个联结
行 9: ADOConnectionMyConnection = new ADOConnection(MyConnString);
行 10:
行 11: //打开两个DataSetCommand 请各位帮忙!
解决方案 »
- 用VS2008创建单元测试的时候,出现的标记是[TestMethod()],但看到别人代码里是[Test],后者是什么作用?
- ASP.net,access,日期字段怎么赋空值
- 请问如何冻结DataGrid中的列啊??
- 如何使文件路径“c:\inetpub\wwwroot\WebApplication1”与URL“http://localhost/WebApplication1”映射到相同的服务器位置。高手指点!
- 关于datagrid分页的问题!请高手赐教!
- 请在深圳的介绍一下有没有好的软件培训机构
- 问一个关于权限判断的问题!
- 表单如何带参数提交?
- 急急急这个代码怎么能改下在ASP.NET下能用在线等了
- 求问~数据库操作方式:ADO.NET、微软企业库、ORM(如Dapper)?
- 怎么找到这个控件呢
- Excel数据导入DataGrid中如何剔除Excel中重复的数据?
改成
ADOConnection MyConnection = new ADOConnection(MyConnString);
2:应该CodeBeHind
SQL Server
Standard Security:
"Driver={SQL Server};Server=Aron1;Database=pubs;Uid=sa;Pwd=asdasd;"
Trusted connection:
"Driver={SQL Server};Server=Aron1;Database=pubs;Trusted_Connection=yes;"
Prompt for username and password:
oConn.Properties("Prompt") = adPromptAlways
oConn.Open "Driver={SQL Server};Server=Aron1;DataBase=pubs;"
OLEDB, OleDbConnection (.NET)
Standard Security:
"Provider=sqloledb;Data Source=Aron1;Initial Catalog=pubs;User Id=sa;Password=asdasd;"
Trusted Connection:
"Provider=sqloledb;Data Source=Aron1;Initial Catalog=pubs;Integrated Security=SSPI;"
(use serverName\instanceName as Data Source to use an specifik SQLServer instance, only SQLServer2000)
Prompt for username and password:
oConn.Provider = "sqloledb"
oConn.Properties("Prompt") = adPromptAlways
oConn.Open "Data Source=Aron1;Initial Catalog=pubs;"
当然不能操作数据库了加上MyConnection.open();使用Command对象必须显示的打开、关闭与数据库的连接