基本信息
源码名称:C# 验证sql server数据库账号密码是否正确
源码大小:0.04M
文件格式:.zip
开发语言:C#
更新时间:2018-02-17
   友情提示:(无需注册或充值,赞助后即可获取资源下载链接)

     嘿,亲!知识可是无价之宝呢,但咱这精心整理的资料也耗费了不少心血呀。小小地破费一下,绝对物超所值哦!如有下载和支付问题,请联系我们QQ(微信同号):78630559

本次赞助数额为: 2 元 
   源码介绍

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 Ex16_05
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }
        public SqlConnection con = null;//实义数据库连接对象
        private void button1_Click(object sender, EventArgs e)
        {
            if (textBox1.Text == "")
            {
                MessageBox.Show(textBox1.Tag.ToString() "不能为空","提示");
                textBox1.Focus();
                return;
            }
            if (textBox2.Text == "")
            {
                MessageBox.Show(textBox2.Tag.ToString()   "不能为空", "提示");
                textBox2.Focus();
                return;
            }
            if (textBox4.Text == "")
            {
                MessageBox.Show(textBox4.Tag.ToString()   "不能为空", "提示");
                textBox4.Focus();
                return;
            }
            try
            {
                string strcon = "server='"   textBox1.Text.Trim()   "';uid='"   textBox2.Text.Trim()   "';pwd='"   textBox3.Text   "';database='"   textBox4.Text.Trim()   "'";
                con = new SqlConnection(strcon);//实例SqlConnect对象
                con.Open();
                MessageBox.Show("登录成功");
            }
            catch (Exception ee)
            {
                MessageBox.Show(ee.Message);
            }
        }

        private void textBox4_TextChanged(object sender, EventArgs e)
        {

        }

        private void button3_Click(object sender, EventArgs e)
        {
            Application.Exit();
        }

        private void button2_Click(object sender, EventArgs e)
        {
            if (con.State == ConnectionState.Open)
            {
                con.Close();
                MessageBox.Show("联接已断开");
            }
            else
            {
                MessageBox.Show("还没有联接数据库");
            }
        }
    }
}