Database picture

Question

how to store picture in database?
i want to know the code.

Satyapriya Nayak · Answer

Hi Nahhyan,
Already Vulpes has explained you nicely.
Also
Please refer the below link
http://aspalliance.com/articleViewer.aspx?aId=138&pId=
http://www.beansoftware.com/ASP.NET-Tutorials/Images-Database.aspx
Thanks

Vulpes · Answer

Suppose you have a table called 'images' in a SQL Server database and you want to store the picture in the 'image' column of that table. Here's how you'd go about it:
FileStream fs = new FileStream("image.jpg", FileMode.Open); // load image file from disk int fileLen = (int)fs.Length; byte[] bytes = new byte[fileLen]; // create a buffer fs.Read(bytes, 0, fileLen); // read the contents of the file and store them in the buffer fs.Close();
SqlConnection conn = new SqlConnection(connectionString); conn.Open(); SqlCommand cmd = new SqlCommand("insert into images (image) values (@picture)", conn);
cmd.Parameters.Add("@picture, bytes); // set parameter equal to buffer cmd.ExecuteNonQuery(); // insert picture in table conn.Close();