AddTopic1.aspx.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;

public partial class AddTopic1 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            Info();//初始化加载
        }
    }
    private void Info()
    {
        SqlHelper data = new SqlHelper();
        DataTable tb = data.GetDs("select * from fenlei","tb").Tables[0];
        this.bankuai.DataSource = tb;
        bankuai.DataTextField = "fenleiName";
        bankuai.DataValueField = "id";
        bankuai.DataBind();
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        SqlHelper data = new SqlHelper();
        string fenleiID = this.bankuai.SelectedValue;
        data.RunSql("insert into Topic(zhuti,AddUser,Contents,fabiaoshijian,fenleiID)values('" + tb_title.Text + "','" + Session["yonghuhao"].ToString() + "','" + FCKeditor1.Value + "','" + DateTime.Now.ToString("yyyy-MM-dd") + "'," + fenleiID + ")");
        Alert.AlertAndRedirect("发表成功", "tieziList.aspx?fenleiID=" + fenleiID + "");
    }
}