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?xyglxt
{
????public?partial?class?Formdenglu?:?Form
????{
????????public?Formdenglu（）
????????{
????????????InitializeComponent（）;
????????}

????????private?void?buttonload_Click（object?sender?EventArgs?e）
????????{
????????????if?（user.Text?==?“?“?||?pwd.Text?==?“?“）
????????????{
????????????????MessageBox.Show（“輸入登錄信息不完整，請(qǐng)重新輸入！“?“信息提示“?MessageBoxButtons.OK?MessageBoxIcon.Information）;

????????????}
????????????else
????????????{
????????????????string?strconn?=?“server=（local）;Integrated?Security=SSPI;database=學(xué)院管理系統(tǒng)“;
????????????????SqlConnection?conn?=?new?SqlConnection（strconn）;
????????????????conn.Open（）;
????????????????string?mysql?=?“?“;


????????????????if?（radioButstudent.Checked?==?true）
????????????????{


?????????????????????mysql?=?“select?學(xué)號(hào)?from?學(xué)生表?where?學(xué)號(hào)=‘“?+?user.Text?+?“?‘?and??密碼?=‘“?+?pwd.Text?+?“?‘“;
????????????????????SqlDataAdapter?myada1?=?new?SqlDataAdapter（mysql?conn）;
????????????????????DataTable?mydt1?=?new?DataTable（）;
????????????????????myada1.Fill（mydt1）;
????????????????????int?a?=?mydt1.Rows.Count;
????????????????????if?（a?>=?1）
????????????????????{
????????????????????????Formxuesheng?form2?=?new?Formxuesheng（）;
????????????????????????form2.Show（）;

????????????????????}
????????????????????else
????????????????????{
????????????????????????MessageBox.Show（“用戶名或密碼不正確，請(qǐng)你出新輸入！“?“信息提示“?MessageBoxButtons.OK?MessageBoxIcon.Information）;

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

????????????????????if?（radioButteacher.Checked?==?true）
????????????????????{
????????????????????????mysql?=?“select?編號(hào)?from?教師表?where?編號(hào)=‘“?+?user.Text?+?“?‘?and?密碼=‘“?+?pwd.Text?+?“?‘“;
????????????????????????SqlDataAdapter?myada2?=?new?SqlDataAdapter（mysql?conn）;
????????????????????????DataTable?mydt2?=?new?DataTable（）;
????????????????????????myada2.Fill（mydt2）;
????????????????????????int?b?=?mydt2.Rows.Count;
????????????????????????if?（b?>=?1）
????????????????????????{
????????????????????????????Formjiaoshi?form3?=?new?Formjiaoshi（）;
????????????????????????????form3.Show（）;

????????????????????????}
????????????????????????else
????????????????????????{
????????????????????????????MessageBox.Show（“用戶名或密碼不正確，請(qǐng)你出新輸入！“?“信息提示“?MessageBoxButtons.OK?MessageBoxIcon.Information）;

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

????????????????????if?（radioButguanliyuan.Checked?==?true）
????????????????????{
????????????????????????mysql?=?“select?用戶名?from?管理員表?where?用戶名=‘“?+?user.Text?+?“?‘?and?密碼=‘“?+?pwd.Text?+?“?‘“;
????????????????????????SqlDataAdapter?myada3?=?new?SqlDataAdapter（mysql?conn）;
????????????????????????DataTable?mydt3?=?new?DataTable（）;
????????????????????????myada3.Fill（mydt3）;
???????????

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2011-08-22?14:43??xyglxt（終結(jié)版）\
?????目錄???????????0??2010-04-20?17:07??xyglxt（終結(jié)版）\xyglxt\
?????文件????????5835??2010-04-21?17:08??xyglxt（終結(jié)版）\xyglxt\shujuku.txt
?????目錄???????????0??2010-04-20?17:07??xyglxt（終結(jié)版）\xyglxt\xyglxt\
?????文件?????????907??2010-04-19?21:23??xyglxt（終結(jié)版）\xyglxt\xyglxt.sln
?????文件???????25088??2010-04-26?11:39??xyglxt（終結(jié)版）\xyglxt\xyglxt.suo
?????目錄???????????0??2010-04-20?17:07??xyglxt（終結(jié)版）\xyglxt\xyglxt\bin\
?????目錄???????????0??2010-04-20?17:07??xyglxt（終結(jié)版）\xyglxt\xyglxt\bin\Debug\
?????文件????????1466??2010-04-26?11:37??xyglxt（終結(jié)版）\xyglxt\xyglxt\bin\Debug\xyglxt.application
?????文件???????90112??2010-04-26?11:37??xyglxt（終結(jié)版）\xyglxt\xyglxt\bin\Debug\xyglxt.exe
?????文件????????2120??2010-04-26?11:37??xyglxt（終結(jié)版）\xyglxt\xyglxt\bin\Debug\xyglxt.exe.manifest
?????文件???????99840??2010-04-26?11:37??xyglxt（終結(jié)版）\xyglxt\xyglxt\bin\Debug\xyglxt.pdb
?????目錄???????????0??2010-04-23?13:30??xyglxt（終結(jié)版）\xyglxt\xyglxt\bin\Debug\xyglxt.publish\
?????文件??????423936??2010-04-23?13:30??xyglxt（終結(jié)版）\xyglxt\xyglxt\bin\Debug\xyglxt.publish\setup.exe
?????文件????????5255??2010-04-23?13:30??xyglxt（終結(jié)版）\xyglxt\xyglxt\bin\Debug\xyglxt.publish\xyglxt.application
?????目錄???????????0??2010-04-23?13:30??xyglxt（終結(jié)版）\xyglxt\xyglxt\bin\Debug\xyglxt.publish\xyglxt_1_0_0_0\
?????文件???????81920??2010-04-23?13:30??xyglxt（終結(jié)版）\xyglxt\xyglxt\bin\Debug\xyglxt.publish\xyglxt_1_0_0_0\xyglxt.exe.deploy
?????文件????????5858??2010-04-23?13:30??xyglxt（終結(jié)版）\xyglxt\xyglxt\bin\Debug\xyglxt.publish\xyglxt_1_0_0_0\xyglxt.exe.manifest
?????文件????????1466??2010-04-26?11:37??xyglxt（終結(jié)版）\xyglxt\xyglxt\bin\Debug\xyglxt.vshost.application
?????文件????????5632??2005-12-08?14:51??xyglxt（終結(jié)版）\xyglxt\xyglxt\bin\Debug\xyglxt.vshost.exe
?????文件????????2120??2010-04-26?11:37??xyglxt（終結(jié)版）\xyglxt\xyglxt\bin\Debug\xyglxt.vshost.exe.manifest
?????文件????????5888??2010-04-23?13:02??xyglxt（終結(jié)版）\xyglxt\xyglxt\Form1.cs
?????文件????????9875??2010-04-23?12:17??xyglxt（終結(jié)版）\xyglxt\xyglxt\Form1.Designer.cs
?????文件????????5814??2010-04-23?12:17??xyglxt（終結(jié)版）\xyglxt\xyglxt\Form1.resx
?????文件????????7430??2010-04-26?11:37??xyglxt（終結(jié)版）\xyglxt\xyglxt\Form2.cs
?????文件???????28571??2010-04-26?11:35??xyglxt（終結(jié)版）\xyglxt\xyglxt\Form2.Designer.cs
?????文件????????5814??2010-04-26?11:35??xyglxt（終結(jié)版）\xyglxt\xyglxt\Form2.resx
?????文件???????10059??2010-04-26?11:25??xyglxt（終結(jié)版）\xyglxt\xyglxt\Form3.cs
?????文件???????29683??2010-04-26?11:25??xyglxt（終結(jié)版）\xyglxt\xyglxt\Form3.Designer.cs
?????文件????????5814??2010-04-26?11:25??xyglxt（終結(jié)版）\xyglxt\xyglxt\Form3.resx
?????文件???????45825??2010-04-26?11:15??xyglxt（終結(jié)版）\xyglxt\xyglxt\Form4.cs
............此處省略33個(gè)文件信息