SQL update is not working in asp.net with C#

Question

I wanted to update the cell of the table, but when I did that by writing this code, the table does not get updated and there was no any exceptions or any errors:

protected void btn_Click(object sender, EventArgs e)
{
    using(SqlConnection con = new SqlConnection("My connection string"))
    {
        SqlCommand command = new SqlCommand("UPDATE [Tablename] SET [notes]=@notes WHERE [ID]=@ID", con);
        command.Parameters.AddWithValue("@ID", this.ID);
        command.Parameters.AddWithValue("@notes", TextBox1.Text);

        con.Open();
        command.ExecuteNonQuery();
        con.Close();
    }
}

When I pass the value of "@notes" by myself it works, but when pass the value of "@notes" TextBox1.Text it is not working. Can someone explain me why?

Note: TextBox1.TextMode is Multiline

What is the value of TextBox1.Text exactly? And using con.Close() is redundant. using statement will handle that. — Soner Gönül
– Soner Gönül, Commented Mar 2, 2014 at 14:59
the value of TextBox1.Text is any type of text like "hello world and etc etc" — r.mirzojonov
– r.mirzojonov, Commented Mar 2, 2014 at 15:00
Usual reason is there's something wrong with ID. PS con.close is unnecessary. — Tony Hopkinson
– Tony Hopkinson, Commented Mar 2, 2014 at 15:02
Or on occasion the db you think your are connected to isn't the one you are connected to. — Tony Hopkinson
– Tony Hopkinson, Commented Mar 2, 2014 at 15:03
No errors = id doesn't exist, or no change to notes. That's it. int rowsAffected = command.ExecuteNonQuery() might tell you something. — Tony Hopkinson
– Tony Hopkinson, Commented Mar 2, 2014 at 15:07

r.mirzojonov · Accepted Answer · 2014-03-02 15:45:52Z

2

Thanks to all of you. That was my fault, I've tried to do what @Tony Hopkinson said in the comment and I get the value of 1(that meant everything is going good). The problem was in Page_Load function, I've changed it:

protected void Page_Load(object sender, EventArgs e)
{
    TextBox1.Text = info;
}

To this and everything worked:

protected void Page_Load(object sender, EventArgs e)
{
    if(!IsPostBack)
    {
        TextBox1.Text = info;
    }  
}

Then I've checked the table the value was updated. One more time thanks to all of you...))

answered Mar 2, 2014 at 15:45

r.mirzojonov

1,23911 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Oscar Bralo · Accepted Answer · 2014-03-02 15:07:01Z

1

I recommend to save the "notes" textBox1 in a string. If it´s multiline use something like String.Join, and then pass the string as the parameter ;) It will works!

BTW.. It´s not neccessary to close the connection with the using SqlConnection, because it will Dispose by itself! ;)

answered Mar 2, 2014 at 15:07

Oscar Bralo

1,90713 silver badges12 bronze badges

Collectives™ on Stack Overflow

SQL update is not working in asp.net with C#

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related