469,954 Members | 1,907 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,954 developers. It's quick & easy.

Binding to SqlDataSource that returns multiple datatable

Hello,

Stored procedure returns results of 3 different queries. On ASP.NET 2.0 page
I have a SqlDataSource control with SelectCommand equals this stored
procedure name.
I want to be able to bind 3 different controls on the page: 1 dropdown
control, 2. formview and GridView to each datatable.

Is there a way to do it? I can't find any way of doing it, other then having
3 different SqlDataSource controls for each query. But I dont want to do
that, I want to be able to resue this production sp.

Thank you for your help.

Sep 27 '06 #1
2 2691
DataAdapter.Fill method will create 3 datatables out of your stored
procedure.

--
Eliyahu Goldin,
Software Developer & Consultant
Microsoft MVP [ASP.NET]
"WebMatrix" <We*******@discussions.microsoft.comwrote in message
news:6B**********************************@microsof t.com...
Hello,

Stored procedure returns results of 3 different queries. On ASP.NET 2.0
page
I have a SqlDataSource control with SelectCommand equals this stored
procedure name.
I want to be able to bind 3 different controls on the page: 1 dropdown
control, 2. formview and GridView to each datatable.

Is there a way to do it? I can't find any way of doing it, other then
having
3 different SqlDataSource controls for each query. But I dont want to do
that, I want to be able to resue this production sp.

Thank you for your help.

Sep 27 '06 #2
DataAdapter.Fill method will create 3 datatables out of your stored
procedure.
What abou sqlDataSource control?
Sep 27 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by benoit | last post: by
3 posts views Thread by Mike T | last post: by
1 post views Thread by Per W. | last post: by
1 post views Thread by Simone | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.