using?System;
using?System.Collections.Generic;
using?System.ComponentModel;
using?System.Data;
using?System.Drawing;
using?System.Linq;
using?System.Text;
using?System.Threading.Tasks;
using?System.Windows.Forms;
using?System.Data.SqlClient;
using?System.Runtime.InteropServices;
namespace?SQL課程設(shè)計(jì)
{
????public?partial?class?Form1?:?Form
????{
????????public?Form1（）
????????{
????????????InitializeComponent（）;
????????}
????????private?void?Form1_Load（object?sender?EventArgs?e）
????????{
????????????this.textBox2.PasswordChar?=?‘*‘;
????????????this.label1.BackColor?=?Color.Transparent;
????????????this.label2.BackColor?=?Color.Transparent;
????????????this.Size?=?new?Size（500?300）;
????????????int?xWidth?=?SystemInformation.PrimaryMonitorSize.Width;
????????????//獲取顯示器屏幕高度
????????????int?yHeight?=?SystemInformation.PrimaryMonitorSize.Height;
????????????this.Location?=?new?Point（（xWidth?-?500）?/?2?（yHeight?-?300）?/?2）;
????????????this.StartPosition?=?FormStartPosition.Manual;
????????}

????????private?void?label1_Click（object?sender?EventArgs?e）
????????{

????????}

????????private?void?Button1_Click_1（object?sender?EventArgs?e）
????????{
????????????int?admin?=?0;
????????????string?sql?=?“server=.;database=SQL_Design;uid=kevin;pwd=123456789“;?
????????????string?str?=?“select?*from?users?where?賬號=‘“;
????????????str?+=?this.textBox1.Text;
????????????str?+=?“‘?and?密碼=‘“;
????????????str?+=?this.textBox2.Text;
????????????str?+=?“‘“;
????????????SqlConnection?con?=?new?SqlConnection（sql）;
????????????con.Open（）;
????????????string[]?users?=?new?string[3];
????????????SqlCommand?cmd?=?new?SqlCommand（str?con）;
????????????SqlDataReader?reader?=?cmd.ExecuteReader（）;
????????????object[]?row?=?new?object[reader.FieldCount];

????????????if?（!reader.Read（））
????????????{
????????????????MessageBox.Show（“賬號或密碼錯(cuò)誤“）;
????????????????return;
????????????}
????????????else
????????????{
????????????????reader.GetValues（row）;
????????????????for?（int?i?=?0;?i?????????????????????users[i]?=?row[i].ToString（）;
????????????}

????????????if?（string.Equals（users[2][0]?‘管‘））
????????????????admin?=?3;
????????????else?if?（string.Equals（users[2][0]?‘老‘））
????????????????admin?=?2;
????????????else
????????????????admin?=?1;
????????????con.Close（）;
????????????this.Hide（）;
????????????Form2?form?=?new?Form2（adminthis.textBox1.Text）;
????????????form.Show（）;
????????}
????}
}

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2017-06-22?17:12??SQL\
?????目錄???????????0??2018-05-10?23:19??SQLData\
?????目錄???????????0??2017-06-08?12:21??SQLData\SQL\
?????文件?????????935??2017-04-05?10:30??SQLData\SQL.sln
?????文件???????68096??2017-08-15?11:15??SQLData\SQL.suo
?????文件?????????187??2017-04-05?10:30??SQLData\SQL\App.config
?????目錄???????????0??2017-04-05?10:30??SQLData\SQL\bin\
?????目錄???????????0??2017-04-05?10:46??SQLData\SQL\bin\Debug\
?????文件?????1731584??2017-06-14?11:19??SQLData\SQL\bin\Debug\SQL課程設(shè)計(jì).exe
?????文件?????????187??2017-04-05?10:30??SQLData\SQL\bin\Debug\SQL課程設(shè)計(jì).exe.config
?????文件???????91648??2017-06-14?11:19??SQLData\SQL\bin\Debug\SQL課程設(shè)計(jì).pdb
?????文件???????22984??2017-08-14?19:57??SQLData\SQL\bin\Debug\SQL課程設(shè)計(jì).vshost.exe
?????文件?????????187??2017-04-05?10:30??SQLData\SQL\bin\Debug\SQL課程設(shè)計(jì).vshost.exe.config
?????文件?????????490??2010-03-17?22:39??SQLData\SQL\bin\Debug\SQL課程設(shè)計(jì).vshost.exe.manifest
?????文件????????2574??2017-06-12?21:31??SQLData\SQL\Form1.cs
?????文件????????4471??2017-06-07?17:49??SQLData\SQL\Form1.Designer.cs
?????文件????????5817??2017-06-07?18:08??SQLData\SQL\Form1.resx
?????文件????????4465??2017-06-13?16:05??SQLData\SQL\Form2.cs
?????文件????????5534??2017-06-09?22:49??SQLData\SQL\Form2.Designer.cs
?????文件????????5817??2017-06-09?22:49??SQLData\SQL\Form2.resx
?????目錄???????????0??2017-04-05?10:30??SQLData\SQL\obj\
?????目錄???????????0??2017-06-14?11:19??SQLData\SQL\obj\Debug\
?????文件???????21571??2017-06-11?16:10??SQLData\SQL\obj\Debug\DesignTimeResolveAssemblyReferences.cache
?????文件????????7891??2017-06-11?16:10??SQLData\SQL\obj\Debug\DesignTimeResolveAssemblyReferencesInput.cache
?????文件????????2123??2017-08-14?19:57??SQLData\SQL\obj\Debug\SQL課程設(shè)計(jì).csproj.FileListAbsolute.txt
?????文件????????1616??2017-06-14?10:47??SQLData\SQL\obj\Debug\SQL課程設(shè)計(jì).csproj.GenerateResource.Cache
?????文件???????34083??2017-06-11?16:15??SQLData\SQL\obj\Debug\SQL課程設(shè)計(jì).csprojResolveAssemblyReference.cache
?????文件?????1731584??2017-06-14?11:19??SQLData\SQL\obj\Debug\SQL課程設(shè)計(jì).exe
?????文件?????????180??2017-06-11?16:15??SQLData\SQL\obj\Debug\SQL課程設(shè)計(jì).Form1.resources
?????文件?????????180??2017-06-11?16:15??SQLData\SQL\obj\Debug\SQL課程設(shè)計(jì).Form2.resources
?????文件???????91648??2017-06-14?11:19??SQLData\SQL\obj\Debug\SQL課程設(shè)計(jì).pdb
............此處省略44個(gè)文件信息