UC知道asp.net数据库表遍历出错
来源：百度知道 编辑：UC知道 时间：2024/05/24 20:12:58
sqlServer2005数据库
protected void Filldata()
{
int kong = 4;
int sum = 0;
int sign = 0; int temp = 1;
Random ra = new Random();
temp =ra.Next (1,4);
string CmdSql = "select top "+ temp +" * from FillTable order by newid()"; //随机选出 temp 个数据
string strcon = "database=OnLineExam;data source=(local);integrated security=sspi";//数据库的连接
SqlConnection conn = new SqlConnection(strcon );
conn.Open();
SqlDataAdapter adp = new SqlDataAdapter(CmdSql ,conn );
DataSet ds = new DataSet();
adp.Fill(ds, "tempTable");
for (int i = 0; i < ds.Tables.Count; i++) //计算 Kong 字段的和！但是ds.tables.Count也不对，它只等于1，该怎实现？
{
sum = sum + int.Parse(ds.Tables["tempTable"].Rows[i]["kong"].ToString(
protected void Filldata()
{
int kong = 4;
int sum = 0;
int sign = 0; int temp = 1;
Random ra = new Random();
temp =ra.Next (1,4);
string CmdSql = "select top "+ temp +" * from FillTable order by newid()"; //随机选出 temp 个数据
string strcon = "database=OnLineExam;data source=(local);integrated security=sspi";//数据库的连接
SqlConnection conn = new SqlConnection(strcon );
conn.Open();
SqlDataAdapter adp = new SqlDataAdapter(CmdSql ,conn );
DataSet ds = new DataSet();
adp.Fill(ds, "tempTable");
for (int i = 0; i < ds.Tables.Count; i++) //计算 Kong 字段的和！但是ds.tables.Count也不对，它只等于1，该怎实现？
{
sum = sum + int.Parse(ds.Tables["tempTable"].Rows[i]["kong"].ToString(
foreach (DataRow dr in ds.Tables[0].Rows.Count )
{
sum = sum + int.Parse(dr["kong"].ToString());
}
一般人我都不告诉他，(*^__^*) 嘻嘻……
for (int i = 0; i < ds.Tables.Count; i++)
这里你可能写错了！
应该是:ds.Tables[0].Rows.Count
ds.Tables.Count写错了！！您这是DATASET中的表的个数了，应该是您表中的行数ds.Tables["tempTable"].Rows.Count