Update sql-command string from c# ExecuteNonQuery();

Question

App works but UPDATE through WPF does not work

string sqlIns = "UPDATE Team_table SET result1 = '4:2' where name1=@Team1 and name2=@Team1";    
string Team1_string = Team1.Text;

// Team1, Team2, result1, result2 is the name of TextBox controls

cmdIns.Parameters.AddWithValue("@Team1", Team1_string);
string Team2_string = Team2.Text;
cmdIns.Parameters.AddWithValue("@Team2", Team2_string);
string result1_string = Result1.Text;
cmdIns.Parameters.AddWithValue("@result1", result1_string);

How to do it work?

Are you sure you don't a mistake between "@Team1" and "@Team2", "@result1". Your update command string contains one parameters : "@Team1". Check your code. — tdelepine
– tdelepine, Commented Nov 2, 2013 at 16:47
"Nice" names for variables, they driving me crazy. Especially, this one - TTKZS. Also, why don't use using for disposables? — Dennis
– Dennis, Commented Nov 2, 2013 at 16:48
No, there no mistake and ther is always hhconn. No ttkzs. )) This is from the past — streamc
– streamc, Commented Nov 3, 2013 at 7:35

Scott Chamberlain · Accepted Answer · 2013-11-02 16:53:11Z

3

Unless you are updating the rows when teams play themselves the error is from:

name1=@Team1 and name2=@Team1

I am fairly cofident you ment for that to be

name1=@Team1 and name2=@Team2

answered Nov 2, 2013 at 16:53

Scott Chamberlain

128k37 gold badges299 silver badges448 bronze badges

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

5 Comments

Sudhakar Tillapudi Over a year ago

I Agree With you. Great Point :)

Sudhakar Tillapudi Over a year ago

:) Great I'm just waiting for the one who asked this Question.Okay let me do it.

streamc Over a year ago

But in SQL SERVER this works. For ex: UPDATE Team_table SET result1 = '6:2' where name1='Team1' and name2='Team2'

streamc Over a year ago

How to do it thhrough WPFTextbox via C#?

Scott Chamberlain Over a year ago

You made a typo, just fix it like I showed you, just replace name2=@Team1 with name2=@Team2 in the string sqlIns and it will work.

Sudhakar Tillapudi · Accepted Answer · 2013-11-02 16:43:16Z

1

You are not setting connection string to SqlConnection Object properly

Replace this :

SqlConnection con = new SqlConnection(TTKZS);

with following :

 SqlConnection con = new SqlConnection(hhconn);

answered Nov 2, 2013 at 16:43

Sudhakar Tillapudi

26.3k5 gold badges43 silver badges70 bronze badges

1 Comment

streamc Over a year ago

Yes, I see, i remade connection when post this message. Error is not from this. Sorry

Collectives™ on Stack Overflow

Update sql-command string from c# ExecuteNonQuery();

2 Answers 2

5 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related