private void BtnSearchPayDate_Click(object sender, EventArgs e) { // Formatting the form: LblTotalTrans.Visible = false; LblTotalTravel.Visible = false; TxtTotalTrans.Visible = false; TxtTotalTravel.Visible = false; LblPound1.Visible = false; LblPound2.Visible = false; try { using (DBAuditDataContext dc = new DBAuditDataContext()) { // Calculating: int?IntCount = null; var d = dc.ProCountPayDate(DatePay.Value.Date, ref IntCount); TxtCountRec.Text = IntCount.ToString(); // Search Progress: var c = dc.ProGetTransFeeByPayDate(DatePay.Value.Date); GrdViewTransFees.DataSource = c; } } catch (Exception EX) { MessageBox.Show(EX.Message); } }