Error when Saving into SQL Server

Question

So here is the error...

An error occurred while saving the Panel. System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index at System.ThrowHelper.ThrowArgumentOutOfRangeException() at System.Collections.Generic.List`1.get_Item(Int32 index) at PanelController.Save(Int32 ID, FormCollection FormValues)

During debugging, I checked the parameter it was adding to the save stored proc, and the ID it was adding was 0. Then, when it used this

oDal.Execute("Lending.uspPanelSave")
Item.PanelId = oDal.Parameters("@PanelId").Value

To retrieve the ID to return it, it set it as 1000? Anyone know what the problem is?

i'm not convinced there is enough code to analyse this here, the error implies you have a generic list of int's somewhere that you are accessing by index using an int larger than the list size — Pharabus
– Pharabus, Commented Jul 16, 2010 at 18:35

Mathias F · Accepted Answer · 2010-07-16 19:02:46Z

1

Use SqlServer Profiler (in performance tools) to see what is realy send to SQL Server.

answered Jul 16, 2010 at 19:02

Mathias F

16k25 gold badges95 silver badges167 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Cade Roux · Accepted Answer · 2010-07-16 18:43:17Z

0

Sounds like it's not finding an output parameter called @PanelId in your command object. Was the parameter added and declared with the correct direction? Is the parameter declared properly in the stored procedure?

answered Jul 16, 2010 at 18:43

Cade Roux

90.1k42 gold badges186 silver badges268 bronze badges

1 Comment

Scott Over a year ago

Direction is declared as follows. It's in the stored proc last I checked. With oDal.Parameters With .AddWithValue("@PanelId", Item.PanelId) .Direction = ParameterDirection.InputOutput

Collectives™ on Stack Overflow

Error when Saving into SQL Server

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related