else  set @sql='select top '+str(@pagesize) +' * from ( select top '+str(@recordcount - @pagesize * @pageindex)+' productid,productname, unitprice from products order by productid desc) temptable order by productid asc' exec(@sql)go好了，存儲過程建好了，那么如何在.net中使用呢？請看以下代碼：

        private uint pagecount;  //總頁數         private uint recordcount;  //總記錄數

        private dataset getpagedata(uint pagesize, uint pageindex)

        {

            string strconn = system.configuration.configurationsettings.appsettings["connectionstring"];           

            sqlconnection conn = new sqlconnection(strconn);

            conn.open();

            sqlcommand command = new sqlcommand("getcustomdatapage",conn);  //第一個參數為存儲過程名

            command.commandtype = commandtype.storedprocedure;   //聲明命令類型為存儲過程

            command.parameters.add("@pagesize",sqldbtype.int);

            command.parameters["@pagesize"].value = pagesize;

            command.parameters.add("@pageindex",sqldbtype.int);

            command.parameters["@pageindex"].value = pageindex;

            command.parameters.add("@pagecount",sqldbtype.int);

            command.parameters["@pagecount"].value = pagecount;

            command.parameters["@pagecount"].direction = parameterdirection.output;  //存儲過程中的輸出參數

            command.parameters.add("@recordcount",sqldbtype.int);

            command.parameters["@recordcount"].value = recordcount;

            command.parameters["@recordcount"].direction = parameterdirection.output; //存儲過程中的輸出參數

            sqldataadapter adapter = new sqldataadapter(command);

            dataset ds = new dataset();

            adapter.fill(ds);           

            //獲得輸出參數值

            pagecount = convert.touint32(command.parameters["@pagecount"].value);

            recordcount = convert.touint32(command.parameters["@recordcount"].value);

            conn.close();

            return ds;

        }

        //綁定數據到datagrid中

        private void binddatagrid()

        {

            dataset ds = getpagedata((uint)dgproduct.pagesize,(uint)dgproduct.currentpageindex);

            dgproduct.virtualitemcount = (int)recordcount;

            dgproduct.datasource = ds;

            dgproduct.databind();

        }

        //頁面加載時就綁定datagrid

        private void page_load(object sender, system.eventargs e)

        {

            if(!page.ispostback)

            {

               binddatagrid();

            }

        }

        //用戶翻頁時事件處理

        private void dgproduct_pageindexchanged(object source, system.web.ui.webcontrols.datagridpagechangedeventargs e)

        {

            dgproduct.currentpageindex = e.newpageindex;

            binddatagrid();

        }

        //用戶單擊編輯按紐時事件處理

        private void dgproduct_editcommand(object source, system.web.ui.webcontrols.datagridcommandeventargs e)

        {

            dgproduct.edititemindex = e.item.itemindex;

            binddatagrid();

        }

        //用戶單擊取消按紐時事件處理

        private void dgproduct_cancelcommand(object source, system.web.ui.webcontrols.datagridcommandeventargs e)

        {

            dgproduct.edititemindex = -1;

            binddatagrid();

        }

        //用戶單擊更新按紐時事件處理

        private void dgproduct_updatecommand(object source, system.web.ui.webcontrols.datagridcommandeventargs e)

        {

            string strconn = system.configuration.configurationsettings.appsettings["connectionstring"];           

            sqlconnection conn = new sqlconnection(strconn);

            conn.open();

            //string strsql = "update from products set [email protected], set [email protected] where [email protected]";

            string strsql = "update products set [email protected] where [email protected]";

            sqlcommand command = new sqlcommand(strsql,conn);

            command.parameters.add("@productname",sqldbtype.nvarchar,40);

            command.parameters["@productname"].value = ((textbox)(e.item.cells[1].controls[0])).text.trim();

            //command.parameters.add("@unitprice",sqldbtype.int);

            //command.parameters["@unitprice"].value = convert.toint32(((textbox)(e.item.cells[2].controls[0])).text.trim());

            command.parameters.add("@productid",sqldbtype.int);

            command.parameters["@productid"].value = dgproduct.datakeys[e.item.itemindex];

            command.executenonquery();

            conn.close();

            dgproduct.edititemindex = -1;

            binddatagrid();

        }

       //用戶單擊刪除按紐時事件處理

        private void dgproduct_deletecommand(object source, system.web.ui.webcontrols.datagridcommandeventargs e)

        {

            string strconn = system.configuration.configurationsettings.appsettings["connectionstring"];

            sqlconnection conn = new sqlconnection(strconn);

            conn.open();

            sqlcommand command = new sqlcommand("deleteproduct",conn);

            command.commandtype = commandtype.storedprocedure;

            command.parameters.add("@productid",sqldbtype.int);

            command.parameters["@productid"].value = dgproduct.datakeys[e.item.itemindex];

            command.executenonquery();

            binddatagrid();

        }

        //實現刪除確認及顏色交替顯示功能

        private void dgproduct_itemdatabound(object sender, system.web.ui.webcontrols.datagriditemeventargs e)

        {

            if(e.item.itemtype == listitemtype.item ||e.item.itemtype == listitemtype.alternatingitem)

            {

               button btndelete = (button)(e.item.cells[4].controls[0]);

               btndelete.attributes.add("onclick","javascript:return confirm('確定刪除？')");

               e.item.attributes.add("onmouseover","this.style.backgroundcolor='#ffcc66'");

               e.item.attributes.add("onmouseout","this.style.backgroundcolor='#ffffff'");

            }         }