使用c#完成一个聊天工具的学习过程 01

c# 连接数据库并实现简单登录

数据库连接类

using MySql.Data.MySqlClient;

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

namespace ChatTools.publicFile
{
    class DBConn
    {
        #region  定义连接变量
        public static String strConnRead = "Password=#qwer1234#;User ID=root;Initial Catalog=myqq;Data Source=127.0.0.1;Pooling=true;Connection Lifetime=300";
        public static String strConnEdit = "Password=#qwer1234#;User ID=root;Initial Catalog=myqq;Data Source=127.0.0.1;Pooling=true;Connection Lifetime=300";

        public static String strMySql = "127.0.0.1";

        public static string getStrConn(){
            return strConnRead;
        }
        public static string GetSqlServer()
        {
            return strMySql;
        }

        #endregion

        #region 构造和析构函数
        //构造函数,初始化对象

        public DBConn()
        {
        }

        /// 析构函数,释放对象资源
        ~DBConn()
        {
            //objConn.Dispose();

        }

        #endregion

        #region 获取一个数据连接对象

        public static MySqlConnection GetConn()
        {
            MySqlConnection objConn;
            objConn = new MySqlConnection(strConnRead);
            return objConn;
        }
        #endregion

    }

    
}

控件代码 

<Window x:Class="ChatTools.MainWindow"
        xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
        xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
        xmlns:d=