How to get the datasource of a gridview

c# gridview sqldatasource
Geeth picture Geeth · Jan 6, 2010 · Viewed 9.4k times · Source

I am using a gridview with sqldatasource. How to get back the datasource in the codebehind as a datatable?

Answer

Ravia picture Ravia · Jan 6, 2010

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

You can even extract the DataTable out of DataSet if you are binding DataSet as System.Data.DataTable dt2 = (System.Data.DataTable)((System.Data.DataSet)gvValidDA.DataSource).Tables[0]; you will have to check the index of your table or table name as you prefer.

Happy coding.

Related questions

GridView with merged cells

I need to display data in grid view with merged rows for some columns. Please help me to prepare a grid view in below defined format: And the original data comes from database is in below format: Please help me …

Read More
How to sort columns in an ASP.NET GridView if using a custom DataSource?

I can't get my GridView to enable a user to sort a column of data when I'm using a custom SqlDataSource. I have a GridView in which the code in the ASP reference to it in the HTML is minimal: &…

Read More
Change select command of sqldatasource at runtime

HTML <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="id" DataSourceID="SqlDataSource1"> <Columns> <asp:BoundField DataField="id" HeaderText="id" /> <asp:BoundField DataField="name" HeaderText="name" /> </Columns> </asp:GridView&…

Read More