private void fillItemInformation()
{
try
{
DropDownProducts.Items.Clear();
string q = "select distinct strcod, allcod from innodis_sa_preord order by strcod";
myConn.Open();
OracleCommand cmd = new OracleCommand(q, myConn);
DataTable ProductData = new DataTable();
ProductData.Columns.Add("strcod", typeof(string));
ProductData.Columns.Add("allcod", typeof(string));
ProductData.Columns.Add("ConcatenatedField", typeof(string), "strcod + ' | ' +allcod");
OracleDataAdapter sda = new OracleDataAdapter();
sda.SelectCommand = cmd;
sda.Fill(ProductData);
DropDownProducts.DataSource = ProductData;
DropDownProducts.DataTextField = "ConcatenatedField";
DropDownProducts.DataValueField = "strcod";
DropDownProducts.DataBind();
myConn.Close();
}
catch (OracleException ex)
{
if (myConn.State == ConnectionState.Open)
{
myConn.Close();
}
//enter error handler
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
manager = new ProductManager();
products = manager.ViewModelList();
var objData = ProductsBinderList();
DropDownProducts.DataSource = objData;
DropDownProducts.DataBind();
dropDownSearchCriteria.DataSource = InitSearchCriteria();
dropDownSearchCriteria.DataBind();
}
IsProductChanged = false;
}
