conectform.cs

ADO数据库操作+DataGradView控件

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;
using System.Data.SqlTypes;

namespace ImportC_S
{
    
    public partial class ConectForm : Form
    {
        public string ConnectStr;
        public System.Data.SqlClient.SqlConnection SqlConnect;
        public ConectForm()
        {
            InitializeComponent();
        }

        
        private void Linkcmd_Click(object sender, EventArgs e)
        {
           
            try
            {
                if (jqNameTxt.Text.Length == 0)
                {
                    MessageBox.Show("数据服务器名称不能为空", "提示");
                    return;
                }
                if (DbNameTxt.Text.Length == 0)
                {
                    MessageBox.Show("数据库名称不能为空", "提示");
                    return;
                }
                if (UserNameTxt.Text.Length == 0)
                {
                    MessageBox.Show("用户名不能为空", "提示");
                    return;

                }

                string Provider = jqNameTxt.Text.ToString();
                string DbName = DbNameTxt.Text.ToString();
                string UserName = UserNameTxt.Text.ToString();
                string Pswd = PswdTxt.Text.ToString();
                ConnectStr = "integrated security=SSPI;data source=" + Provider + ";persist security info=False;initial catalog=" + DbName + ";UID=" + UserName + ";Password=" + Pswd;
                SqlConnect.ConnectionString = ConnectStr;
                
                SqlConnect.Open();
                
                MessageBox.Show("连接成功");
                //SqlConnect.Close();
            }
            catch(Exception Err)
            {
                MessageBox.Show(Err.Message);
            }
        }
    }
}