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;
12
13
14public partial class BackAdmin_Hyperlink : System.Web.UI.Page
15...{
16    CAN can = new CAN();
17    protected void Page_Load(object sender, EventArgs e)
18    ...{
19            can.ExecAdapterBindInfoString(GridView1, "select * from tb_hyperlink ORDER BY ID DESC", "id");
20    }
21    protected void LinkButton1_Click(object sender, EventArgs e)
22    ...{
23        Page.Response.Redirect("InsertHyperlink.aspx");
24    }
25    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
26    ...{
27        SqlConnection myconnection = new SqlConnection("server=(local);user id=sa;PWD=sa;DataBase=db_ComPany");
28        myconnection.Open();
29        SqlCommand mycommand = new SqlCommand("delete from tb_hyperlink where id='" + GridView1.DataKeys[e.RowIndex].Value + "'", myconnection);
30        mycommand.ExecuteNonQuery();
31        SqlDataAdapter myadapter = new SqlDataAdapter("select * from tb_hyperlink ORDER BY ID DESC", myconnection);
32        DataSet myset = new DataSet();
33        myadapter.Fill(myset);
34        GridView1.DataSource = myset;
35        GridView1.DataBind();
36        myconnection.Close();
37    }
38    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
39    ...{
40        GridView1.PageIndex = e.NewPageIndex;
41        GridView1.DataBind();
42    }
43    protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
44    ...{
45        if (e.Row.RowType == DataControlRowType.DataRow)
46        ...{
47            ((LinkButton)(e.Row.Cells[3].Controls[0])).Attributes.Add("onclick", "return confirm('确定删除吗？')");
48            e.Row.Cells[0].Text = new CAN().SubStr(e.Row.Cells[0].Text.ToString(), 5);
49            e.Row.Cells[1].Text = new CAN().SubStr(e.Row.Cells[1].Text.ToString(), 17);
50        }
51    }
52}
53