How to set Session Date as default sort

I have below code . I want to set Session Date as default sort
Thanks
7 Replies
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Sign inCreate an account
Anandu G Nath2y agoPosted Dec 27, 2023, 8:45 AM
 

 

 








Add the necessary scripts for DataTables in your HTML or ASPX file
RRRamco Ramco3y agoPosted Apr 3, 2023, 6:20 AM
Hi Tuhin

  I have written like below but still not working

Thanks
RRRamco Ramco3y agoPosted Apr 3, 2023, 1:09 AM
Hi Sachin

  When i use that i get error - DataTables warning: table id=tbldata - Cannot reinitialise DataTable. For more information about this error, please see http://datatables.net/tn/3

Thanks
RRRamco Ramco3y agoPosted Apr 3, 2023, 1:06 AM
Hi Tuhin

    Below is the code . Where is should change



    

        Segment
        Session Date
        Session Start Time
        Session End Time
        Mentor
        Student
        Session Status
        Action
    


    




    
        Book
        Session Date
        Session Start Time
        Session End Time
        Action
    


Below is the code behind
 htmlTable.Append("
");
                        htmlTable.Append("");
                        htmlTable.Append("");
Tuhin Paul3y agoPosted Apr 2, 2023, 9:36 PM
you can add the data-order attribute to the "Session Date" th element

This will make the "Session Date" column the default sort column and will sort the table based on the values in that column when the table is initialized.
Tuhin Paul3y agoPosted Apr 2, 2023, 9:35 PM
Use the data-order attribute of the th element to specify the default sort order for a column. You can set it to the index of the column that you want to sort by, starting from 0.
Sachin Singh3y agoPosted Apr 2, 2023, 6:11 PM
in your sql code you can order by sessionDate or if it is a Jquery DataTable then

$(document).ready(function () {
    $('#tbldata').DataTable({
        order: [[2, 'desc']],
    });
});


    
        Segment
        Session Date
        Session Start Time
    




" + Utility.GetOrdinalNo(Convert.ToInt32(colum.Segment)) + " " + Convert.ToDateTime(colum.SessionDate).ToString("dd-MM-yyyy") + " " + Convert.ToDateTime(colum.SessionStartTime).ToString("HH:mm") + " Session Date