By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,843 Members | 2,300 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,843 IT Pros & Developers. It's quick & easy.

I am new to Sql and looking for some help with this error. Any advice would be apreci

P: 1
System.Data.SqlClient.SqlException: Divide by zero error encountered
[SqlException: Divide by zero error encountered.]
System.Data.SqlClient.SqlDataReader.Read() +176
System.Data.Common.DbDataAdapter.FillLoadDataRow(S chemaMapping mapping) +175
System.Data.Common.DbDataAdapter.FillFromReader(Ob ject data, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue) +260
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) +129
System.Data.Common.DbDataAdapter.FillFromCommand(O bject data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +304
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +77
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +36
Rtprs.DataAccessors.ShiftProductivityReportAccesso r.GetData(AbstractConnection& p_theConnection, DataSet& p_theDataSet, DateTime p_theDate, String p_sPackLine, Int32 p_iShiftId) +326
Rtprs.BusinessLogic.BLogic.GetDataForShiftProducti vityReport(DateTime dateTime, String packLine, Int32 shiftID, String p_sSortColumns) +141
Rtprs.ShiftProductivityReport.Init() +76
Rtprs.ShiftProductivityReport.Build(HtmlTextWriter writer, RtprsState sessionState, Int32 sortColumnNumber) +45
Rtprs.ReportView.RenderReport(HtmlTextWriter writer) +199
Rtprs.ReportView.Render(HtmlTextWriter writer) +7
System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +243
System.Web.UI.Control.RenderChildren(HtmlTextWrite r writer) +72
System.Web.UI.HtmlControls.HtmlForm.RenderChildren (HtmlTextWriter writer) +44
System.Web.UI.HtmlControls.HtmlForm.Render(HtmlTex tWriter output) +262
System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +243
System.Web.UI.Control.RenderChildren(HtmlTextWrite r writer) +72
System.Web.UI.Control.Render(HtmlTextWriter writer) +7
System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +243
System.Web.UI.Page.ProcessRequestMain() +1926
Sep 8 '09 #1
Share this Question
Share on Google+
1 Reply


P: 16
I would guess from the first line that you're trying to divide by zero somewhere. The best thing to do is have a check on your dividing number that if it's equal to zero, don't do the division, just insert a zero.
Sep 9 '09 #2

Post your reply

Sign in to post your reply or Sign up for a free account.