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");
}
}
