Solved

Reorderlist not working on MySQL using sqldatasource

Posted on 2009-07-07
1
592 Views
Last Modified: 2012-05-07
Hi,
I want to the reorderlist with a MySQL database using sqldatasource as the connectors. I'd tried it on editting in Gridview, connecting to the same sqldatasource, and it's working (database can be editted).

However using the same sqldatasource, it is not working on the reorderlist (on the webpage, you can reorder the item, but not getting updated in database).

Anything missing from my code attached? Any help is much appreciated.

<body>

    <form id="form1" runat="server">

    <asp:ScriptManager ID="ScriptManager1" runat="server"/>

        

    <%--reorderlist, after reordering, the database is not being updated--%>

    <cc1:ReorderList ID="ReorderList1" runat="server"

                DataKeyField="id"

                AllowReorder="true" 

                PostBackOnReorder="true"

                DataSourceID="Sqldatasource1" 

                SortOrderField="order_no">

             

       <ItemTemplate>

            <asp:Label ID="Label1" runat="server" Text='<% #Eval("name") %>'></asp:Label>

            <asp:Label ID="Label2" runat="server" Text='<% #Eval("order_no") %>'></asp:Label>

       </ItemTemplate>    

                        

        <DragHandleTemplate>

            <div style="height: 20px; width: 20px; border: solid 1px black; background-color: Red; cursor: pointer;">

            </div>

        </DragHandleTemplate>

        <ReorderTemplate>

            <div style="width: 300px; height: 20px; border: dotted 2px black;">

            </div>

        </ReorderTemplate>                        

    </cc1:ReorderList>

                

    <%--sqldatasource--%>

    <asp:sqldatasource ID="Sqldatasource1" runat="server"

            ConnectionString="Database=muncchdb;Data Source=localhost;User Id=muncchco;Password=muncchco1;charset=utf8"

            ProviderName="MySql.Data.MySqlClient" 

            SelectCommand="SELECT id, name, order_no FROM reorder ORDER BY order_no"

            UpdateCommand="update reorder set order_no=?order_no where id=?id">

       <UpdateParameters>

                <asp:Parameter Name="id" Type="Int32" />

                <asp:Parameter Name="order_no" Type="Int32" />

       </UpdateParameters>        

    </asp:sqldatasource>

        

    <%--The gridview is working, can be editted, to prove that the sqldatasource is called/connected right--%>

    <asp:GridView ID="GridView1" runat="server" DataKeyNames="id" DataSourceID="Sqldatasource1" AutoGenerateEditButton="true">

    </asp:GridView>

        

    </form>

</body>

Open in new window

reorderlist.jpg
0
Comment
Question by:tangteng78
1 Comment
 
LVL 96

Accepted Solution

by:
Bob Learned earned 500 total points
ID: 24805591
I don't see where there would be anything that forces the SqlDataSource to call the UpdateCommand.

You can test with the SqlDataSource.Updating event handler:

http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.sqldatasource.updating.aspx

and, you can manually force an update with the SqlDataSource.Update method.
Sub On_Click(ByVal source As Object, ByVal e As EventArgs)

        SqlDataSource1.Update()

 End Sub 'On_Click

Open in new window

0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …
Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now