一百分求一注册和登录源代码，在线等待，一实现就给分

string strcon ="workstation id=ZHL;packet size=4096;user id=webmap;data source=ZHL;persist security info=True;initial catalog=webmap;password=webmap";
SqlConnection regconn=new SqlConnection(strcon);

regconn.Open();
string StrSql="select * from admin where user_id='"+name+"'";
SqlCommand regCommand=new SqlCommand(StrSql,regconn);
SqlDataReader reader=regCommand.ExecuteReader();
if(reader.Read())
{
userLabel.Visible=true;
reader.Close();
}
else
{
reader.Close();
StrSql="insert  into admin values('"+name.Text+"','"+pws.Text+"','"+sex.SelectedValue+"','"+email.Text+"')";
regCommand=new SqlCommand(StrSql,regconn);
//执行插入语句
regCommand.ExecuteNonQuery(); }


regconn.Close();

}

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Configuration;
using Xxs.Wcapp.DBConnection;namespace wcapp
{
/// <summary>
///  login 的摘要说明: WebCAPP用户重新登录界面的后台代码
/// </summary>
public class login : System.Web.UI.Page
{
protected System.Web.UI.WebControls.TextBox txtloginname;
protected System.Web.UI.WebControls.TextBox txtpsw;
protected System.Web.UI.WebControls.Button btnsubmit;
private String userrole,errmsg;
protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator1;
protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator2;
protected System.Web.UI.HtmlControls.HtmlGenericControl message;
protected System.Web.UI.WebControls.ValidationSummary ValidationSummary1; /// <summary>
/// 页面初始化
/// </summary>
private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
if(! Page.IsPostBack)
{
message.InnerText ="请登录！";
if (Request.QueryString["ReturnUrl"] != null )
{
ViewState["ReturnUrl"]=Request.QueryString["ReturnUrl"].ToString();
}
else
{
Response.End ();
}
}
} #region Web Form Designer generated code
override protected void OnInit(EventArgs e)
{
//
// CODEGEN：该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}

/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.btnsubmit.Click += new System.EventHandler(this.btnsubmit_Click);
this.Load += new System.EventHandler(this.Page_Load); }
#endregion
/// <summary>
/// 用户按下登录按钮,检查用户身份,转到相应的页面
/// </summary>
private void btnsubmit_Click(object sender, System.EventArgs e)
{
try
{
if ( ! UserDB.CheckUser(txtloginname.Text) )
errmsg="您输入的用户名不存在！";
else if (! UserDB.CheckUserAndPsw(txtloginname.Text,txtpsw.Text))
errmsg="您输入的密码错误！";
else
{
userrole=UserDB.GetLoginUserRole(txtloginname.Text,txtpsw.Text);
if (userrole !="error")
if (userrole !="forbid" )
{
Session["username"]=txtloginname.Text;
Session["userrole"]=userrole;
DataTable dt=UserDB.GetUserByUserName(txtloginname.Text);
Session["usertruename"]=dt.Rows[0]["xm"].ToString(); if(ViewState["ReturnUrl"] != null)
{
Response.Redirect(ViewState["ReturnUrl"].ToString());
}
else
{
Response.End();
}

}
else
errmsg="此用户暂时被禁用，请与用户管理员联系！";

else
errmsg="您是合法用户，但还没有分配权限，请与用户管理员联系！";

}
message.InnerText  =errmsg;
}

catch (System.Data.SqlClient.SqlException er)
{
message.InnerText ="错误ID: "+ er.Number  +" 错误信息: "+ er.Message ;
} }
}
}<%@ Page language="c#" Codebehind="login.aspx.cs" AutoEventWireup="false" Inherits="wcapp.login" enableViewStateMac="False" smartNavigation="False"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
<HEAD>
<title>WebCAPP用户登录</title>
<link rel="stylesheet" href="css/table.css" type="text/css">
<link rel="stylesheet" href="css/form.css" type="text/css">
<META http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta content="Microsoft Visual Studio 7.0" name="GENERATOR">
<meta content="http://schemas.microsoft.com/intellisense/ie3-2nav3-0" name="vs_targetSchema">
</HEAD>
<body>
<form id="form1" method="post" runat="server">
<div id="message" align="center" class="msg" runat="server">请登录！</div>
<br>
<table align="center" cellSpacing="0" borderColorDark="#ffffff" cellPadding="0" width="306"
borderColorLight="#000000" border="1">
<tr bgColor="#97bdfd">
<td align="middle" colSpan="2" height="31"><font color="#000000">欢迎您使用W-CAPP 请输入用户名和密码</font></td>
</tr>
<tr bgColor="#fdd582">
<td align="middle" width="79" height="27">用户名：</td>
<td align="middle" width="215" height="27">
<asp:textbox id="txtloginname" runat="server"></asp:textbox>
</td>
</tr>
<tr bgColor="#fdd582">
<td align="middle" width="79">密 码：</td>
<td align="middle" width="215" height="27">
<asp:textbox id="txtpsw" runat="server" TextMode="Password"></asp:textbox>
</td>
</tr>
<tr bgColor="#fdd582">
<td align="middle" colSpan="2" height="32"><asp:button id="btnsubmit" runat="server" Text="登   录"></asp:button>  
<INPUT type="reset" value="取   消"></td>
</tr>
</table>
<asp:requiredfieldvalidator id="RequiredFieldValidator1" runat="server" ErrorMessage="用户名不能为空" ControlToValidate="txtloginname"
Display="None"></asp:requiredfieldvalidator><asp:requiredfieldvalidator id="RequiredFieldValidator2" runat="server" ErrorMessage="密码不能为空" ControlToValidate="txtpsw"
Display="None"></asp:requiredfieldvalidator><asp:validationsummary id="ValidationSummary1" runat="server" ShowMessageBox="True" ShowSummary="False"></asp:validationsummary><br>
</form>
</body>
</HTML>

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient ;
using System.Configuration ;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using Xxs.Wcapp.DBConnection;namespace wcapp.maintain.personnel
{
/// <summary>
/// add_user 的摘要说明: 添加新用户界面的后台代码
/// </summary>
public class add_user : System.Web.UI.Page
{
protected System.Web.UI.HtmlControls.HtmlInputText tx_username;
protected System.Web.UI.HtmlControls.HtmlInputText tx_psw;
protected System.Web.UI.HtmlControls.HtmlInputText tx_name;
protected System.Web.UI.HtmlControls.HtmlSelect se_sex;
protected System.Web.UI.HtmlControls.HtmlInputText tx_nl;
protected System.Web.UI.HtmlControls.HtmlInputText tx_tc;
protected System.Web.UI.HtmlControls.HtmlSelect se_xl;
protected System.Web.UI.HtmlControls.HtmlSelect se_zc;
protected System.Web.UI.HtmlControls.HtmlInputText tx_phone;
protected System.Web.UI.HtmlControls.HtmlInputText tx_email;
protected System.Web.UI.HtmlControls.HtmlSelect se_role;
protected System.Web.UI.WebControls.RadioButton jy1;
protected System.Web.UI.WebControls.RadioButton jy2;
protected System.Web.UI.HtmlControls.HtmlGenericControl errmsg;
protected System.Web.UI.HtmlControls.HtmlSelect se_ssbm;

/// <summary>
/// 页面初始化
/// </summary>
private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
try
{
if (Page.IsPostBack  )//提交后的页面
{
if (! UserDB.CheckUser(Request.Form["tx_username"])) //没有重名的新用户名
{
AddOneUser();
}
else //有重名的新用户名
{
errmsg.InnerText ="您输入的用户名已经存在，请换一个用户名！";
}

}
else //初次进入的页面
{
UserValid usv=new UserValid();
if( ! usv.CheckValidLogIn("用户管理员"))
{
Response.Redirect("..\\..\\login.aspx?ReturnUrl=" + Request.Url.ToString());
} DataTable dt;
dt=UserDB.GetUserRole();//取得用户角色列表
se_role.DataSource =dt.DefaultView;
se_role.DataValueField ="roleid";
se_role.DataTextField ="rolename";
se_role.DataBind() ;
}
}
catch (System.Data.SqlClient.SqlException er)
{
errmsg.InnerText ="错误ID: "+ er.Number  +" 错误信息: "+ er.Message ;
}
}

/// <summary>
/// 在远程SQL数据库tb_personal中增加新用户
/// </summary>
/// <res>
/// 调用UserDB组件的AddUser增加记录
///</res>
private void AddOneUser()
{
string[] addrec=new String[13];
try
{
addrec[0]=Request.Form["tx_username"];
addrec[1]=Request.Form["tx_psw"];
addrec[2]=Request.Form["tx_name"];
addrec[3]=Request.Form["se_sex"];
addrec[4]=Request.Form["tx_nl"];
addrec[5]=Request.Form["tx_tc"];
addrec[6]=Request.Form["se_xl"];
addrec[7]=Request.Form["se_zc"];
addrec[8]=Request.Form["tx_phone"];
addrec[9]=Request.Form["tx_email"];
addrec[10]=Request.Form["se_role"];
addrec[11]=Request.Form["se_ssbm"];
addrec[12]=jy1.Checked.ToString();
UserDB.AddUser(addrec);
errmsg.InnerText ="该用户已经成功添加！";
}
catch (System.Data.SqlClient.SqlException er)
{
errmsg.InnerText ="错误ID: "+ er.Number  +" 错误信息: "+ er.Message ;
}
} #region Web Form Designer generated code
override protected void OnInit(EventArgs e)
{
//
// CODEGEN：该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}

/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.Load += new System.EventHandler(this.Page_Load); }
#endregion
}
}都在这，你自己调试吧

