c#对数据验证两种方式

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using SqlLibrary;
using System.Data;

namespace ConsoleApplication15
{
    class Program
    {
        static void Main(string[] args)
        {
            //Person p = new Person() { UserName = "张开国", PassWord = "851016" };
            //Person p2 = new Person() { UserName = "萱萱", PassWord = "141229" };
            //Person p3 = new Person() { UserName = "宝水", PassWord = "110921" };
            //List<Person> list = new List<Person>() { p, p2, p3 };
            //foreach (Person item in list)
            //{
            //    string sql = $"insert into dblogin values('{item.UserName}','{item.PassWord}')";
            //    int c=Sql.EditSql(sql);
            //    Console.WriteLine(c);
            //}

            Console.WriteLine("欢迎进入登录系统。。。。");
            Console.Write("请输入用户名:");
            string inputname = Console.ReadLine();
            Console.Write("请输入用户密码:");
            string inputpwd = Console.ReadLine();

            //bool result =test1( inputname,  inputpwd);
            //第二种方式
            bool result = test2(inputname, inputpwd);

            if (result)
            {
                Console.WriteLine("登录成功");
            }else
            {
                Console.WriteLine("登录失败，用户名或密码错误");
            }
            


            Console.ReadKey();

        }

        public static bool test1(string inputname,string intputpwd)
        {
            string sql = "select * from dblogin";
            DataTable table = Sql.Search(sql);

            for (int i = 0; i < table.Rows.Count; i++)
            {
                string username = table.Rows[i]["UserName"].ToString().Trim();
                string password = table.Rows[i]["PassWord"].ToString().Trim();
         
                Console.WriteLine(username==inputname);
            

                if (inputname==username && intputpwd==password)
                {
                    return true;
                }
         
            }
            return false;

        }


        public static bool test2(string user,string pwd)
        {
            string sql = $"select * from dblogin where username='{user}' and password='{pwd}'";

            DataTable table = Sql.Search(sql);
            if (table.Rows.Count>0)
            {
                return true;
            }else
            {
                return false;
            }
        }
    }

    public class Person
    {
        public String UserName;
        public string PassWord;
    }
}