Form1.cs

最新推荐文章于 2024-08-14 15:54:38 发布

转载最新推荐文章于 2024-08-14 15:54:38 发布 · 275 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/HarryChis/p/10368758.html

本文介绍了一个使用C#和SQL进行用户登录验证的示例代码，同时展示了如何从数据库中读取用户信息并将其显示在dataGridView控件上。通过SqlParameter参数化查询，提高了SQL查询的安全性。

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 _001
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            string sql = "select count(*) from tbusers where loginid=@loginid and loginpwd=@loginpwd";
            SqlParameter[] pms = new SqlParameter[]{
            new SqlParameter("@loginid",SqlDbType.VarChar,50){Value=textBox1.Text.Trim()},
            new SqlParameter("@loginpwd",SqlDbType.VarChar,50){Value=textBox2.Text.Trim()}
            };
            int i=(int)SqlHelper.ExecuteScalar(sql,pms);
            if(i>0)
            {
            this.Text="成功";
            }
            else
            {
            this.Text="失败";
            }
        }

        private void button2_Click(object sender, EventArgs e)
        {
            //声明集合
            List<tbusers> list= new List<tbusers>();
            string sql="select loginid,loginpwd from tbusers";
            using (SqlDataReader reader = SqlHelper.ExecuteReader(sql))
            {
                if (reader.HasRows)
                {
                    while (reader.Read())
                    {
                        //添加到数据模型
                        tbusers model = new tbusers();
                        model.loginid = reader.GetString(0);
                        model.loginpwd = reader.GetString(1);

                        //把数据添加到集合里
                        list.Add(model);
                    }
                }
            }
            //将集合的数据绑定到dataGridView控件
            dataGridView1.DataSource = list;
        }

private void Form1_Load(object sender, EventArgs e)
{

}
}
}

转载于:https://www.cnblogs.com/HarryChis/p/10368758.html