How can I update a database string value from a TextBox?
<p>I cant update my database through textbox.in the case of numeric value i can update but cant with a string value.
my coding is...</p>

<pre><code>SqlCommand cmdup= new SqlCommand("UPDATE [port1] SET [prt1]=@prt1 WHERE [no]= 1",cn);
cmdup.Parameters.Add("@prt1", TextBox1.Text);  
cmdup.ExecuteNonQuery();
</code></pre>

<p>if any one know the ans: reply me</p>
