91av视频/亚洲h视频/操亚洲美女/外国一级黄色毛片 - 国产三级三级三级三级

  • 大小: 3.81M
    文件類型: .zip
    金幣: 1
    下載: 0 次
    發布日期: 2020-12-26
  • 語言: C#
  • 標簽: SQL??Server??C#??ADO.NET??

資源簡介

 



【實例源碼】


朋友們好，該功能在測試中突然發現，通過Windows身份驗證時，服務器IP與數據庫值為空的時候，測試連接也會提示連接成功，這個BUG請大家給予幫助，謝謝！


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

namespace ConData
{
    public partial class ConnectionData : Form
    {
        public ConnectionData()
        {
            InitializeComponent();
        }

        private void btnSQLOK_Click(object sender, EventArgs e)
        {
            string strcon = string.Format("server={0};database={1};uid={2};pwd={3};", this.txtIP.Text.Trim(), txtDataBase.Text.Trim(), txtUser.Text.Trim(), txtPwd.Text.Trim());
            try
            {
                using (SqlConnection con = new SqlConnection(strcon))
                {
                    con.Open();
                    MessageBox.Show("測試成功！");
                    con.Close();
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

        private void btnWindowsOK_Click(object sender, EventArgs e)
        {
            string strCon = string.Format("server={0};database={1};Trusted_Connection=SSPI", txtWindowsIP.Text.Trim(), txtWindowsDB.Text.Trim());
            try
            {
                using (SqlConnection con = new SqlConnection(strCon))
                {
                    con.Open();
                    MessageBox.Show("測試成功！");
                    con.Close();
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
    }
}


資源截圖

代碼片段和文件信息 

using?System;
using?System.ComponentModel;
using?System.Data.SqlClient;
using?System.Drawing;
using?System.Windows.Forms;

namespace?ConData
{
	public?class?ConnectionData?:?Form
	{
		private?IContainer?components?=?null;

		private?Button?btnSQLOK;

		private?Label?label1;

		private?TextBox?txtIP;

		private?Label?label2;

		private?TextBox?txtDatabase;

		private?Label?label3;

		private?TextBox?txtUser;

		private?Label?label4;

		private?TextBox?txtPwd;

		private?GroupBox?groupBox1;

		private?GroupBox?groupBox2;

		private?Label?label6;

		private?TextBox?txtWindowsDB;

		private?Label?label5;

		private?TextBox?txtWindowsIP;

		private?Button?btnWindowsOK;

		protected?override?void?Dispose（bool?disposing）
		{
			if?（disposing?&&?this.c

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2018-08-03?21:34??.vs\
?????目錄???????????0??2018-08-03?21:34??.vs\ConData\
?????目錄???????????0??2018-08-03?21:36??.vs\ConData\v15\
?????文件???????36864??2018-08-03?21:36??.vs\ConData\v15\.suo
?????目錄???????????0??2018-08-03?21:34??.vs\ConData\v15\Server\
?????目錄???????????0??2018-08-03?21:34??.vs\ConData\v15\Server\sqlite3\
?????文件???????????0??2018-08-03?21:34??.vs\ConData\v15\Server\sqlite3\db.lock
?????文件????????4096??2018-08-03?21:34??.vs\ConData\v15\Server\sqlite3\storage.ide
?????文件???????32768??2018-08-03?21:34??.vs\ConData\v15\Server\sqlite3\storage.ide-shm
?????文件??????523272??2018-08-03?21:34??.vs\ConData\v15\Server\sqlite3\storage.ide-wal
?????目錄???????????0??2018-08-03?21:34??ConData\
?????文件????????7330??2018-08-03?21:34??ConData\ConnectionData.cs
?????文件????????1792??2018-08-03?21:34??ConData\FormMessageBox.cs
?????文件?????????305??2018-08-03?21:34??ConData\Program.cs
?????目錄???????????0??2018-08-03?21:34??ConData.Properties\
?????文件????????1131??2018-08-03?21:34??ConData.Properties\Resources.cs
?????文件?????????499??2018-08-03?21:34??ConData.Properties\Settings.cs
?????文件????????2468??2018-08-03?21:34??ConData.csproj
?????文件???????12800??2014-04-16?15:31??ConData.exe
?????文件????????1112??2018-08-03?21:36??ConData.sln
?????目錄???????????0??2018-08-03?21:34??Properties\
?????文件?????????974??2018-08-03?21:34??Properties\AssemblyInfo.cs
?????目錄???????????0??2018-08-03?21:34??bin\
?????目錄???????????0??2018-08-03?21:34??bin\Debug\
?????文件???????12288??2018-08-03?21:34??bin\Debug\ConData.exe
?????文件???????24064??2018-08-03?21:34??bin\Debug\ConData.pdb
?????文件?????2975744??2018-06-06?09:33??bin\Debug\System.Data.dll
?????文件??????630784??2018-06-06?09:33??bin\Debug\System.Drawing.dll
?????文件?????5025792??2018-06-06?09:33??bin\Debug\System.Windows.Forms.dll
?????文件?????3203072??2018-06-06?09:33??bin\Debug\System.dll
?????目錄???????????0??2018-08-03?21:34??obj\
............此處省略10個文件信息

評論

共有 條評論