Database Structure
Fileupload.aspx
- <asp:FileUpload ID=”FileUpload” runat=”server” />
- <asp:Button ID=”btnsubmit” runat=”server” Text=”Upload” OnClick=”btnsubmit_Click” />
- <asp:Label ID=”alert” runat=”server”></asp:Label>
- <asp:gridview ID=”Fileup” runat=”server” />
Fileupload.aspx.cs
Storing a image into database:
CODE:
- protected void btnsubmit_Click(object sender, EventArgs e)
- {
- try
- {
- byte[] imgbyte = null;
- if(FileUpload.HasFile & FileUpload.PostedFile != null)
- {
- HttpPostedFile file = FileUpload.PostedFile;
- imgbyte = new byte[file.ContentLength];
- file.InputStream.Read(imgbyte, 0, file.ContentLength);
- }
- SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings[“userconnstring”].ConnectionString);
- SqlCommand cmd = new SqlCommand(“insert into tbl_Imgdb ([Image_Name],[Image_Detail]) values (@Image_Name,@Image_Detail)”, con);
- con.Open();
- cmd.Parameters.AddWithValue(“@Image_Name”, FileUpload.PostedFile.FileName);
- cmd.Parameters.AddWithValue(“@Image_Detail”, imgbyte);
- cmd.ExecuteNonQuery();
- alert.Text = “Image Uploaded Successfully”;
- con.Close();
- }
- catch(Exception ex)
- {
- throw ex;
- }
- }
Dharmendra Kumar PanditPosted Sep 30, 2018, 8:02 AM
Thank You Sir. Very helpful. I was searching it from a long time. But finally got it from your code. Thank you again.
Vinodh NarayananPosted Oct 14, 2015, 3:31 AM
Thanks a lot sir
Sujeet SumanPosted Oct 13, 2015, 12:39 PM
Nice Article...............
Vinodh NarayananPosted Aug 22, 2015, 2:40 AM
ok i will send it to u EOD
Vivek JoyPosted Aug 20, 2015, 10:07 AM
i need the code