how to put images in SQL database?

Question

I want to know how to store images in sql database using c# and also how to display the through c# stored in word file and also in a folder

Mukesh Kumar · Answer

Hi, //Save Image Hide Copy Code SqlConnection cn = new SqlConnection( " data source=localhost;initial catalog=notitest;user id=sa;password=cos123" ); cn.Open(); SqlCommand cmd = new SqlCommand( " insert imgtest values(" + textBox1.Text + " ,'" + ImageToBase64(pictureBox1.Image, System.Drawing.Imaging.ImageFormat.Png) + " ')" , cn); SqlDataReader dr = cmd.ExecuteReader(); cn.Close(); //Retrive Hide Copy Code SqlConnection cn = new SqlConnection( " data source=localhost;initial catalog=notitest;user id=sa;password=cos123" ); cn.Open(); SqlCommand cmd = new SqlCommand( " select * from imgtest" , cn); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { textBox2.Text = dr[ 0 ].ToString(); pictureBox2.Image = Base64ToImage(dr[ 1 ].ToString()); } cn.Close(); //Methods Hide Copy Code public string ImageToBase64(Image image, System.Drawing.Imaging.ImageFormat format) { using (MemoryStream ms = new MemoryStream()) { // Convert Image to byte[] image.Save(ms, format); byte[] imageBytes = ms.ToArray(); // Convert byte[] to Base64 String string base64String = Convert.ToBase64String(imageBytes); return base64String; } } public Image Base64ToImage(string base64String) { // Convert Base64 String to byte[] byte[] imageBytes = Convert.FromBase64String(base64String); MemoryStream ms = new MemoryStream(imageBytes, 0 , imageBytes.Length); // Convert byte[] to Image ms.Write(imageBytes, 0 , imageBytes.Length); Image image = Image.FromStream(ms, true ); return image; } Hope this will help you. thanks

Ravi Patel · Answer

Hi, go through following link http://www.aspsnippets.com/Articles/Save-and-Retrieve-images-from-database-in-ASPNet.aspx

Krishna Rajput Singh · Answer

Hello Amandeep singh Thanks for writing below links i hope helpful for you...:) http://www.c-sharpcorner.com/Blogs/12306/simple-procedure-to-insert-an-image-into-the-database-sql-s.aspx http://www.dotnetgallery.com/kb/resource21-How-to-store-and-retrieve-images-from-SQL-server-database-using-aspnet.aspx.aspx http://www.codeproject.com/Articles/21208/Store-or-Save-images-in-SQL-Server Special Thanks http://www.c-sharpcorner.com find helpful answer mark as correct

how to put images in SQL database?

Answers (3)