ASP.net关于循环显示问题
protected void Page_Load(object sender, EventArgs e)
{
SqlConnection sqlconstr = new SqlConnection();
sqlconstr.ConnectionString = "Data Source=localhost;Initial Catalog=YoanExtend;User ID=sa;Password=iiszwjlovelp";
sqlconstr.Open();
SqlCommand com = new SqlCommand();
com.Connection = sqlconstr;
com.CommandText = "GetWebUserIntegrationList";
com.CommandType = CommandType.StoredProcedure;
SqlParameter[] p_htno = new SqlParameter[7];
p_htno[0] = new SqlParameter("@UserID",SqlDbType.VarChar,24);
p_htno[1] = new SqlParameter("@BY",SqlDbType.Int);
p_htno[2] = new SqlParameter("@BM", SqlDbType.Int);
p_htno[3] = new SqlParameter("@EY", SqlDbType.Int);
p_htno[4] = new SqlParameter("@EM", SqlDbType.Int);
p_htno[5] = new SqlParameter("@Count", SqlDbType.Int);
p_htno[6] = new SqlParameter("@SumFee", SqlDbType.VarChar,12);
string strSe = Session["data"].ToString();
Response.Write(strSe);
p_htno[0].Value = strSe;
p_htno[1].Value = 2014;
p_htno[2].Value = 1;
p_htno[3].Value = 2014;
p_htno[4].Value = 5;
p_htno[5].Direction = ParameterDirection.Output;
p_htno[6].Direction = ParameterDirection.Output;
for (int i = 0; i < p_htno.Length; i++)
{
com.Parameters.Add(p_htno[i]);
}
SqlDataReader dr = com.ExecuteReader();
while (dr.Read())
{
//循环显示查询结果
Response.Write("<div>"+dr["n_y"].ToString() + "年<br >" + dr["n_m"].ToString() + "月<br >" + dr["n_bccm"].ToString() + "抄码<br >" + dr["n_ysl"].ToString() + "水量" + "<br ><br ></div>");
}
这个B页面是从A页面跳转过来的。单独打开B页面会显示我想要的结果,但跳转过来的时候显示不出来结果是什么原因?我查看了代码会变成这样
<div>2014年<br >1月<br >2237抄码<br >0水量<br ><br ></div><div>2014年<br >2月<br >2240抄码<br >3水量<br ><br ></div><div>2014年<br >3月<br >2241抄码<br >1水量<br ><br ></div><div>2014年<br >4月<br >2243抄码<br >2水量<br ><br ></div><div>2014年<br >5月<br >2245抄码<br >2水量<br ><br ></div>5笔<br>53.60元
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head><title>
</title></head>
<body>
<form method="post" action="qfcx.aspx" id="form1">
<div class="aspNetHidden">
<input type="hidden" name="__VIEWSTATE" id="__VIEWSTATE" value="/wEPDwULLTE2MTY2ODcyMjlkZIarZPbR62fhhiPN7Wt2MVB7/gO0Ofkd18zMppADB0mA" />
</div>
<div class="aspNetHidden">
<input type="hidden" name="__VIEWSTATEGENERATOR" id="__VIEWSTATEGENERATOR" value="31B9D3EF" />
</div>
<div>
</div>
</form>
</body>
</html>
我想到的另一种方法后台添加Label。循环输出。(可惜俺是小白,不知道怎么写,请求代码)