登录窗口后台验证

using System;using System.Collections.Generic;using ponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Threading.Tasks;using System.Windows.Forms;namespace AliWorkbenchProgram{public partial class LoginForm : Form{public LoginForm(){InitializeComponent();}private void BtnLogin_Click(object sender, EventArgs e){//获取文本框中的值string username = this.TxtUserName.Text;string password = this.TxtPassWord.Text;if (username.Equals("") || password.Equals(""))//用户名或密码为空{MessageBox.Show("用户名或密码不能为空");}else//用户名或密码不为空{//到数据库中验证string selectSql = "select * from tb_user where username='" + username + "' and password='" + password + "'";ClassLoginOp classLoginOp = new ClassLoginOp();int count = classLoginOp.SqlServerRecordCount(selectSql);//返回符合的结果数量if (count > 0)//如果信息>0则说明匹配成功{MessageBox.Show("信息验证成功");//将当前登录日志信息写入数据库(待开发...)//跳转到主页面AdminForm adminForm = new AdminForm();//创建一个新页面adminForm.Show();//显示新页面this.Hide();//隐藏当前页面}else{MessageBox.Show("用户名或密码错误");}}}}}

数据库连接核心代码

using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Threading.Tasks;using System.Data;using System.Data.SqlClient;namespace AliWorkbenchProgram{class ClassLoginOp{///私有属性:数据库连接字符串///Data Source=(Local)服务器地址///Initial Catalog=SimpleMESDB 数据库名称///User ID=sa 数据库用户名///Password=wxd123456 数据库密码private const string connectionString = "Data Source=(Local);Pooling=False;Max Pool Size = 1024;Initial Catalog=SimpleMESDB;Persist Security Info=True;User ID=sa;Password=wxd123456";/// <summary>/// sqlHelp 的摘要说明:数据库访问助手类/// sqlHelper是从DAAB中提出的一个类，在这里进行了简化，DAAB是微软Enterprise Library的一部分，该库包含了大量大型应用程序/// 开发需要使用的库类。/// </summary>public static SqlConnection conn;//打开数据库连接public static void OpenConn(){string SqlCon = connectionString;//数据库连接字符串conn = new SqlConnection(SqlCon);if (conn.State.ToString().ToLower() == "open"){}else{conn.Open();}}//关闭数据库连接public static void CloseConn(){if (conn.State.ToString().ToLower() == "open"){//连接打开时conn.Close();conn.Dispose();}}// 读取数据public static SqlDataReader GetDataReaderValue(string sql){OpenConn();SqlCommand cmd = new SqlCommand(sql, conn);SqlDataReader dr = cmd.ExecuteReader();CloseConn();return dr;}// 返回DataSetpublic DataSet GetDataSetValue(string sql, string tableName){OpenConn();SqlDataAdapter da;DataSet ds = new DataSet();da = new SqlDataAdapter(sql, conn);da.Fill(ds, tableName);CloseConn();return ds;}// 返回DataTablepublic DataTable GetDataTableValue(string sql){OpenConn();DataTable dt = new DataTable();SqlDataAdapter da = new SqlDataAdapter(sql, conn);da.Fill(dt);CloseConn();return dt;}// 执行一个SQL操作:添加、删除、更新操作public void ExecuteNonQuery(string sql){OpenConn();SqlCommand cmd;cmd = new SqlCommand(sql, conn);cmd.ExecuteNonQuery();cmd.Dispose();CloseConn();}// 执行一个SQL操作:添加、删除、更新操作，返回受影响的行public int ExecuteNonQueryCount(string sql){OpenConn();SqlCommand cmd;cmd = new SqlCommand(sql, conn);int value = cmd.ExecuteNonQuery();return value;}// 返回记录数public int SqlServerRecordCount(string sql){OpenConn();SqlCommand cmd = new SqlCommand();mandText = sql;cmd.Connection = conn;SqlDataReader dr;dr = cmd.ExecuteReader();int RecordCount = 0;while (dr.Read()){RecordCount = RecordCount + 1;}CloseConn();return RecordCount;}}}

如果觉得《【淘宝ERP】WinForm（C#）：登录页面实现+SQL Server数据库连接方式》对你有帮助，请点赞、收藏，并留下你的观点哦！