title: Whats wrong with this SQLCe Query?
body: <p>in the past hour i have been trying different variants of this query but i get error at the username   , and the username is just a normal string with username that i get from xml file containing no special characters or whatsoever </p>
  
  <p>I'm using SLQ compact 3.5 </p>
  
  <p>P.S i tried to use ? instead of @username also not working
  all feilds are "nchar" except "date"</p>
  
  <pre><code>                C = nodeItem["user_from"].InnerText;
                  avatar = nodeItem["user_from_avatar"].InnerText;
                  string msgText = nodeItem["message"].InnerText;
                  DateTime dt=DateTime.Now;
  
                  string sql = "INSERT INTO posts(user,msg,avatar,date) VALUES(@username,@messige,@userpic,@thedate)";
                  using (SqlCeCommand cmd = new SqlCeCommand(sql, connection))
                  {
                      cmd.Parameters.Add("@username",C);
                      cmd.Parameters.Add("@messige", msgText.ToString());
                      cmd.Parameters.Add("@userpic", avatar.ToString());
                      cmd.Parameters.Add("@thedate", dt);
                      connection.Open();
                      cmd.ExecuteNonQuery();
                      adapter.Update(data);
                      connection.Close();
                  }
  </code></pre>
  
  <p>The error msg :  <a href="https://i.stack.imgur.com/aAR8c.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/aAR8c.png" alt="alt text"></a><br>
  <sub>(source: <a href="http://clip2net.com/clip/m11962/1247582804-clip-16kb.png" rel="nofollow noreferrer">clip2net.com</a>)</sub><br>
  Thanks , 
  Nikola </p>