triggers Please solve this one urgent

Question

if i create table
dept


contain fields

deptno,deptname,depthead


if i insert the deptname compulsary for every timeinsert how can i check that condition in trigger

please write the trigger for that problem....if any body help me  it is very urgent

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