Trying To Add Info To Database Using A Stored Procedure

Hi there :)





I was hoping someone could help me figure out why this doesn't work....





I have a class called ProductsDB with a method called AddProduct that looks like this:








public String AddProduct(int categoryID, int makeID, string name, double price, double saleprice, double offerprice, int homepage, string thumbpath, string imagepath, string description)


{


// Create Instance of Connection and Command Object


SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);


SqlCommand myCommand = new SqlCommand("ProductsAdd", myConnection);





// Mark the Command as a SPROC


myCommand.CommandType = CommandType.StoredProcedure;





// Add Parameters to SPROC


SqlParameter parameterCategoryID = new SqlParameter("@CategoryID", SqlDbType.Int, 4);


parameterCategoryID.Value = categoryID;


myCommand.Parameters.Add(parameterCategoryID);





SqlParameter parameterMakeID = new SqlParameter("@MakeID", SqlDbType.Int, 4);


parameterMakeID.Value = makeID;


myCommand.Parameters.Add(parameterMakeID);





SqlParameter parameterName = new SqlParameter("@Name", SqlDbType.NVarChar, 50);


parameterName.Value = name;


myCommand.Parameters.Add(parameterName);





SqlParameter parameterPrice = new SqlParameter("@Price", SqlDbType.Money, 8);


parameterPrice.Value = price;


myCommand.Parameters.Add(parameterPrice);





SqlParameter parameterSalePrice = new SqlParameter("@SalePrice", SqlDbType.Money, 8);


parameterSalePrice.Value = saleprice;


myCommand.Parameters.Add(parameterSalePrice);





SqlParameter parameterOfferPrice = new SqlParameter("@OfferPrice", SqlDbType.Money, 8);


parameterOfferPrice.Value = offerprice;


myCommand.Parameters.Add(parameterOfferPrice);





SqlParameter parameterHomepage = new SqlParameter("@Homepage", SqlDbType.Bit, 1);


parameterHomepage.Value = homepage;


myCommand.Parameters.Add(parameterHomepage);





SqlParameter parameterThumbnail = new SqlParameter("@Thumbnail", SqlDbType.NVarChar, 50);


parameterThumbnail.Value = thumbpath;


myCommand.Parameters.Add(parameterThumbnail);





SqlParameter parameterImage = new SqlParameter("@Image", SqlDbType.NVarChar, 50);


parameterImage.Value = imagepath;


myCommand.Parameters.Add(parameterImage);





SqlParameter parameterProductID = new SqlParameter("@ProductID", SqlDbType.Int, 4);


parameterProductID.Direction = ParameterDirection.Output;


myCommand.Parameters.Add(parameterProductID);





try


{


myConnection.Open();


myCommand.ExecuteNonQuery();


myConnection.Close();





// Calculate the ProductID using Output Param from SPROC


int productId = (int)parameterProductID.Value;





return productId.ToString();


}


catch


{


return String.Empty;


}


}











And then in another cs file for my aspx page I have an event handler for an add button in a webform, which looks like this:








// Add New Product to ProductDB database


bikescene.Components.ProductsDB accountSystem = new bikescene.Components.ProductsDB();


String productId = accountSystem.AddProduct(Int32.Parse(DDLproductcategory.SelectedValue), Int32.Parse(DDLproductmanufacturer.SelectedValue), TBproductname.Text, Double.Parse(TBproductprice.Text), Double.Parse(TBproductsaleprice.Text), Double.Parse(TBproductofferprice.Text), Int32.Parse(DDLproducthomepage.SelectedValue), thumbnailpath, imagepath, TBproductdescription.Text);








And finally, here is my stored procedure:








CREATE Procedure ProductsAdd


(


@ProductID int,


@CategoryID int,


@MakeID int,


@Name nvarchar(50),


@Price money,


@SalePrice money,


@OfferPrice money,


@Homepage int,


@Thumbnail nvarchar(50),


@Image nvarchar(50),


@Description nvarchar(500)


)


AS





INSERT INTO Products


(


productID,


categoryID,


makeID,


name,


price,


saleprice,


offerprice,


homepage,


thumbpath,


imagepath,


description


)


VALUES


(


@ProductID,


@CategoryID,


@MakeID,


@Name,


@Price,


@SalePrice,


@OfferPrice,


@Homepage,


@Thumbnail,


@Image,


@Description


)





SELECT


@ProductID = @@Identity


GO








Basically, my images are uploaded to the server just fine but nothing is being added to the database + I don't get any error messages.





Any ideas?





Many thanks indeed :)