title: insert text into sql table
body: <p>when i insert a text into a table in sql server, rows didn't show text and show ??????</p>
  
  <p>i know with blow code can correct it:</p>
  
  <pre><code>INSERT [dbo].[TableName] (CityName,latitude,longitude)
  VALUES (N'txt',34,56) 
  </code></pre>
  
  <p>but i use this code for insert : </p>
  
  <pre><code>INSERT INTO [dbo].[TableName]
  VALUES (@CityName,@latitude,@longitude)
  
  sqlcmd.Parameters.Add("@CityName",SqlDbType.VarChar);
  sqlcmd.Parameters.Add("@latitude", SqlDbType.Int);
  sqlcmd.Parameters.Add("@longitude", SqlDbType.Int);
  </code></pre>
  
  <p>what can i do ? </p>
  
  <p>thanks</p>