Duplicate web controls on a form

Question

Hi,
Apologies for this question, I'm sure that it very basic....
I have a form and I want to put two controls that display a drop-down of currency codes.  It is to calculate an amount from a 'from' and a 'to' currency.
We have a generic Currency User Control that is suitable, but I want to run a slightly different bit of SQL to populate the dropdown when the form loads.
Can anyone provide me with an example and an explanation of how to do it?
Thanks
Paul

Answer 1

Here is another simple of doing this.

DECLARE @listContactIdStr VARCHAR(MAX)
select  @listContactIdStr = COALESCE(@listContactIdStr+',' ,'') +ContactId from dbo.ContactGroupReln where ContactGroupId=@ContactGroupId

SELECT @listContactIdStr

Please let me know, if it is not helping you.

Answer 2

Please check this link and try the query out there http://www.c-sharpcorner.com/UploadFile/ff2f08/comma-separated-value-in-sql-query/