delete.aspx

来自「呵呵 很好的 大家都来看看啊」· ASPX 代码 · 共 37 行

<%@Import Namespace="System.Data.OleDb" %>
<%@Import Namespace="System.Data" %>
<%
	string sID=Request["idNumber"],SendFlag;
	if(Session["AdminLogged"]=="1"){
		if(sID==null || sID=="")
			SendFlag="2";
		else{

		string DB_STR="Provider=Microsoft.Jet.OLEDB.4.0; Persist Security Info=False; Data Source=" + Server.MapPath("Database/GuestBook.mdb"); 
	    OleDbConnection	 conn = new OleDbConnection( DB_STR );
	    OleDbCommand     cmd  = new OleDbCommand( "select * from guestbook where number="+sID, conn );
	    OleDbDataAdapter da   = new OleDbDataAdapter();
	    da.SelectCommand = cmd;
	    DataSet ds = new DataSet();
	    da.Fill( ds );
	    conn.Close();

            DataTable msgDel=ds.Tables[0];
			if(msgDel.Rows.Count==0)
				SendFlag="3";
			else{
			string strDELETE = "DELETE * FROM GuestBook where number="+sID;
			OleDbConnection objConnect = new OleDbConnection(DB_STR);
			objConnect.Open();
			OleDbCommand objCommand = new OleDbCommand(strDELETE, objConnect);
			objCommand.ExecuteNonQuery();
			objConnect.Close();
				SendFlag="1";
			    }
		     }
			}
	else{ 
		SendFlag="4";
	}
	Response.Write("&&SendFlag="+SendFlag);
%>