quite.aspx.cs

visual stdio 2005

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.OleDb;

public partial class quite : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        Session.Remove("name");
        string StrCoon = "Provider=Microsoft.Jet.OLEDB.4.0;Data source=" + Server.MapPath("BDB/BookStore.mdb");
        OleDbConnection cnA = new OleDbConnection();
        cnA.ConnectionString = StrCoon;
        cnA.Open();
        string strsql = " DELETE FROM BookCar";
        OleDbCommand cmA = new OleDbCommand(strsql, cnA);
        cmA.ExecuteNonQuery(); 
        cnA.Close();
        
        /*
        //Response.Write("<script>alert('欢迎您下次光临')</script>");
        string ee = "";
        OleDbConnection cnA = new OleDbConnection();
        cnA.ConnectionString = "provider=Microsoft.Jet.OLEDB.4.0;data source=" + Server.MapPath("BDB/BookStore.mdb");
        cnA.Open();
        string cmdtext = "Update userinfo set userstate='"+ee+"';";
        //string nname = "1231e23";
        //string ppassword = "12312";
        //string eemail = "[e-mail]";
        //string cmdtext = "INSERT  INTO userinfo (username) values('"+nname +"')";             
        OleDbCommand cmA = new OleDbCommand(cmdtext, cnA);
        cmA.ExecuteNonQuery();
       // string cmtext = "Update userinfo set password='" + ppassword  + "'WHERE username='123123';";
        //OleDbCommand  ccmA = new OleDbCommand(cmtext,cnA);
        //ccmA.ExecuteNonQuery();  
        cnA.Close();
         * */

    }
    protected void Button1_Click(object sender, EventArgs e)
    {
             
        Response.Redirect("Default.aspx");
        

    }
}