المساعد الشخصي الرقمي

مشاهدة النسخة كاملة : Passing multiple parameters to query which counts number of rows in C#



C# Programming
04-04-2009, 09:40 AM
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.