Error When Data Binding A Repeater Control Who's Data Source Has Changed

The logic in a nutshell is I have a sqlDataSource that gets some data. Then a repeater control uses that data source to display a list on the page. Then the user can add to this list by typing in a textfield and clicking a button. Everything displays fine on the initial page load. The user types in some data to add to the list and clicks a button. To avoid a complete page post back I use a ajax event to capture the click and insert the user's data into the db. Then I call Select on the sqlDataSource to grab the data from the db again. Then I call DataBind on the repeater to refresh the list and display the data agian. This is where the error occurs. I beleive the error occurs because on the initial page load the sqlDataSource returns (lets say) 2 records and the repeater creates 2 controls from the item template to display the 2 records. Then the user adds some data and clicks the button. My code inserts the data into the db and then the Select call on the sqlDataSource retuns (now) 3 records but the DataBind call on the repeater binds the first two records and then chokes and pukes on the third because there is only 2 controls in the repeater. I need the repeater to rerender and create (in this example) 3 controls form its item template.

What I'm I missing here or is this even the reason I get the error.

Hello Tyler and Welcome to the CodeASP.NET Community.

I think you are doing something wrong in your code. Probably showing the necessary parts of your code will be crucial for us to give you good advices and possible solutions.

However, I have created one simple solution which does what you (as I think) you need.

ASPX code

    <form id="form1" runat="server">
    <div>
        <asp:ScriptManager ID="ScriptManager1" runat="server">
        </asp:ScriptManager>
        <br />
        <br />
        <asp:Button ID="Button1" runat="server" onclick="Button1_Click" Text="ADD" />
        <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
    </div>
    <asp:UpdatePanel ID="UpdatePanel1" runat="server">
        <ContentTemplate>
            <asp:Repeater ID="Repeater1" runat="server" DataSourceID="SqlDataSource1">
                <ItemTemplate>
                    <%# Eval("Item") %> <br /> <!-- replace your ItemTemplate aspx code as appropriate -->
                </ItemTemplate>
            </asp:Repeater>
            <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
                ConnectionString="<%$ ConnectionStrings:MySampleDBConnectionString %>" 
                SelectCommand="SELECT [Item] FROM [Item]"></asp:SqlDataSource>
        </ContentTemplate>
    </asp:UpdatePanel>
    </form>

If you see, I'm using ScriptManager and UpdatePanel. Have one Button ADD and TextBox to add it in the Repeater. In the Repeater, I have one <%# Eval('Item') %> which I get from the SqlDataSource's select command retrieved from database. You should replace your own commands, Repeater ItemTemplate ASPX code and the Connection String in the SqlDataSource.

Then, In code behind everything you need to do is the following.

On Button1_Click method

            SqlConnection con = new SqlConnection(WebConfigurationManager.ConnectionStrings["MySampleDBConnectionString"].ConnectionString);
            SqlCommand cmd = new SqlCommand("insert into Item values ('" + TextBox1.Text + "')", con);
            using (con)
            {
                con.Open();
                cmd.ExecuteNonQuery();
            }
            //replace above code with your code for INSERTING INTO DATABASE TABLE
           //then just call the Repeater1.DataBind();, nothing else.


            Repeater1.DataBind();

Well, I don't have the ExtJS right on this machine, but will test it later or tomorrow, surely.

Meanwhile, instead of using the SqlDataSource to execute the update command, try doing that using standard SqlCommand as I did that in my previous post.

Use the SqlDataSource just to select the data for the Repeater.

There is possibility that the ScriptManagers of both AJAX frameworks might make conflict, but let met first test that then will reply shortly with my suggestion.

Also, I see you are calling the CompleteAdd method on Complete event of your Ext Editor. You should take a look around there. I'm not sure if it is a suitable event for calling that method.

Again, I will reply once I try the code.

Regards,
Hajan