Capturing Parameters

[Guest]

I have a SQLDataSource that runs a stored procedure which returns just one
record which is an EmployeeID. In the same webform I have a second
SQLDataSource that runs a simple SELECT statement but needs the EMPLOYEEID in
the first datasource as the criteria or parameter.
Question is what is the best way to make this happen? I know I can
indicate a parameter in the 2nd data source bound to a CONTROL or QUERY
STRING, but I dont know how to make this work? please help.

thanks.

 

[Plamen Ratchev]

Here is an example of setting a parameter to populate a data control:
http://support.microsoft.com/kb/306574

Regards,

Plamen Ratchev
http://www.SQLStudio.com