C#连接SQL SERVER数据库的登录窗口

其中包含两个文件：

1、App.config

<? xml version = " 1.0 "  encoding = " utf-8 "   ?>
< configuration >
   < appSettings  >
     < add key = " url "  value = " 192.168.0.2 " />
     < add key = " database "  value = " WFXX " />
     < add key = " uname "  value = " sa " />
     < add key = " psd "  value = " sa " />
   </ appSettings  >
</ configuration >

2、Form1.cs 

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

namespace  Login
{
     public   partial   class  Login : Form
    {
         string  url  =  System.Configuration.ConfigurationSettings.AppSettings[ " url " ];
         string  database  =  System.Configuration.ConfigurationSettings.AppSettings[ " database " ];
         string  uname  =  System.Configuration.ConfigurationSettings.AppSettings[ " uname " ];
         string  psd  =  System.Configuration.ConfigurationSettings.AppSettings[ " psd " ];

         public  Login()
        {
            InitializeComponent();
        }

         private   void  button2_Click( object  sender, EventArgs e)
        {
            Close();
        }

         private   void  button1_Click( object  sender, EventArgs e)
        {
             string  userlogin  =  txt_uname.Text;
             string  psdlogin  =  txt_psd.Text;

            SqlConnection conn  =   new  SqlConnection( @" data source=  "   +  url  +   " ;uid= "   +  uname  +   " ;pwd= "   +  psd  +   " ;database= "   +  database);
            conn.Open();
            SqlCommand cmd  =   new  SqlCommand( " select password from UserLogin where username =' "   +  userlogin  +   " ' " , conn);
            SqlDataReader reader  =  cmd.ExecuteReader();
             if  (reader.Read())
            {
                 if  (psdlogin  ==  reader[ " password " ].ToString().Trim())
                {
                     this .Hide();
                    LoginForm lg  =   new  LoginForm();
                    lg.Show();
                }
                 else
                {

                    MessageBox.Show( " 密码不正确！ " );
                }
            }
             else
            {
                MessageBox.Show( " 不存在此用户！ " );
            }
        }
    }
}