private void frm_employee_Load(object sender, EventArgs e) { lblTime.Text = DateTime.Now.ToLongTimeString(); lblDate.Text = DateTime.Now.ToShortDateString(); lb_curent_user.Text = Main_Form.curnt_emp; try { Connection con = new Connection(); if (this.Name == "search") { this.btn_add.Visible = false; this.btn_edit.Visible = false; this.btn_delete.Visible = false; this.btn_ok.Visible = true; emp = new cls_employee(); //dt = emp.select_employee(); dt = con.selectt("select * from employee where [dbo].[employee].[id] not in(select [emp_id]from [dbo].[users]);"); if (dt.Rows.Count == 0) { MessageBox.Show("تم تسجيل جميع الموظفين واختيار اسم مسخدم وكلمة مرور لهم ", "تنبيه ", MessageBoxButtons.OK, MessageBoxIcon.Information); } } else { emp = new cls_employee(); dt = emp.select_employee(); if (dt.Rows.Count > 0) { emp_code = dt.Rows[dt.Rows.Count - 1][0].ToString(); } else { emp_code = "Emp_100"; } } dv = new DataView(dt); dgv_employee.DataSource = dv; dgv_employee.Columns[0].HeaderText = "كود الموظف"; dgv_employee.Columns[1].HeaderText = "اسم الموظف"; dgv_employee.Columns[2].Visible = false; dgv_employee.Columns[3].HeaderText = "رقم الهاتف"; dgv_employee.Columns[4].HeaderText = "الحالة الاجتماعية"; dgv_employee.Columns[14].HeaderText = "المؤهل"; dgv_employee.Columns[5].Visible = false; dgv_employee.Columns[6].Visible = false; dgv_employee.Columns[7].Visible = false; dgv_employee.Columns[8].Visible = false; dgv_employee.Columns[9].Visible = false; dgv_employee.Columns[10].Visible = false; dgv_employee.Columns[11].Visible = false; dgv_employee.Columns[12].Visible = false; dgv_employee.Columns[13].Visible = false; dgv_employee.Columns[15].Visible = false; dgv_employee.Columns[21].Visible = false; dgv_employee.Columns[22].Visible = false; dgv_employee.Columns[23].Visible = false; dgv_employee.Columns[24].Visible = false; dgv_employee.Columns[25].Visible = false; dgv_employee.Columns[16].Visible = false; dgv_employee.Columns[17].Visible = false; dgv_employee.Columns[18].Visible = false; dgv_employee.Columns[19].Visible = false; dgv_employee.Columns[20].Visible = false; } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }