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; }