tags:

views:

223

answers:

1
Q: 

Using Sql 'In' Operator within .NET 2.0 DataTable Filter expression.

Does the .NET 2.0 Framework DataTable filterexperssion property support the SQL "IN" operator? If you have a solution to this please provide example code. Thank you.

A: 

The RowFilter property of a DataView doesn't support SQL in any way. Is this what you were referring to?

John Saunders  2009-07-02 00:24:36

related questions

Best way to get a comma delineated string into xml format?
Table NewRow() Causes Memory Leak
Querying DataColumnCollection with LINQ
Compare datatables
.NET DataTable skips rows on Load(DataReader)
OOP and DataTables for Rank Amateurs
"Endless scrolling" effect in a HTML table
How do you convert a DataTable into a generic list?
How do I display only certain columns from a data table?
Getting Count from Grouped DataTable in VB via Linq
DataTable + DataGrid Data Binding Performance Againsts Custom Data Source Object + Data Grid
.NET Fastest way to iterate through rows in a datatable?
Cast or convert when retrieving data from a database?
How can I make a globally accessible datatable in a Winforms application?
DataGridView's bound table only generates one RowChanged event on a double-click. How do I make it do two?
Abstracting storage data structures within XPath
Speed of DataSet row/column lookups?
How do I bind the result of DataTable.Select() to a ListBox control?
How many DataTable objects should I use in my C# app?
Trigger update on DataTable bound to DataGridView
DataTable to readable text string
.Net - Returning DataTables in WCF
Datatables, Dataviews and distincts! (ASP.Net/VB)
Datatable vs Dataset
Check for changes to a SQL table?