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;

namespace?WindowsApplication1
{
????public?partial?class?Form1?:?Form
????{
????????public?Form1（）
????????{
????????????InitializeComponent（）;
????????}
????????private?void?button1_Click（object?sender?EventArgs?e）
????????{
????????????string?username?=?this.tbUserName.Text;
????????????string?password?=?this.tbPassword.Text;
????????????SqlConnection?conn?=?new?SqlConnection（@“Data?Source=.;Initial?Catalog=tushu;
?????????????????????????????????????????????????Integrated?Security=True“）;
????????????string?sql?=?“select?*?from?usertable?where?userna=@uname?and?password=@pwd“;
????????????try
????????????{
????????????????conn.Open（）;
????????????????SqlCommand?cmmd?=?new?SqlCommand（sql?conn）;
????????????????SqlParameter?pUname?=?new?SqlParameter（“@uname“?SqlDbType.NVarChar）;
????????????????SqlParameter?pPwd?=?new?SqlParameter（“@pwd“?SqlDbType.NVarChar）;
????????????????pUname.Value?=?username;
????????????????pPwd.Value?=?password;
????????????????cmmd.Parameters.Add（pUname）;
????????????????cmmd.Parameters.Add（pPwd）;
????????????????object?o?=?cmmd.ExecuteScalar（）;
????????????????if?（o?==?null）
????????????????{
????????????????????MessageBox.Show（“帳號或密碼錯誤“）;
????????????????}
????????????????else
????????????????{
????????????????????Form2?f2?=?new?Form2（）;
????????????????????f2.ShowDialog（）;
????????????????}
????????????}
????????????catch?（Exception?exc）
????????????{
????????????????MessageBox.Show（exc.Message）;
????????????}
????????????finally
????????????{
????????????????conn.Close（）;

????????????}
????????}
????}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2009-01-14?09:05??圖書管理系統\WindowsApplication1\
?????文件?????????946??2009-01-13?11:33??圖書管理系統\WindowsApplication1\WindowsApplication1.sln
?????文件???????37888??2009-01-17?15:04??圖書管理系統\WindowsApplication1\WindowsApplication1.suo
?????目錄???????????0??2009-01-14?09:04??圖書管理系統\WindowsApplication1\WindowsApplication1\
?????目錄???????????0??2009-01-14?09:04??圖書管理系統\WindowsApplication1\WindowsApplication1\bin\
?????目錄???????????0??2009-01-14?09:04??圖書管理系統\WindowsApplication1\WindowsApplication1\bin\Debug\
?????文件???????40960??2009-01-13?21:23??圖書管理系統\WindowsApplication1\WindowsApplication1\bin\Debug\WindowsApplication1.exe
?????文件???????79360??2009-01-13?21:23??圖書管理系統\WindowsApplication1\WindowsApplication1\bin\Debug\WindowsApplication1.pdb
?????文件????????5632??2005-11-11?22:25??圖書管理系統\WindowsApplication1\WindowsApplication1\bin\Debug\WindowsApplication1.vshost.exe
?????文件????????1832??2009-01-13?19:00??圖書管理系統\WindowsApplication1\WindowsApplication1\Form1.cs
?????文件????????5303??2009-01-13?19:00??圖書管理系統\WindowsApplication1\WindowsApplication1\Form1.Designer.cs
?????文件????????5814??2009-01-13?19:00??圖書管理系統\WindowsApplication1\WindowsApplication1\Form1.resx
?????文件?????????589??2009-01-13?21:09??圖書管理系統\WindowsApplication1\WindowsApplication1\Form2.cs
?????文件????????5694??2009-01-13?21:09??圖書管理系統\WindowsApplication1\WindowsApplication1\Form2.Designer.cs
?????文件????????5814??2009-01-13?21:09??圖書管理系統\WindowsApplication1\WindowsApplication1\Form2.resx
?????文件????????1119??2009-01-13?21:09??圖書管理系統\WindowsApplication1\WindowsApplication1\Form3.cs
?????文件????????5772??2009-01-13?21:09??圖書管理系統\WindowsApplication1\WindowsApplication1\Form3.Designer.cs
?????文件????????5814??2009-01-13?21:09??圖書管理系統\WindowsApplication1\WindowsApplication1\Form3.resx
?????文件?????????618??2009-01-13?21:09??圖書管理系統\WindowsApplication1\WindowsApplication1\Form4.cs
?????文件????????5285??2009-01-13?21:09??圖書管理系統\WindowsApplication1\WindowsApplication1\Form4.Designer.cs
?????文件????????5814??2009-01-13?21:09??圖書管理系統\WindowsApplication1\WindowsApplication1\Form4.resx
?????文件????????2505??2009-01-13?21:21??圖書管理系統\WindowsApplication1\WindowsApplication1\Form5.cs
?????文件????????8105??2009-01-13?21:10??圖書管理系統\WindowsApplication1\WindowsApplication1\Form5.Designer.cs
?????文件????????5814??2009-01-13?21:10??圖書管理系統\WindowsApplication1\WindowsApplication1\Form5.resx
?????文件????????1562??2009-01-13?21:23??圖書管理系統\WindowsApplication1\WindowsApplication1\Form6.cs
?????文件????????3312??2009-01-13?19:00??圖書管理系統\WindowsApplication1\WindowsApplication1\Form6.Designer.cs
?????文件????????5814??2009-01-13?19:00??圖書管理系統\WindowsApplication1\WindowsApplication1\Form6.resx
?????文件????????2224??2009-01-13?21:23??圖書管理系統\WindowsApplication1\WindowsApplication1\Form7.cs
?????文件????????6760??2009-01-13?21:09??圖書管理系統\WindowsApplication1\WindowsApplication1\Form7.Designer.cs
?????文件????????5814??2009-01-13?21:09??圖書管理系統\WindowsApplication1\WindowsApplication1\Form7.resx
?????文件????????2034??2009-01-13?21:09??圖書管理系統\WindowsApplication1\WindowsApplication1\Form8.cs
............此處省略34個文件信息