datacontrolmdb.aspx

来自「asp.net1.1入门经典C#.2003」· ASPX 代码 · 共 36 行

ASPX
36
字号
<%@ Page Language="C#" %>
<%@ import Namespace="System.Data" %>
<%@ import Namespace="System.Data.OleDb" %>
<script runat="server">

    void Page_Load(Object sender, EventArgs e)
    {
       OleDbConnection objConnection;
       OleDbDataAdapter objCommand;
       String strConnect;
       String strCommand;
       DataSet DataSet1 = new DataSet();
    
       strConnect =  @"Provider=Microsoft.Jet.OLEDB.4.0;";
       strConnect += @"Data Source=C:\BegASPNET11\grocertogo.mdb;";
       strConnect += @"Persist Security Info=False";
    
       strCommand = "SELECT ProductName, UnitPrice FROM Products";
    
       objConnection = new OleDbConnection(strConnect);
       objCommand = new OleDbDataAdapter(strCommand, objConnection);
       objCommand.Fill(DataSet1, "products");
       DataGrid1.DataSource=DataSet1.Tables["Products"].DefaultView;
       DataGrid1.DataBind();
    }

</script>
<html>
<head>
    <title>Data Grid Control example</title>
</head>
<body>
    <asp:DataGrid id="DataGrid1" runat="server"></asp:DataGrid>
</body>
</html>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?