How can I export a GridView.DataSource to a datatable or dataset?

Question

How can I export GridView.DataSource to datatable or dataset?

Answer 1

Assuming your DataSource is of type DataTable, you can just do this:

myGridView.DataSource as DataTable

Answer 2

http://www.vbforums.com/showthread.php?t=474895

  //If DataSource of GridView1 is a DataTable
  DataTable dt = (DataTable)GridView1.DataSource;

  //If DataSource of GridView1 is a DataView
  DataView dv = (DataView)GridView1.DataSource;

Answer 3

Personally I would go with:

DateTable tbl = Gridview1.DataSource as DataTable;

This would allow you to test for null as this results in either DataTable object or null. Casting it as a datable using (DataTable)Gridview1.Datasource would cause a crashing error in case the datasource is actually a DataSet or even some kind of collection.

Supporting Dcoumentation: MSDN Documentation on "as"