注册（带验证用户名）

// -------------------------------Program.cs--------------------------------------------------------------

using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace _07注册
{
    static class Program
    {
        /// <summary>
        /// The main entry point for the application.
        /// </summary>
        [STAThread]
        static void Main()
        {
            Application.EnableVisualStyles();
            Application.SetCompatibleTextRenderingDefault(false);
            Application.Run(new Form1());
        }
    }
}

//------------------------------------Form1--------------------------------------------------------------------

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace _07注册
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        /// <summary>
        /// 获得用户名，查询数据库是否存在该数据
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void txtUid_Leave(object sender, EventArgs e)
        {

            string uid = txtUid.Text.Trim();
            // 验证
            if (string.IsNullOrEmpty(uid))
            {
                lbNote.Text = "";
                return;
           
            }
            // 连接字符串
            // sql
            // 连接对象
            // 执行对象
            // 打开
            // 执行
          
            string connStr = @"server=.;database=MySecondDB;uid=sa;password=520;";
            string sql = "select count(*) from loginPrimaryTest where uid='" + uid + "'";
            int count;
            using (SqlConnection conn = new SqlConnection(connStr))
            {
                using (SqlCommand cmd = new SqlCommand(sql, conn))
                {
                    conn.Open();
                    count = (int)cmd.ExecuteScalar(); // 拆箱
                }
            }
            if (count > 0)
            {
                // 存在
                lbNote.ForeColor = Color.Red;
                lbNote.Text = "用户已存在";
            }
            else
            {
                // 不存在
                lbNote.ForeColor = Color.Green;
                lbNote.Text = "√";
            }
        }

        private void btnReg_Click(object sender, EventArgs e)
        {
            // 完成注册

             // 获得用户名
            string uid = txtUid.Text.Trim();  // 这里需要Trim
            // 获得用户的第一个密码
            string pwd1 = txtPwd1.Text; // 这里不用Trim
            // 获得用户的第二个密码
            string pwd2 = txtPwd2.Text; // 不需要Trim

            // 验证用户输入
            if (string.IsNullOrEmpty(uid) || string.IsNullOrEmpty(pwd1) || string.IsNullOrEmpty(pwd2))
            {
                MessageBox.Show("请填写完整信息");
                return;
            }
            if(pwd1!=pwd2)
            {
                MessageBox.Show("两次输入的密码不一致");
                return;
            }

            // 进入ADO.NET部分
            string connStr = @"server=.;database=MySecondDB;uid=sa;password=520;";
            string sql1 = "insert into loginPrimaryTest(uid, pwd) values('"+ uid +"','"+ pwd1 +"');";
            string sql2 = string.Format("insert into loginPrimaryTest(uid, pwd) values('{0}','{1}');", uid, pwd1);
            using (SqlConnection conn = new SqlConnection(connStr))
            {
                if (lbNote.Text == "√")
                {
                    using (SqlCommand cmd = new SqlCommand(sql1, conn))
                    {
                        conn.Open();
                        int count = cmd.ExecuteNonQuery();

                        conn.Dispose();
                        cmd.Dispose();

                        MessageBox.Show(count > 0 ? "注册成功！" : "注册失败！");
                    }
                }
            } // ADO.NET

        }
    }
}

//------------------------------------配置文件--------------------------------------------------------------

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
    <startup>
        <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.5" />
    </startup>
  <connectionString>
    <add name="sql" connectionString="sever=.;database=MySecondDB;uid=sa;pwd=520;"/>
    <add name="sql1" connectionString="第一个sql语句"/>
  </connectionString>
</configuration>