C#中用户登录密码设置的代码

[jhr123321]

小弟编写了个用户登录的界面，数据库用的是sqlsever2005 ，代码如下：
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.Collections;

namespace WindowsFormsApplication4
{


public partial class Form1 : Form
{
public SqlConnection m_con = new SqlConnection();
public Form1()
{
InitializeComponent();
}

private void button1_Click(object sender, EventArgs e)
{
string connsql = String.Format("server=127.0.0.1;Uid=sa;pwd=sasys;database= aa;");
//mySqlConnection1 = new MySqlConnection(connStr);
m_con.ConnectionString = connsql;

try
{
m_con.Open();

String str = "SELECT * FROM aa";

SqlCommand cmd = m_con.CreateCommand();
cmd.CommandText = str;
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = cmd;
DataSet ds = new DataSet();
adapter.Fill(ds);
ds.Tables[0].TableName = "LONG_DN_TableName";

// DataColumn dc = ds.Tables["s_tables_dict"].Columns["TABLE_NAME"];
// int intcr = Convert.ToInt32( ds.Tables["s_tables_dict"].get);
// int intcrindex = 0;lvw_bjt
foreach (DataRow row in ds.Tables["LONG_DN_TableName"].Rows)
{
//DataRow dr = ds.Tables["s_tables_dict"].Rows[intcrindex];
string str1 = Convert.ToString(row[0]);
string str2 = Convert.ToString(row[1]);
string str3 = Convert.ToString(row[2]);

MessageBox.Show(str1);



}

}
catch (Exception ex1)
{
MessageBox.Show(ex1.Message);
}
finally
{
m_con.Close();
}


/* try
{
// MessageBox.Show(strsqldata);
SqlCommand cmd = m_con.CreateCommand();
cmd.CommandText = strsqldata;
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = cmd;
DataSet ds = new DataSet();
adapter.Fill(ds);


ds.Tables[0].TableName = "f_files_manager";
int i = ds.Tables[0].Rows.Count;

int index = 0;

foreach (DataRow row in ds.Tables["f_files_manager"].Rows)
{
string str1 = Convert.ToString(row["userCnName"]);
MessageBox.Show(str1);

index++;
}


}
catch
{
MessageBox.Show("mysqlerror");
}
*/


}

private void maskedTextBox2_MaskInputRejected(object sender, MaskInputRejectedEventArgs e)
{

}

private void maskedTextBox1_MaskInputRejected(object sender, MaskInputRejectedEventArgs e)
{

}

private void button2_Click(object sender, EventArgs e)
{
Application.Exit();
}
}
}
现在想添加用户名密码验证，求大神来帮忙啊！

[bdmh]

构造函数中去数据库select对应的用户信息，存在就是通过

[dlx_2632641148]

用户登录验证数据输入是否正确示例 //登录页面设置 <asp:TextBox ID="txtUserName" runat="server" Width="141px"></asp:TextBox>//用户名文本框设置 <asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ControlToValidate="txtUserName" ErrorMessage="用户名必须填写">*</asp:RequiredFieldValidator>//必填设置 <asp:TextBox ID="txtUserpass" runat="server" Width="141px" TextMode="Password"></asp:TextBox>//用户密码框设置 <asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server" ControlToValidate="txtUserpass" ErrorMessage="密码必须填写">*</asp:RequiredFieldValidator> <asp:TextBox ID="txtCode" runat="server" Width="65px"></asp:TextBox></td>//验证码设置 <td style="width: 136px; text-align: left" valign="top"> <asp:RequiredFieldValidator ID="RequiredFieldValidator3" runat="server" ControlToValidate="txtCode" ErrorMessage="验证码必须填写">*</asp:RequiredFieldValidator><img style=" cursor:hand;width: 76px; height: 21px" id="imgCode" src="CheckCode.aspx" alt="看不清，请点击我！" onclick="this.src=this.src+'?'" /> <asp:Button ID="btnLog" runat="server" Text="登 录" OnClick="btnLog_Click" />//登录按钮事件 //登录cs页面验证用户名、密码设置 protected void btnLog_Click(object sender, EventArgs e) { //获取验证码 string code = txtCode.Text; //判断用户输入的验证码是否正确 if (Request.Cookies["CheckCode"].Value == code) { //创建数据库连接 SqlConnection con = new SqlConnection("server=.;database=db_Register;uid=sa;pwd=;"); //打开数据库连接 con.Open(); //使用MD5加密将用户输入的密码加密 string pass = FormsAuthentication.HashPasswordForStoringInConfigFile(txtUserpass.Text, "MD5"); //创建SQL语句，该语句用来查询用户输入的用户名和密码是否正确 string sqlSel = "select count(*) from tb_userInfo where userName=@name and userPass=@pass"; //创建SqlCommand对象 SqlCommand com = new SqlCommand(sqlSel, con); //使用Parameters的add方法添加参数类型 com.Parameters.Add(new SqlParameter("name", SqlDbType.VarChar, 20)); //设置Parameters的参数值 com.Parameters["name"].Value = txtUserName.Text; com.Parameters.Add(new SqlParameter("pass", SqlDbType.VarChar, 50)); com.Parameters["pass"].Value = pass; //判断ExecuteScalar方法返回的参数是否大于0大于表示登录成功并给出提示 if (Convert.ToInt32(com.ExecuteScalar()) > 0) { RegisterStartupScript("", "<script>alert('登录成功！')</script>"); //清空文本框 txtCode.Text = txtUserName.Text = ""; } else { RegisterStartupScript("", "<script>alert('用户名或密码错误！')</script>"); } } else { RegisterStartupScript("", "<script>alert('验证码输入错误！')</script>"); }

[JJ___fly]

初学 最近也在尝试做一个登陆界面

[於黾]

写了一堆,都是啥呀 学写代码之前,先学会写伪代码,把逻辑捋通顺了,再翻译成代码 从你的代码上来看,你自己都不知道到底想干啥 先说登陆, 1.根据用户名查询数据库,判断行数是否大于0 2.如果不大于0,用户名不存在,如果大于0,判断密码是否正确 3.如果密码不正确,提示密码错误,如果密码正确,关闭登陆窗体,打开主窗体 如果要修改密码 1.至少要有3个文本框,一个输入旧密码,两个输入新密码 2.先判断旧密码是否正确 3.判断两个新密码是否相同 4.都判断成功了,更新数据库

[devmiao]

http://bbs.csdn.net/topics/390886059 看里面的 C# Creating a Windows Forms Application With Login winforms实现用户登录逻辑