How to pass cascade parameters in sql

Question

I have a table in which i have First table(recordid,insertionid,year,name)Values(1,21,2008,Danish)

Now I am binding these records to a gridview using store procedure , The issue is that I want to get the  the value from another table where insertionid(as foriegn key) mean another table 

secondtable(id,insertionid(f),Questionid) Now I want to get  the QuestionId by passing the insertionid which i have in first table , and then pass this questionid  as parameter and get the question text from another table Thirdtable(id,QuestionId,QuestionText) so cascaded nature of parameter how to get that using store procedure write full code any one can assist pls

Answer 1

Do you mean you want to convert the JPEG image to PNG while loading the JPEG image (and not after)?

Are you selecting and loading the JPEG image using the OpenFileDialog Class?

If yes, you can get the name of the JPEG file, pass it Image.FromFile method:
https://msdn.microsoft.com/en-us/library/system.drawing.image.fromfile.aspx
And then save it to PNG using the
Image.Save method (Stream, ImageFormat):
https://msdn.microsoft.com/en-us/library/ms142147.aspx

But if you face any problem while loading or saving the JPEG or PNG images, you can try using loading and saving features from leadtools programming toolkit.

Answer 2

Hi,

Please refer below URLs

http://stackoverflow.com/questions/17294737/converting-an-image-to-png-on-upload


http://stackoverflow.com/questions/3906260/how-can-i-convert-a-jpeg-image-to-a-png-one-with-transparent-background


http://www.c-sharpcorner.com/UploadFile/scottlysle/ImageConverter09132006105604AM/ImageConverter.aspx

Thanks