I have done the same thing. But when i insert new row from infopath form it take old value.(e.g. if i select first name and last name different then first row then the age value will be given old one(first row)). i have debug my code. all the function working fine but only value not get updated.
Take a look of my drop down function.
public void ddlCostCenter_Changed(object sender, XmlEventArgs e)
{
ExpenseCode = "";
CostCode = "";
FundCode = "";
Milage = 0;
// Write your code here to change the main data source.
XPathNavigator elementddlCostCenter = this.MainDataSource.CreateNavigator().SelectSingleNode("//my:myFields/my:group1/my:group2/my:ddlCostCenter", this.NamespaceManager);
ddlCostCenter = elementddlCostCenter.Value;
if (ddlDepartmentToCharge != null && ddlDepartmentToCharge != "" && ddlDepartmentToCharge != "Select department to charge...." && ddlCostCenter != null && ddlCostCenter != "" && ddlCostCenter != "Select cost center..")
{
//assignValue(ddlDepartedFrom, ddlArrivalAt);
//getMileage(ddlDepartmentToCharge);
string DeptCode = getDepartmentCode(ddlDepartmentToCharge);
string CostCodeLocal = getCostCenterFundCode(ddlCostCenter);
string FundCodeLocal = getCostCenterFund(ddlCostCenter);
string ExpenseCodeLocal = "6410";
string AccountCode = FundCodeLocal + DeptCode + CostCodeLocal + ExpenseCodeLocal;
DataRow _row = PayoutAccountSummary.NewRow();
_row[0] = AccountCode;
PayoutAccountSummary.Rows.Add(_row);
}
}
Please suggest i am stuck here and nothing find that can help me.