.NET, SQL and apostrophes

  • Thread starter Thread starter Chris Huddle
  • Start date Start date
C

Chris Huddle

Normally, if you have a value in a SQL statement that contains an
apostrophe, you replace the ' with a ''. But how do you handle it in VB.NET
if you are using a DataAdapter? The SQL statements are created on the fly
by the commandbuilder and there's no way to replace the apostrophe. Surely
Microsoft has a way around this. Thanks! - Chris
 
Back
Top