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();

Database picture

Answers (2)