Image upload and save

Question

I want upload image and show in database using sql

Sachin Singh · Answer

if you want to save image insted of its path then follow below code byte[] buffer = new byte[fileUpload1.FileContent.Length]; Stream s = fileUpload1.FileContent; s.Read(buffer, 0 , buffer.Length); save this buffer to your varbinary column

Sachin Singh · Answer

"FileUpload1" runat= "server" /> "btnUpload" Text= "Upload" runat= "server" OnClick= "UploadFile" /> "Image1" runat= "server" Height = "100" Width = "100" /> protected void UploadFile(object sender, EventArgs e) { string folderPath = Server.MapPath( "~/Files/" ); //Check whether Directory (Folder) exists. if (!Directory.Exists(folderPath)) { //If Directory (Folder) does not exists Create it. Directory.CreateDirectory(folderPath); } //Save the File to the Directory (Folder). FileUpload 1 .SaveAs(folderPath + Path.GetFileName(FileUpload 1 .FileName)); var path=folderPath + Path.GetFileName(FileUpload 1 .FileName); using (SqlConnection con = new SqlConnection(cs)) { SqlCommand cmd = new SqlCommand( "insert into table values (@path)" , con); cmd.Parameters.AddWithValue( "@path" ,path); con.Open(); cmd.ExecuteNonQuery(); } //Display the Picture in Image control. Save this path to Database Image 1 .ImageUrl = "~/Files/" + Path.GetFileName(FileUpload 1 .FileName); }

Rajanikant Hawaldar · Answer

https://www.c-sharpcorner.com/UploadFile/009464/save-image-to-database-using-fileupload-in-Asp-Net/ https://www.c-sharpcorner.com/UploadFile/ca2535/how-to-upload-images-and-save-the-images-into-database-using/ https://www.c-sharpcorner.com/uploadfile/0c1bb2/uploading-images-to-database-using-asp-net-c-sharp/