这么样创建ASP.NET 的数据库连接.

[flybird000]

我就一个页面用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

请各位帮忙！

[paul8765]

ADOConnectionMyConnection = new ADOConnection(MyConnString);
改成
ADOConnection MyConnection = new ADOConnection(MyConnString);

[brightheroes]

1:应该使用ADO.NET
2:应该CodeBeHind

[showjun]

.NET中各种数据库连接大全
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;"

[matchchen]

ADO.net结构图：http://matchchen.blogchina.com/blog/article_35952.239440.html

[czhenq]

楼主只声明了一个连接对象，还没打开连接
当然不能操作数据库了

加上

MyConnection.open();

使用Command对象必须显示的打开、关闭与数据库的连接