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

how to insert image in database using c#

Answers (6)