ASP.NET

<br />
 //Comm Paramemters<br />
            Comm.Parameters.Clear();<br />
            Comm.Parameters.AddWithValue("@Site_Number", selectedSite);<br />
<br />
            //Create a Dataset<br />
            SqlDataAdapter da = new SqlDataAdapter(Comm);<br />
            da.Fill(ds);<br />
<br />
            //Count Returned Values<br />
            int thisTotal = ds.Tables[0].Rows.Count;<br />
            count = count + thisTotal;<br />
<br />
            //Check for returned results<br />
            if (count < 1)   //No AE's<br />
            {<br />
                title = "0 Results Returned";<br />
                message = "There are no AE's at this site!";<br />
                Session["message"] = message;<br />
                Session["title"] = title;<br />
                Response.Redirect("MessageBox.aspx");<br />
                Session.Remove(message);<br />
                Session.Remove(title);<br />
                return;<br />
            }<br />
<br />
            //Data Grid<br />
            GridViewAeSummary.DataSource = ds.Tables[0].DefaultView;<br />
            GridViewAeSummary.DataBind();<br />
<br />
        }<br />
        catch (Exception ex)  //Catch Errors<br />
        {<br />
            Console.WriteLine("Error : " + ex.Message);<br />
        }<br />

const string _themeListIDKey = "_themeListIDKey";
    protected void Page_PreInit(object sender, EventArgs e)
    {
        if (IsPostBack)
        {
            string uniqueID = Request[_themeListIDKey];

            if (uniqueID != null && Request[uniqueID] != null)
            {
                Theme = Request[uniqueID];
                Session["SelectedTheme"] = Theme;
            }
        }
    }

protected void Page_Load(object sender, EventArgs e)
    {
        ClientScript.RegisterHiddenField(_themeListIDKey, ((DropDownList)(this.Master.FindControl("DropDownList1"))).UniqueID);
    }