can any1解决错误:无法将类型为'System.Boolean'的对象强制转换为'System.String'。 [英] can any1 resolve error: Unable to cast object of type 'System.Boolean' to type 'System.String'.
问题描述
我将数据从excel文件导入到数据集但是它给了我以上异常
以下是我的代码
DataSet ds = o_Cls_Utility.ReadExcelToDataSet(FilePath,输入文件 - DASHBOARD,TotalCash,false);
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();
对于strSquareOffMode它给出了上述异常。
以下是商店程序。
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
插入INTRADAY_FNODASHBRD_IMP( ID,....,SQUAREOFFMODE
,M2M_BPL,EXIM_ID)
VALUES(INTRADAYCASH .....,
Insert into INTRADAY_FNODASHBRD_IMP (ID, .... ,SQUAREOFFMODE
,M2M_BPL, EXIM_ID)
VALUES ( INTRADAYCASH..... ,
sSquareOffMode , sM2M_BPL , nEximID);
COMMIT;
end;
begin
begin
推荐答案
您可以通过不尝试强制转换不相关的类型来修复它。如果您甚至需要使用布尔值,而不是使用System.Boolean.ToString
,请使用布尔值:
http://msdn.microsoft.com/en-us/library/system.boolean.aspx [ ^ ]。
-SA
You can fix it by not trying to cast unrelated types. Instead of usingSystem.Boolean.ToString
, use Boolean, if you even need to:
http://msdn.microsoft.com/en-us/library/system.boolean.aspx[^].
—SA
这篇关于can any1解决错误:无法将类型为'System.Boolean'的对象强制转换为'System.String'。的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!