title: how to save string variable with apostrophe using .net
body: <p>I have a query like this:</p>
  
  <pre><code>sql = "Select * From T_ExhibitorLocation 
          where F_ExhibitionCode='" &amp; Cmb_Exhibition.SelectedValue.ToString &amp; "' 
            and F_ExhibitorCode='" &amp; Trim(Txt_ExhibitorID.Text) &amp; "' 
            and F_Site='" &amp; cmb_Site.SelectedValue.ToString &amp;` "'"
  </code></pre>
  
  <p>Some time my F_site name come with apostrophe,
  example like this  <strong><code>'Artist's Shell'</code></strong>. So this time how I can save this name with apostrophe ?? thanks in advance</p>