save Edited Image on Sql

Question

i have a image in the form in asp.net i have a button i have dragged some labels controls and placed on that image if i click the button i want to save it to sql. Any idea regarding this

senthil · Answer

Thanks for ur Timely help......see the rar file i uploaded as for Example....

senthil · Answer

i have attached a image ..... see Example... i have image control here and some label controls in form.. i drag and drop labels on that image ... atlast the image with drag and dropped labels stored in database

paul daniel · Answer

Hi First u create ImgId,Img,Imglength in ur database and create a byte[] for saving the image in ur db int imagelen = Upload.PostedFile.ContentLength; byte[] picbyte = new byte[imagelen]; Upload.PostedFile.InputStream.Read (picbyte, 0, imagelen); conn.Open (); SqlCommand cmd = new SqlCommand ("insert into Imgtble" + "(ImageField, ImageID) values (@Img, @imageid)", conn); cmd.Parameters.Add ("@Img", picbyte); cmd.Parameters.Add ("@imageid", lblImageID.Text); cmd.ExecuteNonQuery (); Thanks, Paul daniel

Rekha Singh · Answer

if u wanna save the image.. convert it into binary n save it in ur table db with column datatime as image .. if this is wat u r looking for let me know.. will give an example for this

save Edited Image on Sql

Answers (4)