08 2011 档案
.net静态页 输出新闻列表,带分页
摘要：using System.Collections.Generic;using System.Linq;using System.Text;using System.Data.SqlClient;using System.Data;using System.IO;namespace helper{ public class helper { public static DataSet ExecuteDataset(string connString, CommandType txtType, string sql) { SqlConnection conn = new SqlConnection
自己总结的分页存储过程，不足之处请大家指点出来，我也努力更正
摘要：create procedure pagefunction --利用SQL 2005中的Row_number() ( @tblName varchar(255), -- 表名 @strGetFields varchar(1000) = '*', -- 需要返回的列 @OrderName varchar(255)='', -- 排序的字段名 @PageSize int = 10, -- 页尺寸 @PageIndex int = 1, -- 页码 @doCount bit = 0, -- 返回记录总数, 非 0 值则返回 @OrderType bit = 0, --
存储过程 递归删除
摘要：create proc [up_delete_nclass]@did int aswith my1 as(select * from NewsClass where id = @did union all select NewsClass.* from my1, NewsClass where my1.id = NewsClass.parentID)delete from NewsClass where exists (select id from my1 where my1.id = NewsClass.id)
