数据显示不出,请高手帮忙解决,谢谢!
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];
SqlDataAdapter testda = new SqlDataAdapter(testsql, testcon);
DataSet tempds = new DataSet();
testda.Fill(tempds);
DataRow tbQuestionRow = tbQuestions.NewRow();
tbQuestionRow[ "questionIdentity "] = Guid.NewGuid();
tbQuestionRow[ "questionID "] = tempds.Tables[0].Rows[0][ "questionID "];
Response.Write(tempds.Tables[0].Rows[0][ "questionID "]+ "end <br> ");
Response.Write(tbQuestionRow[ "questionID "]+ "finish <br> ");
tbQuestionRow[ "question "] = tempds.Tables[0].Rows[0][ "question "];
tbQuestionRow[ "answer1 "] = tempds.Tables[0].Rows[0][ "answer1 "];
tbQuestionRow[ "answer2 "] = tempds.Tables[0].Rows[0][ "answer2 "];
tbQuestionRow[ "answer3 "] = tempds.Tables[0].Rows[0][ "answer3 "];
tbQuestionRow[ "answer4 "] = tempds.Tables[0].Rows[0][ "answer4 "];
}
/*** rptTest.DataSource = testds.Tables[0];
rptTest.DataBind();*/
GridView1.DataSource = testds.Tables[0];
GridView1.DataBind();
[解决办法]
testds里没数据;
tbQuestionRow[ "answer4 "] = tempds.Tables[0].Rows[0][ "answer4 "];
tbQuestions.Rows.Add(tbQuestionRow );
}