Divide By zero Error

Question

Hi i am trying to do the following calculation but I get an error satating 'divide by error encountered'

SELECT        Customer1, QtyRefunded, Year, Month, QtySales, CAST(SUM(QtyRefunded) * 1000000 / SUM(QtySales) AS DECIMAL(9, 2)) AS PPM
FROM            dbo.[Refunds&ShippedJoin]
GROUP BY Customer1, QtyRefunded, Year, Month, QtySales

I pressume it is becuase I am dividing a number by 0, however I don't know how to ressolve this error.
Thank you for your help in advance.

Answer 1

what is the access modifier of your GetProducts() method? Make sure it's public and not protected.

Answer 2

I re did it. All is ok but it shows error for GridView1.DataSource = productsAdapter.GetProducts();

 

It says GetProducts () is not accessible. I have added the method GetProducts () in TypedDataset but it doesn't work.

Answer 3

You may need to recreate your web form again and grab a new GridView control from the toolbox. This could sometimes happen if you directly copy and pasted codes/html in your code behind in which the designer cannot register the controls for you. 

 

So try generate back your page and then step back through the article you referred. 

Answer 4

Yes I did use the ID GridView1 in aspx.cs but still it's showing the same error . Also I did what u suggested but now the method GetProducts() shows error and says it is not accessible due to protection level.

Answer 5

In the first error make sure that you have a GridView control in your ASPX.CS file with ID "GridView1"

 

In your second error make sure that you declare the namespace where the ProductTableAdapter class was defined. Or simply use the fully qualified name like NameSpaceName.ProductTableAdapater

Answer 6

Thank you for answering. The errors are:

 

The name GridView1 doesn't contain in the current context. And ProductTableAdapter is missing a namespace.

Answer 7

What's the actual error you get?

 

Typed DataSets are kinda obsolete and since you are new to ASP.NET I would suggest you to take a look at Entity Framework instead as your Data Access mechanism.

 

http://geekswithblogs.net/dotNETvinz/archive/2011/04/04/entity-framework----inserting-data-to-database.aspx 

 

And if I may add. Start learning MVC instead of WebForms :)