Re: Where clause in DataTable.Select method

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

From: Marina (someone_at_nospam.com)
Date: 02/22/05 

Date: Tue, 22 Feb 2005 11:14:46 -0500

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" <forum@DotNetMonster.com> wrote in
message news:5af17f8afea84a6082ef548cd95a885d@DotNetMonster.com...
> 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

Relevant Pages

  • Re: deleting duplicates
    ... There is none (but see below form some kludges). ... then any WHERE clause that matches one will match the other as ... (Column1 int NOT NULL, ... FROM MyTableTMP ...
    (microsoft.public.sqlserver.mseq)
  • Re: Copy Row Of Data From Table to Table In Same DB
    ... The syntax error is because of the commas in the WHERE clause. ... conditions in the WHERE clause are logical expressions and you have to use ... SELECT column1, ... procedure and the purpose of passing those column parameters. ...
    (comp.databases.ms-sqlserver)