I get results from a stored procedure that is working but I can't get to yValues. Error message The name 'acc1' does not exist in the current context, valid for all values. How it should be done?
using (SqlDataReader rdr = cmd.ExecuteReader())
{
// Handle first result set (M1, M2, etc.)
if (rdr.HasRows)
{
while (rdr.Read())
{
double acc1 = double.Parse(rdr["M1"].ToString());
double acc2 = double.Parse(rdr["M2"].ToString());
double acc3 = double.Parse(rdr["M3"].ToString());
double acc4 = double.Parse(rdr["M4"].ToString());
double acc5 = double.Parse(rdr["M5"].ToString());
double acc6 = double.Parse(rdr["M6"].ToString());
double acc7 = double.Parse(rdr["M7"].ToString());
double acc8 = double.Parse(rdr["M8"].ToString());
double acc9 = double.Parse(rdr["M9"].ToString());
double acc10 = double.Parse(rdr["M10"].ToString());
double acc11 = double.Parse(rdr["M11"].ToString());
double acc12 = double.Parse(rdr["M12"].ToString());
}
}
if (rdr.NextResult() && rdr.HasRows)
{
while (rdr.Read())
{
double val1 = double.Parse(rdr["V1"].ToString());
double val2 = double.Parse(rdr["V2"].ToString());
double val3 = double.Parse(rdr["V3"].ToString());
double val4 = double.Parse(rdr["V4"].ToString());
double val5 = double.Parse(rdr["V5"].ToString());
double val6 = double.Parse(rdr["V6"].ToString());
double val7 = double.Parse(rdr["V7"].ToString());
double val8 = double.Parse(rdr["V8"].ToString());
double val9 = double.Parse(rdr["V9"].ToString());
double val10 = double.Parse(rdr["V10"].ToString());
double val11 = double.Parse(rdr["V11"].ToString());
double val12 = double.Parse(rdr["V12"].ToString());
}
}
}
double[] yValues =
{
(acc1*200000)/val1,
((acc1+acc2)*200000)/(val1+val2),
((acc1+acc2+acc3)*200000)/(val1+val2+val3),
((acc1+acc2+acc3+acc4)*200000)/(val1+val2+val3+val4),
((acc1+acc2+acc3+acc4+acc5)*200000)/(val1+val2+val3+val4+val5),
((acc1+acc2+acc3+acc4+acc5+acc6)*200000)/(val1+val2+val3+val4+val5+val6),
((acc1+acc2+acc3+acc4+acc5+acc6+acc7)*200000)/(val1+val2+val3+val4+val5+val6+val7),
((acc1+acc2+acc3+acc4+acc5+acc6+acc7+acc8)*200000)/(val1+val2+val3+val4+val5+val6+val7+val8),
((acc1+acc2+acc3+acc4+acc5+acc6+acc7+acc8+acc9)*200000)/(val1+val2+val3+val4+val5+val6+val7+val8+val9),
((acc1+acc2+acc3+acc4+acc5+acc6+acc7+acc8+acc9+acc10)*200000)/(val1+val2+val3+val4+val5+val6+val7+val8+val9+val10),
((acc1+acc2+acc3+acc4+acc5+acc6+acc7+acc8+acc9+acc10+acc11)*200000)/(val1+val2+val3+val4+val5+val6+val7+val8+val9+val10+val11),
((acc1+acc2+acc3+acc4+acc5+acc6+acc7+acc8+acc9+acc10+acc11+acc12)*200000)/(val1+val2+val3+val4+val5+val6+val7+val8+val9+val10+val11+val12)
};