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
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
in connection string.
Submit an article or tip