best method for display and upload image

Try the below one.

protected void btnUpload_Click(object sender, EventArgs e)
{
byte[] imageData = null;
string fileName = string.Empty;
if (!string.IsNullOrEmpty(FileUpload1.FileName))
{
if (FileUpload1.HasFile)
{
imageData = FileUpload1.FileBytes;
fileName = FileUpload1.FileName;
}
}
string conString = @"Data Source=WVDI1IHCL32\WVDI1IHCL32;Initial Catalog=Test;Integrated Security=True;";
SqlConnection con = new SqlConnection(conString);
con.Open();
SqlCommand cmd;
string filename = FileUpload1.FileName;
cmd = new SqlCommand("insertingImage", con);
cmd.CommandText = "INSERT INTO ProductImage(ProductImage, Description) VALUES(@ProductImage ,@Description)";
cmd.Parameters.AddWithValue("@ProductImage", imageData);
cmd.Parameters.AddWithValue("@Description", "Sample image");
cmd.ExecuteNonQuery();
con.Close();
}
protected void btnRetrieve_Click(object sender, EventArgs e)
{
string conString = @"Data Source=WVDI1IHCL32\WVDI1IHCL32;Initial Catalog=Test;Integrated Security=True;";
SqlConnection con = new SqlConnection(conString);
con.Open();
SqlCommand cmd = null;
cmd = new SqlCommand("SelectImage", con);
cmd.CommandText = "Select * from ProductImage where ID = 1";
SqlDataReader sqlReader = cmd.ExecuteReader();
sqlReader.Read();
Byte[] imageData = (byte[])sqlReader["ProductImage"];
Response.BinaryWrite(imageData);
}

Database:
create table ProductImage
(
ID int not null identity constraint PK_Image primary key,
ProductImage image,
Description varchar(50)
)

3 Replies

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

Suthish Nair15y ago
Both ways have its advantages and disadvantages. Saving a file to drive and path to DB, can avoid file conversions.If you storing the files in DB then you need to convert the files to bytes for storage and retrievals. There are lots of articles available in Our recommended articles sections.
0
Dorababu Meka15y ago
Try this article

http://www.aspsnippets.com/Articles/Display-Images-in-GridView-Control-using-the-path-stored-in-SQL-Server-database.aspx
0
Marimuthu Arigovindasamy16y ago
Try the below one.

protected void btnUpload_Click(object sender, EventArgs e)
{
byte[] imageData = null;
string fileName = string.Empty;
if (!string.IsNullOrEmpty(FileUpload1.FileName))
{
if (FileUpload1.HasFile)
{
imageData = FileUpload1.FileBytes;
fileName = FileUpload1.FileName;
}
}
string conString = @"Data Source=WVDI1IHCL32\WVDI1IHCL32;Initial Catalog=Test;Integrated Security=True;";
SqlConnection con = new SqlConnection(conString);
con.Open();
SqlCommand cmd;
string filename = FileUpload1.FileName;
cmd = new SqlCommand("insertingImage", con);
cmd.CommandText = "INSERT INTO ProductImage(ProductImage, Description) VALUES(@ProductImage ,@Description)";
cmd.Parameters.AddWithValue("@ProductImage", imageData);
cmd.Parameters.AddWithValue("@Description", "Sample image");
cmd.ExecuteNonQuery();
con.Close();
}
protected void btnRetrieve_Click(object sender, EventArgs e)
{
string conString = @"Data Source=WVDI1IHCL32\WVDI1IHCL32;Initial Catalog=Test;Integrated Security=True;";
SqlConnection con = new SqlConnection(conString);
con.Open();
SqlCommand cmd = null;
cmd = new SqlCommand("SelectImage", con);
cmd.CommandText = "Select * from ProductImage where ID = 1";
SqlDataReader sqlReader = cmd.ExecuteReader();
sqlReader.Read();
Byte[] imageData = (byte[])sqlReader["ProductImage"];
Response.BinaryWrite(imageData);
}

Database:
create table ProductImage
(
ID int not null identity constraint PK_Image primary key,
ProductImage image,
Description varchar(50)
)
0