摘要：
1.排序datatable dtSJList=赋值;DataView dv = new DataView(dtSJList);dv.Sort = "souaddtime desc";//按时间进行倒序排序dtSJList = dv.ToTable();2.筛选datatable的Select方法例如： //进行模糊查找 protected void btnSearch_Click(object sender, ImageClickEventArgs e) { this.AspNetPager1.Visible = true; try { DataTable ds = ser 阅读全文
摘要：
replace("字段","内容","替换内容");例如：ALTER PROCEDURE [dbo].[UP_GetDateRanking] @Top int=0,@daytime datetime --查询日期ASBEGINDECLARE @st varchar(20); DECLARE @et varchar(20); SET @st=(Select CONVERT(varchar(100), @daytime, 23)+' 00:00:00'); SET @et=(Select CONVERT(varchar(1 阅读全文