后台代码
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Collections.Generic;
using System.Text;
using Lucene.Net.Analysis.Standard;
using Lucene.Net.Analysis;
using Lucene.Net.Index;
using Lucene.Net.Documents;
using System.IO;
using Lucene.Net.Analysis.Cn;
using Rainsoft.WordSeg;
using System.Data.SqlClient;
using bean;
public partial class aspx_demo : System.Web.UI.Page
{
conn con = new conn();
protected void Page_Load(object sender, EventArgs e)
{
//初始化控件属性
this.GridView1.AutoGenerateDeleteButton = true;
this.GridView1.AutoGenerateEditButton = true;
this.GridView1.Width = new System.Web.UI.WebControls.Unit("100%");
this.GridView1.AllowPaging = true;
this.GridView1.PageSize = 3;
this.BangDing();
}
//绑定函数
public void BangDing()
{
string sql = "select * from guanjianci";
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(sql, con.CreateConnection());
da.Fill(ds, "List");
GridView1.DataKeyNames = new string[] { "id" }; //主键
this.GridView1.DataSource = ds.Tables["List"].DefaultView;
this.GridView1.DataBind();
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
string sqlstr = "delete from guanjianci where id='" + GridView1.DataKeys[e.RowIndex].Value.ToString() + "'";
Response.Write(sqlstr);
}
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{
this.TextBox1.Text = this.GridView1.Rows[e.NewEditIndex].Cells[2].Text;
}
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
int index = e.NewPageIndex;
Response.Write(index+"<br>");
this.GridView1.PageIndex = index;
BangDing();
}
}
前台代码
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="demo.aspx.cs" Inherits="aspx_demo" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>无标题页</title>
</head>
<body>
<form id="form1" runat="server">
<asp:TextBox ID="TextBox1" runat="server" Width="728px"></asp:TextBox>
<asp:GridView ID="GridView1" runat="server" CellPadding="4" ForeColor="#333333"
GridLines="None" onrowdeleting="GridView1_RowDeleting"
onrowediting="GridView1_RowEditing" Width="347px"
onpageindexchanging="GridView1_PageIndexChanging">
<FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<RowStyle BackColor="#EFF3FB" />
<PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
<SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
<HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<EditRowStyle BackColor="#2461BF" />
<AlternatingRowStyle BackColor="White" />
</asp:GridView>
</form>
</body>
</html>