CREATE TABLE [dbo].[Users] (
    [ID] [int] IDENTITY (1, 1) NOT NULL ,
    [TrueName] [char] (20) NOT NULL ,
    [RegName] [char] (20) NOT NULL ,
    [Pwd] [char] (10) NOT NULL ,
    [Sex] [char] (2) NULL ,
    [Email] [char] (20) NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Users] WITH NOCHECK ADD
    CONSTRAINT [PK_Users] PRIMARY KEY  NONCLUSTERED
    (
        [ID]
    )  ON [PRIMARY]
GOusing System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Diagnostics;
using System.Web;
using System.Web.Services;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;

namespace WebData
{
    /// <summary>
    /// Service1 的摘要说明。
    /// </summary>
    [WebService (Namespace = "http://www.ourfly.com", Description = "<font size=4 color='#FF6633'><b><br><center>使用C#写的三层架构的程序。</center></b><br><br></font>")]
    public class Service1 : System.Web.Services.WebService
    {
        SqlDataAdapter MyAdapter;
        string strConn="data source=localhost;initial catalog=TestUser;uid=sa;pwd=";

        public Service1()
        {
            //CODEGEN：该调用是 ASP.NET Web 服务设计器所必需的
            InitializeComponent();
        }

        #region Component Designer generated code

