Having trouble while writing update query

Question

0.00/5 (No votes)

See more:

C#

string str1 = "update Login_Table set p_word=" + TextBox2.Text + " where user_name='" + Session["name"].ToString() + "'";

cmd = new SqlCommand();
cmd.CommandText = str1;
cmd.Connection = db.con;
cmd.ExecuteNonQuery();

I am getting error like , invalid column name. I am bad at writing queries.

Posted 15-Jun-13 19:58pm

Parth Dotnet1

Add a Solution

Comments

Surendra Adhikari SA 16-Jun-13 2:03am

error is self explaining.. i.e. you have to check for column name in Login_Table. You must match column name in your commandtext . can you give your table structure then we can update your quiry string.

Parth Dotnet1 16-Jun-13 2:08am

sure its user_name , p_word , flag

i am taking user_name value from seesion

flag is for activation of account from admin side

Surendra Adhikari SA 16-Jun-13 4:36am

its fine then.

1 solution

Add a Solution

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

Surendra Adhikari SA · Accepted Answer · 2013-06-15T20:06:00

is your password column column is numeric??
probably not. so it should be p_word='" + TextBox2.Text + "' .you have to give password in quoate as it is a string .copy and enjoy :

C#

string str1 = "update Login_Table set p_word='" + TextBox2.Text + "' where user_name='" + Session["name"].ToString() + "'";

Having trouble while writing update query

1 solution

Solution 1

Add your solution here

Preview 0

Having trouble while writing update query

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us