using?System;
using?System.Collections.Generic;
using?System.Text;

using?System.Data;
using?System.Windows.Forms;
using?System.Data.SqlClient;

namespace?ExamManageSystem
{
????class?DataHelp
????{
????????private?static?string?connStr?=?“server=.\\SQLExpress;database=ExamSystem;Integrated?Security=true“;
????????public?static?SqlConnection?conn?=?new?SqlConnection（connStr）;
????????public?static?SqlCommand?com;
????????public?static?DataSet?dataSet;????????????//數據集對象
????????public?static?SqlDataAdapter?dataAdapter;?//適配器對象

????????//將注冊的管理員的信息提交到數據庫
????????//參數類型?Admin
????????//返回值類型?bool
????????public?static?bool?AdminInfoReferToData（Admin?admin）
????????{
????????????bool?result?=?false;
????????????try
????????????{
????????????????conn.Open（）;
????????????????com?=?new?SqlCommand（“uep_EnrolAdmin“?conn）;
????????????????com.CommandType?=?CommandType.StoredProcedure;
????????????????//獲取對象的值，并賦值給存儲過程參數
????????????????com.Parameters.Add（“@LoginId“SqlDbType.NVarChar50）.Value=admin.GetLoginId（）;
????????????????com.Parameters.Add（“@LoginPwd“SqlDbType.NVarChar50）.Value=admin.GetLoginPwd（）;
????????????????com.Parameters.Add（“@AdminName“SqlDbType.NVarChar50）.Value=admin.GetAdminName（）;
????????????????com.Parameters.Add（“@Sex“SqlDbType.NVarChar2）.Value=admin.GetSex（）;
????????????????//執行SQl命令并返回結果
????????????????int?res?=?（int）com.ExecuteNonQuery（）;
????????????????if?（res?==?1）
????????????????{
????????????????????result?=?true;
????????????????????MessageBox.Show（“注冊成功！“?“系統提示“?MessageBoxButtons.OK?MessageBoxIcon.Information）;
????????????????}
????????????????else
????????????????{
????????????????????MessageBox.Show（“注冊失敗！\n請稍后再注冊“?“系統提示“?MessageBoxButtons.OK?MessageBoxIcon.Error）;
????????????????}
????????????}
????????????catch?（Exception?ex）
????????????{
????????????????MessageBox.Show（ex.Message）;
????????????}
????????????finally
????????????{
????????????????conn.Close（）;
????????????}
????????????return?result;
????????}

????????//將注冊的教員的信息提交到數據庫
????????//參數類型?Teacher
????????//返回值?bool
????????public?static?bool?TeacherInfoReferToData（Teacher?teacher）
????????{
????????????bool?result?=?false;
????????????try
????????????{
????????????????conn.Open（）;
????????????????com?=?new?SqlCommand（“uep_EnrolTeacher“?conn）;
????????????????com.CommandType?=?CommandType.StoredProcedure;
????????????????//獲取對象的值，并賦值給存儲過程參數
????????????????com.Parameters.Add（“@LoginId“?SqlDbType.NVarChar?50）.Value?=?teacher.GetLoginId（）;
????????????????com.Parameters.Add（“@LoginPwd“?SqlDbType.NVarChar?50）.Value?=?teacher.GetLoginPwd（）;
????????????????com.Parameters.Add（“@TeacherName“?SqlDbType.NVarChar?50）.Value?=?teacher.GetTeacherName（）;
????????????????com.Parameters.Add（“@Sex“?SqlDbType.NVarChar?2）.Value?=?teacher.GetSex（）;
????????????????//執行SQl命令并返回結果
????????????????int?res?=?（int）com.ExecuteNonQuery（）;
????????????????if?（res?==?1）
?????????

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

?????文件????????937??2008-12-24?12:17??考試管理系統下載版\ExamManageSystem\ExamManageSystem.sln

????..A..H.????100864??2010-04-20?23:00??考試管理系統下載版\ExamManageSystem\ExamManageSystem.suo

?????文件?????445440??2009-01-05?18:53??考試管理系統下載版\ExamManageSystem\使用說明\考試管理系統.doc

?????文件?????176640??2009-01-05?18:53??考試管理系統下載版\ExamManageSystem\使用說明\考試管理系統.ppt

?????文件?????????44??2009-01-05?19:01??考試管理系統下載版\ExamManageSystem\使用說明\說明.txt

?????文件??????26909??2008-11-21?14:20??考試管理系統下載版\ExamManageSystem\images\About.jpg

?????文件?????235002??2006-06-29?20:24??考試管理系統下載版\ExamManageSystem\images\bg01.jpg

?????文件???????3553??2001-05-18?04:35??考試管理系統下載版\ExamManageSystem\images\bg02.jpg

?????文件???????7570??1998-05-04?00:00??考試管理系統下載版\ExamManageSystem\images\bg03.jpg

?????文件???????6897??1998-05-04?00:00??考試管理系統下載版\ExamManageSystem\images\bg04.jpg

?????文件??????17147??2002-08-29?09:25??考試管理系統下載版\ExamManageSystem\images\bg05.jpg

?????文件???????3802??2008-11-14?10:53??考試管理系統下載版\ExamManageSystem\images\bg06.jpg

?????文件???????4389??2002-08-29?09:25??考試管理系統下載版\ExamManageSystem\images\bg07.jpg

?????文件????????963??2005-02-25?01:32??考試管理系統下載版\ExamManageSystem\images\cut.gif

?????文件???????7886??2007-08-03?11:07??考試管理系統下載版\ExamManageSystem\images\Icon.ico

?????文件????????982??2005-02-25?01:32??考試管理系統下載版\ExamManageSystem\images\icon_editor_url.gif

?????文件????????927??2005-02-25?01:32??考試管理系統下載版\ExamManageSystem\images\icon_paperclip.gif

?????文件?????729398??2009-01-09?10:08??考試管理系統下載版\ExamManageSystem\images\Login2.bmp

?????文件?????648246??2009-01-09?10:11??考試管理系統下載版\ExamManageSystem\images\loginImage.bmp

?????文件???????1092??2005-02-25?01:32??考試管理系統下載版\ExamManageSystem\images\MP.GIF

?????文件????????990??2005-02-25?01:32??考試管理系統下載版\ExamManageSystem\images\refurbish.gif

?????文件????????963??2005-02-25?01:32??考試管理系統下載版\ExamManageSystem\images\searchAll.gif

?????文件????????468??2005-02-25?01:32??考試管理系統下載版\ExamManageSystem\images\SWF.GIF

?????文件???????8743??2008-12-22?18:50??考試管理系統下載版\ExamManageSystem\ExamManageSystem\DataHelp.cs

?????文件??????13079??2009-01-07?11:49??考試管理系統下載版\ExamManageSystem\ExamManageSystem\ExamManageSystem.csproj

?????文件????????466??2008-12-13?12:10??考試管理系統下載版\ExamManageSystem\ExamManageSystem\FrmAbout.cs

?????文件???????6669??2008-12-13?12:10??考試管理系統下載版\ExamManageSystem\ExamManageSystem\FrmAbout.Designer.cs

?????文件??????58497??2008-12-13?12:10??考試管理系統下載版\ExamManageSystem\ExamManageSystem\FrmAbout.resx

?????文件??????18190??2008-12-24?16:01??考試管理系統下載版\ExamManageSystem\ExamManageSystem\FrmEnrolUsers.cs

?????文件??????23362??2003-01-01?01:06??考試管理系統下載版\ExamManageSystem\ExamManageSystem\FrmEnrolUsers.Designer.cs

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