Hi, I'm trying to write a select statement in C# based on the value from my dropdownlist.
I set a breakpoint in my code and the output displays a double quote at the end:
sqltext "select nameoffile from FileViewer where category ='US Corrugated Capabilities'" string
How would I get rid of that double quote and replace it with a single quote?
string sqltext = "select nameoffile from FileViewer where category =" + "'" + GroupDDL.SelectedItem.Text + "'";