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:\Synbuf\0. My Working\Testing\Strong Tech\Synbuf.Component.DAL\DataOperation.cs:line 56 at Synbuf.Component.UI.RptProfitAndLoss.loadSales() in E:\Synbuf Working\SYNBUF PROJECTS WORKING ON\TESTING\StrongTech\Synbuf.Component.UI\Reports\RptProfitAndLoss.aspx.cs:line 56 at Synbuf.Component.UI.RptProfitAndLoss.btnSearch_Click(Object sender, EventArgs e) in E:\Synbuf Working\SYNBUF PROJECTS WORKING ON\TESTING\StrongTech\Synbuf.Component.UI\Reports\RptProfitAndLoss.aspx.cs:line 80 ClientConnectionId:fe775664-2494-4968-9f23-8d5e1be21bb1 Error Number:8134,State:1,Class:16 STRONG TECH ENGINEERING SERVICES AND RESEARCH(I) PVT LTD
Profit & Loss Report
Report
From To
Summary
Total Sales Total Expense Profit/Loss
_ _ _
Sales
  Expenses