C#的一个问题,高手来呀
来源:百度知道 编辑:UC知道 时间:2024/06/03 07:43:02
private void GetAllTest(int sid)
{
//创建连接并打开
SqlConnection conn = DBHelper.connection;
conn.Open();
//进行查找
string sql = string.Format("select questionId,answer from question where subjectid = {0}",sid);
SqlCommand cmd = new SqlCommand(sql, conn);
SqlDataReader dr = cmd.ExecuteReader();
DataTable dt = new DataTable();
dt.Load(dr);
int rownum = dt.Rows.Count;
QuestionHelper.allTest = new object[rownum, 2];
QuestionHelper.State = new bool[rownum];
for (int i = 0; i <rownum;i++ )
{
QuestionHelper.allTest[i, 0] = dt.Rows[i][0];
QuestionHelper.allTest[i, 1] = dt.Rows[i][1];
QuestionHelper.State[i] = false;
}
请问一下,这段代码有什么意义呢
{
//创建连接并打开
SqlConnection conn = DBHelper.connection;
conn.Open();
//进行查找
string sql = string.Format("select questionId,answer from question where subjectid = {0}",sid);
SqlCommand cmd = new SqlCommand(sql, conn);
SqlDataReader dr = cmd.ExecuteReader();
DataTable dt = new DataTable();
dt.Load(dr);
int rownum = dt.Rows.Count;
QuestionHelper.allTest = new object[rownum, 2];
QuestionHelper.State = new bool[rownum];
for (int i = 0; i <rownum;i++ )
{
QuestionHelper.allTest[i, 0] = dt.Rows[i][0];
QuestionHelper.allTest[i, 1] = dt.Rows[i][1];
QuestionHelper.State[i] = false;
}
请问一下,这段代码有什么意义呢
无返回值 ? ....
应该是给这个 QuestionHelper.allTest[i, 1] (是不是数组?) 添加记录吧?
DBHelper是什么?
这不就是显示一个类别的问题和答案吗,有什么特殊的吗?直接用dataset不更好