hidden field value not updating in mysql database

Question

0.00/5 (No votes)

See more:

HTML

if (con.State.ToString() == "Open")
        {
            MySqlCommand cmd = new MySqlCommand("insert into discussion values(@g,@h,@i,@j)", con);
            
                cmd.Parameters.AddWithValue("@g",Session["user"]);
                cmd.Parameters.AddWithValue("@h", TextBox3.Text);
                cmd.Parameters.AddWithValue("@i", TextBox1.Text);
                cmd.Parameters.AddWithValue("@j", TextBox2.Text);
                MySqlCommand cmdd = new MySqlCommand("UPDATE users SET points=@k WHERE user_name=@userName", con);
                cmd.Parameters.AddWithValue("@k", HiddenField1.Value);
                cmd.Parameters.AddWithValue("@userName", Session["user"].ToString());
                cmd.ExecuteNonQuery();
                Response.Redirect("~\\show.aspx");

i want to increase the points value every time user he click the button above code is not working please help me

Posted 17-Aug-14 0:20am

ben.josey

Add a Solution

1 solution

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)

Dilan Shaminda · Accepted Answer · 2014-08-17T01:01:00

Solution 1

The problem is you are using wrong MySqlCommand object when setting parameters for cmdd.
These two lines

C#

cmd.Parameters.AddWithValue("@k", HiddenField1.Value);
cmd.Parameters.AddWithValue("@userName", Session["user"].ToString());

should be corrected as

C#

cmdd.Parameters.AddWithValue("@k", HiddenField1.Value);
cmdd.Parameters.AddWithValue("@userName", Session["user"].ToString());

Also you have forgotten this line too

C#

cmdd.ExecuteNonQuery();

Hope this will help to you :-)

Posted 17-Aug-14 1:01am

Dilan Shaminda

Comments

ben.josey 17-Aug-14 7:37am

dude i tried your code but it not helped me

[no name] 17-Aug-14 8:26am

Whoa "dude" try not to load us down with so much useful information. "Not working" and "not helped" convey so much information to us that it just boggles the mind. Rewrite your code so that it makes sense and you would see the problem for yourself.

Dilan Shaminda 17-Aug-14 8:40am

is there any exception you are getting?

ben.josey 17-Aug-14 8:47am

dude no exception no errors but the values are not updating in db.

Dilan Shaminda 17-Aug-14 8:49am

then debug your code and check the value you are passing to @k parameter