private void Treatments_Load(object sender, EventArgs e) { string sql = "select count(Treatment_ID) from Treatment;"; string sql1 = "select Patient_Name from Patient_Details"; count = db.GetIntValue(sql); // set data from database to combo box comboxPname.DataSource = db.SelectOneColumn(sql1).Tables[0]; comboxPname.DisplayMember = "Patient_Name"; comboxPname.Text = "Select Patient"; dateTreatment.Value = DateTime.Today; txttid.Text = (count + 1).ToString(); }
public void data(ComboBox cmb, string sql, string displayMem, string text) { cmb.DataSource = db.SelectOneColumn(sql).Tables[0]; cmb.DisplayMember = displayMem; cmb.Text = text; }