Update SQL entry using textbox values on button click event using C# WPF

Question

I have a WPF form with a button.

There is a textbox under the button and I want the .text to go into a list box

"Not performing the desired result"? Your SQL doesn't look valid. What is the current result? Does the app crash / throw an exception? — Brendan Green
– Brendan Green, Commented Mar 15, 2017 at 23:54
You should really consider databinding that textbox text if its a permanent feature of this app you are writing. — Chris Watts
– Chris Watts, Commented Mar 15, 2017 at 23:56

mendosi · Accepted Answer · 2017-03-15 23:58:55Z

2

The syntax for your update command should be something like this, note that you haven't mentioned the name of the table in the database which is storing the data, so I've just called it ButtonTable:

...
cmd.CommandText = "UPDATE [ButtonTable] SET [TimesClicked] = @nm WHERE [ButtonName] = @buttonName;";
cmd.Parameters.Add("@buttonName", SqlDbType.VarChar, 100).Value = "Button1";
cmd.Parameters.Add("@nm", SqlDbType.Int).Value = textBox1.Text;
...

Also, I recommend specifying the type of your parameters as in the above sample.

edited Mar 15, 2017 at 23:58

answered Mar 15, 2017 at 23:52

mendosi

2,0611 gold badge14 silver badges18 bronze badges

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

1 Comment

Brendan Green Over a year ago

If we're going to use a parameter for TimesClicked, we should also use one for ButtonName.

Collectives™ on Stack Overflow

Update SQL entry using textbox values on button click event using C# WPF

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related