can any1 resolve error: Unable to cast object of type 'System.Boolean' to type 'System.String'.

See more:

ASP.NET

Oracle

i am importing data from excel file to dataset but it gives me above exception

below is my code

DataSet ds = o_Cls_Utility.ReadExcelToDataSet(FilePath, "Input file - DASHBOARD", "TotalCash", false);

double[] dAlertLevel = (from row in ds.Tables[0].AsEnumerable()
                        select Convert.ToDouble(row["AlertLevel"])).ToArray();

string[] strSquareOffMode = ds.Tables[0]
                           .AsEnumerable()
                           .Select(row => row.Field<string>("SquareOffMode").Trim())
                           .ToArray();

for strSquareOffMode it gives the above exception .
below is store procedure.

CREATE OR REPLACE PROCEDURE SP_INTRADAY_FNODASHBRD_IMP
(

      sClientCode IN   VARCHAR2,
      sClientName IN   VARCHAR2,

      sSquareOffMode            IN   VARCHAR2,
      sM2M_BPL                  IN   FLOAT,
      nEximID   IN   NUMBER

  )
is

Insert into INTRADAY_FNODASHBRD_IMP (ID, .... ,SQUAREOFFMODE
,M2M_BPL, EXIM_ID)
VALUES ( INTRADAYCASH..... ,

sSquareOffMode       ,      sM2M_BPL ,   nEximID);

 COMMIT;
end;

begin