数据库连接数据库（登录）

最新推荐文章于 2023-09-27 20:14:30 发布

weixin_30496751

最新推荐文章于 2023-09-27 20:14:30 发布

阅读量158

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/hujianwei/p/9679392.html

版权

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;
namespace 病区管理系统
{
    public partial class 登录 : Form
    {
        public 登录()
        {
            InitializeComponent();
        }

        private void DengLu_Click(object sender, EventArgs e)
        {
            SqlConnection sqlConnection = new SqlConnection();
            sqlConnection.ConnectionString =
                "Server=(local);Database=病区管理;Integrated Security=false;uid=jsj;password=2wsx@WSX";
            SqlCommand sqlCommand = new SqlCommand();
            sqlCommand.Connection = sqlConnection;
            sqlCommand.CommandText =
                "SELECT COUNT(1) FROM 登录"
                + " WHERE No='" + 账号.Text.Trim() + "'"
                + " AND Password='" + 密码.Text.Trim() + "';";
            sqlConnection.Open();
            int rowCount = (int)sqlCommand.ExecuteScalar();
            sqlConnection.Close();
            if (rowCount == 1)
            {
                MessageBox.Show("登录成功。");
            }
            else
            {
                MessageBox.Show("用户号/密码有误，请重新输入！");
               密码.Focus();
                密码.SelectAll();
            }
        }
    }
}

转载于:https://www.cnblogs.com/hujianwei/p/9679392.html