当前文件路径：DaDaNews/Admin/Class.aspx.cs

		            
 1using System;
 2using System.Collections;
 3using System.Configuration;
 4using System.Data;
 5using System.Data.SqlClient;
 6using System.Web;
 7using System.Web.Security;
 8using System.Web.UI;
 9using System.Web.UI.HtmlControls;
10using System.Web.UI.WebControls;
11using System.Web.UI.WebControls.WebParts;
12
13
14public partial class Class : System.Web.UI.Page
15...{
16    Db pn163 = new Db();
17    protected void Page_Load(object sender, EventArgs e)
18    ...{
19        if (Session["Admin"] == null)
20        ...{
21            Response.Redirect("./Default.Aspx");
22        }
23
24        SqlConnection Conn = new SqlConnection(pn163.strConn);
25
26        SqlDataAdapter Da = new SqlDataAdapter("select * from NewClass order by St", Conn);
27
28        DataSet Ds = new DataSet();
29
30        Da.Fill(Ds, "NewClass");
31        Repeater1.DataSource = Ds.Tables[0].DefaultView;
32        Repeater1.DataBind();
33    }
34
35    protected void DelComm_Click(object sender, CommandEventArgs e)
36    ...{
37        int ID = Convert.ToInt32(e.CommandName);
38
39        SqlConnection Conn = new SqlConnection(pn163.strConn);
40
41        Conn.Open();
42
43        SqlCommand Cmd = new SqlCommand("delete from NewClass where id=" + ID, Conn);
44   
45        Cmd.ExecuteNonQuery();
46
47        Conn.Close();
48
49        Response.Redirect("Class.aspx");
50    }
51}
52