asked on

A local variable named 'rowCount' cannot be declared in this scope because it would give a different meaning to 'rowCount', which is already used in a 'parent or current' scope

Error 1 A local variable named 'rowCount' cannot be declared in this scope because it would give a different meaning to 'rowCount', which is already used in a 'parent or current' scope to denote something else C:\Users\Aministrator\Desktop\InitialPriceReporting\InitialPriceReporting\DotNet\InitialPriceReportingSpreadsheet\Program.cs 105 22 InitialPriceReportingSpreadsheet

// Process discounts
for (int rowCount = currRow; rowCount <= currRow + 3; rowCount++)
{
// Read the discounts
try
{
cellvalue = (Microsoft.Office.Interop.Excel.Range)inputRange.Cells[rowCount, 16];
if (cellvalue.Value2.ToString().Length > 0)
{
discounts[rowCount - currRow, 0] = (int)cellvalue.Value2;
cellvalue = (Microsoft.Office.Interop.Excel.Range)inputRange.Cells[rowCount, 17];

discounts[rowCount - currRow, 1] = (int)cellvalue.Value2;
cellvalue = (Microsoft.Office.Interop.Excel.Range)inputRange.Cells[rowCount, 18];

if (cellvalue.Value2.ToString() != "N/A")
{
// Des Barley is the last discount
discounts[rowCount - currRow, 2] = (int)cellvalue.Value2;
Update_Price_List_Header_with_Discounts(discounts);
// save the discounts
break; // TODO: might not be correct. Was : Exit For
}
else
{
discounts[rowCount - currRow, 2] = 0;
}
}
}
catch
{
Console.WriteLine("Exception has occurred.");
}
}

renjurdevan

Are you declared rowCount somewhere else in the function other than
for (int rowCount = currRow; rowCount <= currRow + 3; rowCount++)

if it been so, you could have used another variable name!

mathieu_cupryk

ASKER

what should i do in the second for loop
For rowCount = 10 To inputRange.Rows.Count
' Read the grade name and price
' skip rows where the grade name is empty
Try
' Initial prices load file has the prices in column 16
' All other load files have their prices in column 18
If initialButton.Checked = True Then
pricesColumn = 16
Else
pricesColumn = 18
End If
cellvalue = CType(inputRange.Cells(rowCount, pricesColumn), Excel.Range)
If Len(cellvalue.Value) > 0 Then
If cellvalue.Value.ToString = "Stones" Or cellvalue.Value.ToString = "Tough" Then ' all prices have been read
currRow = rowCount + 1 ' skip a row to where the discounts are
Exit For
End If
Price = CDbl(cellvalue.Value)
cellvalue = CType(inputRange.Cells(rowCount, 15), Excel.Range)
gradeName = cellvalue.Value.ToString
Insert_Price_List_Detail(gradeName, Price) ' insert the prices
End If
Catch
Console.WriteLine("Exception has occurred.")
End Try
Next

' Process discounts
For rowCount = currRow To currRow + 3

what should this be converted to?
For rowCount = currRow To currRow + 3

ASKER CERTIFIED SOLUTION

Gautham Janardhan

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

renjurdevan

No need of delcaration like
for (int rowCount = currRow; rowCount <= currRow + 3; rowCount++)

so do it like

int rowCount;
for (rowCount = currRow; rowCount <= currRow + 3; rowCount++)
{
....
....

....
}