ASP.NET

HatakeKaKaShi wrote:

For about 900 records there's about 50 min.

HatakeKaKaShi wrote:

SQL server 2000 to and excel spreadsheet

HatakeKaKaShi wrote:

Then first i select all the main info id and use the for loop to loop through all the sub details table whether the id is match.

<configuration><br />
   <system.web><br />
      <compilation><br />
         <codeSubDirectories><br />
           <add directoryName="mySubDir1"/><br />
           <add directoryName="mySubDir2"/><br />
           </codeSubDirectories><br />
      </compilation><br />
   </system.web><br />
</configuration>

// Which question are they on
int question_number = 0;  // This could come from Request[] or a hidden field on the page or something
int.TryParse(Request["question_number"], out question_number);

int max_questions = 9;

int seed = 42;  // The seed could be set from maybe a student id or user id to ensure the questions are random across students
System.Random rand = new System.Random( seed );

int random_question_index = 0;

// Move to the appropriate random question based on which question number they're on
for(int i = 0; i < question_number; i++)
    random_question_index = rand.Next(0, max_questions);