资源描述:
《C#,GridView_DataList存储过程分页(效率高)》由会员上传分享,免费在线阅读,更多相关内容在教育资源-天天文库。
1、C#GridViewDataList存储过程分页(效率高)2010-06-0920:32:51作者:佚名来源:浏览次数:0protectedvoidbindlist(){SqlConnectionmyConnection=newSqlConnection(ConfigurationManager.ConnectionStrings["Netconntiong"].ConnectionString);SqlCommandcommand=newSqlCoprotectedvoidbindlist(){SqlConnectionmyConnection=newSqlConnec
2、tion(ConfigurationManager.ConnectionStrings["Netconntiong"].ConnectionString);SqlCommandcommand=newSqlCommand();//获取数据库连接字符串,生成新的数据库连接对象.SqlCommandmyCommand=newSqlCommand("Tech_SearchListzgbfwTion",myConnection);//标记数据库访问对象的命令类型为存储过程.myCommand.CommandType=CommandType.StoredProcedure;intpa
3、geindex=0;if(Request.QueryString["selectis"]=="1"){key=Server.HtmlDecode(Request.QueryString["keys"]);}else{key="";}//stringstrWhere="";if(AspNetPager1.CurrentPageIndex<1){pageindex=1;}else{pageindex=AspNetPager1.CurrentPageIndex;}SqlParameter[]parameters={newSqlParameter("@tblname",SqlDb
4、Type.VarChar,255),newSqlParameter("@strGetFields",SqlDbType.VarChar,1000),newSqlParameter("@fldName",SqlDbType.VarChar,255),newSqlParameter("@pagesize",SqlDbType.Int,4),newSqlParameter("@pageindex",SqlDbType.Int,4),newSqlParameter("@doCount",SqlDbType.Bit),newSqlParameter("@ordertype",Sql
5、DbType.Bit),newSqlParameter("@strwhere",SqlDbType.VarChar,2000),newSqlParameter("@key",SqlDbType.VarChar,2000)};parameters[0].Value="expertadd";//数据表parameters[1].Value="id,title,Company,Content,tel,date";parameters[2].Value="date";parameters[3].Value=AspNetPager1.PageSize;//多少条为一页paramet
6、ers[4].Value=pageindex;//索引页parameters[5].Value=0;//这里写死0就行了parameters[6].Value=1;//这里的1是降序,0为升序parameters[7].Value="andclassid=1andonhot=1";//查询条件组合parameters[8].Value=key;//查询条件组合foreach(SqlParameterpinparameters){myCommand.Parameters.Add(p);}SqlDataAdaptersda=newSqlDataAdapter(myComman
7、d);DataSetds=newDataSet();sda.Fill(ds);//动态设置用户自定义文本内容AspNetPager1.RecordCount=int.Parse(ds.Tables[1].Rows[0][0].ToString());AspNetPager1.CustomInfoText="共"+AspNetPager1.RecordCount.ToString()+"条,";AspNetPager1.CustomInfoText+="总页数"+AspNetPager1.PageCount.ToString()