<%@ Page Language="C#" AutoEventWireup="true"  CodeFile="Default.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>分组Group By查询</title>
    <style type="text/css">



        .style1
        {
            font-family: 华文琥珀;
            font-size: xx-large;
            color: #008000;
        }
        .style2
        {
            color: #008080;
            border-left-color: #ACA899;
            border-right-color: #C0C0C0;
            border-top-color: #ACA899;
            border-bottom-color: #C0C0C0;
            font-family: 华文细黑;
            font-weight: bold;
        }
    </style>
</head>
<body>

    <form id="form1" runat="server">
        <div>
    <table align="center" style="width: 460px">
        <tr>
            <td align="center" class="style1">
                <span class="style2">分组Group By查询</span>
                <br />
            </td>
        </tr>
        <tr>
            <td align="center">
                &nbsp; 请选择分组字段：<asp:DropDownList ID="DropDownList1" runat="server" 
                    Height="16px" Width="87px">
                    <asp:ListItem>职工号</asp:ListItem>
                    <asp:ListItem>供应商号</asp:ListItem>
                </asp:DropDownList>
&nbsp;&nbsp;&nbsp;&nbsp;
                <asp:Button ID="Button1" runat="server" Height="30px" Text=" 分组查询 " 
                    Width="92px" onclick="Button1_Click" />
                <br />
                <br />
            </td>
        </tr>
        <tr>
            <td align="center">
                &nbsp;
                <asp:GridView ID="GridView1" runat="server" BackColor="LightGoldenrodYellow" 
                    BorderColor="Tan" BorderWidth="1px" CellPadding="2" ForeColor="Black" 
                    GridLines="None" Height="163px" Width="437px">
                    <FooterStyle BackColor="Tan" />
                    <PagerStyle BackColor="PaleGoldenrod" ForeColor="DarkSlateBlue" 
                        HorizontalAlign="Center" />
                    <SelectedRowStyle BackColor="DarkSlateBlue" ForeColor="GhostWhite" />
                    <HeaderStyle BackColor="Tan" Font-Bold="True" />
                    <AlternatingRowStyle BackColor="PaleGoldenrod" />
                </asp:GridView>
            </td>
        </tr>
    </table>

    
    </div>
    </form>
</body>
</html>
