Populate formview off of another formview

[dstrange]

Hello,

I'm a asp.net newbie so be patient. I have 2 formviews that load at the same time. formview1 comes from tableA and formview2 comes from table2. They both share a common field.
What I would like is for formview2 to load based off a value that is loaded in formview1. I know it involves setting parameters in the datasource I just need to know how to do it. Any help would be appreciated. Thanks.

 

[jbenson001]

Don't use the datasource controls. They are fine for simple forms, but you cannot debug them, and become a problem when you have more complicated SQL.

I would write a stored procedure for this which would produce 2 datasets. Then you can just bind each formview to a one of the tables in the dataset.