Hello,
I will select DataRow from DataTable,
but my filter-expression is not OK.
myDataTable.Select("place = 'La Tour d'Auvergne'");
That does not work, because place includes the apostrophe.
What can I do
Please, help me.
Filter-expression
Hot Topic
- WSE 'Bad Key' Exception
- Cannot get a datasource other than SQL/SQLExpress to work with parameters
- How can I build a 3-tiers application using VC# Express Edition
- SSL on TCP Socket, how in .NET 1.1?
- COM connection point events failing to cross the COM interop boundary
- Connection to a SQL Server Database with mixed authentication
- serialize an exception
- Combobox - ChangeValue status (Possible or NOT)
- AppDomain and PrivateBinPath
- ConfigurationManager, WebConfigurationManager and class libraries
.NET Development
- Determining hidden members via reflection.
- How to trace time for FTP Upload
- Databinding change between FW 1.1 and 2.0?
- aspnet_compiler.exe from within VS2005
- DB Changes not committed in VS/SQL Server DB
- Value of first parameter to Stored proc always goes as a blank.
- Possible to Cast from String representation of Type?
- representing XmlElement
- Com+ Error
- Problem in DateTime Serialization
Filter-expression
JochenS
that was helpful.
KBeBo
myDataTable.Select("place =" & Criteria);
njohe
"place =" &
ControlChars.Quote & "La Tour d'Auvergne" & ControlChars.QuoteI would use the quotes vs the apostrophe just to make sure!!!
Pavel S. Kozlov
Replace the single apostrophe in the value with two apostrophes (not a single double-quote character):
"place = 'La Tour d''Auvergne'"
This is the same syntax that most databases use in queries.
I hope this information proves helpful.
David Sceppa
ADO.NET Program Manager
Microsoft