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;

namespace?test
{
????public?partial?class?AddStu?:?Form
????{
????????public?AddStu（）
????????{
????????????InitializeComponent（）;
????????}
????????private?SqlConnection?conn?=?null;
????????private?SqlCommand?cmd?=?null;
??????//??private?SqlDataReader?reader?=?null;
????????private?SqlDataAdapter?adp?=?null;
????????private?SqlCommandBuilder?build?=?null;
????????private?DataSet?data_set?=?new?DataSet（）;
????????private?void?AddStu_Load（object?sender?EventArgs?e）
????????{
????????????cmb_Asex.Text?=?“男“;
????????????cmb_Acollege.Text?=?“管理學系“;
????????????cmb_Adepart.Text?=?“工商管理“;
????????}
??????
????????private?void?textBox1_Asno_Leave（object?sender?EventArgs?e）?//設置選項列表的值項
????????{
????????????conn?=?new?SqlConnection（“Data?Source?=.;?Initial?Catalog?=?test_hxw;User?ID?=?hxw;?Pwd?=?hxw“）;
????????????conn.Open（）;
????????????string?strSql?=?“SELECT?*?FROM?student?WHERE?sno=‘“?+?textBox1_Asno.Text?+?“‘“;
????????????cmd?=?new?SqlCommand（strSql?conn）;
????????????SqlDataReader?reader?=?cmd.ExecuteReader（）;//用來遍歷讀取出的數據庫中的數據??
????????????if?（reader.Read（））?{
????????????????MessageBox.Show（“該學號已存在，請重新輸入！“?“錯誤“?MessageBoxButtons.OK?MessageBoxIcon.Error）;
????????????????textBox1_Asno.SelectAll（）;
????????????????textBox1_Asno.Focus（）;
????????????????return;
????????????}

????????}
????????private?void?but_Asave_Click（object?sender?EventArgs?e）
????????{
???????????
??????????
????????????string?sage?=?textBox3_Aage.Text.Trim（）;
????????????int?s?=?sage.Length;

????????????string?maxCl?=?textBox6_AmaxCla.Text.Trim（）;
????????????int?m?=?maxCl.Length;
????????????if?（textBox1_Asno.Text.Trim（）?==?““?||?textBox2_Aname.Text.Trim（）?==?““?||?cmb_Adepart.Text.Trim（）?==?““?||?textBox3_Aage.Text.Trim（）?==?““?||?textBox5_Anation.Text.Trim（）?==?““?||?textBox6_AmaxCla.Text.Trim（）?==?““）
????????????{
????????????????MessageBox.Show（“請輸入完整信息！“?“錯誤“?MessageBoxButtons.OK?MessageBoxIcon.Error）;
????????????????return;
????????????}
????????????else
????????????{
????????????????for?（int?i?=?0;?i?????????????????{
????????????????????if?（!char.IsNumber（sage[i]））
????????????????????{
????????????????????????MessageBox.Show（“年齡輸入有誤！“?“錯誤“?MessageBoxButtons.OK?MessageBoxIcon.Error）;
????????????????????????textBox3_Aage.SelectAll（）;
????????????????????????textBox3_Aage.Focus（）;
????????????????????????return;
????????????????????}
????????????????}
????????????}
????????????int?age?=?int.Parse（textBox3_Aage.Text.Trim（））;
????????????if?（age??160）
????????????{
????????????????MessageBox.Show（“年齡在1~100之間！“?“錯誤“?MessageBoxButtons.OK?MessageBoxIcon.Error）;
????????????????textBox3_Aage.SelectAll（）;
???????

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件???????7769??2015-01-08?09:40??test\test\AddStu.cs

?????文件??????14652??2014-11-22?16:16??test\test\AddStu.Designer.cs

?????文件???????5817??2014-11-22?16:16??test\test\AddStu.resx

?????文件????????167??2014-11-19?16:31??test\test\App.config

?????文件????1100392??2007-10-10?09:48??test\test\bin\Debug\Microsoft.Office.Interop.Excel.dll

?????文件??????45568??2015-01-08?10:03??test\test\bin\Debug\test.exe

?????文件????????167??2014-11-19?16:31??test\test\bin\Debug\test.exe.config

?????文件??????67072??2015-01-08?10:03??test\test\bin\Debug\test.pdb

?????文件??????11592??2015-01-08?10:04??test\test\bin\Debug\test.vshost.exe

?????文件????????167??2014-11-19?16:31??test\test\bin\Debug\test.vshost.exe.config

?????文件????????490??2010-03-17?22:39??test\test\bin\Debug\test.vshost.exe.manifest

?????文件???????7011??2015-01-08?09:39??test\test\ChangeInfo.cs

?????文件??????14905??2014-11-22?16:21??test\test\ChangeInfo.Designer.cs

?????文件???????5817??2014-11-22?16:21??test\test\ChangeInfo.resx

?????文件???????1441??2015-01-08?09:36??test\test\Login.cs

?????文件???????6134??2014-11-19?16:42??test\test\Login.Designer.cs

?????文件???????5817??2014-11-19?16:42??test\test\Login.resx

?????文件??????18808??2015-01-08?10:03??test\test\main.cs

?????文件??????22679??2014-11-27?10:06??test\test\main.Designer.cs

?????文件???????6001??2014-11-27?10:06??test\test\main.resx

?????文件??????20733??2014-11-19?16:24??test\test\obj\Debug\DesignTimeResolveAssemblyReferences.cache

?????文件???????6481??2015-01-08?10:17??test\test\obj\Debug\DesignTimeResolveAssemblyReferencesInput.cache

?????文件????????892??2015-01-08?10:03??test\test\obj\Debug\GenerateResource.read.1.tlog

?????文件???????1990??2015-01-08?10:03??test\test\obj\Debug\GenerateResource.write.1.tlog

?????文件??????????0??2014-11-19?09:47??test\test\obj\Debug\TemporaryGeneratedFile_036C0B5B-1481-4323-8D20-8F5ADCB23D92.cs

?????文件??????????0??2014-11-19?09:47??test\test\obj\Debug\TemporaryGeneratedFile_5937a670-0e60-4077-877b-f7221da3dda1.cs

?????文件??????????0??2014-11-19?09:47??test\test\obj\Debug\TemporaryGeneratedFile_E7A71F73-0F8D-4B9B-B56E-8E70B10BC5D3.cs

?????文件???????4608??2014-11-19?16:31??test\test\obj\Debug\TempPE\Properties.Resources.Designer.cs.dll

?????文件????????180??2015-01-08?10:03??test\test\obj\Debug\test.AddStu.resources

?????文件????????180??2015-01-08?10:03??test\test\obj\Debug\test.ChangeInfo.resources

............此處省略34個文件信息