protected void getTable() { if (Session["SearchVal"] != null) { NotFound.Text = "<h2>You Searched for " + Session["SearchVal"].ToString() + "</h2>"; try { DataTable dt = new DataTable(); dt.Columns.Add("ID"); dt.Columns.Add("AppName"); dt.Columns.Add("AppFileName"); dt.Columns.Add("Extension"); dt.Columns.Add("AppSize"); dt.Columns.Add("Description"); con.Open(); cmd = new SqlCommand("select * from AppDetailsWCat where AppName like '%" + Session["SearchVal"].ToString() + "%';", con); rd = cmd.ExecuteReader(); if (!rd.HasRows) { NotFound.Text = "<h2>" + Session["SearchVal"].ToString() + " Not Found</h2>"; } else { dt.Load(rd); rd.Close(); con.Close(); SearchView.DataSource = dt; SearchView.DataBind(); } } catch (Exception ex) { ErrorLabel.Text = ex.Message; } } else if (Session["Category"] != null) { NotFound.Text = "<h2>" + Session["Category"].ToString() + " Applications</h2>"; try { DataTable dt = new DataTable(); dt.Columns.Add("ID"); dt.Columns.Add("AppName"); dt.Columns.Add("AppFileName"); dt.Columns.Add("Extension"); dt.Columns.Add("AppSize"); dt.Columns.Add("Description"); dt.Columns.Add("Category"); con.Open(); cmd = new SqlCommand("select * from AppDetails where Category like '%" + Session["Category"].ToString() + "%';", con); rd = cmd.ExecuteReader(); if (!rd.HasRows) { NotFound.Text = "<H2>Sorry, There is no applications under " + Session["Category"].ToString() + " Category</H2>"; } else { dt.Load(rd); rd.Close(); con.Close(); SearchView.DataSource = dt; SearchView.DataBind(); } } catch (Exception ex) { ErrorLabel.Text = ex.Message; } } else { Response.Redirect("~/Home.aspx"); } }