当前位置:首页 > 代码 > 正文

asp.net注册代码(asp登陆代码)

admin 发布:2022-12-19 19:19 135


本篇文章给大家谈谈asp.net注册代码,以及asp登陆代码对应的知识点,希望对各位有所帮助,不要忘了收藏本站喔。

本文目录一览:

Asp.net注册代码

string username = "";//从前台控件获得用户填写的数据 如:txtUsername.Text()

string userpwd = "";//从前台控件获得用户填写的数据 如:txtUsername.Text()

string mail = "";//从前台控件获得用户填写的数据 如:txtUsername.Text()

SqlConnection con = new SqlConnection("数据库连接字符串");

con.Open();

string sql = string.Format("insert into 用户表名称(username,userpwd,mail) values('{0}','{1}','{2}')",username,userpwd,mail);

SqlCommand cmd = new SqlCommand(sql, con);

cmd.ExecuteNonQuery();

con.Close();

asp.net注册页面代码帮忙解释一下

【确认密码】为必填项,并且与【用户密码】一致

【用户年龄】为必填项,并且要在1到150之间

【电子信箱】为必填项,并且要符合电子邮箱的格式

点【提 交】按钮的时候,如果上面三个输入方式不符合上面的要求就会出现红色的提示信息

asp.net登录及注册代码

创建两个类调用

(有时代码都正确但还是注册不了,可能是数据表有问题,删除重表建一张)

****************************************person类:

using System;

using System.Data;

using System.Configuration;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

/// summary

///person 的摘要说明

/// /summary

public class person

{

public string uName;

public string uPwd;

public string uSex;

public person()

{

//

//TODO: 在此处添加构造函数逻辑

//

}

}

*********************************************personOperate类

using System;

using System.Data;

using System.Configuration;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

using System.Data.SqlClient;

/// summary

///personOperate 的摘要说明

/// /summary

public class personOperate

{

public personOperate()

{

//

//TODO: 在此处添加构造函数逻辑

//

}

public static SqlConnection createConnection()

{

SqlConnection con = new SqlConnection("server=.;database=log;uid=sa;pwd=sa");

return con;

}

public static bool insertOperate(person p)

{

try

{

SqlConnection con =personOperate.createConnection();

con.Open();

SqlCommand cmd = new SqlCommand("insert into www values(@uName,@uPwd,@uSex)", con);

SqlParameter para = new SqlParameter("@uName", SqlDbType.VarChar, 50);

para.Value = p.uName;

cmd.Parameters.Add(para);

para = new SqlParameter("@uPwd", SqlDbType.VarChar, 50);

para.Value = p.uPwd;

cmd.Parameters.Add(para);

para = new SqlParameter("@uSex", SqlDbType.VarChar, 2);

para.Value = p.uSex;

cmd.Parameters.Add(para);

cmd.ExecuteNonQuery();

return true;

}

catch (Exception e)

{

return false;

}

}

}

********************************************注册页面代码

using System;

using System.Configuration;

using System.Data;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

}

protected void btgo_Click(object sender, EventArgs e)

{

person p = new person();

p.uName = this.tbUser.Text;

p.uPwd = this.tbPwd.Text;

if (this.rbman.Checked)

{

p.uSex = "男";

}

else

{

p.uSex = "女";

}

if(personOperate.insertOperate(p))

{

Response.Write("注册成功");

}

else

{

Response.Write("失败");

}

Res

注册二代码:

protected void btnsend_Click(object sender, EventArgs e)

{

SqlConnection con = DB.createConnection();

con.Open();

string cmdtext = "insert into newreplay(mname,msubject,mcontent,mphone,madd,mqq,mmail,mhttp,mface,mip,mdatetime,mreplaytime) values(@name,@subject,@content,@phone,@add,@qq,@mail,@http,@face,@ip,@datetime,@datetime)";

SqlCommand cmd = new SqlCommand(cmdtext, con);

cmd.Parameters.Add("@name", SqlDbType.VarChar, 50);

cmd.Parameters["@name"].Value = this.tname.Text;

cmd.Parameters.Add("@subject", SqlDbType.VarChar, 50);

cmd.Parameters["@subject"].Value = this.tsubject.Text;

cmd.Parameters.Add("@content", SqlDbType.Text);

cmd.Parameters["@content"].Value = this.tcontent.Text;

cmd.Parameters.Add("@phone", SqlDbType.VarChar, 50);

cmd.Parameters["@phone"].Value = this.tphone.Text;

cmd.Parameters.Add("@add", SqlDbType.VarChar, 50);

cmd.Parameters["@add"].Value = this.tadd.Text;

cmd.Parameters.Add("@qq", SqlDbType.VarChar, 50);

cmd.Parameters["@qq"].Value = this.tqq.Text;

cmd.Parameters.Add("@mail", SqlDbType.VarChar, 50);

cmd.Parameters["@mail"].Value = this.tmail.Text;

cmd.Parameters.Add("@http", SqlDbType.VarChar, 50);

cmd.Parameters["@http"].Value = this.thttp.Text;

cmd.Parameters.Add("@face", SqlDbType.VarChar, 50);

cmd.Parameters["@face"].Value = this.dface.SelectedValue.ToString();

cmd.Parameters.Add("@ip", SqlDbType.VarChar, 50);

cmd.Parameters["@ip"].Value = GetIP();

cmd.Parameters.Add("@datetime", SqlDbType.DateTime);

cmd.Parameters["@datetime"].Value = DateTime.Now.ToString();

try

{

cmd.ExecuteNonQuery();

con.Close();

Response.Write("scriptalert('发表成功')/script");

this.tadd.Text = "";

this.tcontent.Text = "";

this.thttp.Text = "";

this.tmail.Text = "";

this.tsubject.Text = "";

this.tphone.Text = "";

this.tname.Text = "";

this.tqq.Text = "";

}

catch (Exception error)

{

throw new System.Exception(error.Message);

}

}

登陆:

public partial class LOGIN : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

}

protected void Button1_Click(object sender, EventArgs e)

{

SqlConnection con = DB.createConnec();

con.Open();

SqlCommand cmd = new SqlCommand("select * from LOGIN where name='" + this.TextBox1.Text + "'and password='" + this.TextBox2.Text + "'", con);

SqlDataReader dr = cmd.ExecuteReader();

if (dr.Read())

{

Session["username"] = dr["name"]; //从数据库读出

Session["userpassword"] = dr["password"]; //从数据库读出

if ((int)Session["userpassword"] == 1) //类型要注意 还有一种是SESSION["WWW"].TOSTRING()=="1"; //!=

{

Response.Redirect("TIME.aspx");

}

else if ((int)Session["userpassword"] == 2)

{

Response.Redirect("add.aspx");

}

else

{

Response.Redirect("list.aspx");

}

}

else

{

Response.Write("ksks");

}

con.Close();

}

}

要是可以给我好评好么!我在收集分数

关于asp.net注册代码和asp登陆代码的介绍到此就结束了,不知道你从中找到你需要的信息了吗 ?如果你还想了解更多这方面的信息,记得收藏关注本站。

版权说明:如非注明,本站文章均为 AH站长 原创,转载请注明出处和附带本文链接;

本文地址:http://ahzz.com.cn/post/20004.html


取消回复欢迎 发表评论:

分享到

温馨提示

下载成功了么?或者链接失效了?

联系我们反馈

立即下载