public string[] getSpecificRandomQIDArrayNotSelectLevel1(int intQuestionNum, string strPaperID) { //傳回的陣列 string[] arrayQID = new String[intQuestionNum]; int intArrayIndex = 0; //代表arrayQID的指標 //到QuestionIndex找出符合條件的問題 //string strSQL = "SELECT * FROM QuestionIndex I , QuestionMode M WHERE M.cQuestionGroupID = '"+strGroupID+"' AND I.cQID = M.cQID "; string strSQL = mySQL.getSpecificQuestionLevel1NotSelect(strPaperID); DataSet dsQuestionList = sqldb.getDataSet(strSQL); //亂數選取問題後存入Array中 //檢查intQuestionNum是否大於QuestionList中的題目數量 if (intQuestionNum <= dsQuestionList.Tables[0].Rows.Count) { for (int j = 0; j < intQuestionNum; j++) { //亂數取得一個介於0~RowCount之間的數字 int intRandom = 0; string strQID = ""; do { intRandom = myRandom.Next(0, dsQuestionList.Tables[0].Rows.Count); strQID = dsQuestionList.Tables[0].Rows[intRandom]["cQID"].ToString(); }while(checkArray(strQID, arrayQID)); //將此QID存入Array中 arrayQID[intArrayIndex] = strQID; intArrayIndex += 1; } } else { //把所有的題目都挑選進Array來 for (int j = 0; j < dsQuestionList.Tables[0].Rows.Count; j++) { arrayQID[arrayQID.Length] = dsQuestionList.Tables[0].Rows[j]["cQID"].ToString(); } } dsQuestionList.Dispose(); return(arrayQID); }