資源簡(jiǎn)介
根據(jù)SQL SERVER Management登陸界面制作了一個(gè)類(lèi)似于窗體,無(wú)非是用C#語(yǔ)言實(shí)現(xiàn),寫(xiě)這個(gè)程序原目的是很多人都不會(huì)連接數(shù)據(jù)庫(kù),你可以看看我的代碼,其實(shí)就是那么幾行。

代碼片段和文件信息
using?System;
using?System.Data;
using?System.Data.SqlClient;
using?System.Threading;
using?System.Windows.Forms;
namespace?WinFormLoginSqlServer
{
????public?partial?class?LoginForm?:?Form
????{
????????private?bool?bIdentity;//基本身份驗(yàn)證
????????public?LoginForm()
????????{
????????????InitializeComponent();
????????}
????????private?void?LoginForm_Load(object?sender?EventArgs?e)
????????{
????????????cbServerType.Items.Add(“數(shù)據(jù)庫(kù)搜索引擎“);
????????????cbServerType.SelectedIndex?=?0;
????????????cbServerName.Items.Add(“l(fā)ocalhost“);
????????????cbServerName.SelectedIndex?=?0;
????????????cbIdentity.Items.Add(“基本身份驗(yàn)證“);
????????????cbIdentity.Items.Add(“Windows?身份驗(yàn)證“);
????????????cbIdentity.SelectedIndex?=?0;
????????}
????????private?void?cbIdentity_SelectedIndexChanged(object?sender?EventArgs?e)
????????{
????????????if?(cbIdentity.SelectedIndex?==?0)
????????????{
????????????????bIdentity?=?true;
????????????????txtName.Enabled?=?txtPassword.Enabled?=?true;
????????????}
????????????else
????????????{
????????????????bIdentity?=?false;
????????????????txtName.Enabled?=?txtPassword.Enabled?=?false;
????????????}
????????}
????????private?void?btnExit_Click(object?sender?EventArgs?e)
????????{
????????????Application.Exit();
????????}
????????private?void?btnGo_Click(object?sender?EventArgs?e)
????????{
????????????string?s?=?““;
????????????if?(bIdentity)
????????????{
????????????????s?=?“server=“?+?cbServerName.Text?+?“;uid=“?+?txtName.Text?+?“;password=“?+?txtPassword.Text?+?“;database=master;“;
????????????}
????????????else
????????????{
????????????????s?=?“Data?Source=“?+?cbServerName.Text?+?“;Integrated?Security=SSPI;Initial?Catalog=master;“;
????????????}
????????????try
????????????{
????????????????SqlConnection?con?=?new?SqlConnection(s);
????????????????con.Open();
????????????????con.Close();
????????????????lbString.Width?=?s.Length;
????????????????lbString.Text?=?“DB:“?+?s;
????????????????//Clipboard.SetDataobject(s);
????????????}
????????????catch?(Exception?ex)
????????????{
????????????????lbString.Text?=?ex.Message.Substring(0?ex.Message.IndexOf(‘。‘));
????????????}
????????}
????}
}
?屬性????????????大小?????日期????時(shí)間???名稱(chēng)
-----------?---------??----------?-----??----
?????文件????????492??2009-02-25?07:45??Program.cs
?????文件???????3269??2009-02-25?09:00??WinFormLoginSqlServer.csproj
?????文件???????1080??2009-02-25?07:44??WinFormLoginSqlServer.sln
????..A..H.?????19968??2009-02-25?09:15??WinFormLoginSqlServer.suo
?????目錄??????????0??2009-02-25?07:45??bin
?????目錄??????????0??2009-02-25?08:03??bin\Debug
?????文件?????700416??2009-02-25?09:01??bin\Debug\WinFormLoginSqlServer.exe
?????文件??????26112??2009-02-25?09:01??bin\Debug\WinFormLoginSqlServer.pdb
?????文件???????5632??2005-09-23?06:56??bin\Debug\WinFormLoginSqlServer.vshost.exe
?????目錄??????????0??2009-02-25?08:03??obj
?????目錄??????????0??2009-02-25?09:01??obj\Debug
?????目錄??????????0??2009-02-25?07:45??obj\Debug\Refactor
?????目錄??????????0??2009-02-25?07:44??obj\Debug\TempPE
?????文件????????846??2009-02-25?08:51??obj\Debug\WinFormLoginSqlServer.csproj.GenerateResource.Cache
?????文件?????700416??2009-02-25?09:01??obj\Debug\WinFormLoginSqlServer.exe
?????文件?????677676??2009-02-25?08:51??obj\Debug\WinFormLoginSqlServer.LoginForm.resources
?????文件??????26112??2009-02-25?09:01??obj\Debug\WinFormLoginSqlServer.pdb
?????文件????????180??2009-02-25?08:03??obj\Debug\WinFormLoginSqlServer.Properties.Resources.resources
?????文件????????746??2009-02-25?09:11??obj\WinFormLoginSqlServer.csproj.FileListAbsolute.txt
?????目錄??????????0??2009-02-25?07:44??Properties
?????文件???????1302??2009-02-25?07:44??Properties\AssemblyInfo.cs
?????文件???????2871??2009-02-25?07:44??Properties\Resources.Designer.cs
?????文件???????5612??2009-02-25?07:44??Properties\Resources.resx
?????文件???????1106??2009-02-25?07:44??Properties\Settings.Designer.cs
?????文件????????249??2009-02-25?07:44??Properties\Settings.settings
?????文件???????2248??2009-02-25?09:01??LoginForm.cs
?????文件??????10321??2009-02-25?08:51??LoginForm.Designer.cs
?????文件????1022082??2009-02-25?08:51??LoginForm.resx
-----------?---------??----------?-----??----
??????????????3208736????????????????????28
............此處省略1個(gè)文件信息
評(píng)論
共有 條評(píng)論