adminpara.aspx.cs

数据绑定采用GridView控件

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 RoleByAccess_adminpara : System.Web.UI.Page
{
    OleDbConnection conn = new OleDbConnection(ConfigurationManager.ConnectionStrings["con"].ConnectionString);
    protected void Page_Load(object sender, EventArgs e)
    {
        if(!this.Page.IsPostBack)
        {
            this.ShowInfoSys();
        }
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        if(this.username.Text==String.Empty)
        {
            Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script language=javascript>alert('用户名不能为空！');</script>");  
            //this.Label1.Text = "用户名不能为空！";
            return;
        }
        if (this.userpwd.Text == String.Empty)
        {
            Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script language=javascript>alert('原密码不能为空！');</script>");  
           // this.Label1.Text = "原密码不能为空！";
            return;
        }
        if (this.newpwd.Text == String.Empty)
        {
            Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script language=javascript>alert('新密码不能为空！');</script>");  
            //this.Label1.Text = "新密码不能为空！";
            return;
        }
        if (this.newreaptpwd.Text == String.Empty)
        {
            Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script language=javascript>alert('重复密码不能为空！');</script>");  
           // this.Label1.Text = "重复密码不能为空！";
            return;
        }
        if (this.newpwd.Text !=this.newreaptpwd.Text)
        {
            Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script language=javascript>alert('两次输入的密码不一致！');</script>");  
            //this.Label1.Text = "两次输入的密码不一致！";
            return;
        }
        string sql = "update  admin  set userpwd='" + this.newpwd.Text.Trim() + "' where username=" + Session["user"].ToString(); ;
        OleDbCommand comm = new OleDbCommand(sql, conn);
        conn.Open();
        comm.ExecuteNonQuery();
        conn.Close();
        comm.Dispose();
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        string sql = "update  sysconfig  set maxletter='"+this.letters.Text.Trim()+"',zanghua='"+this.zanghua.Text.Trim()+"'" ;
        OleDbCommand comm = new OleDbCommand(sql,conn);
        conn.Open();
        comm.ExecuteNonQuery();
        conn.Close();
        comm.Dispose();
        Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script language=javascript>alert('保存成功！');</script>");  
        //this.Label2.Text = "保存成功！";
    }
    private void ShowInfoSys() 
    {
        string str = "select * from sysconfig ";
        OleDbDataAdapter da = new OleDbDataAdapter(str, conn);
        DataSet ds = new DataSet();
        da.Fill(ds, "m");
        this.zanghua.Text = ds.Tables["m"].Rows[0]["zanghua"].ToString();
    }
}