private void DisplayAvailableAndSelectedSuppliers() { if (hdnCategoryId.Value.Trim() != "") { CategoryTransaction cat = new CategoryTransaction(); lblSupplierCategory.Text = cat.GetCategoryNameById(connstring, hdnCategoryId.Value.Trim()); string allSelectedVendors = ""; if (hdnSuppliers.Value.Trim() == "") { if (hdnOTS.Value.Trim() == "") { allSelectedVendors = ""; } else { allSelectedVendors = hdnOTS.Value.Trim(); } } else if (hdnOTS.Value.Trim() == "") { allSelectedVendors = hdnSuppliers.Value.Trim(); } else { allSelectedVendors = hdnSuppliers.Value.Trim() + "," + hdnOTS.Value.Trim(); } SupplierTransaction sup = new SupplierTransaction(); DataSet ds = sup.GetSuppliersByCategoryId_FilteredList(connstring, hdnCategoryId.Value.Trim(), "", allSelectedVendors); DataTable dtAvailable = new DataTable(); DataTable dtSelected = new DataTable(); if (ds.Tables.Count > 0) { try { if (ds.Tables[0] != null) { dtAvailable = ds.Tables[0]; } if (ds.Tables.Count > 1) { if (ds.Tables[1] != null) { dtSelected = ds.Tables[1]; } } } catch { } } lstSupplierA.DataSource = dtAvailable; lstSupplierA.DataTextField = "VendorName"; lstSupplierA.DataValueField = "VendorId"; lstSupplierA.DataBind(); lstSupplierB.DataSource = dtSelected; lstSupplierB.DataTextField = "VendorName"; lstSupplierB.DataValueField = "VendorId"; lstSupplierB.DataBind(); } }