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