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 Manager_AddNews : System.Web.UI.Page
14...{
15    protected void Page_Load(object sender, EventArgs e)
16    ...{
17
18    }
19    protected void bnt_Click(object sender, EventArgs e)
20    ...{
21        string txtTitle = TextBoxTitle.Text.ToString();
22        int nTypes = int.Parse(SelectTypes.SelectedValue.ToString());
23        int nShow = int.Parse(SelectShow.SelectedValue.ToString());
24        string txtText = AddContent.Text.ToString();
25        string txtTime = DateTime.Now.ToString();
26        SqlParameter[] paras =...{ new SqlParameter("@Title", SqlDbType.NVarChar, 50), new SqlParameter("@Content", SqlDbType.NVarChar,4000), new SqlParameter("@Types", SqlDbType.Bit), new SqlParameter("@NewTime", SqlDbType.DateTime, 8), new SqlParameter("@Vis", SqlDbType.Bit) };
27        paras[0].Value = txtTitle;
28        paras[1].Value = txtText;
29        paras[2].Value = nTypes;
30        paras[3].Value = txtTime;
31        paras[4].Value = nShow;
32        SqlHelper.ExcuteNonQurey("INSERT INTO [New] (Name,Content,Types,NewTime,Vis) Values(@Title,@Content,@Types,@NewTime,@Vis)", CommandType.Text, paras);
33        Response.Redirect("New.aspx");
34    }
35    protected void ButtonCancel_Click(object sender, EventArgs e)
36    ...{
37
38        Response.Redirect("New.aspx");
39
40    }
41}
42