Order By
-
I'm using this, "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & m_path & "; Extended Properties=dBASE IV" for accessing dbf files in Account Mate DOS Is there an Order By, to sort the records by date? Or do I have to do a sort on the structure that I stored the values in
-
I'm using this, "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & m_path & "; Extended Properties=dBASE IV" for accessing dbf files in Account Mate DOS Is there an Order By, to sort the records by date? Or do I have to do a sort on the structure that I stored the values in
I can't directly answer your question, but I came across the "DataView" a while ago while developing a utility and found it to be pretty powerful. Check it out ... https://msdn.microsoft.com/en-us/library/system.data.dataview(v=vs.110).aspx[^]
-
I can't directly answer your question, but I came across the "DataView" a while ago while developing a utility and found it to be pretty powerful. Check it out ... https://msdn.microsoft.com/en-us/library/system.data.dataview(v=vs.110).aspx[^]
Interesting. I used a DataTable in my RDLC report generator class. Forget that I can sort in the report RDLC Tablix. So I passed a structure to my database class, to load a DataTable in the report class, to pass to the RDLC. Guess I should take the DataTable straight to the database function to populate it. I wrote this early last summer, sort of forgot how it worked. But good call David on the DataTable.