语言c#,数据库Access,
数据库名为A.mdb,有一表B,表中有UserID和Pswd两列,
现有Form1,上面有textbox1,textbox2,button1
Form2中有label1, 学艺不精啊.....虽然简单,可是我写了,好多个错误,根本不知道从何修改 只有向高手讨代码.... 现在我想实现的功能如下:(和普通的用户登陆无两样) 在textbox1,textbox2中分别输入内容,单击button1后
textbox1,textbox2分别连接到数据库的UserID(帐户)和Pswd(密码)两列,
并且内容一致的话,连接到Form2,并且Form2中的labl1显示为Form1 textbox1的内容... 如果密码错误显示"密码错误"信息
如果不存在帐户,提示"没有此用户" 先向看贴的高手们致敬,
向发代码的前辈表示至高的感谢....
高手有空请帮帮忙,给小弟发段代码,让小弟和自己的对比对比,学习学习 代码尽量简单一些
谢谢谢谢~~~
数据库名为A.mdb,有一表B,表中有UserID和Pswd两列,
现有Form1,上面有textbox1,textbox2,button1
Form2中有label1, 学艺不精啊.....虽然简单,可是我写了,好多个错误,根本不知道从何修改 只有向高手讨代码.... 现在我想实现的功能如下:(和普通的用户登陆无两样) 在textbox1,textbox2中分别输入内容,单击button1后
textbox1,textbox2分别连接到数据库的UserID(帐户)和Pswd(密码)两列,
并且内容一致的话,连接到Form2,并且Form2中的labl1显示为Form1 textbox1的内容... 如果密码错误显示"密码错误"信息
如果不存在帐户,提示"没有此用户" 先向看贴的高手们致敬,
向发代码的前辈表示至高的感谢....
高手有空请帮帮忙,给小弟发段代码,让小弟和自己的对比对比,学习学习 代码尽量简单一些
谢谢谢谢~~~
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Login.aspx.cs" Inherits="Login" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head id="Head1" runat="server">
<title></title>
<script language="javascript" type="text/javascript">
function btnClose_onclick() {
window.close();
}
function clickInter()
{
window.open('Index.aspx','_blank',scrollbars='no',toolbar='no',menubar='no');
window.opener=null;
window.close();
}
</script>
<LINK href="Style/login.css" type="text/css" rel="stylesheet"/>
</head>
<body class="PageBody" leftMargin="0" topMargin="0" onLoad="nLoad();" MARGINHEIGHT="0" MARGINWIDTH="0">
<form id="form1" runat="server" style="text-align:center; vertical-align:middle" >
<table width="100%" cellSpacing="0" cellPadding="0" border="0">
<tr>
<td style="width:25%"> </td>
<td style="width:60%"> <asp:Label ID="Label1" runat="server" Height="130px"></asp:Label></td>
<td style="width:15%"> </td>
</tr>
<tr>
<td > </td>
<td style="text-align:right" class="VersionTitle" >版本:V1.00
</td>
<td> </td>
</tr>
<tr style="height:80px">
<td> </td>
<td class="UpTr">
<asp:Image ID="Image1" runat="server" ImageUrl="~/Photo/login/logo.gif" />
<hr style="background-color:Red; height:4px; width:100%" />
</td>
<td> </td>
</tr>
<tr>
<td> </td>
<td>
<table width="100%" class="DownTr" cellSpacing="0" cellPadding="0" border="0">
<tr>
<td style="width:5%"> </td>
<td style="width:50%">
</td>
<td style="width:45%"> </td>
</tr>
<tr>
<td> </td>
<td>
<table width="100%">
<tr>
<td align="right" style="text-align: right"> 用户名:</td>
<td align="left">
<asp:TextBox ID="txtUserName" runat="server"></asp:TextBox>
<asp:RequiredFieldValidator ID="requUserName" runat="server" ControlToValidate="txtUserName"
ErrorMessage="*" Display="Dynamic"></asp:RequiredFieldValidator>
</td>
<td> </td>
</tr>
<tr>
<td align="right" style="text-align: right"> 密 码:</td>
<td align="left">
<asp:TextBox ID="txtPwd" runat="server" TextMode="Password" Width="148px"></asp:TextBox>
<asp:RequiredFieldValidator ID="requPwd" ControlToValidate="txtPwd" runat="server"
ErrorMessage="*" Display="Dynamic"></asp:RequiredFieldValidator>
</td>
<td> </td>
</tr>
<tr>
<td style="text-align: center" colspan="2" > <asp:Button ID="btnSubmit" runat="server" OnClick="btnSubmit_Click" Text="登录" Width="58px" Height="25px" />
<input id="btnClose" type="button" value="关闭" onclick="return btnClose_onclick()" style="width: 58px; height: 25px;" />
</td>
<td> </td>
</tr>
<tr>
<td s style="text-align: center" colspan="2"> <asp:Label ID="lblError" runat="server" ForeColor="Red"></asp:Label></td>
<td> </td>
</tr>
</table>
</td>
<td><asp:Image ID="Image2" runat="server" ImageUrl="~/Photo/login/logo_bg.gif" /></td>
</tr>
<tr>
<td> </td>
<td style="background:url(Photo/login/logo_copyright_bg.gif)" align="right" class="VersionTitle" colspan="2">
版权所有
</td >
</tr>
</table>
</td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> <asp:Label ID="Label2" runat="server" Height="169px"></asp:Label></td>
<td> </td>
</tr>
</table>
</form>
</body>
</html>
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;
using Model;
using IDAL;
using DALFactory;
using BLL;
using AccessDAL;
using DBUtility;public partial class Login : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
//this.Session.Clear();
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
#region
///判断用户的密码和名称是否正确
//IWorker iWorker = null;
Worker worker = new Worker();
//MWorker mWorker = null; string strName = txtUserName.Text.Trim().ToString();
string strPassWord = txtPwd.Text.Trim().ToString(); #region OleDbConnection 取值
OleDbConnection con = new OleDbConnection(AccessHelper.Connection); ///创建SqlCommand
OleDbCommand cmd = new OleDbCommand("SELECT WorkerId,Name,Sex,Department,Auditing ,PassWord,IsAdmin FROM worker where Name=@Name and PassWord=@PassWord", con); cmd.Parameters.Add("@Name", SqlDbType.VarChar);
cmd.Parameters.Add("@PassWord", SqlDbType.VarChar);
cmd.Parameters[0].Value = strName;
cmd.Parameters[1].Value = strPassWord; ///定义OleDbDataReader
OleDbDataReader dr = null;
try
{
///打开连接
con.Open();
///读取数据
dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
}
catch (Exception ex)
{ ///抛出异常
throw new Exception(ex.Message, ex);
}
#endregion if (dr == null)
{
return;
} bool isLogin = false;
if (dr.Read())
{
///读取用户的登录信息,并保存,用了2种方式取OleDbDataReader中的值
worker.Name = dr.GetValue(1).ToString();
worker.PassWord = dr.GetValue(5).ToString();
worker.Sex = dr.GetValue(2).ToString();
worker.WorkerId = Convert.ToInt16(dr["workerId"].ToString());
worker.Auditing = dr["auditing"].ToString();
worker.Department = dr["department"].ToString();
worker.IsAdmin=dr.GetValue(6).ToString(); ///保存到Session中
Session["WorkerId"] = worker.WorkerId;//唯一编号
Session["name"] = worker.Name; //姓名(登录名)
Session["Sex"] = worker.Sex;//性别
Session["IsAdmin"] = worker.IsAdmin;//是否是管理员
Session["Auditing"] = worker.Auditing;//是否可以审核公告
Session["Department"] = worker.Department;//所属部门
Session["pwd"] = worker.PassWord;//密码 ///保存到全局信息中 IsAdmin
//ASP.global_asax.Users.Add(work); isLogin = true;
}
dr.Close();
///如果用户登录成功
if (isLogin == true)
{
Response.Redirect("Index.aspx");
//Response.Redirect("Index.aspx?name="+txtUserName.Text.Trim().ToString()); //跨页面传值 ///清空登录框中的信息
txtUserName.Text = txtPwd.Text = string.Empty;
return;
}
else
{
this.lblError.Text = "帐号或密码错误,请重新输入!";
txtUserName.Text = txtPwd.Text = string.Empty;
}
#endregion
}
}
记得给分!
Form1:
private void button1_Click(object sender, EventArgs e)
{
OleDbConnection conn = new OleDbConnection();
conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;DataSource=A.mdb;User Id=admin;Password=;";
conn.Open();
OleDbCommand cmd = new OleDbCommand("select * from B where userid='"+textBox1.Text.Trim()+"'", conn);
OleDbDataReader dr = cmd.ExecuteReader();
if (!dr.Read())
{
MessageBox.Show("用户名错误");
}
else
{
if (dr["pswd"].ToString() != textBox2.Text.Trim())
{
MessageBox.Show("密码错误");
}
else
{
Form2 f2 = new Form2();
f2.getusername=textBox1.Text;
f2.ShowDialog();
}
}
}
Form2:
public partial class Form2 : Form
{
public string getusername
{
get
{
return label1.Text;
}
set
{
label1.Text = value;
}
}
public Form2()
{
InitializeComponent();
}
private void Form2_Load(object sender, EventArgs e)
{
}
}没测过,大概意思明白就好了