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.SqlClient;

namespace?dingdanshengcheng
{
????public?partial?class?Form1?:?Form
????{
????????public?String?TextValue
????????{
????????????get
????????????{
????????????????return?this.myname.Text;
????????????}
????????}
????????public?Form1（）
????????{
????????????InitializeComponent（）;
????????}

????????private?void?button1_Click（object?sender?EventArgs?e）
????????{
????????????String?connsql?=?“server=.;database=dingdanchuli;integrated?security=SSPI“;
????????????string?username?=?myname.Text.Trim（）;
????????????//string?usname?=?myname.Text;
????????????string?userpwd?=?mima.Text.Trim（）;
????????????string?sql?=?“select?*?from?yonghuxinxi?where?uname=‘“?+?username?+?“‘?and?password=‘“?+?userpwd?+?“‘“;
????????????SqlConnection?con?=?new?SqlConnection（connsql）;
????????????con.Open（）;

????????????//定義查詢命令:表示對數(shù)據(jù)庫執(zhí)行一個SQL語句或存儲過程
????????????SqlCommand?com?=?new?SqlCommand（sql?con）;

????????????//執(zhí)行查詢:提供一種讀取數(shù)據(jù)庫行的方式
????????????SqlDataReader?sread?=?com.ExecuteReader（）;

????????????try
????????????{
????????????????//如果存在用戶名和密碼正確數(shù)據(jù)執(zhí)行進入系統(tǒng)操作
????????????????if?（sread.Read（））
????????????????{
????????????????????Form3?Mwind?=?new?Form3（username）;????//顯示登錄主菜單
????????????????????this.Hide（）;????????????????//隱藏當前登陸窗體
????????????????????Mwind.Show（）;???????????????//顯示主登陸窗體;
????????????????}
????????????????else
????????????????{
????????????????????MessageBox.Show（“請輸入正確的用戶名和密碼“）;
????????????????}
????????????}
????????????catch?（Exception?msg）
????????????{
????????????????throw?new?Exception（msg.ToString（））;??//處理異常信息
????????????}
????????????finally
????????????{
????????????????con.Close（）;????????????????????//關(guān)閉連接
????????????????con.Dispose（）;??????????????????//釋放連接
????????????????sread.Dispose（）;????????????????//釋放資源
????????????}
????????}

????????private?void?button2_Click（object?sender?EventArgs?e）
????????{
????????????Form2?zhuce?=?new?Form2（）;
????????????this.Hide（）;
????????????zhuce.Show（）;
????????}

????????private?void?linkLabel1_linkClicked（object?sender?linkLabellinkClickedEventArgs?e）
????????{
????????????Form5?guanliyuandenglu?=?new?Form5（）;
????????????this.Hide（）;
????????????guanliyuandenglu.Show（）;
????????}
????}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2017-05-09?14:30??數(shù)據(jù)庫課程設(shè)計訂單生成系統(tǒng)\
?????目錄???????????0??2017-04-22?08:45??數(shù)據(jù)庫課程設(shè)計訂單生成系統(tǒng)\dingdanshengcheng\
?????目錄???????????0??2017-05-07?10:14??數(shù)據(jù)庫課程設(shè)計訂單生成系統(tǒng)\dingdanshengcheng\.vs\
?????目錄???????????0??2017-05-07?10:14??數(shù)據(jù)庫課程設(shè)計訂單生成系統(tǒng)\dingdanshengcheng\.vs\dingdanshengcheng\
?????目錄???????????0??2017-05-07?10:14??數(shù)據(jù)庫課程設(shè)計訂單生成系統(tǒng)\dingdanshengcheng\.vs\dingdanshengcheng\v14\
?????文件???????57856??2017-05-08?21:18??數(shù)據(jù)庫課程設(shè)計訂單生成系統(tǒng)\dingdanshengcheng\.vs\dingdanshengcheng\v14\.suo
?????目錄???????????0??2017-04-22?09:01??數(shù)據(jù)庫課程設(shè)計訂單生成系統(tǒng)\dingdanshengcheng\dingdanshengcheng\
?????文件?????????893??2017-04-22?08:45??數(shù)據(jù)庫課程設(shè)計訂單生成系統(tǒng)\dingdanshengcheng\dingdanshengcheng.sln
?????文件???????27648??2017-04-22?14:19??數(shù)據(jù)庫課程設(shè)計訂單生成系統(tǒng)\dingdanshengcheng\dingdanshengcheng.suo
?????目錄???????????0??2017-04-22?08:45??數(shù)據(jù)庫課程設(shè)計訂單生成系統(tǒng)\dingdanshengcheng\dingdanshengcheng\bin\
?????目錄???????????0??2017-04-22?09:22??數(shù)據(jù)庫課程設(shè)計訂單生成系統(tǒng)\dingdanshengcheng\dingdanshengcheng\bin\Debug\
?????文件???????39936??2017-05-08?14:26??數(shù)據(jù)庫課程設(shè)計訂單生成系統(tǒng)\dingdanshengcheng\dingdanshengcheng\bin\Debug\dingdanshengcheng.exe
?????文件???????71168??2017-05-08?14:26??數(shù)據(jù)庫課程設(shè)計訂單生成系統(tǒng)\dingdanshengcheng\dingdanshengcheng\bin\Debug\dingdanshengcheng.pdb
?????文件???????22696??2017-05-08?20:44??數(shù)據(jù)庫課程設(shè)計訂單生成系統(tǒng)\dingdanshengcheng\dingdanshengcheng\bin\Debug\dingdanshengcheng.vshost.exe
?????文件?????????490??2012-06-06?02:06??數(shù)據(jù)庫課程設(shè)計訂單生成系統(tǒng)\dingdanshengcheng\dingdanshengcheng\bin\Debug\dingdanshengcheng.vshost.exe.manifest
?????文件????????5213??2017-04-22?09:22??數(shù)據(jù)庫課程設(shè)計訂單生成系統(tǒng)\dingdanshengcheng\dingdanshengcheng\dingdanshengcheng.csproj
?????文件????????2713??2017-04-22?11:15??數(shù)據(jù)庫課程設(shè)計訂單生成系統(tǒng)\dingdanshengcheng\dingdanshengcheng\Form1.cs
?????文件????????6027??2017-04-22?09:22??數(shù)據(jù)庫課程設(shè)計訂單生成系統(tǒng)\dingdanshengcheng\dingdanshengcheng\Form1.Designer.cs
?????文件????????5817??2017-04-22?09:22??數(shù)據(jù)庫課程設(shè)計訂單生成系統(tǒng)\dingdanshengcheng\dingdanshengcheng\Form1.resx
?????文件????????2480??2017-04-22?09:22??數(shù)據(jù)庫課程設(shè)計訂單生成系統(tǒng)\dingdanshengcheng\dingdanshengcheng\Form2.cs
?????文件????????6598??2017-04-22?09:22??數(shù)據(jù)庫課程設(shè)計訂單生成系統(tǒng)\dingdanshengcheng\dingdanshengcheng\Form2.Designer.cs
?????文件????????5817??2017-04-22?09:22??數(shù)據(jù)庫課程設(shè)計訂單生成系統(tǒng)\dingdanshengcheng\dingdanshengcheng\Form2.resx
?????文件???????10833??2017-04-22?14:16??數(shù)據(jù)庫課程設(shè)計訂單生成系統(tǒng)\dingdanshengcheng\dingdanshengcheng\Form3.cs
?????文件???????12269??2017-04-22?12:58??數(shù)據(jù)庫課程設(shè)計訂單生成系統(tǒng)\dingdanshengcheng\dingdanshengcheng\Form3.Designer.cs
?????文件????????5817??2017-04-22?12:58??數(shù)據(jù)庫課程設(shè)計訂單生成系統(tǒng)\dingdanshengcheng\dingdanshengcheng\Form3.resx
?????文件???????10449??2017-05-08?20:48??數(shù)據(jù)庫課程設(shè)計訂單生成系統(tǒng)\dingdanshengcheng\dingdanshengcheng\Form4.cs
?????文件???????17568??2017-04-22?14:18??數(shù)據(jù)庫課程設(shè)計訂單生成系統(tǒng)\dingdanshengcheng\dingdanshengcheng\Form4.Designer.cs
?????文件????????5817??2017-04-22?14:18??數(shù)據(jù)庫課程設(shè)計訂單生成系統(tǒng)\dingdanshengcheng\dingdanshengcheng\Form4.resx
?????文件????????2454??2017-04-22?12:58??數(shù)據(jù)庫課程設(shè)計訂單生成系統(tǒng)\dingdanshengcheng\dingdanshengcheng\Form5.cs
?????文件????????5312??2017-04-22?12:58??數(shù)據(jù)庫課程設(shè)計訂單生成系統(tǒng)\dingdanshengcheng\dingdanshengcheng\Form5.Designer.cs
?????文件????????5817??2017-04-22?12:58??數(shù)據(jù)庫課程設(shè)計訂單生成系統(tǒng)\dingdanshengcheng\dingdanshengcheng\Form5.resx
............此處省略34個文件信息