private void fillIndividualClientDropDown()
{
try
{
DropIndividual.Items.Clear();
string q = "select distinct nadcod, ordctn from innodis_sa_preorh";
myConn.Open();
OracleCommand cmd = new OracleCommand(q, myConn);
DataTable ClientData = new DataTable();
ClientData.Columns.Add("nadcod", typeof(string));
ClientData.Columns.Add("ordctn", typeof(string));
ClientData.Columns.Add("ConcatenatedField", typeof(string), "nadcod + ' | ' +ordctn");
OracleDataAdapter sda = new OracleDataAdapter();
sda.SelectCommand = cmd;
sda.Fill(ClientData);
DropIndividual.DataSource = ClientData;
DropIndividual.DataTextField = "ConcatenatedField";
DropIndividual.DataValueField = "nadcod";
DropIndividual.DataBind();
myConn.Close();
}
catch (OracleException ex)
{
if (myConn.State == ConnectionState.Open)
{
myConn.Close();
}
//enter error handler
}
}
protected void ButtonFilterIndividual_Click(object sender, EventArgs e)
{
if (TextBoxIndividual.Text.Trim() == string.Empty)
{
return;
}
var manager = new IndividualManager();
var table = manager.SearchByName(TextBoxIndividual.Text.Trim().ToLower());
DropIndividual.Items.Clear();
DropIndividual.DataSource = table;
DropIndividual.DataTextField = table.individual_nameColumn.ColumnName;
DropIndividual.DataValueField = table.individual_nameColumn.ColumnName;
DropIndividual.DataBind();
DropIndividual.Enabled = DropIndividual.Items.Count > 0;
}
