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.IO;
using?System.Data.OleDb;

namespace?english_test
{
????public?partial?class?Form1?:?Form
????{
????????//string?dir_word?=?@“..\..\..\..\..\..\ciku\“;
????????string?dir_word?=?@“E:\liuyu\xiangmu2\english_test_liuyu\english_test\ciku\“;
????????public?const?int?question_cout?=?5;//定義一套考卷的數目
????????const?int?time_temp?=?65;//定義第一次考試時間
????????int?time?=?time_temp;//每次闖關的倒計時時間
????????int?time_next?=?time_temp;//下一關的關卡時間
????????string?temp_s;//秒
????????string?temp_m;//分
????????string?temp_h;//時
????????public?const?int?scorePass?=?10;//及格分數線
????????int?score?=?0;//計分數
????????
????????int?index_ti=1;//題的索引，根據index_ti?上一題，下一題
????????string[][]?answer?=?new?string[question_cout][];//5道題的答案都存放在danan[][]數組中

???????
????????DataTable?data_table_temp?=?new?DataTable（）;//定義一個臨時題目表0列題目，1列答案
????????//定義闖關模式的時間
????????string[]?answer_sel?=?new?string[question_cout];????????
???????//?string[]?answer_sel?=?{?“abcd“?“abcd“?“abcd“?“abcd“?“abcd“?};?//將選中的五題答案存放到answer_sel

????????public?Form1（）
????????{
????????????InitializeComponent（）;
??????????
????????}
????????public?DataSet?ExcelToDataSet（string?fileName）
????????{
????????????
????????????DataSet?ds;
????????????string?strCon?=?“Provider=Microsoft.ACE.OLEDB.12.0;“?+
????????????????????????????“Extended?Properties=Excel?8.0;“?+
????????????????????????????“data?source=“?+?fileName;
????????????OleDbConnection?myConn?=?new?OleDbConnection（strCon）;
????????????string?strCom?=?“SELECT?*?FROM?[Sheet1$]“;
????????????myConn.Open（）;
????????????OleDbDataAdapter?myCommand?=?new?OleDbDataAdapter（strCom?myConn）;

????????????ds?=?new?DataSet（）;
????????????myCommand.Fill（ds）;
????????????myConn.Close（）;
????????????return?ds;
????????????
????????}

????????public?static?DataTable?GetExcelTable（string?excelFilename）
????????{
???????????/*?string?connectionString?=?“Provider=Microsoft.ACE.OLEDB.12.0;“?+
????????????????????????????“Extended?Properties=Excel?8.0;“?+
????????????????????????????“data?source=“?+?excelFilename;//2007excel
????????????*/
????????????string?connectionString?=?“Provider=Microsoft.Jet.OLEDB.4.0;“?+
????????????????????????“Extended?Properties=Excel?8.0;“?+
????????????????????????“data?source=“?+?excelFilename;//2003excel
????????????DataSet?ds?=?new?DataSet（）;
????????????string?tableName;
????????????using?（OleDbConnection?connection?=?new?OleDbConnection（connectionString））
????????????{
????????????????connection.Open（）;
????????????????DataTable?table?=?connection.GetOleDbSchemaTable（System.Data.OleDb.OleDbSchemaGuid.Tables?null）;
????????????????tableName?=?table.Rows[0][“Table_Name“].ToString（）;
????????????????string?strExcel?=?“select?*?from?“?+?“[“?+?tableName?+?“]“;
????????????????OleDb

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2012-04-28?12:49??xiangmu2\
?????目錄???????????0??2012-04-19?16:48??xiangmu2\english_test_liuyu\
?????目錄???????????0??2012-04-28?12:49??xiangmu2\english_test_liuyu\english_test\
?????目錄???????????0??2012-04-26?14:11??xiangmu2\english_test_liuyu\english_test\bin\
?????目錄???????????0??2012-04-19?18:03??xiangmu2\english_test_liuyu\english_test\bin\Debug\
?????文件???????24064??2012-04-28?12:48??xiangmu2\english_test_liuyu\english_test\bin\Debug\english_test.exe
?????文件???????46592??2012-04-28?12:48??xiangmu2\english_test_liuyu\english_test\bin\Debug\english_test.pdb
?????文件???????14328??2012-04-28?18:56??xiangmu2\english_test_liuyu\english_test\bin\Debug\english_test.vshost.exe
?????文件?????????490??2007-07-21?01:33??xiangmu2\english_test_liuyu\english_test\bin\Debug\english_test.vshost.exe.manifest
?????目錄???????????0??2012-04-28?11:33??xiangmu2\english_test_liuyu\english_test\ciku\
?????文件??????446464??2012-02-04?15:26??xiangmu2\english_test_liuyu\english_test\ciku\09SAT3500詞頻.xls
?????文件??????619008??2012-02-04?15:27??xiangmu2\english_test_liuyu\english_test\ciku\10SAT填空單詞詞頻.xls
?????文件??????222720??2012-04-20?14:36??xiangmu2\english_test_liuyu\english_test\ciku\1初中.xls
?????文件??????353280??2012-02-04?15:12??xiangmu2\english_test_liuyu\english_test\ciku\2四級單詞.xls
?????文件??????465408??2012-02-04?15:13??xiangmu2\english_test_liuyu\english_test\ciku\3自考英語.xls
?????文件??????605696??2012-02-04?15:17??xiangmu2\english_test_liuyu\english_test\ciku\4新概念.xls
?????文件??????345600??2012-04-28?11:31??xiangmu2\english_test_liuyu\english_test\ciku\5TOEFL核心詞匯.xls
?????文件??????241664??2012-02-04?15:20??xiangmu2\english_test_liuyu\english_test\ciku\6托福詞匯.xls
?????文件??????103424??2012-02-04?15:21??xiangmu2\english_test_liuyu\english_test\ciku\7托福聽力詞匯.xls
?????文件??????276480??2012-04-28?11:33??xiangmu2\english_test_liuyu\english_test\ciku\8考研英語2222.xls
?????文件????????3770??2012-04-26?14:11??xiangmu2\english_test_liuyu\english_test\english_test.csproj
?????文件???????26624??2012-04-28?12:49??xiangmu2\english_test_liuyu\english_test\Form1.cs
?????文件???????16417??2012-04-26?14:02??xiangmu2\english_test_liuyu\english_test\Form1.Designer.cs
?????文件????????6008??2012-04-26?14:02??xiangmu2\english_test_liuyu\english_test\Form1.resx
?????目錄???????????0??2012-04-19?16:48??xiangmu2\english_test_liuyu\english_test\obj\
?????目錄???????????0??2012-04-28?12:48??xiangmu2\english_test_liuyu\english_test\obj\Debug\
?????文件????????2884??2012-04-28?18:56??xiangmu2\english_test_liuyu\english_test\obj\Debug\english_test.csproj.FileListAbsolute.txt
?????文件?????????847??2012-04-26?14:02??xiangmu2\english_test_liuyu\english_test\obj\Debug\english_test.csproj.GenerateResource.Cache
?????文件???????24064??2012-04-28?12:48??xiangmu2\english_test_liuyu\english_test\obj\Debug\english_test.exe
?????文件?????????180??2012-04-26?14:11??xiangmu2\english_test_liuyu\english_test\obj\Debug\english_test.Form1.resources
?????文件???????46592??2012-04-28?12:48??xiangmu2\english_test_liuyu\english_test\obj\Debug\english_test.pdb
............此處省略12個文件信息