Server Error in '/' Application.

Invalid attempt to read when no data is present.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidOperationException: Invalid attempt to read when no data is present.

Source Error:


Line 95:         DBReader = DBCommand.ExecuteReader();
Line 96:         DBReader.Read();
Line 97:         productname = DBReader["description"].ToString();
Line 98:         DBReader.Close();
Line 99:         DBConnection.Close();

Source File: g:\ApedaApplications\AgriExchange\agriexchange\product_profile\india_standing_imp.aspx.cs    Line: 97

Stack Trace:


[InvalidOperationException: Invalid attempt to read when no data is present.]
   System.Data.SqlClient.SqlDataReader.CheckDataIsReady(Int32 columnIndex, Boolean allowPartiallyReadColumn, Boolean permitAsync, String methodName) +1775141
   System.Data.SqlClient.SqlDataReader.TryReadColumn(Int32 i, Boolean setTimeout, Boolean allowPartiallyReadColumn) +48
   System.Data.SqlClient.SqlDataReader.GetValueInternal(Int32 i) +31
   System.Data.SqlClient.SqlDataReader.GetValue(Int32 i) +73
   System.Data.SqlClient.SqlDataReader.get_Item(String name) +28
   india_standing_imp.product_name() in g:\ApedaApplications\AgriExchange\agriexchange\product_profile\india_standing_imp.aspx.cs:97
   india_standing_imp.Page_Load(Object sender, EventArgs e) in g:\ApedaApplications\AgriExchange\agriexchange\product_profile\india_standing_imp.aspx.cs:64
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +51
   System.Web.UI.Control.OnLoad(EventArgs e) +95
   System.Web.UI.Control.LoadRecursive() +59
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +678


Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.7.4081.0