C#十四章 例子三

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.SqlClient;
namespace ConsoleApplication1
{
    class Program
    {
        private const string strConn = @"Data Source=.;Initial Catalog=MySchool;Integrated Security=True";
        static void Main(string[] args)
        {
            Program p = new Program();
            string userName = "admin";
            string pwd = "0";
            string strMsg = "用来保存信息";
            bool y = p.CheckUserInfo(userName ,pwd, ref strMsg);
            if (y)
            {
                Console.WriteLine(strMsg);
            }
            else
            {
                Console.WriteLine(strMsg);
            }
            Console.ReadLine();
        }
        public bool CheckUserInfo(string userName, string pwd, ref string strMsg)
        {
            string connString = "Data Source=.;Initial Catalog=MySchool;Integrated Security=True;";
            SqlConnection a = new SqlConnection(connString);
            try
            {
                string strSql = "SELECT COUNT(*) FROM [MySchool].[dbo].[Admin] where LoginId='" + userName + "'and LoginPwd='" + pwd + "'";
                Console.WriteLine(strSql);

                a.Open();
                Console.WriteLine("打开成功");
                SqlCommand comm = new SqlCommand(strSql, a);
                int iRet = (int)comm.ExecuteScalar();
                if (iRet != 1)
                {
                    strMsg = "输入无效";
                    return false;
                }
                else
                {
                    return true;
                }
            }
            catch (Exception)
            {

                strMsg = "异常";
                return false;
            }
            finally
            {
                a.Close();

            }
        }
    }
}