Problem in updating database table in asp.net using c#
<p>I want to update Basic table in my database but it doesn't generate any effect in table.<br>
I am using following statement</p>

<pre><code>sql ="UPDATE Basic SET Current_city='"+ TextBox1.Text +"',Home_Town='"+ TextBox2.Text +"';
SqlCommand cmd = new SqlCommand(sql, con);
cmd.ExecuteNonQuery();
</code></pre>
