InfoPath Dev

I have 3 dropdown lists, all of them are cascading,on selection of one ddlist i'm populating other ddlist with set of values from Sharepoint list,now i need to populate the 3rd dropdown list with the SQL database values,that selection is based on values in 2 ddls..i'm populating the 2nd list with managed c# code,i need help in achieveing this scenario of populating the 3rd dropdown list from SQL..

Any help would be highly apprecciated..

Thanks in Advance

Hi --

If you have a secondary data source connection to your SQL database, you can modify the command in code to contain a where clause (for example) that would filter on the value in the field bound to your second drop down. Here is a great code sample (uses a stored procedure, but you can modify for straight SQL) by S.Y.M Wong-A-Ton.