usingSystem;usingSystem.Collections.Generic;usingSystem.Linq;usingsystem.web;usingSystem.Web.UI;usingSystem.Web.UI.WebControls;usingSystem.Data;usingSystem.Data.SqlClient; Public Partial classmain:system.web.ui.page{protected voidPage_Load (Objectsender, EventArgs e) { intTotalpage; List<StuInfo> List =NewList<stuinfo>(); Gv_stu. DataSource= Getstuinfo (Ten,2,' ', outtotalpage); Gv_stu. DataBind (); } PublicList<stuinfo> Getstuinfo (intPageSizeintCurrentPage,stringCondition out inttotalpage) {List<StuInfo> List =NewList<stuinfo>(); //string sqlconstr = "Data source=.;i Nitial catalog=example; User Id=sa; password=123456 "; stringSqlconstr ="Data Source=.;i Nitial catalog=example;integrated security=true"; stringsql ="Proc_getstuinfo"; SqlConnection Con=NewSqlConnection (SQLCONSTR); SqlCommand cmd=NewSqlCommand (sql, con); Cmd.commandtype=CommandType.StoredProcedure; Con. Open (); SqlDataReader SDR=cmd. ExecuteReader (); Sqlparameter[] Para= { NewSqlParameter ("@pagesize", pagesize),NewSqlParameter ("@currentpage", currentpage),NewSqlParameter ("@condition", condition),NewSqlParameter ("@pagesize", SqlDbType.Int)}; para[3]. Direction =ParameterDirection.Output; Cmd. Parameters.addrange (para); { while(SDR). Read ()) {Stuinfo Stu=NewStuinfo (); Stu. Stuid= sdr["Stuid"]. ToString (); Stu. Stuname= sdr["Stuname"]. ToString (); Stu. Age= Convert.ToInt32 (sdr[" Age"]); Stu. Address= sdr["Address"]. ToString (); List.add (Stu); }} con. Close (); Totalpage=convert.toint32 (para[3]. Value); returnList; }}
ADO Execute SQL Stored procedure