摘要：
<asp:TemplateField HeaderText="行号"> <EditItemTemplate> <asp:TextBox ID="TextBox1" runat="server" Text="<%# Container.DataItemIndex+1 %>" ></asp:TextBox> </EditItemTemplate> <ItemTemplate> <asp:Label ID="Label1& 阅读全文
摘要：
按小时select CONVERT(varchar(13),createdtime,120)+':00:00' as adddate1,count(*) as allhour from [User] group by CONVERT(varchar(13),CreatedTime ,120) --按日 selectsum([统计字段]),day([时间字段]) from 表明 whereyear([时间字段]) ='2009'groupbyday([时间字段]) --按周selectsum([统计字段]),datename(week,[时间字段]) from c 阅读全文