private void BtnSearchLocation_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.ProCountLocation(int.Parse(ComboLocation.SelectedValue.ToString()), ref IntCount); TxtCountRec.Text = IntCount.ToString(); // Search Progress: var c = dc.ProGetTransFeeByLocationID(int.Parse(ComboLocation.SelectedValue.ToString())); GrdViewTransFees.DataSource = c; } } catch (Exception EX) { MessageBox.Show(EX.Message); } }