useredit.aspx.cs

包含了几个由sql server2005开发的典型程序

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 GROUP.Manage;

public partial class useredit : System.Web.UI.Page
{
    BaseClass BaseClass1 = new BaseClass();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["name"] != null)
        {
            if (!Page.IsPostBack)
            {
                string strsql = "select 用户名,密码,真实姓名,电话,地址,邮编 from 用户 where 用户名 ='" + Session["name"].ToString() + "'";
                DataTable dt = new DataTable();
                dt = BaseClass1.ReadTable(strsql);
                TextBox1.Text = dt.Rows[0].ItemArray[0].ToString();
                TextBox2.Text = dt.Rows[0].ItemArray[1].ToString();
                TextBox3.Text = dt.Rows[0].ItemArray[1].ToString();
                TextBox4.Text = dt.Rows[0].ItemArray[2].ToString();
                TextBox5.Text = dt.Rows[0].ItemArray[3].ToString();
                TextBox6.Text = dt.Rows[0].ItemArray[4].ToString();
                TextBox7.Text = dt.Rows[0].ItemArray[5].ToString();
            }
            
        }
        else 
        {
            Response.Redirect("default.aspx");
        }

    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        string strsql;
        strsql = "update 用户 set 密码='" + TextBox2.Text + "',真实姓名='" + TextBox4.Text + "',电话='" + TextBox5.Text + "',地址='" + TextBox6.Text + "',邮编='" + TextBox7.Text + "'"
            + " where 用户名 ='" + Session["name"].ToString() + "'";
        BaseClass1.execsql(strsql);
        Response.Write("<script>alert(\"修改成功！\");</script>");
        Response.Redirect("default.aspx");

    }
}