studenttest.cs

来自「本论文叙述了联机考试系统的现状以及C#语言的概况。重点介绍了联机考试系统的实现过」· CS 代码 · 共 34 行

using System;
using System.Data;
using System.Data.OleDb;


namespace OES
{
	/// <summary>
	/// Summary description for StudentTest.
	/// </summary>
	public class StudentTest
	{
		public StudentTest()
		{
			
		}


		public DataTable FetchPaper(string [] searchValue)
		{
			string str="";
			str="select * from tbl_QuestionBank,tbl_TestPaper where tbl_QuestionBank.QuestNo=tbl_TestPaper.QNumber and tbl_TestPaper.ExamCode like '"+searchValue[0]+"' and SubjectCode like '" +searchValue[1]+"'";
			
		Console.WriteLine(str);
		DataAccess.oleAdapter=new OleDbDataAdapter(str,DataAccess.oleconn);
		DataAccess.dSet = new DataSet("Testpaper");
		DataAccess.oleAdapter.Fill(DataAccess.dSet,"Testpaper");
		Console.WriteLine(DataAccess.dSet.Tables[0].Rows.Count.ToString());
		return DataAccess.dSet.Tables[0]; 
		}
	}
}