Label Text Not showing after Updation

Question

0.00/5 (No votes)

See more:

I'm Opening Fancybox on Repeater' Row Edit linkButton n updating content i want to show label text as "Updated" after the execution of Update Query.But Don't Know whats wrong with this code Label text is not showing after Updation can anyone help me out ?
thanks in advance.

C#

protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e)
    {
        Thread.Sleep(3000);
        //foreach (RepeaterItem item2 in Repeater1.Items)
        //{
            TextBox name = (TextBox)e.Item.FindControl("TextBox1");
            TextBox address = (TextBox)e.Item.FindControl("TextBox2");
            //Label lbl = (Label)e.Item.FindControl("Label1");


            if (e.CommandName == "Edit")
            {
                int p_id = Convert.ToInt32(e.CommandArgument);
                SqlConnection sqlconn = new SqlConnection("server=.\\sqlexpress;database=practice;integrated security=true;");
                SqlCommand sqlcomm = new SqlCommand("Update persons set p_name='" +name.Text +"' , p_address='" + address.Text + "'  where p_id='" + p_id + "'", sqlconn);
                sqlconn.Open();
                sqlcomm.ExecuteNonQuery();
                
                sqlconn.Close();
                //lbl.Text = "Updated";
                Label1.Text = "updated";
                
                
                Bind();
                

                
                


            }
            
            
        //}
        
    }

ASPX part-

ASP.NET

<asp:ScriptManager ID="ScriptManager1" runat="server">
    </asp:ScriptManager>
        <asp:Repeater ID="Repeater1" runat="server" 
            onitemcommand="Repeater1_ItemCommand">
        
         <HeaderTemplate>
        <table cellpadding="5px" style="margin-removed600px;margin-removed200px">
       <th>ID</th><th>Name</th><th>Address</th><th>Edit</th>
        
        </HeaderTemplate>
        <ItemTemplate>
       <tr> <td><%#Eval("p_id") %></td><td><%#Eval("p_name") %></td><td><%#Eval("p_address") %></td><td>
           <asp:LinkButton ID="LinkButton1"  runat="server" class="modalbox" href="#inline"><img alt="" src="pencil.png" /></asp:LinkButton>
           
           
          <div id="inline">
              <asp:UpdatePanel ID="UpdatePanel1" runat="server" UpdateMode="Conditional" ChildrenAsTriggers="true">
             <ContentTemplate> 
          <table>
           <tr><td>Name</td><td>
               <asp:TextBox ID="TextBox1" runat="server" Text='<%#Eval("p_name") %>'></asp:TextBox></td></tr>
             <tr><td>Address</td><td>
               <asp:TextBox ID="TextBox2" runat="server" Text='<%#Eval("p_address") %>'></asp:TextBox></td></tr>
             <tr><td>
                 </td><td>
                 
                 <asp:Button ID="Button1" runat="server" Text="Update" CommandName="Edit" CommandArgument='<%#Eval("p_id") %>'/></td></tr>
                 <tr>
                 <br />
              <asp:UpdateProgress ID="UpdateProgress1" runat="server">
              <ProgressTemplate>
              <%--<img src="ajaxgif.gif" />--%>
              Updating...
              
              </ProgressTemplate>
              </asp:UpdateProgress>
                        <tr><asp:Label ID="Label1" runat="server"></asp:Label></tr>

              </tr>
              
          </table>
          </ContentTemplate>
          </asp:UpdatePanel>
          </div>
          
          
           
           </td></tr>
        
        </ItemTemplate>
        <FooterTemplate>
        
         </table>
        
        </FooterTemplate>
        
        
        
        </asp:Repeater>

Posted 4-Dec-12 22:52pm

Surendra0x2

Add a Solution

Comments

Deenuji 5-Dec-12 4:59am

u can see that label before update?????

Surendra0x2 5-Dec-12 5:03am

Yes i tested it is showing before updation means if i set Text="Something" then it is showing But when i'm clicking on Update Button then it is not showing

2 solutions

Solution 2

Hi,

You have placed Label1 Outside of the update panel and the event is raised from inside the update panel. So the label's text is changed but it is not refreshed on the client side.

So the solution is You have to put the label inside the update panel.

Also one more suggestion, instead of putting update panel inside ItemTemplate, put the Repeater control itself inside the update panel.
Having lots of update panels in a page is also not a good practice.

Hope this helps you.

-Gayatri

Posted 5-Dec-12 0:00am

Er. Gayatri

Comments

Surendra0x2 5-Dec-12 6:10am

Mam My Label is Inside Update Panel.
and i'm Opening the Content which i palced Inside Update panel in Fancybox so i dnt wanna refresh the page thats y i'm using update panel.

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

RahulRana723 · Accepted Answer · 2012-12-04T23:55:00

C#

protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e)
{
   Thread.Sleep(3000);        
   TextBox name = (TextBox)e.Item.FindControl("TextBox1");
   TextBox address = (TextBox)e.Item.FindControl("TextBox2");
   Label lbl = (Label)e.Item.FindControl("Label1"); 
   if (e.CommandName == "Edit")
   {
      int p_id = Convert.ToInt32(e.CommandArgument);
      SqlConnection sqlconn = new SqlConnection("server=.\\sqlexpress;database=practice;integrated security=true;");
                SqlCommand sqlcomm = new SqlCommand("Update persons set p_name='" +name.Text +"' , p_address='" + address.Text + "'  where p_id='" + p_id + "'", sqlconn);
      sqlconn.Open();
      sqlcomm.ExecuteNonQuery();
      sqlconn.Close();
      lbl.Text = "Updated";       
   }                             
}

//Don't Call Your Bind() Method In ItemCommand Event and Call it In Your Page_Load With IspostBack=false
//In Page_Load
If(!IsPostBack)
{
   Bind();//Use it!....
}