1using System;
 2using System.Data;
 3using System.Configuration;
 4using System.Collections;
 5using System.Web;
 6using System.Web.Security;
 7using System.Web.UI;
 8using System.Web.UI.WebControls;
 9using System.Web.UI.WebControls.WebParts;
10using System.Web.UI.HtmlControls;
11using System.Data.SqlClient;
12public partial class manageruku : System.Web.UI.Page
13...{
14    protected void Page_Load(object sender, EventArgs e)
15    ...{
16        if (!IsPostBack)
17        ...{
18            gridviewBind();
19        }
20    }
21    //gridview绑定
22    private void gridviewBind()
23    ...{
24        string str = "select rukuID,rukuDate,rukuBianma,huoName,shuliang,jinjia,zhonge,beizhu,ghdw,jingbanren from ruku order by rukuID desc";
25        SqlConnection scon = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
26        scon.Open();
27        SqlDataAdapter dbAdapter = new SqlDataAdapter(str, scon);
28        DataSet ds = new DataSet();
29        dbAdapter.Fill(ds);
30        scon.Close();
31        GridView1.DataSource = ds.Tables[0].DefaultView;
32        GridView1.DataKeyNames = new string[] ...{ "rukuID" };
33        GridView1.DataBind();
34    }
35    /**/////f分页
36    protected void GridView1_PageIndexChanging1(object sender, GridViewPageEventArgs e)
37    ...{
38        GridView1.PageIndex = e.NewPageIndex;
39        GridView1.DataBind();
40        gridviewBind();
41    }
42    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
43    ...{
44        string ss = "delete from ruku where rukuID='" + this.GridView1.DataKeys[e.RowIndex].Value.ToString() + "'";
45        SqlConnection scon = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
46        scon.Open();
47        SqlCommand scmd = new SqlCommand(ss, scon);
48        scmd.ExecuteNonQuery();
49        scon.Close();
50        GridView1.DataBind();
51        gridviewBind();
52    }
53    protected void Button1_Click(object sender, EventArgs e)
54    ...{
55
56    }
57    protected void Button2_Click(object sender, EventArgs e)
58    ...{
59
60    }
61}