retrieve image from database

Ankita Singh

protected void btnUpdate_Click(object sender, EventArgs e)

{

string id = Request.QueryString["id"].ToString();

string qry = "update appformtbl set can_name=@can_name,fath_name=@fath_name,photo=@photo,sign=@sign,pass_gra=@pass_gra where id=" + id + "";

SqlConnection con = new SqlConnection(connection);

SqlCommand cmd = new SqlCommand(qry, con);

if (image1.HasFile)

{

image1.SaveAs(MapPath("~/Rimage/" + image1.FileName));

System.Drawing.Image img1 = System.Drawing.Image.FromFile(MapPath("~/Rimage/") + image1.FileName);

NormalImage.ImageUrl = "~/Rimage/" + image1.FileName;

}

else

{

var preimg = cmd.Parameters.AddWithValue("@photo", image1.ToString());

if (image1!= null)

{

preimg.Value = image1.FileName;-

}

cmd.Parameters.AddWithValue("@photo", SqlDbType.NVarChar).Value = image1.FileName.Trim();

my problem:- hello friends, when i am updating new image then show in table but without change image click on update button then not find previous image... how to do it??? please help me.. thank you

8 Replies

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

Nitin Sontakke8y ago
Accepted answer
If I understand the requirement correctly, when you don't receive the image, you do not wish to update the [photo] column and leave it as it is.

If yes, you can construct your UPDATE query as follows:
string qry = @"update [dbo].[appformtbl] set
   [can_name] = @can_name
  ,[fath_name] = @fath_name
  ,[photo] = isnull(nullif(@photo, ''), [photo])
  ,[sign] = @sign
  ,[pass_gra] = @pass_gra
where [id] = " + id;
In the else part of your code send empty string as a parameter value for @photo parameter, which will be considered as null due to the code I had written in the update statement.

I sincerely believe that the best approach is to write a stored procedure, so that all of this can be handled there itself.
Nitin Sontakke8y ago
Glad to be of help!

I cannot help but comment, so please take it in right way.

What is appformtbl? Is it Application Form table? then call it [dbo].[tblApplicationForm].

What is can_name? Is it Candidate Name? then call it [candidate_name].

What is fath_name? Is it Father Name? then call it [father_name].

Almost 25 - 30 years back when I started coding, there was a system limitation of giving unique variable names in maximum length of 8 characters. Not any more. You have limit of 255 chars. So use it.

Kanjusi while spending is fine. Why being kanjus while naming variable?
Ankita Singh8y ago
thank you so much... my problem is solved..
Ankita Singh8y ago
this is already my question... i have no idea how to get old image url through code please exaplain it...
Kaushik Dhameliya8y ago
In else condition get old image url then update image.
Ankita Singh8y ago
problem is in else condition... how to write code for else condition
Ankita Singh8y ago
image is change when update new image then no issue create but problem is create when without update image click update button then not showing image in table...
Kaushik Dhameliya8y ago
Hello

check image is change or not if image is changed then ok otherwise get previous image URL from the database based on Id