Server Error in '/' Application.

Invalid attempt to access a field before calling Read()

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: MySql.Data.MySqlClient.MySqlException: Invalid attempt to access a field before calling Read()

Source Error:


Line 17:           MyReader1 = MyCommand1.ExecuteReader();
Line 18:           MyReader1.Read();
Line 19:           string name= MyReader1["name"].ToString();
Line 20:           string imagename= MyReader1["imagename"].ToString();
Line 21:           string position_collage= MyReader1["position_collage"].ToString();

Source File: c:\inetpub\wwwroot\DDSS\faculty_open.aspx    Line: 19

Stack Trace:


[MySqlException (0x80004005): Invalid attempt to access a field before calling Read()]
   MySql.Data.MySqlClient.ResultSet.get_Item(Int32 index) +261
   MySql.Data.MySqlClient.MySqlDataReader.GetFieldValue(Int32 index, Boolean checkNull) +43
   MySql.Data.MySqlClient.MySqlDataReader.GetValue(Int32 i) +79
   MySql.Data.MySqlClient.MySqlDataReader.get_Item(String name) +28
   ASP.faculty_open_aspx.__RenderContent2(HtmlTextWriter __w, Control parameterContainer) in c:\inetpub\wwwroot\DDSS\faculty_open.aspx:19
   System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +276
   System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +80
   ASP.masterpage_master.__Renderform1(HtmlTextWriter __w, Control parameterContainer) in c:\inetpub\wwwroot\DDSS\MasterPage.master:369
   System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +276
   System.Web.UI.HtmlControls.HtmlForm.RenderChildren(HtmlTextWriter writer) +11661639
   System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) +47
   System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +80
   System.Web.UI.HtmlControls.HtmlForm.RenderControl(HtmlTextWriter writer) +53
   System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +169
   System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +80
   System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +169
   System.Web.UI.Page.Render(HtmlTextWriter writer) +40
   System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +80
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +4239


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