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?MySchool
{
????///?

????///?增加試題窗體
????///?

????public?partial?class?AddQuestion?:?Form
????{
????????int?difficulty?=?0;?????//難度
????????int?subjectId?=?0;??????//科目編號
????????string?answer?=?““;?????//答案

????????public?AddQuestion（）
????????{
????????????InitializeComponent（）;
????????}

????????//提示用戶選擇的答案
????????public?void?rdoAnswer_Click（object?sender?EventArgs?e）
????????{
????????????//將sender轉換為單選按鈕，并獲取選中的單選按鈕的值
????????????string?answer?=?（（RadioButton）sender）.Text;
????????????MessageBox.Show（“你選擇了答案“?+?answer?“提示“?MessageBoxButtons.OK?MessageBoxIcon.Information）;
????????}

????????//提示用戶選擇的難度
????????public?void?rdoDifficulty_Click（object?sender?EventArgs?e）
????????{
????????????string?answer?=?（（RadioButton）sender）.Text;
????????????MessageBox.Show（“你選擇了難度“?+?answer?“提示“?MessageBoxButtons.OK?MessageBoxIcon.Information）;
????????}

????????private?void?AddQuestionExit_Click（object?sender?EventArgs?e）
????????{
????????????this.Close（）;
????????}

????????//窗體加載時將科目載入科目組合框中
????????public?void?增加試題_Load（object?sender?EventArgs?e）
????????{
????????????//查詢科目的SQL語句
????????????string?sql?=?“SELECT?SubjectName?FROM?Subject“;
????????????SqlConnection?conn?=?new?SqlConnection（）;
????????????SqlConnectionStringBuilder?connbuilder?=?new?SqlConnectionStringBuilder（）;
????????????connbuilder.DataSource?=?@“.\SQLEXPRESS“;
????????????connbuilder.InitialCatalog?=?“MySchool“;
????????????connbuilder.IntegratedSecurity?=?true;
????????????conn.ConnectionString?=?connbuilder.ConnectionString;
????????????try
????????????{
????????????????SqlCommand?command?=?new?SqlCommand（sqlconn）;
????????????????conn.Open（）;

????????????????SqlDataReader?dataReader?=?command.ExecuteReader（）;

????????????????while?（dataReader.Read（））
????????????????{
????????????????????cboSubject.Items.Add（dataReader[“SubjectName“].ToString（））;
????????????????}
????????????????dataReader.Close（）;
????????????}
????????????catch?（Exception?ex）
????????????{
????????????????Console.WriteLine（ex.Message）;
????????????}
????????????finally
????????????{
????????????????conn.Close（）;
????????????}
????????}

????????//輸入驗證
????????public?bool?ValidateInput（）
????????{
????????????if?（txtQuestion.Text?==?““）
????????????{
????????????????MessageBox.Show（“請輸入問題！“）;
????????????????txtQuestion.Focus（）;
????????????????return?false;
????????????}
????????????else?if?（txtOptionA.Text?==?““）
????????????{
????????????????MessageBox.Show（“請輸入答案A“）;
????????????????txtOptionA.Focus（）;
????????????????return?false;
????????????}
????????????else?if?（txtOptionB.Text?==?““）
????????????{
????????????????MessageBox.Show（“請輸入答案B“）;
?????????

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2013-12-22?14:26??考試管理系統\
?????文件??????200178??2013-12-17?23:19??考試管理系統\MySchool.sql
?????目錄???????????0??2013-12-22?14:26??考試管理系統\WindowsFormsApplication1\
?????文件?????????930??2009-10-26?18:57??考試管理系統\WindowsFormsApplication1\MySchool.sln
?????文件??????158720??2014-01-06?23:41??考試管理系統\WindowsFormsApplication1\MySchool.suo
?????目錄???????????0??2013-12-22?14:26??考試管理系統\WindowsFormsApplication1\WindowsFormsApplication1\
?????文件???????24528??2009-11-07?13:37??考試管理系統\WindowsFormsApplication1\WindowsFormsApplication1\AddQuestion.Designer.cs
?????文件????????8831??2013-11-29?23:03??考試管理系統\WindowsFormsApplication1\WindowsFormsApplication1\AddQuestion.cs
?????文件???????17946??2009-11-07?13:37??考試管理系統\WindowsFormsApplication1\WindowsFormsApplication1\AddQuestion.resx
?????文件???????18466??2013-12-05?20:52??考試管理系統\WindowsFormsApplication1\WindowsFormsApplication1\AddStudentForm.Designer.cs
?????文件???????11327??2013-12-17?22:54??考試管理系統\WindowsFormsApplication1\WindowsFormsApplication1\AddStudentForm.cs
?????文件???????17946??2013-12-05?20:52??考試管理系統\WindowsFormsApplication1\WindowsFormsApplication1\AddStudentForm.resx
?????文件???????13718??2013-12-05?22:25??考試管理系統\WindowsFormsApplication1\WindowsFormsApplication1\AddTeacherForm.Designer.cs
?????文件????????4323??2013-12-17?23:00??考試管理系統\WindowsFormsApplication1\WindowsFormsApplication1\AddTeacherForm.cs
?????文件????????5817??2013-12-05?22:25??考試管理系統\WindowsFormsApplication1\WindowsFormsApplication1\AddTeacherForm.resx
?????文件???????30121??2009-11-07?14:22??考試管理系統\WindowsFormsApplication1\WindowsFormsApplication1\AnswerCard.Designer.cs
?????文件????????2958??2013-11-30?11:36??考試管理系統\WindowsFormsApplication1\WindowsFormsApplication1\AnswerCard.cs
?????文件???????18145??2009-11-07?14:22??考試管理系統\WindowsFormsApplication1\WindowsFormsApplication1\AnswerCard.resx
?????文件????????9339??2009-11-07?13:44??考試管理系統\WindowsFormsApplication1\WindowsFormsApplication1\AnswerQuestionForm.Designer.cs
?????文件????????5955??2013-11-30?11:36??考試管理系統\WindowsFormsApplication1\WindowsFormsApplication1\AnswerQuestionForm.cs
?????文件???????18145??2009-11-07?13:44??考試管理系統\WindowsFormsApplication1\WindowsFormsApplication1\AnswerQuestionForm.resx
?????文件???????????1??2009-10-12?19:55??考試管理系統\WindowsFormsApplication1\WindowsFormsApplication1\ClassDiagram1.cd
?????文件???????????1??2009-10-26?19:14??考試管理系統\WindowsFormsApplication1\WindowsFormsApplication1\ClassDiagram2.cd
?????文件?????????429??2009-10-30?17:52??考試管理系統\WindowsFormsApplication1\WindowsFormsApplication1\ClassDiagram3.cd
?????文件???????24592??2009-11-07?13:45??考試管理系統\WindowsFormsApplication1\WindowsFormsApplication1\DetailsQuestions.Designer.cs
?????文件???????10220??2013-11-29?23:07??考試管理系統\WindowsFormsApplication1\WindowsFormsApplication1\DetailsQuestions.cs
?????文件???????17946??2009-11-07?13:45??考試管理系統\WindowsFormsApplication1\WindowsFormsApplication1\DetailsQuestions.resx
?????文件???????13256??2013-12-17?22:55??考試管理系統\WindowsFormsApplication1\WindowsFormsApplication1\EditStudentForm.cs
?????文件???????31396??2013-12-05?22:00??考試管理系統\WindowsFormsApplication1\WindowsFormsApplication1\EditStudentForm.designer.cs
?????文件????????5814??2013-12-05?22:00??考試管理系統\WindowsFormsApplication1\WindowsFormsApplication1\EditStudentForm.resx
?????文件????????6097??2013-12-05?22:26??考試管理系統\WindowsFormsApplication1\WindowsFormsApplication1\EditTeacherForm.cs
............此處省略212個文件信息