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