更新在转发器中不起作用 [英] updation is not working in repeater

问题描述

嗨
我正在处理转发器中的更新，但它无法正常工作，我的编码就是这样......

Hi I am working on update in repeater,but Its not working,My coding is this......

<asp:Repeater ID="Repeater1" runat="server" OnItemCommand="Repeater1_ItemCommand">
        <HeaderTemplate>
        <table>
        <tr>
        <th>FEEDBACK</th>
        </tr>
      </HeaderTemplate>
      <ItemTemplate>
      <tr>
      <td>
          <asp:TextBox ID="TextBox1" runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "feedback")%>'></asp:TextBox></td>
        <td> <asp:LinkButton ID="btnaprove" Runat="server"  CommandName="Approve" CommandArgument='<%#DataBinder.Eval(Container.DataItem,"feedback") %>'>Approve</asp:LinkButton></td>
          <td> <asp:LinkButton ID="btnupdate" Runat="server"  CommandName="Update" CommandArgument='<%#DataBinder.Eval(Container.DataItem,"feedback") %>'>Update</asp:LinkButton></td>

          <td> <asp:LinkButton ID="btndelete" Runat="server"  CommandName="Delete" CommandArgument='<%#DataBinder.Eval(Container.DataItem,"feedback") %>'>Delete</asp:LinkButton></td>
      </td>
      </tr>
      </ItemTemplate>
        <FooterTemplate>
           </table>
        </FooterTemplate>
        </asp:Repeater>

Default.cs页面......

Default.cs page...

protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e)
    {
        
         if (e.CommandName == "Update")
        {
            string str1 = ((TextBox)e.Item.FindControl("TextBox1")).Text;
            cmd = new SqlCommand("update Table1 set feedback=@feedback where status='true'", con);
            cmd.Parameters.AddWithValue("@feedback", str1);
            con.Open();
            cmd.ExecuteNonQuery();
            con.Close();
            bind();
        }
       
    }

    private void bind()
    {
        da = new SqlDataAdapter("select feedback from Table1", con);
        DataSet ds = new DataSet();
        da.Fill(ds);
        Repeater1.DataSource = ds;
        Repeater1.DataBind();
    }

}

推荐答案

在Page_Load上调用绑定方法（）

Call Bind Method on Page_Load()

protected void Page_Load(object sender, EventArgs e)
    {

if(!page.ispostback)
{
Bind();

}
}

Public Void Bind()
{

da = new SqlDataAdapter("select feedback from Table1", con);
        DataSet ds = new DataSet();
        da.Fill(ds);
        Repeater1.DataSource = ds;
        Repeater1.DataBind();


}

和在Item_command之后你做了 -

and after Item_command as u did-

protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e)
    {
        
         if (e.CommandName == "Update")
        {
            string str1 = ((TextBox)e.Item.FindControl("TextBox1")).Text;
            cmd = new SqlCommand("update Table1 set feedback=@feedback where status='true'", con);
            cmd.Parameters.AddWithValue("@feedback", str1);
            con.Open();
            cmd.ExecuteNonQuery();
            con.Close();
            Bind();
        }
       
    }

这篇关于更新在转发器中不起作用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！