image name is already exists it update the data

Question

0.00/5 (No votes)

See more:

i am storing image name and image path in database.i want when image name is already exists it update the data but there is some problem.my this code it update the image but gives error "ExecuteNonQuery: Connection property has not been initialized."
actually i want if image name exists update it if not insert it???

C#

protected void Button2_Click1(object sender, EventArgs e)
        {
            {
                string username =(string)( Session["UserAuthentication"]);
                //Get Filename from fileupload control
               // string filename = Path.GetFileName(fileuploadimages.PostedFile.FileName);
                //Save images into Images folder
                FileUpload1.SaveAs(Server.MapPath("Images/" + username));
                string str = "Images/" + username;
                //Getting dbconnection from web.config connectionstring
                SqlConnection con = new SqlConnection(connstring);
                //Open the database connection
                con.Open();
                //Query to insert images path and name into database

                //SqlCommand cmd = new SqlCommand("Insert into imagePath(imagename,imgpath) values(@imagename,@imgpath)", con);
                cmd=new SqlCommand("UPDATE imagepath SET imgpath='"+str+"' WHERE imagename='"+username+"'");
                //Passing parameters to query
               cmd.Parameters.AddWithValue(username, username);
               cmd.Parameters.AddWithValue(str, "Images/" + username);
                cmd.ExecuteNonQuery();
                //Close dbconnection
                con.Close();
                //Response.Redirect("~/Default.aspx");
            }

Posted 13-Jun-13 19:54pm

fak_farrukh

Add a Solution

Comments

vakativamsi 14-Jun-13 2:02am

Hi ,
define the connection in the query ending "CON"
replace the below line i8n you project

cmd=new SqlCommand("UPDATE imagepath SET imgpath='"+str+"' WHERE imagename='"+username+"'",con);

Thankyou

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

_Amy · Answer 1 · 2013-06-13T19:59:00

Solution 1

Add connection object in SqlCommand as second parameter. Try this:

C#

cmd=new SqlCommand("UPDATE imagepath SET imgpath='"+str+"' WHERE imagename='"+username+"'", con);

[Edit 1]
First you need to check the count in database for that image. If image exists in database the count will be more than zero(in this case 1). If count is coming more than zero then update the image otherwise insert that.
Try this:

C#

cmd=new SqlCommand("SELECT COUNT(*) FROM imagepath  WHERE imagename='"+username+"'", con);
int count  = Convert.ToInt32(cmd.ExecuteScalar());
if(count > 0){
    //Write update code here.
}
else{
    //Write insert code here.
}

--Amit

Posted 13-Jun-13 19:59pm

_Amy

Updated 13-Jun-13 21:17pm

v2

Comments

Prasad_Kulkarni 14-Jun-13 2:06am

Oh man, you made it 6 mins before, 5'ed

_Amy 14-Jun-13 2:23am

Thank you Prasad. :)

fak_farrukh 14-Jun-13 3:10am

please now tell if imagename is already exists in database then update otherwise insert the data how will i do this???

_Amy 14-Jun-13 3:17am

See my updated answer. :)

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 14-Jun-13 3:28am

Hi Amit,

Nice answer.
One suggestion from my side.
Counting only the primary key (ID) instead of all columns (*) will be faster and is always preferred.

Thanks,
Tadit

_Amy 14-Jun-13 3:32am

Thank you! Yup. You are right.
I've given (*) because in the question OP didn't discuss about ID column. :)
--Amit

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 14-Jun-13 4:03am

Ok... Welcome. :)

fak_farrukh 14-Jun-13 3:44am

thanx it is done
but when my insert code run after pressing button of upload its shows nothing and when i again run and upload image its show the image
here is my insert code

SqlCommand cmd1 = new SqlCommand("Insert into imagePath(imagename,imgpath) values(@imagename,@imgpath)", con);
cmd1.Parameters.AddWithValue("@imagename", username);
cmd1.Parameters.AddWithValue("@imgpath", "Images/" + username);
cmd1.ExecuteNonQuery();

please tell me

_Amy 14-Jun-13 4:10am

Keep a button(say Upload), and run the code on click of upload button. It'll work.

fak_farrukh 14-Jun-13 6:08am

code is already in the button

Prasad_Kulkarni · Answer 2 · 2013-06-13T20:05:00

C#

protected void Button2_Click1(object sender, EventArgs e)
        {
            {
                string username =(string)( Session["UserAuthentication"]);
                FileUpload1.SaveAs(Server.MapPath("Images/" + username));
                string str = "Images/" + username;
                SqlConnection con = new SqlConnection(connstring);
                con.Open();
                cmd=new SqlCommand("UPDATE imagepath SET imgpath='"+str+"' WHERE imagename='"+username+"'", con);//You need to mention connection string object here with command                
               cmd.Parameters.AddWithValue(username, username);
               cmd.Parameters.AddWithValue(str, "Images/" + username);
                cmd.ExecuteNonQuery();               
                con.Close();
            }

vakativamsi · Answer 3 · 2013-06-13T20:26:00

Solution 3

Hi ,
define the connection in the query ending   "CON"
replace the below line i8n you project

cmd=new SqlCommand("UPDATE imagepath SET imgpath='"+str+"' WHERE imagename='"+username+"'",con);


Thankyou

Posted 13-Jun-13 20:26pm

vakativamsi