Unable to get the value from a Variable

July 02, 2019 06:43
1

I have a Table and having some columns like "HSNCode", "MRP", "Total" etc.. I want to merge the "MRP" value to the immediate below row when "HSNCode" value is empty in any of the row. Just I am looping on one condition.

If HSNCode is not empty then I am storing the value in "another" variable. Like that it will be in the loop until "HSNCode" is empty. When HSNCode is empty then in the "another" variable previous value of MRP will be stored. I want to copy that MRP to the below row if HSNCode is Empty.

But the Problem is that value is not storing

using System;

string another = string.Empty;

int count = 20;

for(int i = 0; i<count; i++)
{
    if(Context.Field("HSNCode").Text != "")
    {
        another = Context.Field("MRP").Text;   
    }
    else if(Context.Field("HSNCode").Text == "")
    {
        Context.Field("MRP").Text = another;
    }    
}

Comments

1 comment

Ekaterina

October 21, 2019 06:47
Hello,

In your code sample I do not see the “i” variable into the loop.

Please see the sample:

int rowsNumber = Context.Field("Name").Items.Count; //we count the number of table's rows
string Value = "";//we create a variable to store the last found Classification value

for (int index = 0; index < rowsNumber; index ++) //we iterate through all rows
{
if (Context.Field("Name").Items[index].Text != "")
{
Value = Context.Field("Name").Items[index].Text; //if "Name" is not empty, then we fill the variable with the found value
}
else
{
Context.Field("Name").Items[index].Text = Value;//if "Name" is empty, then we write to the field the last found value
}
}

0

Please sign in to leave a comment.

Community