how to save image data in database?

Question

i want to save image data in sql server 2005 what can i do?

Dinkar Chavhan · Answer

first create table with 1 field then create SP and take fileupload control and 1 button double click on button and write this code { string img = FileUpload1.FileName.ToString(); SqlConnection con1 = new SqlConnection(Data Source=shashi-pc;Initial Catalog=offer;User ID=sa;Password=omsairam); SqlCommand cmd1 = new SqlCommand(); cmd1.Connection = con1; con1.Open(); cmd1.CommandType = CommandType.StoredProcedure; cmd1.CommandText = SP_insertImage; cmd1.Parameters.AddWithValue(@image~/images/+img); int i = cmd1.ExecuteNonQuery(); con1.Close(); if (i > 0) { Label1.Text = posted successful; FileUpload1.PostedFile.SaveAs(MapPath(~/images/ + img)); } else Label1.Text = pls fill correct;

Krishna Garad · Answer

Check put the article in Our Recommended Articles Section right side of this post.