美容面部学位图片大全:能不能把接收的数据先存入DataRow数组里,在显示在列里

5月22日 19:27 if(!Page.IsPostBack)
{
SqlCommand com=new SqlCommand("select distinct Course_name from scoreview",con);
con.Open();
SqlDataReader dr=com.ExecuteReader();
DataTable tab=new DataTable();
tab.Columns.Add(new DataColumn("学号",typeof(string)));
tab.Columns.Add(new DataColumn("姓名",typeof(string)));
while(dr.Read())
{this.Label1.Text=dr[0].ToString();
tab.Columns.Add(new DataColumn(dr[0].ToString(),typeof(string)));
}
con.Close();

SqlCommand sqlcom=new SqlCommand("select distinct Student_no,Student_name from scoreview",con);
con.Open();
SqlDataReader sdr=sqlcom.ExecuteReader();
DataRow drow;
while(sdr.Read())
drow=tab.NewRow();
for(int i=0;i<2;i++)
{
drow[i]=sdr[i].ToString();
}
tab.Rows.Add(drow);
}
con.Close();

SqlCommand cnu=new SqlCommand("select count(distinct Course_name),count(*) from scoreview",con);
con.Open();
SqlDataReader fcdr=cnu.ExecuteReader();
if(fcdr.Read())
{
num=int.Parse(fcdr[0].ToString().Trim());
}
con.Close();
SqlCommand scom=new SqlCommand("select distinct Student_no,Student_name,Course_name,Score_result from scoreview",con);
con.Open();
SqlDataReader fdr=scom.ExecuteReader();
while(fdr.Read())
{
drow=tab.NewRow();
if(j<num+2)
{drow[j]=fdr[3].ToString();
j=j+1;
else
{
j=2;
}
con.Close();
this.DataGrid1.DataSource=tab;
this.DataGrid1.DataBind();
}
}
tab.Rows.Add(drow);

你把这段代码拷上试一试!