how to insert image in database using c#

Question

sir please tell me how will do

Munesh Sharma · Answer

http://www.c-sharpcorner.com/uploadfile/e628d9/inserting-retrieving-images-from-sql-server-database-without-using-stored-procedures/

Amit Kumar · Answer

Hi Dear Please follow the below link I hope it will resolve your problem. http://www.c-sharpcorner.com/uploadfile/e628d9/inserting-retrieving-images-from-sql-server-database-without-using-stored-procedures/ http://net-informations.com/csprj/dataset/cs-insert-image.htm http://www.shabdar.org/sql-server/105-store-save-images-in-sql-server.html

Rahul Chavan · Answer

protected void btnUpload_Click( object sender EventArgs e) { // Read the file and convert it to Byte Array string filePath = FileUpload1.PostedFile.FileName; string filename = Path .GetFileName(filePath); string ext = Path .GetExtension(filename); string contenttype = String .Empty; //Set the contenttype based on File Extension switch (ext) { case .doc : contenttype = application/vnd.ms-word ; break ; case .docx : contenttype = application/vnd.ms-word ; break ; case .xls : contenttype = application/vnd.ms-excel ; break ; case .xlsx : contenttype = application/vnd.ms-excel ; break ; case .jpg : contenttype = image/jpg ; break ; case .png : contenttype = image/png ; break ; case .gif : contenttype = image/gif ; break ; case .pdf : contenttype = application/pdf ; break ; } if (contenttype != String .Empty) { Stream fs = FileUpload1.PostedFile.InputStream; BinaryReader br = new BinaryReader (fs); Byte [] bytes = br.ReadBytes(( Int32 )fs.Length); //insert the file into database string strQuery = insert into tblFiles(Name ContentType Data) +  values (@Name @ContentType @Data) ; SqlCommand cmd = new SqlCommand (strQuery); cmd.Parameters.Add( @Name  SqlDbType .VarChar).Value = filename; cmd.Parameters.Add( @ContentType  SqlDbType .VarChar).Value = contenttype; cmd.Parameters.Add( @Data  SqlDbType .Binary).Value = bytes; InsertUpdateData(cmd); lblMessage.ForeColor = System.Drawing. Color .Green; lblMessage.Text = File Uploaded Successfully ; } else { lblMessage.ForeColor = System.Drawing. Color .Red; lblMessage.Text = File format not recognised. +  Upload Image/Word/PDF/Excel formats ; } } private Boolean InsertUpdateData( SqlCommand cmd) { String strConnString = System.Configuration. ConfigurationManager .ConnectionStrings[ conString ].ConnectionString; SqlConnection con = new SqlConnection (strConnString); cmd.CommandType = CommandType .Text; cmd.Connection = con; try { con.Open(); cmd.ExecuteNonQuery(); return true ; } catch ( Exception ex) { Response.Write(ex.Message); return false ; } finally { con.Close(); con.Dispose(); } }

Amit Singh · Answer

If u got the answer... Accept My Answer as Correct

dharmender kumar · Answer

ok sir

Amit Singh · Answer

Hey Check this out 1.http://www.c-sharpcorner.com/uploadfile/e628d9/inserting-retrieving-images-from-sql-server-database-without-using-stored-procedures/ 2.http://www.aspsnippets.com/Articles/Inserting-and-Retrieving-images-from-SQL-Server-database-without-using-Stored-Procedures.aspx