Select where in

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Is there a way to select to find multiple conditions?

I.e., in SQL, you can typically SELECT from myTable where someColumn in
('x','y','z')
instead of passing in explicit strings, I'd like to pass in an array of
values, is this possible, i.e., perhaps just a single column as a dataview?

Can a nested select be used as can be used in SQL?

I haven't seen may in-depth Datatable.Select examples that demonstrate such
functionality... if they are out there, please point the way!

Thx,
MS


.

Relevant Pages

  • Re: .net VS 05 HELL!
    ... > Perhaps the control is passing NULL and not DBNULL. ... I have my SQL that has LIKE in the where clause, ... >>> query ... >>> grid ...
    (microsoft.public.dotnet.framework.aspnet)
  • updating a SQL database from a multiple selection listbox
    ... Can anyone tell me what is the best approach for passing multiple keys ... I am using asp.net 2.0 and SQL 2000, ... a cooler way to do it, like passing some custom array object to the sp, ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Using date in SQL Server.
    ... Assuming your host language supports a date/time datatype and some method of ... aware of for passing date parameters is using the ADO Parameter object where ... SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: updating a SQL database from a multiple selection listbox
    ... Thanks to SQL Server's XML support, ... delimited-string idea and proceed using XML. ... Can anyone tell me what is the best approach for passing multiple keys ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: updating a SQL database from a multiple selection listbox
    ... Thanks to SQL Server's XML support, ... delimited-string idea and proceed using XML. ... Can anyone tell me what is the best approach for passing multiple keys ...
    (microsoft.public.dotnet.framework.aspnet)