datalist分页（cj168.DataAccess.MagsDB中的2个方法）-.NET教程,Asp.Net开发

public icollection getsearchresult(string txtsearch, int startindex, int pagesize)
        {
            
            sqlconnection myconnection = new sqlconnection(configurationsettings.appsettings["connectionstring"]);
            sqldataadapter mycommand = new sqldataadapter("getsearchresult", myconnection);
            
            mycommand.selectcommand.commandtype = commandtype.storedprocedure;
            
            sqlparameter parametertxtsearch = new sqlparameter("@txtsearch", sqldbtype.varchar, 255);
            parametertxtsearch.value = txtsearch;
            mycommand.selectcommand.parameters.add(parametertxtsearch);

            dataset mydataset = new dataset();
        
            mycommand.fill(mydataset, startindex, pagesize, "searchresult");
            
            return mydataset.tables["searchresult"].defaultview;

        }

        public int getsearchresultcount(string txtsearch)
        {
            int intcount ;
            intcount = 0;
            

            sqlconnection myconnection = new sqlconnection(configurationsettings.appsettings["connectionstring"]);
            sqlcommand mycommand = new sqlcommand("getsearchresultcount", myconnection);
            mycommand.commandtype = commandtype.storedprocedure;

            sqlparameter parametertxtsearch = new sqlparameter("@txtsearch", sqldbtype.varchar, 255);
            parametertxtsearch.value = txtsearch;
            mycommand.parameters.add(parametertxtsearch);

            myconnection.open();
            sqldatareader dr =mycommand.executereader();
            
            if(dr.read())
            {
                intcount = int32.parse(dr["co"].tostring());
            }
            else
            {
                intcount = 0;
            }
            
            dr.close();
            return intcount;

        }