How to get gridview data source

Question

I am using gridview with sqldatasource. How to return data source in codebehind as datatable?

Answer 1

Edited

Use the SqlDataSource.Select Method and assign it to dataview

DataView dv = (DataView)SqlDataSource1.Select(DataSourceSelectArguments.Empty);

Then fetch the datatable using

DataTable dt =  (DataTable)dv.ToTable();

Answer 2

Use System.Data.DataTable dt = (System.Data.DataTable) gview.DataSource; if you bind a DataTable.

DataTable DataSet, DataSet System.Data.DataTable dt2 = (System.Data.DataTable) ((System.Data.DataSet) gvValidDA.DataSource). [0]; , .

.

Answer 3

Gridview, .

Gridview.DataSource , NULL, gridview !

SQL...

        DataSourceSelectArguments dss = new DataSourceSelectArguments();
        DataView dvS = sdsADDorREMstudentData.Select(dss) as DataView;
        DataTable dtS = dvS.ToTable() as DataTable;
        if (dtS != null)
        {
          ... etc...
        }

ViewState Gridview.

    DataView dvClasses = (DataView)sdsClasses.Select(DataSourceSelectArguments.Empty);

    gvStudents.DataSourceID = "sdsClasses";
    gvStudents.DataSource = null; // Null out the source, as we have a SourceID instead
    gvStudents.DataBind();

    //save the data in a viewstate for later use (to control adding and removing students, without doing a postback! See ADD & REM methods below)
    DataView dv = (DataView)dvClasses;
    DataTable dt = new DataTable();
    if (dv != null)
    {
        dt = dv.ToTable();
        ViewState["gv"] = dt;
    }

ViewState, DataTable, Gridview...

DataTable dt = (DataTable)ViewState["gv"];