调用存储过程没做用？？？帮忙看看代码

[hang51]

SqlConnection con = new Bind().Getcon();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "sale_put_reckon_all";
cmd.Connection = con;
SqlParameter parshopid = new SqlParameter("@shopid", System.Data.SqlDbType.Char, 5);
parshopid.Direction = ParameterDirection.Input;
cmd.Parameters.Add(parshopid);
SqlParameter parselldate = new SqlParameter("@selldate", System.Data.SqlDbType.DateTime, 8);
parselldate.Direction = ParameterDirection.Input;
cmd.Parameters.Add(parselldate);
parshopid.Value = Session["depart"].ToString();
parselldate.Value = Convert.ToDateTime(selldateStr);
cmd.ExecuteNonQuery();

运行后存储过程没执行，也没有提示出错。。。。

[boyi_yan]

你看出啥来了吗？我是没看出来！
描述清楚点！

[badtank]

SqlConnection con = new Bind().Getcon();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "sale_put_reckon_all";
cmd.Connection = con;
SqlParameter parshopid = new SqlParameter("@shopid", System.Data.SqlDbType.Char, 5);
parshopid.Direction = ParameterDirection.Input;
parshopid.Value = Session["depart"].ToString();
cmd.Parameters.Add(parshopid);
SqlParameter parselldate = new SqlParameter("@selldate", System.Data.SqlDbType.DateTime, 8);
parselldate.Direction = ParameterDirection.Input;
parselldate.Value = Convert.ToDateTime(selldateStr);
cmd.Parameters.Add(parselldate);

cmd.ExecuteNonQuery();

还不行就开起来SQL Profiler来监视运行结果。