public static void load_data_to_combobox_with_query(ComboBox ip_cbo, string ip_str_value_field, string ip_str_display_field, eTAT_CA ip_e_tat_ca, string ip_query)
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
DataTable v_dt = new DataTable();
v_ds.Tables.Add(v_dt);
v_us.FillDatasetWithQuery(v_ds, ip_query);
ip_cbo.DisplayMember = ip_str_display_field;
ip_cbo.ValueMember = ip_str_value_field;
ip_cbo.DataSource = v_ds.Tables[0];
if (ip_e_tat_ca == eTAT_CA.YES)
{
DataRow v_dr = v_ds.Tables[0].NewRow();
v_dr[0] = -1;
v_dr[1] = "------ Tất cả ------";
v_ds.Tables[0].Rows.InsertAt(v_dr, 0);
ip_cbo.SelectedIndex = 0;
}
else
{
ip_cbo.SelectedIndex = 0;
}
}
public static void load_data_to_auto_complete_source(string ip_str_table_name, string ip_str_column_name, TextBox ip_txt)
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
DataTable v_dt = new DataTable();
v_ds.Tables.Add(v_dt);
v_us.FillDatasetWithProc(v_ds, ip_str_table_name, ip_str_column_name);
for (int i = 0; i < v_ds.Tables[0].Rows.Count; i++)
{
DataRow v_dr = v_ds.Tables[0].Rows[i];
ip_txt.AutoCompleteCustomSource.Add(v_dr[ip_str_column_name].ToString());
}
}