The SqlDataSource is a piece of software that wraps all functionality in one
convenient wrapper. Underneath the hood it contains all of the plumbing to
make simple drag and drop and configure a reality. In .NET, you use multiple
SqlDataSource controls to complete multiple steps. You might be able to
kludge this, but I am not sure it is worth it. If you want to go this route,
you can try concatenating multiple SQL statements, but I am not sure how you
would separate out the many tables. But, I have not dug deeply into the
SqlDataSource.
If you need to step outside of this box, you should learn about the
underlying objects and code you own data access.
--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
http://gregorybeamer.spaces.live.com
Co-author: Microsoft Expression Web Bible (upcoming)
************************************************
Think outside the box!
************************************************
"Madison" <Ma*****@discussions.microsoft.comwrote in message
news:30**********************************@microsof t.com...
Hi all,
Could I use the sqldatasource with stored-procedure to return multiple
recordset? I did not want to have any sqldatasourec in the one page just
to
return the record back to dropdownlists. In my stored procedure will have
2
select statement. If it can be done how I refer to each dropdownlist to
correct recordset. Please advise. Thanks.