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();
}