chaxun/kehu.aspx

微信扫码关注公众号，代码整理好后第一时间通知你。

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="kehu.aspx.cs" Inherits="chaxun_kehu" %>

<!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 id="Head1" runat="server">

<link href="../images/Style.css" rel="stylesheet" type="text/css">
    <title>无标题页</title>
</head>
<body>
<br>
    <form id="form1" runat="server">

<div class=formzone>
<div class=namezone>客户列表</div>
<DIV class=listzone>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" BackColor="White" 
                    BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px" 
        CellPadding="3"  Width="98%" AllowPaging="True"  
        OnPageIndexChanging="GridView1_PageIndexChanging"
        DataSourceID="SqlDataSource1" EnableModelValidation="True">
<RowStyle ForeColor="#000066"  />
                    <Columns>
                    
                     
  <asp:BoundField DataField="khlb" HeaderText="客户类别"  SortExpression="khlb" />
 
      <asp:BoundField DataField="num" HeaderText="数量"  SortExpression="num" />
                    </Columns>
                <FooterStyle BackColor="White" ForeColor="#000066" />
                    <PagerStyle BackColor="White" ForeColor="#000066" 
        HorizontalAlign="Left" />
                    <SelectedRowStyle BackColor="#669999" Font-Bold="True" 
        ForeColor="White" />
                    <HeaderStyle BackColor="#006699" Font-Bold="True" 
        ForeColor="White" />
    </asp:GridView>
</DIV>

    <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
        ConnectionString="<%$ ConnectionStrings:DConnectionString %>" 
        SelectCommand="SELECT a.khlb,count(1) as num FROM kehu a,xiaoshou b where a.khxm=b.kh group by a.khlb">
    </asp:SqlDataSource>
<DIV class=adminsubmit></div>
</div>


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