I am sure this has been answered a jillion times but i have looked and am not finding answers to my case -
i have a dataset i load up to pull data from while a user navigates the dataset.
if the user wants to sort the default load of the query, i would like to allow him to with the currently loaded dataset and not re-querying the actual database since his computer is super slow to begin with.
i put the basic dataset load below - basically want objds.tables("contacts").d
.sort = "LName DESC"
objDA = New OleDb.OleDbDataAdapter(strSQL, objcon)
maxRows = objDS.Tables("Contacts").Rows.Count