Passing multiple parameters to query which count number of rows
-
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. :)