title: How to remove single quote in C#'s SQL query string?
body: <p>In C#.net, I'm trying to pass the radiobutton's selected value into SQL's SELECT statement. This string is a part of my code that can export my values to Excel.</p>
  
  <pre><code>string whitespace_1 = " ";
  
  strQuery1 += " SELECT TOP 1 ";
  strQuery1 += "'" + RadioButtonList_ReportOption.SelectedValue + "'";
  strQuery1 += "'" + whitespace_1 + "'";
  strQuery1 += "'" + RadioButtonList_ReportType.SelectedValue + "'";
  strQuery1 += "AS [Item Movement Report]";
  </code></pre>
  
  <p>How do I properly get rid of the single quotes between the Items and Summary?
  Thanks</p>
  
  <p>current:</p>
  
  <p><img src="https://i.stack.imgur.com/eyRhv.jpg" alt="enter image description here"></p>
  
  <p>Want to look like this:</p>
  
  <p><img src="https://i.stack.imgur.com/JRKg4.jpg" alt="enter image description here"></p>