I am getting a "Divide by Zero Error Encountered" when I run my ASP.NET application. The error looks like is encountered when filling DataSet.
I have a GridView on frontpage that is configured to get data from a Dataset which uses Stored Procedure to get data. The SP runs perfectly when I run in SQL Server but I don't know why is it throwing an error when I run from ASP.NET.
Any help is really appreciated.
I am attaching some images below to give more information:
Image of Default.aspx page and DataSet
http://www.fiu.edu/~atmakurk/ustrade...lt_DataSet.jpg
Image of Error
http://www.fiu.edu/~atmakurk/ustrade/Error.jpg
Image of Stored Procedure Code
http://www.fiu.edu/~atmakurk/ustrade/SP.jpg
Image of Output when Stored Procedure is executed in SQL Server
http://www.fiu.edu/~atmakurk/ustrade/SP_RUN.jpg
(I have noticed that when stored procedure is executed in SQL server, it returns a Value '0' in a second table. I am don't know why is "DECLARE @return_value int" and "SELECT 'Return Value' = @return_value" are created in the Stored Procedure when I created SP.