protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { List <RequestEntity> requests = null; string conString = ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString; SqlConnection con = new SqlConnection(conString); SqlCommand com = new SqlCommand("SELECT i2.ItemId MyItemId, i2.ItemName MyItemName, i2.ItemDesc MyItemDesc, i2.ContentType MyContentType, i2.Image MyImage, i2.Category MyCategory, i2.UserId MyUserId, " + "i.ItemId, i.ItemName, i.ItemDesc, i.ContentType, i.Image, i.Category, i.UserId, r.RequestId, 0 As IsMyRequest, 'MyRequest' AS CssClass " + "FROM ExchangeDB..Request r " + "JOIN ExchangeDB..Item i ON r.RequesterItemId = i.ItemId " + "JOIN ExchangeDB..Item i2 ON r.ItemId = i2.ItemId " + "WHERE i2.UserId = @UserId AND r.RequestComplete = 0 " + "UNION ALL " + "SELECT i.ItemId MyItemId, i.ItemName MyItemName, i.ItemDesc MyItemDesc, i.ContentType MyContentType, i.Image MyImage, i.Category MyCategory, i.UserId MyUserId, " + "i2.ItemId, i2.ItemName, i2.ItemDesc, i2.ContentType, i2.Image, i2.Category, i2.UserId, r.RequestId, 1 As IsMyRequest, 'Requested' AS CssClass " + "FROM ExchangeDB..Request r " + "JOIN ExchangeDB..Item i ON r.RequesterItemId = i.ItemId " + "JOIN ExchangeDB..Item i2 ON r.ItemId = i2.ItemId " + "WHERE i.UserId = @UserId AND r.RequestComplete = 0", con); com.Parameters.Add("@UserId", SqlDbType.Int).Value = Session["UserId"] == null ? 0 : Convert.ToInt32(Session["UserId"]); con.Open(); var lDataAdapter = new SqlDataAdapter(com); var lDataSet = new DataSet(); lDataAdapter.Fill(lDataSet); if (lDataSet.Tables[0].Rows.Count != 0) { requests = lDataSet.Tables[0].AsEnumerable().Select(row => new RequestEntity(row)).ToList(); } con.Close(); RequestList.DataSource = requests; RequestList.DataBind(); } }