Server Error in '/' Application.

SELECT * ,(SELECT fld_title FROM tbl_grade where fld_id=tbl_train.fld_gradeID) as Grade ,(SELECT fld_title FROM tbl_subject where fld_id=tbl_train.fld_subID) as Subject ,(SELECT fld_title FROM tbl_unit where fld_id=tbl_train.fld_unitID) as Unit ,(SELECT fld_title FROM tbl_chap where fld_id=tbl_train.fld_chapID) as chap from tbl_train where fld_id=fld_id and fld_unitID=0  and fld_subID=208 order by fld_order desc , fld_id desc <br>Object reference not set to an instance of an object.

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.Exception: SELECT * ,(SELECT fld_title FROM tbl_grade where fld_id=tbl_train.fld_gradeID) as Grade ,(SELECT fld_title FROM tbl_subject where fld_id=tbl_train.fld_subID) as Subject ,(SELECT fld_title FROM tbl_unit where fld_id=tbl_train.fld_unitID) as Unit ,(SELECT fld_title FROM tbl_chap where fld_id=tbl_train.fld_chapID) as chap from tbl_train where fld_id=fld_id and fld_unitID=0  and fld_subID=208 order by fld_order desc , fld_id desc <br>Object reference not set to an instance of an object.

Source Error:


Line 64:             catch (Exception ex)
Line 65:             {
Line 66:                 throw new Exception(sqlStr + " <br>" + ex.Message);
Line 67:             }
Line 68:             finally

Source File: c:\WebServer\areeg\App_Code\Cdb.cs    Line: 66

Stack Trace:


[Exception: SELECT * ,(SELECT fld_title FROM tbl_grade where fld_id=tbl_train.fld_gradeID) as Grade ,(SELECT fld_title FROM tbl_subject where fld_id=tbl_train.fld_subID) as Subject ,(SELECT fld_title FROM tbl_unit where fld_id=tbl_train.fld_unitID) as Unit ,(SELECT fld_title FROM tbl_chap where fld_id=tbl_train.fld_chapID) as chap from tbl_train where fld_id=fld_id and fld_unitID=0  and fld_subID=208 order by fld_order desc , fld_id desc <br>Object reference not set to an instance of an object.]
   Cdb.OleExecDataSet(String sqlStr) in c:\WebServer\areeg\App_Code\Cdb.cs:66
   Train.select(String SubID) in c:\WebServer\areeg\App_Code\Train.cs:209
   Control_Second.HasTrainUnit(String tp) in c:\WebServer\areeg\Control\ShowSecond.ascx.cs:99
   ASP.control_showsecond_ascx.__DataBind__control8(Object sender, EventArgs e) in c:\WebServer\areeg\Control\ShowSecond.ascx:307
   System.Web.UI.Control.OnDataBinding(EventArgs e) +100
   System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) +178
   System.Web.UI.Control.DataBindChildren() +248
   System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) +195
   System.Web.UI.WebControls.DataList.CreateItem(Int32 itemIndex, ListItemType itemType, Boolean dataBind, Object dataItem) +175
   System.Web.UI.WebControls.DataList.CreateControlHierarchy(Boolean useDataSource) +885
   System.Web.UI.WebControls.BaseDataList.OnDataBinding(EventArgs e) +89
   Control_Second.Fill() in c:\WebServer\areeg\Control\ShowSecond.ascx.cs:40
   Control_Second.Page_Load(Object sender, EventArgs e) in c:\WebServer\areeg\Control\ShowSecond.ascx.cs:31
   System.Web.UI.Control.OnLoad(EventArgs e) +108
   System.Web.UI.Control.LoadRecursive() +90
   System.Web.UI.Control.LoadRecursive() +185
   System.Web.UI.Control.LoadRecursive() +185
   System.Web.UI.Control.LoadRecursive() +185
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1533


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