I set up a simple search using the wizard in the customization screen. How do I search through the SubConShipD table to get data from multiple rows based on the PackNum?
private void SearchOnsubconshipentryShowDialog()
{
// Wizard Generated Search Method
// You will need to call this method from another method in custom code
// For example, [Form]_Load or [Button]_Click
bool recSelected;
string whereClause = string.Empty;
System.Data.DataSet dssubconshipentry = Ice.UI.FormFunctions.SearchFunctions.listLookup(this.oTrans, "subconshipentry", out recSelected, true, whereClause);
if (recSelected)
{
System.Data.DataRow adapterRow = dssubconshipentry.Tables[0].Rows[0];
// Map Search Fields to Application Fields
EpiDataView edvUD100 = ((EpiDataView)(this.oTrans.EpiDataViews["UD100"]));
System.Data.DataRow edvUD100Row = edvUD100.CurrentDataRow;
if ((edvUD100Row != null))
{
edvUD100Row.BeginEdit();
edvUD100Row["Key1"] = adapterRow["PackNum"];
edvUD100Row.EndEdit();
}
}
}