protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { //Get Recent Blog DbParameter[] parameters = new DbParameter[1]; parameters = null; DataTable dt = AmplodisConnect.ExecuteStoredProcedure("sp_fetchBlogParentChildRelation", parameters); DataTable dtn = dt.Clone(); for (int i = 0; i < 3; i++) { dtn.ImportRow(dt.Rows[i]); } lstRecentPost.DataSource = dtn; lstRecentPost.DataBind(); //Get Recent Tag DbParameter[] paramTag = new DbParameter[1]; paramTag = null; DataTable dtTag = AmplodisConnect.ExecuteStoredProcedure("sp_fetchTag", paramTag); lstTag.DataSource = dtTag; lstTag.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { DbParameter[] parameters = new DbParameter[1]; if (Request.QueryString["ID"] != null) { parameters[0] = new SqlParameter("@Id", Request.QueryString["ID"].ToString()); parameters[0].Direction = ParameterDirection.Input; parameters[0].DbType = DbType.String; } else { parameters = null; } DataTable dt = AmplodisConnect.ExecuteStoredProcedure("sp_fetchBlogParentChildRelation", parameters); if (dt.Columns.Contains("Answer")) { lblDate.Text = dt.Rows[0]["AnswerDate"].ToString(); lblBlogName.Text = dt.Rows[0]["BlogName"].ToString(); lblDesc.Text = dt.Rows[0]["Answer"].ToString(); lblTagName.Text = dt.Rows[0]["TagName"].ToString(); imgUser.Src = dt.Rows[0]["ImageUrl"].ToString(); } } }
protected void Page_Load(object sender, EventArgs e) { lblMsg.Text = ""; if (!IsPostBack) { DbParameter[] parameters = new DbParameter[1]; parameters = null; DataTable dt = AmplodisConnect.ExecuteStoredProcedure("sp_fetchBlogParentChildRelation", parameters); ddlBlog.DataSource = dt; ddlBlog.DataValueField = "Id"; ddlBlog.DataTextField = "BlogName"; ddlBlog.DataBind(); } }
protected void btnSaveAns_Click(object sender, EventArgs e) { DbParameter[] parameters = new DbParameter[2]; parameters[0] = new SqlParameter("@Answer", txtAnswer.Text); parameters[0].Direction = ParameterDirection.Input; parameters[0].DbType = DbType.String; parameters[1] = new SqlParameter("@BlogId", ddlBlog.SelectedValue); parameters[1].Direction = ParameterDirection.Input; parameters[1].DbType = DbType.String; AmplodisConnect.ExecuteNonQueryStoredProcedure("sp_insertAnswer", parameters); lblMsg.Text = "Answer Saved Successfully"; txtAnswer.Text = ""; }
protected void btnSave_Click(object sender, EventArgs e) { DbParameter[] parameters = new DbParameter[3]; parameters[0] = new SqlParameter("@BlogName", txtBlog.Text); parameters[0].Direction = ParameterDirection.Input; parameters[0].DbType = DbType.String; parameters[1] = new SqlParameter("@Description", txtDesc.Text); parameters[1].Direction = ParameterDirection.Input; parameters[1].DbType = DbType.String; parameters[2] = new SqlParameter("@ParentId", null); parameters[2].Direction = ParameterDirection.Input; parameters[2].DbType = DbType.String; AmplodisConnect.ExecuteNonQueryStoredProcedure("sp_insertBlogParentChildRelation", parameters); lblMsg.Text = "Blog Saved Successfully"; txtBlog.Text = ""; txtDesc.Text = ""; }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { DataTable dtTag = AmplodisConnect.ExecuteStoredProcedure("sp_fetchTag", null); String category = null; foreach (DataRow DRow in dtTag.Rows) { category += "<a class='category-btn " + DRow["ClassName"] + "-btn' href='amplodis-forum.aspx?tid=" + DRow["TagId"] + "'>" + DRow["TagName"] + "</a>"; } dvContainerTag.InnerHtml = category; this.strClass = "all-blog"; DbParameter[] parameters = new DbParameter[1]; if (Request.QueryString["ID"] != null) { parameters[0] = new SqlParameter("@Id", Request.QueryString["ID"].ToString()); parameters[0].Direction = ParameterDirection.Input; parameters[0].DbType = DbType.String; } else { parameters[0] = new SqlParameter("@TagId", Request.QueryString["tid"] == null || Request.QueryString["tid"] == "" ? null : Request.QueryString["tid"].ToString()); parameters[0].Direction = ParameterDirection.Input; parameters[0].DbType = DbType.String; } DataTable dt = AmplodisConnect.ExecuteStoredProcedure("sp_fetchBlogParentChildRelation", parameters); { grdBlog.Visible = true; grdBlog.DataSource = dt; if (dt.Rows.Count > 0) { this.strClass = dt.Rows[0]["ClassName"].ToString(); grdBlog.DataBind(); } } } }