rnd integer = new rnd();
integer.amount = 20;
integer.total = 50;
int[] listArray = new int[integer.amount];
listArray = integer.generaternd();
for (int i = 1; i <=20; i++)
{
}
SqlConnection testcon = new SqlConnection(Convert.ToString(ConfigurationManager.ConnectionStrings[ "TESTDBConnectionString "].ConnectionString));
DataSet testds = new DataSet();
DataTable tbQuestions = new DataTable( "tbQuestions ");
testds.Tables.Add(tbQuestions);
DataColumn questionIdentity = new DataColumn( "questionIdentity ", typeof(System.String));
DataColumn questionID = new DataColumn( "questionID ", typeof(System.String));
DataColumn question = new DataColumn( "question ", typeof(System.String));
DataColumn answer1 = new DataColumn( "answer1 ", typeof(System.String));
DataColumn answer2 = new DataColumn( "answer2 ", typeof(System.String));
DataColumn answer3 = new DataColumn( "answer3 ", typeof(System.String));
DataColumn answer4 = new DataColumn( "answer4 ", typeof(System.String));
tbQuestions.Columns.Add(questionIdentity);
tbQuestions.Columns.Add(questionID);
tbQuestions.Columns.Add(question);
tbQuestions.Columns.Add(answer1);
tbQuestions.Columns.Add(answer2);
tbQuestions.Columns.Add(answer3);
tbQuestions.Columns.Add(answer4);
for (int i = 1; i <= 20; i++)
{
string testsql = "select * from questions_table where courseType= ' " + course + " ' and questionID= " + listArray[i];