private void Page_Load(object sender, System.EventArgs e) {
// 在此处放置用户代码以初始化页面 if( !Page.IsPostBack ) {
if(Request.QueryString["page"] == null) {
//第一次开启页面时默认传递的页码参数为1 DataBindDg2(1); } else {
DataBindDg2(int.Parse(Request.QueryString["page"].ToString())); } } }
private void DataBindDg2(int intPage) {
string str1 = " select * from Mobile ";//不带排序语句的SQL语句 int intRecsPerPage = 10;//每页容纳的记录数
string strID = " MobileID ";//需要排序的不重复的ID号 string strSort = " MobileID ";//排序字段及规则
string strTBName = "Mobile";//数据库当中的要提取数据的表
SqlConnection con = new SqlConnection("uid=sa;pwd=123456;database=Test;"); SqlCommand cmd = new SqlCommand("Proc_Paging",con); http://www.77cn.com.cnmandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@SQL",SqlDbType.NVarChar,4000)); cmd.Parameters.Add(new SqlParameter("@Page",SqlDbType.Int)); cmd.Parameters.Add(new SqlParameter("@RecsPerPage",SqlDbType.Int)); cmd.Parameters.Add(new SqlParameter("@ID",SqlDbType.NVarChar,255)); cmd.Parameters.Add(new SqlParameter("@Sort",SqlDbType.NVarChar,255)); cmd.Parameters.Add(new SqlParameter("@TBName",SqlDbType.NVarChar,255)); SqlParameter parameterPageCount = new SqlParameter("@PageCount",SqlDbType.Int); parameterPageCount.Direction = ParameterDirection.Output; cmd.Parameters.Add(parameterPageCount); cmd.Parameters["@SQL"].Value = str1; cmd.Parameters["@Page"].Value = intPage;
cmd.Parameters["@RecsPerPage"].Value = intRecsPerPage; cmd.Parameters["@ID"].Value = strID; cmd.Parameters["@Sort"].Value = strSort;
13 / 19