public frm_jorclose(pro_view.fld_PL.fld_Login.frm_main frm_Main) { frm_main = frm_Main; InitializeComponent(); bl.company_id = frm_main.com_companies.SelectedValue.ToString(); ds = bl.Select(); com_oldfyear.ValueMember = "id"; com_oldfyear.DisplayMember = "aname"; com_oldfyear.DataSource = ds.Tables["tbl_oldfyear"]; if (ds.Tables["tbl_oldfyear"].Rows.Count > 1) { com_oldfyear.SelectedValue = ds.Tables["tbl_oldfyear"].Rows[1]["id"]; } com_newfyear.ValueMember = "id"; com_newfyear.DisplayMember = "aname"; com_newfyear.DataSource = ds.Tables["tbl_newfyear"]; }
public frm_Stu_Search(pro_view.fld_PL.fld_Login.frm_main frm_Main, TextBox t) { InitializeComponent(); frm_main = frm_Main; txt_dgv_search.Text = t.Text; #region dgv_parents_search dgv_stu_search.AutoGenerateColumns = false; var id = new DataGridViewTextBoxColumn(); id.Name = "id"; id.HeaderText = "المسلسل"; id.DataPropertyName = "id"; id.AutoSizeMode = DataGridViewAutoSizeColumnMode.None; id.Width = 100; dgv_stu_search.Columns.Add(id); var f_parent_id = new DataGridViewTextBoxColumn(); f_parent_id.Name = "f_parent_id"; f_parent_id.HeaderText = "رقم هوية الاب"; f_parent_id.DataPropertyName = "f_parent_id"; f_parent_id.AutoSizeMode = DataGridViewAutoSizeColumnMode.None; f_parent_id.Width = 100; dgv_stu_search.Columns.Add(f_parent_id); var f_aname = new DataGridViewTextBoxColumn(); f_aname.Name = "f_aname"; f_aname.HeaderText = "اسم الاب"; f_aname.DataPropertyName = "f_aname"; f_aname.AutoSizeMode = DataGridViewAutoSizeColumnMode.None; f_aname.Width = 100; dgv_stu_search.Columns.Add(f_aname); var f_mobile1 = new DataGridViewTextBoxColumn(); f_mobile1.Name = "f_mobile1"; f_mobile1.HeaderText = "جوال الاب"; f_mobile1.DataPropertyName = "f_mobile1"; f_mobile1.AutoSizeMode = DataGridViewAutoSizeColumnMode.None; f_mobile1.Width = 100; dgv_stu_search.Columns.Add(f_mobile1); var m_parent_id = new DataGridViewTextBoxColumn(); m_parent_id.Name = "m_parent_id"; m_parent_id.HeaderText = "رقم هويةالام"; m_parent_id.DataPropertyName = "m_parent_id"; m_parent_id.AutoSizeMode = DataGridViewAutoSizeColumnMode.None; m_parent_id.Width = 100; dgv_stu_search.Columns.Add(m_parent_id); var m_aname = new DataGridViewTextBoxColumn(); m_aname.Name = "m_aname"; m_aname.HeaderText = "اسم الام"; m_aname.DataPropertyName = "m_aname"; m_aname.AutoSizeMode = DataGridViewAutoSizeColumnMode.None; m_aname.Width = 100; dgv_stu_search.Columns.Add(m_aname); var m_mobile1 = new DataGridViewTextBoxColumn(); m_mobile1.Name = "m_mobile1"; m_mobile1.HeaderText = "جوال الام"; m_mobile1.DataPropertyName = "m_mobile1"; m_mobile1.AutoSizeMode = DataGridViewAutoSizeColumnMode.None; m_mobile1.Width = 100; dgv_stu_search.Columns.Add(m_mobile1); module.company_id = frm_main.com_companies.SelectedValue.ToString(); module.selecttype = "Select_All"; ds = module.Select(); ds.Tables[0].DefaultView.RowFilter = "id like'%" + t.Text + "%' or f_parent_id like '%" + t.Text + "%' or f_aname like '%" + t.Text + "%' or f_mobile1 like '%" + t.Text + "%'"; dgv_stu_search.Rows.Clear(); foreach (DataRowView r in ds.Tables[0].DefaultView) { dgv_stu_search.Rows.Add(r["id"], r["f_parent_id"], r["f_aname"], r["f_mobile1"], r["m_parent_id"], r["m_aname"], r["m_mobile1"]); } dgv_stu_search.ClearSelection(); }