Later in my code, I try to sort based on "View_Order", but it acts like a string. The values sort as 1,2,20,21,22,3,4, NOT 1,2,3,4,20,21,22 like it should.
Using Cint() while moving the values from table to table didn't work for me... and the boolean becomes text as well. Is the problem in this code, or would it be elsewhere?
Expand|Select|Wrap|Line Numbers
- Private Function ConvertTable(ByVal ds As DataSet, ByVal TableName As String, Byval WHEREexpression As String, Byval SORTexpression As String) As DataTable
- 'For Schedule Tasks, convert all "dates+times" to "dates only" as strings
- Dim dv As DataView = GetViewTable(ds.Tables(TableName), WHEREexppression, SORTexpression)
- Dim dt As New DataTable
- dt.Columns.Add(New DataColumn("Task", GetType(String)))
- dt.Columns.Add(New DataColumn("View_Order", System.Type.GetType("System.Int64")))
- dt.Columns.Add(New DataColumn("Completed", GetType(Boolean)))
- For i = 0 To dv.Table.Rows.Count - 1
- dt.Rows.Add()
- dt.Rows(i).Item("Task") = dv.Table.Rows(i).Item("Task").ToString
- dt.Rows(i).Item("View_Order") = CInt(dv.Table.Rows(i).Item("View_Order").ToString)
- Try
- dt.Rows(i).Item("Completed") = dv.Table.Rows(i).Item("Completed")
- Catch ex As Exception
- End Try
- Next i
- Return dt
- End Function