private void layDS_Phong() { //cbbPhong.DataSource = null; //cbbPhong.Items.Clear(); //cbbPhong.Refresh(); DataTable dt = pbbus.DANH_SACH_PHONG_BAN(cbbMaCN.Text); //DataRow first_row = dt.NewRow(); //first_row[0] = "Tất cả"; //dt.Rows.InsertAt(first_row, 0); cbbPhong.DataSource = dt; cbbPhong.DisplayMember = "TENPB"; cbbPhong.ValueMember = "MAPB"; if (dt.Rows.Count > 0) { cbbPhong.SelectedIndex = 0; } //strCmd = "SELECT * FROM PHONGBAN WHERE MACN='" + cbbMaCN.Text.Trim() + "'"; //SqlDataAdapter adapter = new SqlDataAdapter(); //try //{ // frmMain.conn.Open(); // adapter.SelectCommand = new SqlCommand(strCmd, frmMain.conn); // adapter.SelectCommand.ExecuteReader(); // frmMain.conn.Close(); //} //catch (Exception ex) //{ // MessageBox.Show(ex.ToString()); //} //DataSet ds = new DataSet(); //adapter.Fill(ds); //dtResult = ds.Tables[0]; //int iRows = dtResult.Rows.Count; //for (int i = 0; i < iRows; i++) //{ // try // { // cbbPhong.Items.Add(dtResult.Rows[i]["TenPB"].ToString()); // arrPhong.Add(dtResult.Rows[i]["MaPB"].ToString()); // //arrChucvu.Add(dtResult.Rows[i]["Chucvu"].ToString()); // } // catch (Exception ex) // { // MessageBox.Show(ex.ToString()); // } //} //if (iRows > 0) //{ // cbbPhong.SelectedIndex = 0; //} }