I need help to sort a table ( data from sql table ) displayed on website using jQuery on the client side. I need to know how to use the jQuery, after displaying the table using asp/vbnet , code behind.
I also want to know how to position the table below the few controls , eg labels, text boxes, dropdown boxes.
I am using jquery.dataTables.min.js, and demo_table.css.
I created a string
Dim sTable As String = ""
sTable = "<div><table id=""tbldata"" class=""display""><thead><tr>"
Dim DT As DataTable
DT = myDatatable
If Not DT.Rows.Count = 0 Then
Dim iNumberofColums As Int16 = DT.Columns.Count - 1
Dim hc As String
Dim c As Int16 = 0
For Each CL As DataColumn In DT.Columns
hc = CL.ColumnName
sTable = sTable & "<th>" & hc & "</th>"
Next
sTable = sTable & "</tr></thead><tbody>"
Dim tc As String
For Each RW As DataRow In DT.Rows
sTable = sTable & "<tr>"
c = 0
For c = 0 To iNumberofColums
tc = RW(c).ToString
sTable = sTable & "<td>" & tc & "</td>"
Next
sTable = sTable & "</tr>"
Next
sTable = sTable & "</tbody></table></div>"
End If
Response.Write(sTable)
and response.write(sTable) to display the table.
in the aspx
<script type="text/javascript">
$(document).ready(function () {
$('#tbldata').dataTable({
"aaSorting": [[2, 'desc']],
"aoColumns": [null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null
]
});
});
</script>
Is this a proper method ?. How can I improve. Thanks for your advice