public void PopulateLabels() { // Grab QueryString Parameter string qString; qString = Request.QueryString["ID"]; if (string.IsNullOrEmpty(qString)) { // Get from Route qString = Page.RouteData.Values["ID"] as string; } // Update Select Parameter Sql_PageItems.SelectParameters["groupId"].DefaultValue = qString; Sql_Comments.SelectParameters["groupId"].DefaultValue = qString; // Update Literal for Reference this.lit_groupId.Text = qString; SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["LocalSqlServer"].ConnectionString); SqlCommand cmd = new SqlCommand("SELECT tbl_collection.collectionId, collectionName, tbl_group.collectionId, groupName, groupDescription, tbl_user.userId, tbl_group.userId, userName FROM tbl_collection, tbl_group, tbl_user WHERE tbl_user.userId = tbl_group.userId AND tbl_collection.collectionId = tbl_group.collectionId AND groupId = '" + qString + "'", sqlConn); cmd.Connection.Open(); SqlDataReader SqlDrItemList; SqlDrItemList = cmd.ExecuteReader(); while (SqlDrItemList.Read()) { string GroupTitle = SqlDrItemList["groupName"].ToString(); string GroupDescription = SqlDrItemList["groupDescription"].ToString(); string AuthorName = SqlDrItemList["userName"].ToString(); string CollectionId = SqlDrItemList["collectionId"].ToString(); string CollectionName = SqlDrItemList["collectionName"].ToString(); this.lit_collectionId.Text = CollectionId; this.lit_collectionName.Text = CollectionName; this.lit_GroupTitle.Text = Helper.Trim(GroupTitle, 30); //this.txt_renamePage.Text = PageTitle; this.lit_GroupDescription.Text = Helper.Trim(GroupDescription, 420); //this.txt_renameDescription.Text = PageDescription; this.hyp_AuthorName.Text = AuthorName; this.hyp_AuthorName.NavigateUrl = "/" + AuthorName; this.imb_author.PostBackUrl = "/" + AuthorName; this.txt_rename.Text = GroupTitle; this.txt_renameDescription.Text = GroupDescription; // Set Image Control URL imb_author.ImageUrl = "~/Images/Users/" + AuthorName + ".jpg"; } cmd.Connection.Close(); cmd.Connection.Dispose(); }
public void PopulateLabels() { // Grab Querystring string qString; qString = Request.QueryString["ID"]; if (string.IsNullOrEmpty(qString)) { // Get From Route qString = Page.RouteData.Values["ID"] as string; } // Update Select Parameter Sql_Items.SelectParameters["itemId"].DefaultValue = qString; Sql_Comments.SelectParameters["itemId"].DefaultValue = qString; SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["LocalSqlServer"].ConnectionString); SqlCommand cmd = new SqlCommand("SELECT itemId, itemName, itemDescription, itemUrl, groupId, tbl_user.userId, tbl_item.userId, userName FROM tbl_item, tbl_user WHERE tbl_user.userId = tbl_item.userId AND itemId = '" + qString + "'", sqlConn); cmd.Connection.Open(); SqlDataReader SqlDrItemList; SqlDrItemList = cmd.ExecuteReader(); while (SqlDrItemList.Read()) { string ItemTitle = SqlDrItemList["itemName"].ToString(); string ItemDescription = SqlDrItemList["itemDescription"].ToString(); string AuthorName = SqlDrItemList["userName"].ToString(); string ItemUrl = SqlDrItemList["itemUrl"].ToString(); this.lit_itemUrl.Text = ItemUrl; this.lit_itemId.Text = SqlDrItemList["itemId"].ToString(); this.lit_groupId.Text = SqlDrItemList["groupId"].ToString(); this.hyp_AuthorName.Text = AuthorName; this.hyp_AuthorName.NavigateUrl = "/" + AuthorName; this.imb_author.PostBackUrl = "/" + AuthorName; this.txt_rename.Text = ItemTitle; this.txt_renameDescription.Text = ItemDescription; // Set Image Control URL imb_author.ImageUrl = "~/Images/Users/" + AuthorName + ".jpg"; // Set Edit Controls //this.txt_itemTitle.Text = ItemTitle; //this.txt_itemDescription.Text = ItemDescription; } }