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站长 原创,转载请注明出处和附带本文链接;
相关推荐
- 04-23web图片特效代码(网页效果图代码)[20240423更新]
- 04-23办公系统代码(办公系统代码在哪里找)[20240423更新]
- 04-23java代码exe(在哪里找免费的JAVA代码)[20240423更新]
- 04-23源代码.net版本(net开发基础)[20240423更新]
- 04-23网页中视频播放器代码(网页中视频播放器代码是什么)[20240423更新]
- 04-23舆情监控系统代码(舆情系统 源代码)[20240423更新]
- 04-23js小游戏代码大全(js网页小游戏)[20240423更新]
- 04-23友情链接html代码(友情链接常用代码)[20240423更新]
- 04-23discuz怎么注释代码(论坛discuz注入)[20240423更新]
- 04-23cfar代码(cfa全称)[20240423更新]
取消回复欢迎 你 发表评论:
- 标签列表
- 最近发表
- 友情链接