addnew.aspx.cs

包含了几个由sql server2005开发的典型程序

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using GROUP.Manage;

public partial class addnew : System.Web.UI.Page
{
    BaseClass BaseClass1 = new BaseClass();

    protected void Page_Load(object sender, System.EventArgs e)
    {
        if (Session["admin"] == null)
        {
            Response.Redirect("login.aspx");
        }
        
        // 在此处放置用户代码以初始化页面
        if (!Page.IsPostBack)
        {
            DataTable dt = new DataTable();
            string strsql = "select * from 新闻类别";
            dt = BaseClass1.ReadTable(strsql);
            DropDownList1.DataSource = dt;
            DropDownList1.DataTextField = "新闻类别";
            DropDownList1.DataValueField = "新闻类别";
            DropDownList1.DataBind();

        }
        // 在此处放置用户代码以初始化页面
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        string strsql;
        strsql = "insert into 新闻信息 (新闻标题,新闻内容,新闻类别,添加时间) values ('" + TextBox1.Text + "','" + TextBox2.Text + "','" + DropDownList1.SelectedValue + "','" + System.DateTime.Now.ToString() + "')";
        BaseClass1.execsql(strsql);
        Response.Write("<script>alert(\"新闻发表成功！\");</script>");
        TextBox1.Text = "";
        TextBox2.Text = "";

    }
}