2.aspx.cs

可以实现用户的添加、修改及模糊搜索及登陆验证 将DB_51aspx文件里面的 数据库文件 附加就可以了 数据库为(Sqlserver 2005 ) 帐号/密码: 51aspx/51aspx We

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;

public partial class _2 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if(!Page.IsPostBack)
        {
        Get();
        }
    }
    protected void Get()
    {
        string urlid = Request.QueryString["id"];
        if(urlid!=string.Empty)
        {
            Info info = new Info();
            info.ID = Convert.ToInt32(urlid);
            Dal dal = new Dal();
            DataTable Dt = dal.Getinfo(info);
            nametext.Text = Dt.Rows[0]["I_UserName"].ToString();
            pwdtext.Text = Dt.Rows[0]["I_Userpwd"].ToString();
            admintext.Text = Dt.Rows[0]["I_IsAdmin"].ToString();
        }
        
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        int _id =Convert.ToInt32( Request.QueryString["id"].ToString());
        string _name = nametext.Text;
        string _pwd = pwdtext.Text;
        string _isadmin = admintext.Text;
        Info user = new Info(_id,_name,_pwd,_isadmin);
        Dal work = new Dal();
        int result = work.Update(user);
        if (result != 0)
        {
            string js = "2.aspx?id=" + Request.QueryString["id"];
            Jscript.AlertAndRedirect("修改成功！", js);
        }
        else
        {
            Jscript.Alert("修改失败");
        }
    }
}