How can I update a database string value from a TextBox?

Question

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...

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

if any one know the ans: reply me

I will never understand why people like to roll their questions back to poorly written sentences... — R. Martinho Fernandes
– R. Martinho Fernandes, Commented Dec 3, 2009 at 14:35
Not everyone knows or has a full grasp of the English language — Darien Ford
– Darien Ford, Commented Dec 3, 2009 at 15:22
Ahh I understand what you were saying, you edited the question to make it easier to understand, and then they rolled it back. Got it, sorry :) — Darien Ford
– Darien Ford, Commented Dec 3, 2009 at 15:24

AdaTheDev · Accepted Answer · 2009-12-03 14:37:32Z

1

I'd recommend explicitly defining the parameter type to match the type in the DB, and passing the value to Parameters.Add as the appropriate type.

e.g. at the moment, you are passing a string typed value to Parameters.Add, and not defining the type explicitly. Therefore, it will assume the data type from the type of value supplied...so the @prt1 type will be passed in to the DB as NVARCHAR I believe.

If the prt1 field is an INTEGER for example, much safer IMHO to do something like:

cmd.Parameters.Add("@prt", SqlDbType.Int,4).Value = Int32.Parse(TextBox1.Text);

or

cmd.Parameters.AddWithValue("@prt", Int32.Parse(TextBox1.Text));

I always like to fully define the type of the parameters I pass in to SQL to rule out any potential, unexpected issues.

answered Dec 3, 2009 at 14:37

AdaTheDev

148k28 gold badges215 silver badges204 bronze badges

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

Comments

Goows · Accepted Answer · 2009-12-03 14:37:33Z

1

Check the datatype for the @prt1 to see if it is a Int value because you are setting to the same column two different values.

answered Dec 3, 2009 at 14:37

Goows

8392 gold badges7 silver badges10 bronze badges

Comments

Aryapawan · Accepted Answer · 2012-02-17 08:16:02Z

1

Parse the textBox to Integer as you want to insert a numeric value i.e. Int64.Parse("Textbox1.Text"); well with string it does have problems.

answered Feb 17, 2012 at 8:16

Aryapawan

211 bronze badge

2 Comments

Aryapawan Over a year ago

or with Int32 or int.Parse("txt1.Text"); but 64 is much preferabble. . . 32 or 64 are bits, as c sharp strongly typed language so it has strict specification every datatypes

Stephen Over a year ago

you can edit your answer, rather than putting it in bits in the comment section.

Joscha · Accepted Answer · 2009-12-03 14:28:57Z

0

Just a wild guess: Does prt maybe only accept numeric values?

answered Dec 3, 2009 at 14:28

Joscha

4,6931 gold badge31 silver badges35 bronze badges

Collectives™ on Stack Overflow

How can I update a database string value from a TextBox?

4 Answers 4

Comments

Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related