foreach (DataRow row in dt.Rows){}只能读到第一行 咋回事 sql语句正常
foreach (DataRow row in dt.Rows){}只能读到第一行
咋回事
sql语句正常


[解决办法]
你那代码写的真是错误了，给你修改了下

C# code

  foreach (DataRow row in dt.Rows)  {  string username = row["name"].ToString();  string daynum = row["total_day"].ToString();  string avgtime = row["total_minute"].ToString();  Decimal hours = Convert.ToDecimal(avgtime) / 60;  int minuteday = Convert.ToInt32(Convert.ToDecimal(avgtime) / Convert.ToDecimal(daynum));  ret += "<p username=\"" + username + "\" total_hour=\"" + hours + "\" day_minute=\"" + minuteday + "\"/>";  }
[解决办法]
用了foreach，里面怎么还用下标呢，当然是一行了啊。
DataTable dt = UserDA.GetTime(uid, btime, etime);
 foreach (DataRow row in dt.Rows)
 {
 string username = row["name"].ToString();
 string daynum = row["total_day"].ToString();
 string avgtime = row["total_minute"].ToString();
 ... 
}