I want to store images in database tables

I have written a code as follows -

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.IO;
namespace Shop
{
public partial class addimage : System.Web.UI.Page
{ SqlConnection con = new SqlConnection("Data Source=(LocalDB)\\MSSQLLocalDB;AttachDbFilename=C:\\Users\\Sayan\\Documents\\Saanvi.mdf;Integrated Security=True;Connect Timeout=30");
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Buttonuploadimage_Click(object sender, EventArgs e)
{
FileUpload f = new FileUpload();
if (f.HasFile)
{
string str = f.FileName;
f.PostedFile.SaveAs(Server.MapPath(".") + "//Images//" + str);
string path = "~//Images//" + str.ToString();
con.Open();
SqlCommand cmd=new SqlCommand("Insert into Images values('" + path + "')", con);
cmd.ExecuteNonQuery();
con.Close();
Labeluploadimage.Text = "Image uploaded successfully";
}
else
{
Labeluploadimage.Text = "Pls. upload an image";
}

However, I see that the if statement is not executed and always the statement under the else statement is executed. Is this something to do with the Button click event handler? I have a "upload image" button and a "upload" control used from the toolbox. I have an "Images" folder under solution explorer, where I have already kept few pics.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Gokhul Varman9y ago
It is a hideous process and needs more coding refer the link for more explanation:http://www.dba-oracle.com/t_storing_insert_photo_pictures_tables.htm
Vincent Maverick Durano9y ago
That's because you are declaring a new FileUplaod object which has no files in it. You need to declare/define the FileUpload control in the markup (ASPX) and use that instead to get the file uploaded.

See this article for your reference: https://www.codeproject.com/Tips/1116809/ASP-NET-WebForms-Uploading-Validating-And-Displayi