how should i retrieve image in image control using this code

Byte[] bytes = null;

string text2 = this.FileUploadFullR.FileName;

string str7 = this.Session["ProductIDA"].ToString();

this.Ade = this.Session["ProductIDA"].ToString();

if (this.FileUploadFullR.HasFile)

{

string filename = FileUploadFullR.PostedFile.FileName;

string str9 = str6 + str4;

string filePath = Path.GetFileName(filename);

Stream fs = FileUploadFullR.PostedFile.InputStream;

BinaryReader br = new BinaryReader(fs);

bytes = br.ReadBytes((Int32)fs.Length);

ConfigurationManager.ConnectionStrings["ConnectionString"].ToString();

connection = new SqlConnection(this.strConnectionstring);

connection.Open();

SqlCommand cmdddd = new SqlCommand("Update TBL_PRODUCTDETAILS Set Picfront = @Picfront where ID = '" + str6 + "' ", connection);

cmdddd.Parameters.Add("@Picfront", SqlDbType.Binary).Value = bytes;

cmdddd.ExecuteNonQuery();

}

1 Reply

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

Madhanmohan Devarajan9y ago
Hope you are trying to read the image from the file upload control (by reading the image as binary) and updating to PicFront field in SQL table TBL_PRODUCTDETAILS.

Please let us know what is the error message you are getting while executing the SQL command. Because steps in the above piece of code seems to be fine. But there may be some issues in the binary reader step or in ExecuteNonQuery. Were you able to read binary values for the image file and store it in "bytes" variable?
0