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
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