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