Add where clause to SQLDataSource with parameter from anothe SQLDataSo

[daughtd]

I have two SQLDataSources I'll call them SQL1 and SQL2.

SQL1 returns all from a table and is the datasource for a datalist.

SQL2 is used as Datasource for a listbox inside my datalist. But I want to add a where clause that filters the rows returned based on a field returned in SQL1.

Is this possible?

 

[vbkris]

yes, very much.

You will have to use the ItemDataBound command for that. i guess the where clause value changes for each item right??

Known is handfull, Unknown is worldfull

 

[daughtd]

Yes it changes for each row

 

[vbkris]

then please try the ItemDataBound event.

in that event you can get the information of the currently binding data using this:

e.Item.DataItem

The above will give you the DataRow. using that you can pick the Column's info that you want in SQL1 and use it to filter SQL2...

Known is handfull, Unknown is worldfull