datalist分頁（cj168.DataAccess.MagsDB中的2個方法）

2024-09-07 19:04:55

字體：大中小

來源：轉載

供稿：網友

商業源碼熱門下載www.html.org.cn

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;

        }

上一篇：圖片上傳到數據庫并顯示（C#+Access）

下一篇：C#連接ACCESS和SQL2000