Apr 18, 2011 03:23 PM|WarrenW|LINK
Right now I am using the SQLDatasource control to call a stored procedure on an AS400. The SQLDatasource is binded to a gridview control that shows the results. All of this works fine. But what I really want to do is create a datatable from the SQLDatasource
after it is databound and assign the datatable to the gridview control's datasource property. I have tried several ways and cannot get it right.
Can someone show me source on how to do this from creating the datatable from the SQLDatasource control and then assigning it to the gridview? The reason I want to do this is I want to use the datatable for other stuff without requerying such as exporting
to excel and other.
I appreciate your help!