You’re offline. This is a read only version of the page.
1,215
Hi,
I have a DropDown control on an aspx page which consumes a QueryService in AIF of AX 2012 R3.
The query has CustTable in it and I am able to get the AccountNum column in the DropDown.
Now I want to concatenate the AccounNum with the name of the customer, but the DropDown can be assigned to only one data table (if I am correct).
Could there be any way to achieve this?
Any help is appreciated!
Regards,
Abhinay Tharwal
*This post is locked for comments
I have the same question (0)
This is how I achieved it:
Share
Report
All responses (
Answers (
foreach (DataRow dr in dataSet.Tables[0].Rows)
{
DataRow[] foundRows = dataSet.Tables[1].Select("RecId = " + dr["Party"]);
foreach (DataRow drParty in foundRows)
{
string NameStr = dr["AccountNum"] + ":" + drParty["Name"].ToString();
string custNum = dr["AccountNum"].ToString();
ddlCustomers.Items.Add(new ListItem(NameStr, custNum));
}
}
