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/