private void ShowName() { SqlConnection conn = new SqlConnection(dbconn.Configuration()); SqlCommand cmd = null; SqlDataReader rdr = null; string sqlsel = "select name from company"; try { conn.Open(); cmd = new SqlCommand(sqlsel, conn); rdr = cmd.ExecuteReader(); RepeaterName.DataSource = rdr; RepeaterName.DataBind(); } catch (Exception ex) { //LabelMessage.Text = ex.Message; } finally { conn.Close(); } }
/// <summary> /// Show or hide recipe comment /// </summary> public override void fillup() { //Find control Panel Panel1 = (Panel)(placeholder.FindControl("Panel1")); Image CommentImg = (Image)(placeholder.FindControl("CommentImg")); HyperLink CommentLink = (HyperLink)(placeholder.FindControl("CommentLink")); //Instantiate Action Stored Procedure object Blogic FetchData = new Blogic(); try { IDataReader dr = FetchData.GetConfiguration; dr.Read(); //Show hide comment if (dr["HideShowComment"] != DBNull.Value) { this._ShowHideComment = (int)dr["HideShowComment"]; } dr.Close(); dr = null; if (IsShowHideComment) { //If true, display recipe comments, else hide. //Get datasourse RepeaterName.DataSource = RecipeCommentProvider.GetComments(ID); RepeaterName.DataBind(); Panel1.Visible = true; } else { Panel1.Visible = false; CommentImg.Visible = false; CommentLink.Visible = false; } } catch (Exception ex) { throw ex; } FetchData = null; }