using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Data; using System.Data.SqlClient; namespace ClassLibrary1 { public class Class1 { private string connstring = System.Configuration.ConfigurationManager.ConnectionStrings["SampleDBConnectionString"].ConnectionString; public DataSet getall(string sort,int startRowIndex, int maximumRows) { if (sort == "") { sort = "id asc"; } using (SqlConnection conn = new SqlConnection(connstring)) { SqlDataAdapter dr = new SqlDataAdapter("select * from users order by " + sort , conn); DataSet ds = new DataSet(); dr.Fill(ds, startRowIndex, maximumRows, "用户表"); return ds; } } public int getcount() { int nrows; using (SqlConnection conn = new SqlConnection(connstring)) { conn.Open(); SqlCommand dr = new SqlCommand("select count(*) from users", conn); nrows = Convert.ToInt32(dr.ExecuteScalar()); } return nrows; // using (SqlConnection conn = new SqlConnection(connstring)) // { // SqlCommand cmd = new SqlCommand("select count(id) from users", conn); // return cmd.ExecuteScalar; //} } } } =============HTML===========================
<asp:GridView ID="GridView1" runat="server" AllowSorting="true" AllowPaging="True"
DataSourceID="ObjectDataSource1">
</asp:GridView>
<asp:ObjectDataSource ID="ObjectDataSource1" runat="server"
SelectMethod="getall" EnablePaging="true" SortParameterName="sort" SelectCountMethod="getcount" TypeName="ClassLibrary1.Class1">
</asp:ObjectDataSource>