Hello Everyone,

I am having difficulties trying to figure out this error.

System.InvalidCastException: Specified cast is not valid.
CaseStudyData[] dataArray1 = new CaseStudyDB().CaseStudy_GetAllInPage(base.PageGUID);



My code is:

protected void Page_Load(object sender, EventArgs e)
{
CaseStudyData[] dataArray1 = new CaseStudyDB().CaseStudy_GetAllInPage(base.PageGUID);
if (dataArray1.Length > 0)
{
this.Visible = true;
this.Repeater1.DataSource = dataArray1;
this.Repeater1.DataBind();
}
else
{
this.Visible = false;
}
}



Stack Trace

[InvalidCastException: Specified cast is not valid.]
System.Data.SqlClient.SqlBuffer.get_Int32() +106
System.Data.SqlClient.SqlDataReader.GetInt32(Int32 i) +36
CMSDataLayer.DataAccessor.GetInt32(SqlDataReader myReader, Int32 i) in C:\dev\TMC\code\TRC\CMSDataLayer\DataAccessor.cs:92
CMSDataLayer.BaseAccessor.GetCaseStudyDataFromReader(DataAccessor dAccess, SqlDataReader myReader, Int32 iStartIndex) in C:\dev\TMC\code\TRC\CMSDataLayer\BaseAccessor.cs:119
CMSDataLayer.BaseAccessor.GeCaseStudyDatasFromReader(SqlDataReader myReader) in C:\dev\TMC\code\TRC\CMSDataLayer\BaseAccessor.cs:22
CMSDataLayer.CaseStudyDB.CaseStudy_GetAllInPage(Guid l_PageGUID) in C:\dev\TMC\code\TRC\CMSDataLayer\CaseStudyDB.cs:146
Controls_LeftSidebar_RelatedCaseStudies.Page_Load(Object sender, EventArgs e) in c:\Documents and Settings\User\My Documents\Visual Studio 2005\WebSites\TRC\Controls\LeftSidebar\RelatedCaseStudies.ascx.cs:17
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +13
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +45
System.Web.UI.Control.OnLoad(EventArgs e) +80
System.Web.UI.Control.LoadRecursive() +49
System.Web.UI.Control.LoadRecursive() +132
System.Web.UI.Control.LoadRecursive() +132
System.Web.UI.Control.LoadRecursive() +132
System.Web.UI.Control.LoadRecursive() +132
System.Web.UI.Control.LoadRecursive() +132
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3745


Thanks for your help!