将ACCESS数据库绑定到Datagrid的简单例子 -- 非程序员作坊-- 编程爱好者博客

新建一个test.aspx文件内容如下：

<%@ Page Language="C#"%>
<%@ Import namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<html>
<head>
<script language="C#" runat="server">
private void Page_Load(Object Src, EventArgs E) {
    openUserDB();
}
// 打开用户数据库
private void openUserDB(){
  string connStr = "Provider=Microsoft.Jet.Oledb.4.0;Data Source="+Server.MapPath("test.mdb");
  string SQLStr = "SELECT * FROM [user]";
  OleDbConnection myConnection = new OleDbConnection(connStr);
  OleDbDataAdapter myCommand = new OleDbDataAdapter(SQLStr,myConnection);
  //myConnection.Open();//( 多余的！)
  DataSet ds=new DataSet();
  myCommand.Fill(ds,"dept");
  myConnection.Close();
  myConnection.Dispose();
  myCommand.Dispose();
     MyDataGrid.DataSource=ds.Tables["dept"].DefaultView;
     MyDataGrid.DataBind();
}
</script>
</head>
<body style="font: 10pt verdana">
<form runat="server" >
DataView 绑定到 DataGrid －访问test.mdb数据<br>
请将“test.mdb”(内含“USER”表)放到此文件（“test.aspx”）同一目录下
    <ASP:DataGrid id="MyDataGrid" runat="server"
      BackColor="#F4FFF4"
      BorderColor="black"
      ShowFooter="true"
      Font-Size="8pt"
      HeaderStyle-BackColor="lightblue"
    >
    </ASP:DataGrid>
</form>
</body>
</html>

博客介绍

正文

将ACCESS数据库绑定到Datagrid的简单例子 2006-05-15 09:54:00

评论