Saving Data to Access Database with Escape Character RSS

• • Reply
  

  khurj01

  Member

  25 Points

  269 Posts

  Saving Data to Access Database with Escape Character

  Jan 22, 2013 06:31 PM|LINK

  How do I save an Access database field containing "\" (e.g. MS\JDOE) in C#?

  • Edited by khurj01 on Jan 22, 2013 06:35 PM
  • Moved by Mikesdotnetting on Jan 22, 2013 09:35 PM
• • Reply
  

  Mikesdotnett...

  All-Star

  155645 Points

  19985 Posts

  Moderator

  MVP

  Re: Saving Data to Access Database with Escape Character

  Jan 22, 2013 09:33 PM|LINK

  Use parameters: http://www.mikesdotnetting.com/Article/26/Parameter-Queries-in-ASP.NET-with-MS-Access

  var SqlString = "Insert Into MyTable (MyField) Values (?)";
  using (OleDbConnection conn = new OleDbConnection(ConnString))
  {
    using (OleDbCommand cmd = new OleDbCommand(SqlString, conn))
    {
      cmd.CommandType = CommandType.Text;
      cmd.Parameters.AddWithValue("", @"MS\JDOE");
      conn.Open();
      cmd.ExecuteNonQuery();
    }
  }

  As far as dealing with the string itself is concerned, you can either escape the \ by doubling it

  var input = "MS\\JDOE";

  or use the @ character to denote a literal string:

  var input = @"MS\JDOE";

  
  
  
  

  Regards, Mike
  Web Pages CMS | My Site | Twitter
  • Marked as answer by decker dong - msft on Jan 28, 2013 01:20 AM