Does anyone know the problem, how to convert the data source in GridView to DataTable

变脸天使

How to convert the data source in the GridView to a DataTable.

 There are two ways to get the data source of GridView, one is through the DataSource,
One is obtained through DataSourceID, such as
 Way 1
    this.GridView1.DataSource = this.ObjectDataSource1;
    this.GridView1.DataBind ();
 Way 2
   this.GridView1.DataSourceID = "ObjectDataSource1";
   this.GridView1.DataBind ();

Note: There may be many types of data sources in the GridView, which may be DataSet, DataTable,
DataView, DataReader, SqlDataSource, ObjectDataSource.

If the data source is a DataTable or something, that's easy to use.
this.GridView1.DataSource as DataTable is ok.,
But if it is a data source control such as ObjectDataSource, this will not work. Does anyone know how to complete the above requirements?

xing_532

The most stupid way is to traverse the GV, take out the data of each row and column, and put it into a DataTable

burtmao

I don't know what it means. I feel that it is enough to use the previous one. I haven't met it in the back.

393736105

As the landlord said, when the data source of GridView is indeed impossible to convert to DataTable,
The possible approach is probably as follows:

object data = GridView.DataSource;
DataTable dataTable = null;
if (data is DataSet)
{
DataSet ds = data as DataSet;
if (ds! = null&&ds.Tables.Count == 1)
{
dataTable = ds.Tables [0];
}
}
else if (data is DataView)
{
DataView dv = data as DataView;
dataTable = dv.Table;
}
else if (data is DataTable)
{
dataTable = data as DataTable;
}
I don't know how to convert other types to DataTable type.

变脸天使

The previous friend said that traversing the GridView, of course not, I need to take out the data source in the GridView, and you traverse
GridView only takes the data source of the current page. .

The idea of ​​the common people is my idea, but if the data source is a control such as ObjectDataSource, it will not work, does any master know how to solve this problem? ? ?

shenmue024

This is also a stupid way,

Recheck the database

   DataTable dt = ((DataView) ((ObjectDataSource) this.GridView1.DataSource) .Select ()). Table;

变脸天使

Haha, dude, you can get results by repeating a database query. I have also thought about it, but the efficiency is not very good. Connecting to the database and consuming a lot of resources. Do you have any good ways? Continue to discuss

terrorlin

See if there is a copy method for these types. Like what. Copy or something

lhg2772

I also encountered this problem. GV is bound to ObjectDataSource but the following business needs to be converted to DataTable to solve..