当前文件路径：DaDaNews/Admin/EditNews.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
13public partial class Admin_EditNews : System.Web.UI.Page
14...{
15    Db pn163 = new Db();
16
17    public void Dro()
18    ...{
19        SqlConnection Conn = new SqlConnection(pn163.strConn);
20        Conn.Open();
21
22        SqlDataAdapter Da = new SqlDataAdapter("Select * from NewClass", Conn);
23
24        DataSet Ds = new DataSet();
25
26        Da.Fill(Ds, "NewClass");
27
28        Class.DataSource = Ds.Tables[0].DefaultView;
29
30        Class.DataTextField = "Class";
31
32        Class.DataBind();
33    }
34
35    protected void Page_Load(object sender, EventArgs e)
36    ...{
37        if (Session["Admin"] == null)
38        ...{
39            Response.Redirect("./Default.Aspx");
40        }
41        SqlConnection Conn = new SqlConnection(pn163.strConn);
42
43        Conn.Open();
44
45        SqlCommand Cmd = new SqlCommand("select * from NewView where id ="
46    + Request.QueryString["id"], Conn);
47
48        if (!IsPostBack)
49        ...{
50            SqlDataReader Dr = Cmd.ExecuteReader();
51
52            if (Dr.Read())
53            ...{
54                Titel.Text = Dr["Titel"].ToString();
55                Dro();
56                ViewFrom.Text = Dr["ViewFrom"].ToString();
57                content.Value = Dr["AltView"].ToString();
58            }
59        }
60        string ClassName = Class.SelectedValue;
61
62        SqlConnection Class_Conn = new SqlConnection(pn163.strConn);
63
64        Class_Conn.Open();
65
66        SqlCommand ClassCmd = new SqlCommand("select * from NewClass where Class='" + ClassName + "'", Class_Conn);
67
68        SqlDataReader ClassDr = ClassCmd.ExecuteReader();
69
70        if (ClassDr.Read())
71        ...{
72            HiddenField1.Value = ClassDr["id"].ToString();
73        }
74    }
75
76    protected void Button1_Click(object sender, EventArgs e)
77    ...{
78        SqlConnection Conn = new SqlConnection(pn163.strConn);
79
80        Conn.Open();
81
82        SqlCommand Cmd = new SqlCommand("update NewView set Titel='" + Titel.Text + "',Class='" + Class.Text + "',AltView='" + content.Value + "', ViewFrom='" + ViewFrom.Text + "',Class_id='" + HiddenField1.Value + "' where id="
83            +Request.QueryString["id"],Conn);
84
85        Cmd.ExecuteNonQuery();
86
87        Response.Redirect("./AdminNews.aspx");
88
89        Conn.Close();
90    }
91}
92