Update Query with textbox3.text

Question

I'm searching info for updating the database Table named MIB.

Right now i have the update string as follow after opening the connection of the database

string update = "Update MIB set Timeout= "+this.textBox3.Text+"Where Timeout="Convert.ToString(reader.GetValue(0));

the error that is giving me is the following " The left-hand side of the an assignment must be a viaraible, property or indexer.

Arnold Petrona · Answer

I found my Problem.The Port Trap had a space between them in the database and in my query.

Arnold Petrona · Answer

It is working fine but I had to make it bigger and now it given me a problem in the update statement. i'm trying to find where the problem is but till now nothing mine update statement is as follow: string add1 = Update MIB set Timeout='+Convert.ToInt32(this.textBox1.Text)+'Port Trap='+Convert.ToInt32(this.textBox1.Text)+';

Ryan Alford · Answer

string update = Update MIB set Timeout= '  +this.textBox3.Text+  ' Where Timeout= '  + Convert.ToString(reader.GetValue(0))  ' ;