tdignan87
Well-known member
- Joined
- Jul 8, 2019
- Messages
- 95
- Programming Experience
- Beginner
Hi Guys,
Hope someone can help me out here.
I have this query here that works OK if i hardcode the value from the textbox into the query, otherwise i get this error? Here is the code. Any ideas?
This works perfect
if i remove the 'DisplayMixSize' as that should be value in textbox the code breaks,
This breaks
Added a breakpoint and the value is in the Txtbox
Hope someone can help me out here.
I have this query here that works OK if i hardcode the value from the textbox into the query, otherwise i get this error? Here is the code. Any ideas?
This works perfect
C#:
String delete_jobs = db.Query<String>("UPDATE CONFIGD SET CONFIGD.KEYVALUE = " + valueTxtBox.Text + " WHERE CONFIGD.KEYNAME = 'DisplayMixSize' and CONFIGD.SECTIONNAME = 'ProcessOptions' ").FirstOrDefault();
if i remove the 'DisplayMixSize' as that should be value in textbox the code breaks,
This breaks
C#:
String delete_jobs = db.Query<String>("UPDATE CONFIGD SET CONFIGD.KEYVALUE = " + valueTxtBox.Text + " WHERE CONFIGD.KEYNAME = " + keyNameTxtBox.Text + " and CONFIGD.SECTIONNAME = 'ProcessOptions' ").FirstOrDefault();
Added a breakpoint and the value is in the Txtbox