public void LayDuLieuLenComboBox(ComboBox com)
{
DayData day = new DayData();
com.DataSource = day.LayDSDay();
com.DisplayMember = "TENDAY";
com.ValueMember = "MADAY";
}
public void LayDuLieuLenDataGridViewComboBoxColumn(DataGridViewComboBoxColumn col)
{
DayData day = new DayData();
col.DataSource = day.LayDSDay();
col.DisplayMember = "TENDAY";
col.ValueMember = "MADAY";
col.DataPropertyName = "MADAY";
col.HeaderText = "Dãy";
}
/// <summary>
/// Hiển Thị Dữ liệu lên Form
/// </summary>
/// <param name="da"></param>
/// <param name="bin"></param>
public void HienThi(DataGridViewX da, BindingNavigator bin, TextBox ma, TextBox ten, TextBox soluong, ComboBoxEx ktx, ComboBoxEx codo)
{
#region Bingding
BindingSource source = new BindingSource();
source.DataSource = data.LayDSDay();
da.DataSource = source;
bin.BindingSource = source;
#endregion
da.Columns.RemoveAt(3);
da.Columns.RemoveAt(3);
#region Cột Ký túc xá
DataGridViewComboBoxColumn comKTX = new DataGridViewComboBoxColumn();
comKTX.HeaderText = "Ký túc xá";
comKTX.Name = "CotKTX";
new KTXCtrl().LayDataGridViewComboBoxColumnTuDSKTX(comKTX);
da.Columns.Add(comKTX);
#endregion
#region Cột Cờ đỏ
DataGridViewComboBoxColumn comCoDo = new DataGridViewComboBoxColumn();
comCoDo.HeaderText = "Cờ đỏ";
comCoDo.Name = "CotCoDo";
new SinhVienCtrl().LayDataGridViewComboBoxColumn_CoDo(comCoDo);
da.Columns.Add(comCoDo);
#endregion
if (ktx.DataBindings.Count > 0)//Kiểm tra xem các control dá được Binding chưa
{
ktx.DataBindings.RemoveAt(0);
codo.DataBindings.RemoveAt(0);
ma.DataBindings.RemoveAt(0);
ten.DataBindings.RemoveAt(0);
soluong.DataBindings.RemoveAt(0);
}
new KTXCtrl().LayDSKTXLenComboBox(ktx);
ktx.DataBindings.Add("SelectedValue", source, "KTX");
new SinhVienCtrl().LayDSSinhVienLenComboBox(codo);
codo.DataBindings.Add("SelectedValue", source, "MACODO");
ma.DataBindings.Add("Text", source, "MADAY");
ten.DataBindings.Add("Text", source, "TENDAY");
soluong.DataBindings.Add("Text", source, "SOLUONGPHG");
}
public void LayDuLieuLenComboBoxItem(ComboBoxItem cmb)
{
DayData hd = new DayData();
DataTable table = hd.LayDSDay();
foreach (DataRow row in table.Rows)
{
cmb.Items.Add(row["TenDay"]);
}
//cmb.DisplayMember = "TENPHG";
//cmb.ValueMember = "MAPHG";
}
public void HienThi(DataGridView dgv)
{
dgv.DataSource = day.LayDSDay().Tables[0];
}