当前文件： SimpleBbsGuestBook/Default.aspx.cs[1K，2009-6-12 11:54:02]，打开代码结构图

		            
 1using System;
 2using System.Data;
 3using System.Configuration;
 4using System.Web;
 5using System.Web.Security;
 6using System.Web.UI;
 7using System.Web.UI.WebControls;
 8using System.Web.UI.WebControls.WebParts;
 9using System.Web.UI.HtmlControls;
10using System.Data.SqlClient;
11using System.Text;
12
13public partial class _Default : System.Web.UI.Page 
14...{
15    protected void Page_Load(object sender, EventArgs e)
16    ...{
17        if (!Page.IsPostBack)
18        ...{
19            this.BindToGirdView();
20        }
21    }
22
23    private void BindToGirdView()
24    ...{
25        SqlConnection conn = MSSQLConn.getInstance().getSqlConn();
26        string sqlStr = "select gb_id,gb_title,gb_author,gb_date from hl_gb order by gb_id desc";
27        SqlDataAdapter sda = new SqlDataAdapter(sqlStr,conn);
28        DataSet ds = new DataSet();
29        conn.Open();
30        sda.Fill(ds, "gb_list");
31
32        conn.Close();
33
34        this.GV_list.DataSource = ds.Tables["gb_list"].DefaultView;       
35        this.GV_list.DataBind();
36    }
37
38    protected void GV_list_PageIndexChanging(object sender, GridViewPageEventArgs e)
39    ...{
40        GV_list.PageIndex = e.NewPageIndex;
41        this.BindToGirdView();
42    }
43
44    protected void GV_list_RowDeleting(object sender, GridViewDeleteEventArgs e)
45    ...{
46        string id = this.GV_list.DataKeys[e.RowIndex].Value.ToString();
47        Boolean result = MSSQLOperate.delById(Convert.ToInt32(id));
48        if (result)
49        ...{
50            Response.Write("<script>alert('删除成功！');</script>");
51            this.BindToGirdView();
52        }
53        else
54        ...{
55            Response.Write("<script>alert('删除失败！');</script>");
56        }
57    }
58}