Appropriate C# command for ADO.NET SQlite when implementing COUNT() query

Posted by Soham on Stack Overflow See other posts from Stack Overflow or by Soham
Published on 2010-04-16T12:58:42Z Indexed on 2010/04/16 13:03 UTC
Read the original article Hit count: 286

Filed under:
|

Hi All,

Consider this command, as written here:

Command.CommandText = "SELECT COUNT(ASSET) AS POSEXISTS FROM POSITIONS WHERE ASSET = @ASSET";
        Command.Parameters.Add("@ASSET",DbType.String).Value = Symbol;

So here, how should I execute this query so that, I can receive the POSEXISTS variable in the C# environment.

Soham

© Stack Overflow or respective owner

Related posts about c#

Related posts about sqlite3