SQLDataAdapter + GridView + Paging + PageIndexChanging 使用方法
WebForm1.aspx |
<form id="form1" runat="server"> <div> <asp:GridView runat="server" ID="GD1" AllowPaging="true" PageIndex="0" PageSize="3" /> </div> </form> |
WebForm1.aspx.cs |
using System; using System.Web.UI.WebControls; using System.Data; using System.Data.SqlClient; using System.Text; namespace WebApplication34 { public partial class WebForm1 : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) GetData(); GD1.PageIndexChanging += new GridViewPageEventHandler(GD1_PageIndexChanging); } void GD1_PageIndexChanging(object sender, GridViewPageEventArgs e) { GD1.PageIndex = e.NewPageIndex; GetData(); } private void GetData() { SqlConnection con1 = new SqlConnection("Data Source=.\\Express; Initial Catalog=Soccer; Integrated Security=SSPI"); con1.Open(); StringBuilder sb = new StringBuilder(); sb.Append("SELECT * FROM dbo.Team;"); SqlDataAdapter Adapter = new SqlDataAdapter(sb.ToString(), con1); DataSet ds = new DataSet(); Adapter.Fill(ds); GD1.DataSource = ds.Tables[0]; GD1.DataBind(); con1.Close(); con1.Dispose(); } } } |