System.Data.SqlClient.SqlException (0x80131904): Divide by zero error encountered. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows) at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more) at System.Data.SqlClient.SqlDataReader.Read() at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping) at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue) at System.Data.Common.DataAdapter.Fill(DataTable[] dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) at Synbuf.Component.DAL.DataOperation.GetData(String query) in D:\2. Synbuf\0. My Working\Testing\Prohitech\Synbuf.Component.DAL\DataOperation.cs:line 56 at Synbuf.Component.DAL.DataAccess.GetData(String query) in D:\2. Synbuf\0. My Working\Testing\Prohitech\Synbuf.Component.DAL\DataAccess.cs:line 35 at Synbuf.Component.UI.RptProfitAndLoss.loadSales() in C:\WORKING\Testing\ProHitech Pune\Synbuf.Component.UI\Reports\RptProfitAndLoss.aspx.cs:line 56 at Synbuf.Component.UI.RptProfitAndLoss.btnSearch_Click(Object sender, EventArgs e) in C:\WORKING\Testing\ProHitech Pune\Synbuf.Component.UI\Reports\RptProfitAndLoss.aspx.cs:line 80 ClientConnectionId:1a2537b2-9fe9-4f61-a67c-f884f51b29cf Error Number:8134,State:1,Class:16 ProHitech Engineering Services LLP
Profit & Loss Report
Report
From To
Summary
Total Sales Total Expense Profit/Loss
_ _ _
Sales
  Expenses