I am loading a data table object "MyTable" form a reader object. The reader object was populated with data from a sql stored procedure. All is good, except I want to know if there is a way to change/update the data in my DataTable object "MyTable"?
I would like to change the data before it us used to populate a GridView control
Dim MyTable as New DataTable()
Using Command as New SqlCommand(mySqlQuery,connection)
Using reader As SqlDataReader = command.ExecuteReader()