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