在将数据从数据集传输到SQL表类型时添加无效字符。 [英] Add invalid character while transfer data from dataset to SQL table type.

问题描述

我正在从.csv文件中读取数据到数据集，看起来是正确的。然后我将数据从数据集传输到表类型，以便将数据插入到数据库中。虽然我在profiler中看到了查询，但它在字符串中显示了一些无效字符。



Exa

Hi,

I am reading data from .csv file to data set, it look correct. Then i am transfer data from data set to table type for insert data into database. while i was saw query in profiler it show some invalid character in string.

Exa

declare @p2 int
set @p2=2
declare @p3 dbo.ACC_TYPE_NSE_DETAILS
insert into @p3 values(N'ZICOM',N'EQ',44.75,45,44.149999999999999,44.549999999999997,44.450000000000003,44.649999999999999,47912,2136669.1000000001,'2017-01-30 00:00:00',238,N'INE871B01014')
insert into @p3 values(N'ZODIACLOTH',N'EQ',196.5,196.5,186,188.05000000000001,188,189.15000000000001,346,65572.149999999994,'2017-01-30 00:00:00',37,N'INE206B01013')

declare @p4 dbo.ACC_TYPE_BSE_DETAILS
insert into @p4 values(532798,N'NTWK MED 
INV',N'A',N'Q',35.600000000000001,35.850000000000001,
35.299999999999997,35.700000000000003,
35˥649999999999999,35.649999999999999,200,25314,901523)
insert into @p4 values(600180,N'HDFC BANK LT',N'A',N'Q',1451.5,1475,1451.5,1462.8,1465,1474.9000000000001,289,61588,90032815)

exec INSERT_STOCK_PRICES @PRICE_DATE=N'1/30/2017 12:00:00 AM',@Result=@p2 output,@NSE_STOCK_DETAILS=@p3,@BSE_STOCK_DETAILS=@p4
select @p2

无法找到任何解决方案。请做必要的。



我使用WCF服务作为数据库层。



我已经无效字符串用Italic和粗体供我们参考。



我尝试过：



我试过在连接字符串中添加

Does not able to find out any solution on it. Please do the needful.

I use WCF services for as database layer.

I have made invalid string in Italic and bold for our reference.

What I have tried:

I have tried add

MultipleActiveResultSets=True

。

推荐答案

看起来你想要一个小数点而不是l。所以该字段应为 35.49999999999999 。再次检查您的csv文件。

It looks like you want a decimal point instead of the "l". So that field should be "35.49999999999999". Check your csv file again.

这篇关于在将数据从数据集传输到SQL表类型时添加无效字符。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！