string sql = "select *,Age*amount As Count from Cart where ID='" + i + "'";
SqlCommand com = new SqlCommand(sql, con);
SqlDataAdapter da = new SqlDataAdapter(com);
DataSet ds = new DataSet();
da.Fill(ds);
float fl_Count = 0;
foreach(DataRow dr in ds.Tables[0].Rows)
{
fl_Count += Convert.ToSingle(dr[7]);
}
Age_Count = fl_Count.ToString();
dlShoppingCart.DataSource = ds;
dlShoppingCart.DataBind();
fl_Count += Convert.ToSingle(dr[7]);
显示无法找到dr[7],这个是怎么回事
SqlCommand com = new SqlCommand(sql, con);
SqlDataAdapter da = new SqlDataAdapter(com);
DataSet ds = new DataSet();
da.Fill(ds);
float fl_Count = 0;
foreach(DataRow dr in ds.Tables[0].Rows)
{
fl_Count += Convert.ToSingle(dr[7]);
}
Age_Count = fl_Count.ToString();
dlShoppingCart.DataSource = ds;
dlShoppingCart.DataBind();
fl_Count += Convert.ToSingle(dr[7]);
显示无法找到dr[7],这个是怎么回事
foreach(DataRow dr in ds.Tables[0].Rows)
{
fl_Count += Convert.ToSingle(dr[7]);
} for(count=0;count<ds.Tables[0].Rows;count++)
{
if(count==7)
fl_Count += Convert.ToSingle(ds.Tables[0].Rows[7][列名].ToString());
}
{
if(count==7)
{
fl_Count += Convert.ToSingle(ds.Tables[0].Rows[7][列名].ToString());
}
}
另:最好用字段名代替里面的数字,比如:dr["amount"]