System.Data.Sql Client.SqlExcep tion: General network error.
Check your network documentation. I know that this is not
much to go on. But I don't know where to start. the
program updates 186 records and on the 187 record I get
this error. I know this don't make any sense but the code
field has sa in it?
When it bombs I have this in the fields.
ProdIDkey = 488
Name = 10ct diamond & 1.25 Sapphire ring
Code = r1364sa
Caption = 10ct diamond & 1.25 Sapphire ring
Price = 597
SalePrice = 327
CategoryKey = 68
path = Rings:Diamond:G old:14 Kt:White:
CREATE PROCEDURE Update_CSV
@ProdIDkey int,
@Name nvarchar(255),
@code nvarchar(255),
@Caption nvarchar(4000),
@Price int,
@SalePrice int,
@CategoryKey int,
@path nvarchar(255)
as
DECLARE @CountItems int
SELECT
@CountItems = Count(*)
FROM CSV
WHERE ProdIDkey = @ProdIDkey
IF @CountItems > 0 /* There are items - update the
current quantity */
UPDATE CSV
SET Name = @Name, code = @code, Caption =
@Caption, Price = @Price, [Sale-Price] = @SalePrice,
CategoryKey = @CategoryKey, path = @path
WHERE ProdIDkey = @ProdIDkey
ELSE /* New entry for this Cart. Add a new record */
INSERT INTO CSV
(Name, code, Caption, Price, [Sale-
Price], CategoryKey, path,ProdIDkey)
VALUES (@Name, @code, @Caption, @Price, @SalePrice,
@CategoryKey, @path,@ProdIDke y)
GO
..
Check your network documentation. I know that this is not
much to go on. But I don't know where to start. the
program updates 186 records and on the 187 record I get
this error. I know this don't make any sense but the code
field has sa in it?
When it bombs I have this in the fields.
ProdIDkey = 488
Name = 10ct diamond & 1.25 Sapphire ring
Code = r1364sa
Caption = 10ct diamond & 1.25 Sapphire ring
Price = 597
SalePrice = 327
CategoryKey = 68
path = Rings:Diamond:G old:14 Kt:White:
CREATE PROCEDURE Update_CSV
@ProdIDkey int,
@Name nvarchar(255),
@code nvarchar(255),
@Caption nvarchar(4000),
@Price int,
@SalePrice int,
@CategoryKey int,
@path nvarchar(255)
as
DECLARE @CountItems int
SELECT
@CountItems = Count(*)
FROM CSV
WHERE ProdIDkey = @ProdIDkey
IF @CountItems > 0 /* There are items - update the
current quantity */
UPDATE CSV
SET Name = @Name, code = @code, Caption =
@Caption, Price = @Price, [Sale-Price] = @SalePrice,
CategoryKey = @CategoryKey, path = @path
WHERE ProdIDkey = @ProdIDkey
ELSE /* New entry for this Cart. Add a new record */
INSERT INTO CSV
(Name, code, Caption, Price, [Sale-
Price], CategoryKey, path,ProdIDkey)
VALUES (@Name, @code, @Caption, @Price, @SalePrice,
@CategoryKey, @path,@ProdIDke y)
GO
..