private void Btn_Reset_Click(object sender, EventArgs e) { Com_NameS.SelectedIndex = -1; RText_Paid.ResetText(); RText_Rest.ResetText(); RText_Total.ResetText(); DTP_history.Value = Convert.ToDateTime(DateTime.Now); DGV_Bill.ClearSelection(); }
private void Btn_Symptoms_Click(object sender, EventArgs e) { SqlDataAdapter ad = new SqlDataAdapter("select Bill.Id_Bill as'الرقم' , Students.Name as'اسم الطالب', Bill.Paid as 'المبلغ المدفوع' ,Bill.Rest as 'الباقي',Bill.Date as 'تاريخ الدفع' from Bill inner join Students on Students.Id_S = Bill.Id_S where Students.Name like '%" + RText_Search.Text + "%' or Bill.Date like '%" + RText_Search.Text + "%' ", DB.sqlconnection); DataTable dt = new DataTable(); ad.Fill(dt); DGV_Bill.DataSource = dt; DGV_Bill.ClearSelection(); }
private void DGV_Bill_DoubleClick(object sender, EventArgs e) { if (DGV_Bill.SelectedRows.Count == 0) { return; } Com_NameS.Text = DGV_Bill.CurrentRow.Cells[1].Value.ToString(); RText_Paid.Text = DGV_Bill.CurrentRow.Cells[2].Value.ToString(); RText_Rest.Text = DGV_Bill.CurrentRow.Cells[3].Value.ToString(); DTP_history.Value = Convert.ToDateTime(DGV_Bill.CurrentRow.Cells[4].Value.ToString()); DGV_Bill.ClearSelection(); }
private void Btn_Search_Click(object sender, EventArgs e) { DGV_Bill.DataSource = bill.ShowDGV_Search(RText_Search.Text); DGV_Bill.ClearSelection(); }
private void Frm_Bill_Load(object sender, EventArgs e) { DGV_Bill.ClearSelection(); }