write text on images dynamically

Question

hi im doing an app which is write text or draw something on the image, can you help me how can i write the code im trying many ways but im not getting the correct code i need dynamically write something on image...


pls any one can help me....  

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/