找不到存储过程

Question

 数据库的存储过程是这样的  ALTER procedure [dbo].[sp_AddGenerator](@name char(20),@picture char(50),@picturetwo char (50),@content char(500))
as
begin 
 insert  Products(name,picture,picturetwo,Content)
values(@name ,@picture ,@picturetwo ,@Content)
end
数据层的是
   public static Products AddProducts(Products gen)
        {
            string sql = "insert Products(name,picture,picturetwo,Content)"+"values(@name ,@picture ,@picturetwo,@Content)";            try
            {
                SqlParameter[] para = new SqlParameter[]
           {
          
            new SqlParameter("@name",gen.Name),
               new SqlParameter("@picture",gen.Picture),
                  new SqlParameter("@picturetwo",gen.Picturetwo),
                   new SqlParameter("@Content",gen.Content)
           };
               
                int Id = DBHelper.GetScalar(sql, para);
                return GetGeneratorById(Id);            }
            catch (Exception e)
            {
                Console.WriteLine(e.Message);
                throw e;
            
            }
   }    请问到底哪里错了啊   

Answer 1

   这个方法是查询方法吧int Id = DBHelper.GetScalar(sql, para);
而你那个是insert方法。

Answer 2

 public static void AddProducts(Products gen)
        {
            string sql = "insert Products(ProductsId,name,picture,picturetwo,Content)" + "values(@ProductsId,@name ,@picture ,@picturetwo,@Content)";                SqlParameter[] para = new SqlParameter[]
           {
          new SqlParameter("@ProductsId",gen.ProductsId),
            new SqlParameter("@name",gen.Name),
               new SqlParameter("@picture",gen.Picture),
                  new SqlParameter("@picturetwo",gen.Picturetwo),
                   new SqlParameter("@Content",gen.Content)
           };                DBHelper.ExecuteCommand(sql, para);          
   }    换成这样了   还是找不到存储过程

Answer 3

请问你在哪儿 调用了这个存储过程啊。sp_AddGenerator

Answer 4

恩   我在数据库写了个存储过程啊    然后我运行 这个方法的时候    就说找不到存储过程了    
System.Data.SqlClient.SqlException: 找不到存储过程 'insert Products(ProductsId,name,picture,picturetwo,Content)values(@ProductsId,@name ,@picture ,@picturetwo,@Content)'。      我比较菜鸟 帮我看下