protected void btnClearInsurance_Click(object sender, EventArgs e) { DataTable ds = new DataTable(); ds = null; GridViewInsuranceSearches.DataSource = ds; GridViewInsuranceSearches.DataBind(); lblMessage.Text = string.Empty; }
private void InsuranceSearch() { SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["Expenses"].ConnectionString); cn.Open(); SqlCommand cmdGetExpenses = new SqlCommand("spInsuranceSearch", cn); cmdGetExpenses.CommandType = CommandType.StoredProcedure; DateTime startDate = Convert.ToDateTime(String.IsNullOrEmpty(tbStartDate.Text) ? null : tbStartDate.Text); string start = String.Format("{0:MM/dd/yyyy}", startDate); DateTime endDate = Convert.ToDateTime(String.IsNullOrEmpty(tbEndDate.Text) ? null : tbEndDate.Text);; string end = String.Format("{0:MM/dd/yyyy}", endDate); string insurance = tbInsuranceTypeDescription.Text; switch (insurance) { case "Medical": InsuranceTypeId = 1; break; case "Life": InsuranceTypeId = 2; break; case "Car": InsuranceTypeId = 3; break; case "House": InsuranceTypeId = 4; break; case "Content": InsuranceTypeId = 5; break; } cmdGetExpenses.Parameters.AddWithValue("InsuranceTypeId", InsuranceTypeId); cmdGetExpenses.Parameters.AddWithValue("StartDate", String.IsNullOrEmpty(tbStartDate.Text) ? (object)DBNull.Value : start); cmdGetExpenses.Parameters.AddWithValue("EndDate", String.IsNullOrEmpty(tbEndDate.Text) ? (object)DBNull.Value : end); GridViewInsuranceSearches.Visible = true; SqlDataReader rdrS = cmdGetExpenses.ExecuteReader(); GridViewInsuranceSearches.DataSource = rdrS; GridViewInsuranceSearches.DataBind(); cn.Close(); }