        //Web 服务设计器所必需的
        private IContainer components = null;

        /// <summary>
        /// 设计器支持所需的方法 - 不要使用代码编辑器修改
        /// 此方法的内容。
        /// </summary>
        private void InitializeComponent()
        {
        }

        /// <summary>
        /// 清理所有正在使用的资源。
        /// </summary>
        protected override void Dispose( bool disposing )
        {
            if(disposing && components != null)
            {
                components.Dispose();
            }
            base.Dispose(disposing);
        }

        #endregion

//定义一个私有方法，用来判断用户是否存在
        private Boolean BoolReg(string strRegName)
        {
            Boolean strResult;
            SqlConnection cn;
            SqlCommand cmd;

            string strSQL;
            cn=new  SqlConnection(strConn);
            cn.Open();

            strSQL="select count(*) from Users where RegName='"+strRegName+"'";
            cmd=new SqlCommand(strSQL,cn);

            SqlDataReader reader = cmd.ExecuteReader();
            reader.Read();
            int i = reader.GetInt32(0);
            if (i>0)
            {
                reader.Close();
                cn.Close ();
                strResult= true;
            }
            else
            {
                reader.Close();
                cn.Close ();
                strResult=false;
            }

            return strResult;
        }

        [WebMethod(Description="完成用户注册功能.")]
        public string RegUser(string strTrueName,string strRegName,string strPwd,string strSex,string strEmail)
        {
            string strResult;
            SqlConnection cn;
            SqlCommand cmd;

            //判断用户是否存在
            if (BoolReg(strRegName))
                   {
                       strResult="这个用户已经存在，请重新注册";
                       return strResult;
                   }
            else
            {
                string strSQL;
                cn=new  SqlConnection(strConn);
                cn.Open();

                strSQL="insert into Users (TrueName,RegName,Pwd,Sex,Email) values( '";
                strSQL+=strTrueName+"','";
                strSQL+=strRegName+"','";
                strSQL+=strPwd+"','";
                strSQL+=strSex+"','";
                strSQL+=strEmail+"')";

                cmd=new SqlCommand(strSQL,cn);

                try
                {
                    cmd.ExecuteNonQuery();
                    cn.Close ();
                    strResult= "用户注册成功";
                }
                catch(Exception e)
                {
                    cn.Close ();
                    strResult="请仔细检查你的输入项";
                }
            }
            return strResult;

        }

        [WebMethod(Description="用户登录")]
        public string Login(string strRegName,string strPwd)
        {
            SqlConnection cn;
            SqlDataAdapter da;
            DataSet ds;
            string strSQL,strResult;

            strSQL="select TrueName,RegName,Pwd from Users  where RegName='"+strRegName+"' and Pwd='"+strPwd+"'";

            cn=new SqlConnection(strConn);
            cn.Open();

            da=new SqlDataAdapter(strSQL,cn);
            ds=new DataSet();
            da.Fill(ds,"Users");

            if(ds.Tables["Users"].Rows.Count>0)
            {
                strResult= "登录成功";

            }
            else
            {
                strResult= "用户名或口令有误或者没有这个用户！请重新输入！";

            }
            cn.Close();
            return strResult;
        }

        [WebMethod(Description="得到数据集.")]
        public DataSet GetDataSet()
        {
            SqlConnection cn;
            cn=new SqlConnection(strConn);
            string strSel="select * from Customers";
            cn.Open();
            MyAdapter=new SqlDataAdapter(strSel,strConn);
            DataSet ds=new DataSet();
            MyAdapter.Fill(ds,"Customers");
            return ds;
        }
    }
}

调试易

一百分求一注册和登录源代码，在线等待，一实现就给分

解决方案 »