Sometimes I want to use SqlDataSource returned data programmatically and here is how you can do this,
In this example I will assume that SqlDataSource ID is SqlDataSource1 which is the default ID:
In this example I will assume that SqlDataSource ID is SqlDataSource1 which is the default ID:
DataSourceSelectArguments args = new DataSourceSelectArguments();
DataView view = SqlDataSource1.Select(args) as DataView;
DataTable dt = view.ToTable();
Source: https://www.nilebits.com/blog/2011/02/how-to-convert-sqldatasource-to-datatable-and-dataview-in-c-net/