Insert image in table

Question

Hi! I have an image to insert form a URL path in SQL Server using URL http:\..... but it is not working. Could you have any suggestions to help me ?

Suthish Nair · Answer

but it is not working - you didn't mentioned the problem here.

Gomathi Palaniswamy · Answer

byte[]Data = ReadFile(txtPath.Text); SqlConnection Con= new SqlConnection( ); string strqry = insert into ImagesStore (OriginalPathImageData)values(@OriginalPath @ImageData); SqlCommand cmd = new SqlCommand(strqrycon); cmd .Parameters.Add(new SqlParameter(@OriginalPath(object)txtPath.Text)); cmd.Parameters.Add(new SqlParameter(@ImageData (object)Data)); Con.Open(); cmd.ExecuteNonQuery(); Con.Close();

Jiteendra Sampathirao · Answer

Hi Refer these articles: Link1: Click Here Link2: Click here

Jaganathan Bantheswaran · Answer

Hi First you need to read the image from that specified url and than try this Inserting & retrieving images from SQL Server database using stored procedures