Repeater with UpdatePanel

See more:

C#

ASP.NET

Hello everyone!

I have an UpdatePanel which has a Repeater Control in which another Repeater Control is nested. Within this nested Repeater Control,I have a TextBox for adding comments and a Button to Submit it.

On button click, the UpdatePanel is triggered and in the Repeater2_ItemCommand event, I have saved the TextBox value in database and then called Repeater2.DataBind().

According to me, the Repeater must fetch the new values from the DataBase and display them. But it doesn't happen in that manner. On Button Click, the data is being saved but the page is left blank. I can view the data only when I visit the page link again(as Refresh also doesn't work) after adding the comment.

Please tell me what to do!

Code for repeater:

protected void Repeater2_ItemCommand(object sender, RepeaterCommandEventArgs e)
    {
        lblMsg.Visible = false;
        TextBox tb = new TextBox();
        id = e.CommandArgument.ToString();
        column1 = ((TextBox)e.Item.FindControl("txtCol1")).Text.Trim();
        column2 = ((TextBox)e.Item.FindControl("txtCol2")).Text.Trim());
        cmd = new SqlCommand("update tab set col1=@col1,col2=@col2 where id=@id", con);
        cmd.Parameters.AddWithValue("@id", id);
        cmd.Parameters.AddWithValue("@col1", column1);
        cmd.Parameters.AddWithValue("@col2", column2);
        int rwcnt = cmd.ExecuteNonQuery();
        Reapeter2.DataBind();
        if (rwcnt <= 0)
            lblMsg.Visible = true;
    }