Just curious how I would include a WHERE clause in the filter string of the
Select method.

If I want to SELECT * FROM Column1 WHERE Column2 = SomeValue

thanks

--
Message posted via http://www.dotnetmonster.com

What does 'From Column1' mean? You can't select from columns, only from
tables. And the table is always going to be the DataTable you are calling
the Select method on.

So the WHERE clause you have in the statement is already what you need.


"Matthew Towpik via DotNetMonster.com" <(E-Mail Removed)> wrote in
message news:(E-Mail Removed)...
> Just curious how I would include a WHERE clause in the filter string of
> the
> Select method.
>
> If I want to SELECT * FROM Column1 WHERE Column2 = SomeValue
>
> thanks
>
> --
> Message posted via http://www.dotnetmonster.com

you can only select from a DataTable, and the expression passed to Select
would be the WHERE clause

myTable.Select("Column1 > 0 AND Column2 = 'Somevalue' ");

--
This posting is provided "AS IS", with no warranties, and confers no rights.
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.





"Matthew Towpik via DotNetMonster.com" <(E-Mail Removed)> wrote in
message news:(E-Mail Removed)...
> Just curious how I would include a WHERE clause in the filter string of
> the
> Select method.
>
> If I want to SELECT * FROM Column1 WHERE Column2 = SomeValue
>
> thanks
>
> --
> Message posted via http://www.dotnetmonster.com