public void getApplications(object sender, EventArgs e) { if (Session["Username"] == null) { return; } string connStr = ConfigurationManager.ConnectionStrings["iwork"].ToString(); SqlConnection conn = new SqlConnection(connStr); SqlCommand cmd = new SqlCommand("getApplications", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@username", Session["Username"].ToString())); SqlDataAdapter sda = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); sda.Fill(dt); Applications.DataSource = dt; Applications.DataBind(); }