i need to fetch the record from database and in itemdatabound event loop through each item and find the control and apply the class that is in database.
If you run this code you will see that users can pick any icon of their choice on modal and it will appear on the datalist, the challenge am facing here is if i refresh the page the result displayed on datalist disappears, how can i fetch the record from database and in itemdatabound event loop through each item and find the control and apply the class that is in database.
- protected void Page_Load(object sender, EventArgs e)
- {
- if (!this.IsPostBack)
- {
- this.Populatebooks();
- string username5 = this.Page.User.Identity.Name;
- //Path.GetFileName(Request.Url.AbsolutePath);
- //}
- }
- }
- private void Populatebooks()
- {
- string Populatebooks = "GetUserPOSTSEXAMPLE";
- using (SqlConnection con = new SqlConnection(constring4))
- {
- con.Open();
- using (SqlCommand cmd = new SqlCommand(Populatebooks, con))
- {
- cmd.CommandType = CommandType.StoredProcedure;
- // cmd.Parameters.AddWithValue("@Name", Request.QueryString["Id"].ToString());
- cmd.Parameters.AddWithValue("@UserName", Session["userName"]);
- // cmd.Parameters.AddWithValue("@Id", Id);
- //lblpost.Text = TextBixcomment.Text.Replace(Environment.NewLine, "
- SqlDataAdapter sda = new SqlDataAdapter(cmd);
- DataTable dt = new DataTable();
- sda.Fill(dt);
- ViewState["DataTable"] = dt;
- Getpost.DataSource = dt;
- Getpost.DataBind();
- }
- }
- }
- [WebMethod]
- public static string INSERTUSERSTATUS(string userName, string icon, string postId)
- {
- string constr = ConfigurationManager.ConnectionStrings["DB"].ConnectionString;
- using (SqlConnection con = new SqlConnection(constr))
- {
- using (SqlCommand cmd = new SqlCommand("INSERT INTO [UserPICKS](UserName,statuscount,Iconbook,IconCup,IconPen,PostId6) VALUES(@UserName,@statuscount,@Iconbook,@IconCup,@IconPen,@PostId6)"))
- {
- cmd.Connection = con;
- cmd.CommandType = CommandType.Text;
- cmd.Parameters.AddWithValue("@UserName", userName);
- cmd.Parameters.AddWithValue("@statuscount", "1");
- if (icon.ToLower() == "fa fa-book")
- {
- cmd.Parameters.AddWithValue("@Iconbook", "book");
- cmd.Parameters.AddWithValue("@IconCup", "");
- cmd.Parameters.AddWithValue("@IconPen", "");
- }
- if (icon.ToLower() == "fa fa-coffee")
- {
- cmd.Parameters.AddWithValue("@Iconbook", "");
- cmd.Parameters.AddWithValue("@IconCup", "cup");
- cmd.Parameters.AddWithValue("@IconPen", "");
- }
- if (icon.ToLower() == "fa fa-pencil")
- {
- cmd.Parameters.AddWithValue("@Iconbook", "");
- cmd.Parameters.AddWithValue("@IconCup", "");
- cmd.Parameters.AddWithValue("@IconPen", "pen");
- }
- cmd.Parameters.AddWithValue("@PostId6", postId);
- con.Open();
- cmd.ExecuteNonQuery();
- con.Close();
- }
- }
- return "posted";
- }
-
-
Hiten PandyaPosted Mar 9, 2018, 10:28 PM