msgdelete.aspx.cs

B/S asp.net的C#编的网站

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 System.Data.SqlClient;

public partial class MsgDelete : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            string connstr = ConfigurationManager.AppSettings["constr"].ToString();
            SqlConnection conn = new SqlConnection(connstr);            

            try
            {
                //string sql = "Select [Title] From [News] Where [MessageID] = " + Convert.ToInt32(Request.QueryString["msgID"]) + "";
                string sql = "Delete From [Message] Where MessageID = " + Convert.ToInt32(Request.QueryString["msgID"]) + "";
                SqlCommand cmd = new SqlCommand(sql, conn);

                conn.Open();
                cmd.ExecuteNonQuery();
                
            }
            catch (SqlException se)
            {
                se.ToString();
            }
            finally
            {
                conn.Close();
            }

            Response.Redirect("./MessageBook.aspx");
                       
        }
    }
}