1using System;
 2using System.Text;
 3using System.Data;
 4using System.Data.SqlClient;
 5using System.Configuration;
 6using System.Collections;
 7using System.Web;
 8using System.Web.Security;
 9using System.Web.UI;
10using System.Web.UI.WebControls;
11using System.Web.UI.WebControls.WebParts;
12using System.Web.UI.HtmlControls;
13
14public partial class admin_bulletin_Add : System.Web.UI.Page
15...{
16    protected void Page_Load(object sender, EventArgs e)
17    ...{
18
19    }
20    protected void Button1_Click(object sender, EventArgs e)
21    ...{   
22        Add();
23    }
24    /**//// <summary>
25    /// 增加一条数据
26    /// </summary>
27    public void Add()
28    ...{
29        StringBuilder strSql = new StringBuilder();
30        strSql.Append("insert into bulletin(");
31        strSql.Append("title,content,dtt)");
32        strSql.Append(" values (");
33        strSql.Append("@title,@content,@dtt)");
34        SqlParameter[] parameters = ...{
35                    new SqlParameter("@title", SqlDbType.NVarChar),
36                    new SqlParameter("@content", SqlDbType.Text),
37                    new SqlParameter("@dtt", SqlDbType.DateTime)};
38        parameters[0].Value =txttitle.Value;
39        parameters[1].Value =FCKeditor1.Value;
40        parameters[2].Value = DateTime.Now;
41
42        DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
43    }
44}
45