adminhomeeditdetail.aspx.cs

学生寝室管理系统

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 adminhomeeditdetail : System.Web.UI.Page
{

    SqlCommand cmd, cmd1;
    SqlConnection cn;
    SqlDataReader dr, dr1;
    SqlDataAdapter da, da1;
    DataSet ds = new DataSet();
    DataSet ds1 = new DataSet();
    DataTable mytable = new DataTable();
    string  strsql, strsql1, strsql2;
    protected void Page_Load(object sender, EventArgs e)
    {
        this.Label4.Text = this.homesex.SelectedItem.Value.ToString();
      
        if (!this.IsPostBack)
        {
            if (Session["adminname"] == null)
            {
                Response.Redirect("index.aspx");
            }
            else
            {

                this.Label1.Text = Convert.ToString(Request.QueryString["id"]);
                int id = int.Parse(Request.QueryString["id"]);
                cn = sqldata.createcon();
                cn.Open();
                strsql = "select *from homedetail where id=" + id;
                da = new SqlDataAdapter(strsql, cn);
                da.Fill(ds);
                mytable = ds.Tables[(0)];
                this.Label3.Text = Convert.ToString(mytable.Rows[0]["home"]);
                this.Label4.Text = Convert.ToString(mytable.Rows[0]["homesex"]);
            }
            
        }

    }
    
    protected void Button1_Click(object sender, EventArgs e)
    {
       
       int id =int.Parse (Request .QueryString ["id"]);
       cn = sqldata.createcon();
       cn.Open();
        strsql2 = "select * from homedetail where home='" + this.Label3 .Text  + "' and homesex='" + this.Label4.Text + "'";
        cmd1 = new SqlCommand (strsql2, cn);
        dr = cmd1.ExecuteReader();
        if (dr.Read())
        {
            Session["home"] = dr["home"].ToString().Trim();
            Session["homesex"] = dr["homesex"].ToString();
            this.Label2.Text = "要添加的寝室楼已经存在了.";
        }
        else
        {
            dr.Close();
            strsql1 = "update homedetail set home='" + Label3 .Text  + "',homesex='" + this.Label4.Text + "' where id= "+ id ;
          cmd = new SqlCommand (strsql1, cn);
            cmd.ExecuteNonQuery();
            cn.Close();
            this.Label2.Text = "更新成功";
            this.HyperLink1.Visible = true;
        }
    }
    protected void ddlhomeflood_SelectedIndexChanged(object sender, EventArgs e)
    {

    }
}