当前文件： HBDBlog/Admin/AddNew.ascx.cs[2K，2009-6-12 11:43:44]，打开代码结构图

		            
 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;
12public partial class Admin_AddNew : System.Web.UI.UserControl
13...{
14    protected void Page_Load(object sender, EventArgs e)
15    ...{
16        if (!IsPostBack)
17        ...{
18            Bind_Tags();
19        }
20    }
21    void Bind_Tags()
22    ...{
23        //读取数据库连接字符串
24        string settings = Convert.ToString(ConfigurationManager.ConnectionStrings["SqlServices"]);
25        //创建数据库连接
26        SqlConnection myconn = new SqlConnection(settings);
27        //打开数据库连接
28        myconn.Open();
29
30        string strsql = "select * from Tags";
31
32        //执行数据操作命令
33        SqlDataAdapter da = new SqlDataAdapter(strsql, myconn);
34
35        DataSet ds = new DataSet();
36        da.Fill(ds, "Tag_Name");
37
38        ddl_tag.DataSource = ds.Tables["Tag_Name"].DefaultView;
39        ddl_tag.DataTextField = "Tag_Name";
40        ddl_tag.DataValueField = "Tag_ID";
41        ddl_tag.DataBind();
42        myconn.Close();
43    }
44    protected void btn_add_Click(object sender, EventArgs e)
45    ...{
46        string title = tbx_title.Text;
47        
48        
49        string content = tbx_content.Text.Replace("\n", "<br>");
50        string dec = tbx_dec.Text;
51        int tagid = Convert.ToInt32(ddl_tag.SelectedValue.ToString());
52        int viewnum = 0;
53
54
55        //读取数据库连接字符串
56        string settings = Convert.ToString(ConfigurationManager.ConnectionStrings["SqlServices"]);
57        //创建数据库连接
58        SqlConnection myconn = new SqlConnection(settings);
59        //打开数据库连接
60        myconn.Open();
61
62        int id = Convert.ToInt32(Request.QueryString["id"]);
63
64        string strsql = "Insert Into Articles (Title,A_Content,Dec,Tag_ID,PublishedTime,ViewNum) Values('"+ title +"','" + content + "','" + dec + "'," + tagid + ",'" + DateTime.Now + "'," + viewnum + ")";
65       
66
67        //Response.Write(strsql);
68        //Response.End();
69        //创建数据库命令
70        SqlCommand mycmd = new SqlCommand(strsql, myconn);
71
72        mycmd.ExecuteNonQuery();
73        Response.Redirect("ArticleManage.aspx");
74
75    }
76}
77