protected void btnClearMaintenance_Click(object sender, EventArgs e) { DataTable ds = new DataTable(); ds = null; GridViewMaintenanceSearches.DataSource = ds; GridViewMaintenanceSearches.DataBind(); //lblMessage.Text = string.Empty; }
private void MaintenanceSearch() { SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["Expenses"].ConnectionString); cn.Open(); SqlCommand cmdGetExpenses = new SqlCommand("spMaintenanceSearch", 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); if (tbMaintenanceType.Text == "0") { MaintenanceTypeId = 0; } else { MaintenanceTypeId = Convert.ToInt16(ddlMaintenance.SelectedItem.Value); } cmdGetExpenses.Parameters.AddWithValue("MaintenanceTypeId", MaintenanceTypeId); cmdGetExpenses.Parameters.AddWithValue("StartDate", String.IsNullOrEmpty(tbStartDateMaintenance.Text) ? (object)DBNull.Value : start); cmdGetExpenses.Parameters.AddWithValue("EndDate", String.IsNullOrEmpty(tbEndDateMaintenance.Text) ? (object)DBNull.Value : end); GridViewMaintenanceSearches.Visible = true; SqlDataReader rdrS = cmdGetExpenses.ExecuteReader(); GridViewMaintenanceSearches.DataSource = rdrS; GridViewMaintenanceSearches.DataBind(); cn.Close(); }