Select Statement

Question

User-797751191 posted

Hi

  Is the below Statement correct

using (SqlCommand cmd = new SqlCommand("SELECT Count(*) FROM [Test] Where [Invoice No]=@InvoiceNo and [Location] = @Store and [Status] in ('','Pending')", con))

Thanks

Answer 1

User753101303 posted

Hi,

Yes it is syntactically correct. If you have a problem when running this statement it would be easier to directly discuss the problem you have (which error message and on which line).

Answer 2

User61956409 posted

Hi jsshivalik,

Your query accept parameters in the WHERE clause, to execute the SqlCommand you defined as expected, you need to add and supply parameters.

https://docs.microsoft.com/en-us/dotnet/api/system.data.sqlclient.sqlcommand.parameters?view=netframework-4.8

With Regards,

Fei Han