统计重复数据的总数且只显示重复数据的一条记录

来源：互联网发布：python ui选择编辑：程序博客网时间：2024/05/12 02:58

统计重复数据的总数且只显示重复数据的一条记录 aspx

                     <asp:Repeater ID="TransFer" runat="server">
                        <HeaderTemplate>
                        <table width="100%" border="0" cellpadding="0" cellspacing="0" class="table">
                            <tr>
                               <td class="hback" style="height:33px; text-align:center; width:5%; background:#F1D4D8;"> </td>
                               <td class="hback" style="text-align:center; width:10%; background:#F1D4D8;">点击量</td>
                               <td class="hback" style="text-align:center; background:#F1D4D8;">来源网址</td>
                            </tr>
                        </HeaderTemplate>
                        <ItemTemplate>
                            <tr onMouseOver="overColor(this)" onMouseOut="outColor(this)">
                               <td class="hback" style="height:33px; text-align:center; width:5%;"> </td>
                               <td class="hback" style="text-align:center; width:10%;"><%# Eval("countads")%></td>
                               <td class="hback" style="text-align:left; padding-left:10px;"><%# Eval("OriginUrl") %></td>
                            </tr>
                        </ItemTemplate>
                        <FooterTemplate>
                        </table>
                        </FooterTemplate>
                    </asp:Repeater>

aspx.cs

    protected void Page_Load(object sender, EventArgs e)
    {
        Encode.IsLogin();
        string ID = Request.QueryString["id"];
        if (!Page.IsPostBack)
        {

string sql = "select OriginUrl,count( AdsID ) countads from AdsStat where AdsID='" + ID + "' group by OriginUrl";
SqlDataReader sdr = GS.ExecSqlDataReader(sql);

            TransFer.DataSource = GS.ExecSqlDataReader(sql);
            TransFer.DataBind();
        }
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        string Kstime = kstime.Text.ToString();
        string Endtime = endtime.Text.ToString();
        string ID = Request.QueryString["id"];

//Response.Write(" kj");

string sql = "select OriginUrl,count( AdsID ) countads from AdsStat where AdsID='" + ID + "' and (CONVERT(varchar(20),'" + Kstime + "',120) < CONVERT(varchar(20),AddTime,120)) and (CONVERT(varchar(20),AddTime,120) < CONVERT(varchar(20),'" + Endtime + "',120)) group by OriginUrl";
SqlDataReader sdr = GS.ExecSqlDataReader(sql);

TransFer.DataSource = GS.ExecSqlDataReader(sql);
TransFer.DataBind();

}