aod.net

最新推荐文章于 2025-06-03 11:01:07 发布

as86238582

最新推荐文章于 2025-06-03 11:01:07 发布

阅读量546

点赞数

CC 4.0 BY-SA版权

文章标签： button object string sql security 数据库

本文链接：https://blog.csdn.net/as86238582/article/details/7658277

本文介绍了一个使用C#和SQL Server进行用户登录验证的简单应用程序。该应用通过连接到SQL Server数据库并执行参数化查询来检查用户名和密码的有效性。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace WindowsApplication12
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {

          string connString = @"Data Source=k208-38\SQLEXPRESS;Initial Catalog=student;Integrated Security=True";
          SqlConnection conn = new SqlConnection(connString);
          conn.Open();// 打开数据库连接

          //string name = tdname.Text.Trim();//获取用户名控件文本，且去掉空格
          //string pwd = tdpwd.Text.ToString().Trim();
          //string sql = "select count(*) from admin where LoginID = '" + name + "' and LoginPwd='" + pwd + "'";
          string sql = "select count(*) from admin where LoginID =@ID and LoginPwd=@Pwd";

          SqlCommand cmd = new SqlCommand(sql, conn);
          cmd.Parameters.AddWithValue("@ID", tdname.Text);
          cmd.Parameters.AddWithValue("@Pwd", tdpwd.Text);
           int result = (int)cmd.ExecuteScalar();

           if (result > 0)
           {
               Form2 f = new Form2();
               f.Show();

           }
           else
            {
                MessageBox.Show("账户密码错误");
            }

        }

        private void button2_Click(object sender, EventArgs e)
        {
            this.Close();
        }
    }
}