title: Ignore single quote in C#
body: <p>In my program I have this statment 
  ......</p>
  
  <pre><code>ct = String.Format(@"select [Movie Selector] from WSTMDS3
              natural prediction join 
              (select
  
               '{0}'as[Age],
              '{1}'as[Education Level],
              '{2}'as[Gender],
              '{3}'as[Home Ownership],
              '{4}'as[Internet Connection],
              '{5}'as[Marital Status]
  
              )as MovieSelector",
               TextBox1.Text,
               DropDownList1.SelectedValue,
               DropDownList2.SelectedValue,
               DropDownList3.SelectedValue,
               DropDownList4.SelectedValue,
               DropDownList5.SelectedValue)
                  ;
  </code></pre>
  
  <p>But in DropDown list1 "Education Level " 
  I have some value like this Master' Degree
  how i can use the single quote ' in this statment .</p>
  
  <p>thanks</p>