accessdatasource.aspx

来自「关于ASP.NET制作程序模块」· ASPX 代码 · 共 47 行

ASPX
47
字号
<%@ Page Language="C#" AutoEventWireup="true"  CodeFile="AccessDataSource.aspx.cs" Inherits="_Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>无标题页</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <table style="border:solid 1px green;width:40%">
            <tr>
                <td style="background-color:Green">
                    <strong><span style="font-size: 14pt; color: #ffffff">
                    使用AccessDataSource数据源</span></strong></td>
            </tr>
            <tr>
                <td>
                    <asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True"
                        AutoGenerateColumns="False" DataSourceID="AccessDataSource1" BackColor="White" BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px" CellPadding="3">
                        <Columns>
                            <asp:BoundField DataField="uid" HeaderText="uid" SortExpression="uid" />
                            <asp:BoundField DataField="uname" HeaderText="uname" SortExpression="uname" />
                            <asp:BoundField DataField="upwd" HeaderText="upwd" SortExpression="upwd" />
                        </Columns>
                        <FooterStyle BackColor="White" ForeColor="#000066" />
                        <RowStyle ForeColor="#000066" />
                        <SelectedRowStyle BackColor="#669999" Font-Bold="True" ForeColor="White" />
                        <PagerStyle BackColor="White" ForeColor="#000066" HorizontalAlign="Left" />
                        <HeaderStyle BackColor="#006699" Font-Bold="True" ForeColor="White" />
                    </asp:GridView>
                </td>
            </tr>
            <tr>
                <td>
                    <asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="~/App_Data/example.mdb"
                        SelectCommand="SELECT [uid], [uname], [upwd] FROM [person]"></asp:AccessDataSource>
                </td>
            </tr>
        </table>
    
    </div>
    </form>
</body>
</html>

⌨️ 快捷键说明

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