sqldatasource.aspx

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

ASPX
40
字号
<%@ Page Language="C#" AutoEventWireup="true"  CodeFile="sqldatasource.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">
                    <span style="font-size: 14pt; color: #ffffff"><strong>
                    使用SqlDataSource数据源控件</strong></span></td>
            </tr>
            <tr>
                <td>
                    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource1" AllowPaging="True" AllowSorting="True">
                        <Columns>
                            <asp:BoundField DataField="OrderID" HeaderText="OrderID" InsertVisible="False" ReadOnly="True"
                                SortExpression="OrderID" />
                            <asp:BoundField DataField="ShipName" HeaderText="ShipName" SortExpression="ShipName" />
                        </Columns>
                    </asp:GridView>
                </td>
            </tr>
            <tr>
                <td>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>" SelectCommand="SELECT DISTINCT [OrderID], [ShipName] FROM [Orders]"></asp:SqlDataSource>
                </td>
            </tr>
        </table>
    
    </div>
    </form>
</body>
</html>

⌨️ 快捷键说明

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