private void load_combobox() { DataTable dt = new DataTable(); dt.Columns.Add("id", typeof(decimal)); dt.Columns.Add("name", typeof(string)); // string exp = ""; DataRow dr; DAL.Accessdata m = new DAL.Accessdata(); // list = DAL.Manager.listClient(); for (int i = 0; i < list.Count; i++) { DAL.Client client = list[i]; exp = "id=" + client.ID.ToString(); dr = m.getrowbyid(dt, exp); if (dr == null) { dr = dt.NewRow(); dr["id"] = client.ID; dr["name"] = client.DatabaseName + " [" + client.Host + "]"; dt.Rows.Add(dr); } } dt.AcceptChanges(); // // cmbMayTram.DataSource = dt; cmbMayTram.DisplayMember = "name"; cmbMayTram.ValueMember = "id"; // }
private void cmbMail_SelectedIndexChanged(object sender, EventArgs e) { try { DataRow r = m.getrowbyid(m_dt_mail, "id=" + cmbMail.SelectedValue); txtChude.Text = r["tieude"].ToString(); txtNoidung.Text = r["noidung"].ToString(); } catch { txtChude.Text = ""; txtNoidung.Text = ""; } }