Passing multiple parameters to query which counts number of rows in C#

[Deepali Khalkar]

SqlCeCommand cmd = new SqlCeCommand("select count(*) from diet where uname=@uname,day=@dy,month=@mnth,year=@yr", conn); cmd.Connection = conn; SqlCeParameter para = new SqlCeParameter(); para.ParameterName = "@uname" para.Value = uname; cmd.Parameters.Add(para); SqlCeParameter para12 = new SqlCeParameter(); para12.ParameterName = "@dy" para12.Value = dy1; cmd.Parameters.Add(para12); SqlCeParameter para13 = new SqlCeParameter(); para13.ParameterName = "@mnth"; para13.Value = mnth; cmd.Parameters.Add(para13); SqlCeParameter para4 = new SqlCeParameter(); para4.ParameterName = "@yr"; para4.Value = yer1; cmd.Parameters.Add(para4); count = System.Convert.ToInt32(cmd.ExecuteScalar().ToString()); I have tried this code but getting an exception- An error parsing the query. How to pass multiple parameters to the query which counts the rows from a table? Please help. Thanks in advance.

[Lost User]

What database are you using?

select count(*) from diet where uname=@uname,day=@dy,month=@mnth,year=@yr

try instead;

select count(*) from diet where uname=@uname AND day=@dy AND month=@mnth AND year=@yr

If your where-clause is built from multiple filters, use the AND keyword to concatenate them.

I are troll :)