Through a web app designed in asp .net....on Onclick event of a button...I'm trying to take a value of a text box and update my DB table as follow:
string txt = tb.Text;
string query = "Update Jobs Set Actual = 'CONVERT(VARCHAR(8),+ txt +,8)'";
No matter what i try, I keep getting this error:
Conversion failed when converting date and/or time from character string.