http://msmvps.com/blogs/egoldin/archive/2006/12/27/how-to-get-datatable-out-of-sqldatasource.aspxIn many scenarios developers would like to combine the great simplicity of Asp.Net 2.0 declarative databinding with the same level of control over data as they get with good old traditional databinding. Sometimes the developers need to manipulate on theenCommunityServer 2008.5 SP2 (Build: 40407.4157)http://msmvps.com/blogs/egoldin/archive/2006/12/27/how-to-get-datatable-out-of-sqldatasource.aspx#1636692Sun, 22 Jun 2008 13:48:21 GMTd67277c4-116b-43f1-b688-e9ef184ea916:1636692egoldin<p>Hi Dan,</p> <p>You don't have to use declarative databinding. Just run your select into a dataset, do whatever you need on the dataset, assign the dataset to the control's DataSource property and call DataBind().</p> <div style="clear:both;"></div><img src="http://msmvps.com/aggbug.aspx?PostID=1636692" width="1" height="1">http://msmvps.com/blogs/egoldin/archive/2006/12/27/how-to-get-datatable-out-of-sqldatasource.aspx#1635823Mon, 16 Jun 2008 22:41:15 GMTd67277c4-116b-43f1-b688-e9ef184ea916:1635823Dan<p>Thats all good with a dataview, but what if the select calls a stored proc that returns 2 or more tables? the dataview only views the first one how would one person get the rest? Thanks in advance</p> <div style="clear:both;"></div><img src="http://msmvps.com/aggbug.aspx?PostID=1635823" width="1" height="1">http://msmvps.com/blogs/egoldin/archive/2006/12/27/how-to-get-datatable-out-of-sqldatasource.aspx#1361039Tue, 27 Nov 2007 09:48:07 GMTd67277c4-116b-43f1-b688-e9ef184ea916:1361039egoldin<p>Hi Geoff,</p> <p>No, only with GridView, DataList and Repeater.</p> <p>Use regular (not declarative) databinding instead.</p> <div style="clear:both;"></div><img src="http://msmvps.com/aggbug.aspx?PostID=1361039" width="1" height="1">http://msmvps.com/blogs/egoldin/archive/2006/12/27/how-to-get-datatable-out-of-sqldatasource.aspx#1358582Mon, 26 Nov 2007 20:11:59 GMTd67277c4-116b-43f1-b688-e9ef184ea916:1358582Geoff<p>What if I'm binding to a ListBox. &nbsp;Is there any corresponding even where I can pull out the DataSet?</p> <div style="clear:both;"></div><img src="http://msmvps.com/aggbug.aspx?PostID=1358582" width="1" height="1">http://msmvps.com/blogs/egoldin/archive/2006/12/27/how-to-get-datatable-out-of-sqldatasource.aspx#1289575Fri, 09 Nov 2007 09:42:59 GMTd67277c4-116b-43f1-b688-e9ef184ea916:1289575e-interiores » Obtener acceso a los datos de un SqlDataSource<p>Pingback from &nbsp;e-interiores &amp;raquo; Obtener acceso a los datos de un SqlDataSource</p> <img src="http://msmvps.com/aggbug.aspx?PostID=1289575" width="1" height="1">