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