Get dragged / saved items state back from Sql Server

Posted by user571507 on Stack Overflow See other posts from Stack Overflow or by user571507
Published on 2011-01-11T16:18:17Z Indexed on 2011/01/11 17:53 UTC
Read the original article Hit count: 218

Filed under:
|
|
|

Ok i saw many post's on how to serialize the value of dragged items to get hash and they tell how to save them. Now the question is how do i persist the dragged items the next time when user log's in using the has value that i got eg:

  <ul class="list">
        <li id="id_1">
            <div class="item ui-corner-all ui-widget ui-widget-content">
            </div>
        </li>
        <li id="id_2">
            <div class="item ui-corner-all ui-widget ui-widget-content">
            </div>
        </li>
        <li id="id_3">
            <div class="item ui-corner-all ui-widget ui-widget-content">
            </div>
        </li>
        <li id="id_4">
            <div class="item ui-corner-all ui-widget">
            </div>
        </li>
    </ul>

which on serialize will give

"id[]=1&id[]=2&id[]=3&id[]=4"

Now think that i saved it to Sql server database in a single field called SortOrder. Now how do i get the items to these order again ? the code to make these sort is below,without which people didn't know which library i had used to sort and serialize

 <script type="text/javascript">
    $(document).ready(function() {
        $(".list li").css("cursor", "move");
        $(".list").sortable();
    });
</script>

© Stack Overflow or respective owner

Related posts about ASP.NET

Related posts about sql