摘要：
public class PageNums{ /// </summary> /// <param name="ds">DataSet实例</param> /// <param name="datalistname">DataList名称</param> /// <param name="pagesize">分页大小</param> public static string GetPageNum(DataTable ds, DataList datali 阅读全文
摘要：
存储过程1create PROCEDURE gettotalnums(@TableNames NVARCHAR(200),@Filter nvarchar(200))AS IF @Filter = '' SET @Filter = ' WHERE 1=1' ELSE SET @Filter = ' WHERE ' + @Filter EXECUTE('select count(*) from '+@TableNames+' '+@Filter)存储过程2create PROCEDURE [fenye]@TableN 阅读全文
摘要：
delete from Userinfo where userid in (select userid from Userinfo group by userid having count(userid) > 1)and uid not in (select min(uid) from Userinfo group by userid having count(userid )>1) 阅读全文