are you creating a datatable first and then binding the datatable to the gridview? you don't need to databind the gridview to the database. You can populate a datatable and then manipulate it any way you want, then bind it to the gridview... see my reply in this
thread... although I answered the OP wrong, the logic is
correct- i just didn't understand the OP question correctly :P
Does that help?