asp.net操作mdb数据库
刚开始从asp升到asp.net,不知道如何用他来操作以前的数据库!
复制一段别人的代码都出错!
<% @ Page Language="C#" %>
<% @ Import Namespace="System.Data" %>
<% @ Import Namespace="System.Data.ADO" %>
<Script Language="C#" Runat="Server">
public void Page_Load(Objectsrc,EventArgs e)
{
string MyConnString = "Driver={Microsoft Access Driver (*.mdb)};DBQ=c:/test/test.mdb;";
string strComm = "select * from UserList order by id";
ADOConnection MyConnection = new ADOConnection(MyConnString);
ADODataSetcommand MyComm = new ADODataSetCommand(strComm,MyConnection);
DataSet MyDataSet = new DataSet();
MyComm.FillDataSet(MyDataSet,"UserList");
DataGrid1.DataSource = MyDataSet.Tables["UserList"].DefaultView;
DataGrid1.DataBind();
}
</script>
<html>
<head>
<title></title>
</head>
<body>
<form runat="server">
<ASP:DataGrid id="DataGrid1" runat="server"
BorderColor="black"
BorderWidth="1"
GridLines="Both"
CellPadding="3"
CellSpacing="0"
Font-Name="Verdana"
Font-Size="8pt"
HeaderStyle-BackColor="#aaaadd"
AlternatingItemStyle-BackColor="#eeeeee"
/>
</form>
</body>
</html>
先是这句,后来我把它//了,public void Page_Load(Objectsrc,EventArgs e)
然后这句有问题!是怎么回事!
叫我如何学啊!MyComm.FillDataSet(MyDataSet,"UserList");