当前文件路径：DaDaNews/Admin/AddView.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_AddView : System.Web.UI.Page
14...{
15    Db pn163 = new Db();
16    protected void Page_Load(object sender, EventArgs e)
17    ...{
18        if (Session["Admin"] == null)
19        ...{
20            Response.Redirect("./Default.Aspx");
21        }
22        if (!IsPostBack)
23        ...{
24            SqlConnection Conn = new SqlConnection(pn163.strConn);
25
26            SqlDataAdapter Da = new SqlDataAdapter("select * from NewClass", Conn);
27
28            DataSet Ds = new DataSet();
29
30            Da.Fill(Ds, "NewClass");
31
32            Class.DataSource = Ds.Tables[0].DefaultView;
33
34            Class.DataTextField = "Class";
35
36            Class.DataBind();
37        }
38        //取得隐藏参数
39        string ClassName = Class.SelectedValue;
40        SqlConnection Class_Conn = new SqlConnection(pn163.strConn);
41
42        Class_Conn.Open();
43
44        SqlCommand ClassCmd = new SqlCommand("select * from NewClass where Class='" + ClassName + "'", Class_Conn);
45
46        SqlDataReader ClassDr = ClassCmd.ExecuteReader();
47
48        if (ClassDr.Read())
49        ...{
50            HiddenField1.Value = ClassDr["id"].ToString();
51        }
52    }
53    protected void Button1_Click(object sender, EventArgs e)
54    ...{
55        SqlConnection Conn = new SqlConnection(pn163.strConn);
56
57        Conn.Open();
58
59        string AltView = content.Value;
60
61        SqlCommand Cmd = new SqlCommand("Insert Into NewView(Titel,Class,AltView,ViewFrom,Class_id)" + "values('" + Titel.Text + "','"
62            + Class.Text + "','" + AltView + "','" + ViewFrom .Text+ "','"+HiddenField1.Value+"')", Conn);
63
64        if (Titel.Text == "")
65        ...{
66            Response.Write("<script>alert('新闻标题不能为空!');history.go(-1);</script>");
67        }
68        else
69        ...{
70            Cmd.ExecuteNonQuery();
71
72            Response.Redirect("./AdminNews.aspx");
73        }
74        
75        Conn.Close();
76    }
77
78}
79