userxiugai.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 Userxiugai : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            if (Session["uname"] == null)
            {
                Response.Write("<script language='javascript'>alert('您还没有注册或登陆');location.href='Login.aspx'</script>");

            }
            if (Session["uname"] != null)
            {
                SqlConnection con = db.ceratcon();
                con.Open();
                SqlCommand cmd = new SqlCommand("select  * from Users where Uname='" + Session["uname"] + "'", con);//从数据库中选择数据
                cmd.Parameters.Add("@Uname", SqlDbType.VarChar);
                cmd.Parameters["@Uname"].Value = Session["uname"].ToString();

                SqlDataReader sdr = cmd.ExecuteReader();//读数据
                if (sdr.Read())
                {
                    this.txtname.Text = Session["uname"].ToString();
                    this.txtemal.Text = Convert.ToString(sdr["Uemal"]);
                    this.txtpwd.Text = Convert.ToString(sdr["Upwd"]);
                    this.txttel.Text = Convert.ToString(sdr["Utel"]);

                }
                con.Close();
            }
            else
            {
                Response.Write("<script language='javascript'>alert('没有登录请登陆');loation.href='Login.aspx'</script>");

            }
        }
    }
   

    protected void LinkButton1_Click1(object sender, EventArgs e)
    {
        string name = Session["uname"].ToString();
        SqlConnection con = db.ceratcon();
        con.Open();
        SqlCommand cmd = new SqlCommand();
        cmd.Connection = (SqlConnection)con;
        cmd.CommandText = "update   Users set Uname=@Uname,Uemal=@Uemal,Upwd=@Upwd,Utel=@Utel  where  Uname='" + name + "'";
        cmd.Parameters.Add("@Uname", SqlDbType.VarChar);
        cmd.Parameters.Add("@Uemal", SqlDbType.VarChar);
        cmd.Parameters.Add("@Upwd", SqlDbType.VarChar);
        cmd.Parameters.Add("@Utel", SqlDbType.VarChar);

        cmd.Parameters["@Uname"].Value = Session["uname"];
        cmd.Parameters["@Uemal"].Value = this.txtemal.Text;
        cmd.Parameters["@Upwd"].Value = this.txtpwd.Text;
        cmd.Parameters["@Utel"].Value = this.txttel.Text;
        cmd.ExecuteNonQuery();
        con.Close();
        Response.Write("<script language='javascript'>alert('修改成功');location.href='Index.aspx'</script>");
       
       
    }
    protected void LinkButton2_Click(object sender, EventArgs e)
    {
        this.txtemal.Text = "";
        this.txttel.Text = "";
    }
}