Fix error “Index (zero based) must be greater than or equal to zero and less than the size of the argument list”

Fix error "Index (zero based) must be greater than or equal to zero and less than the size of the argument list"

Not so long ago when I was very tired I wrote an SQL-query in my C# application in Visual Studio, but I got error on build. The error was " Index (zero based) must be greater than or equal to zero and less than the size of the argument list.". Error string was this:

updateCommand = String.Format("UPDATE [UserTbl] SET [PhoneWork] = '{0}', 
             [PhoneHome] = '{1}', 
             [PhoneMob] = '{2}', 
WHERE [EntityId] = '{3}'", PhoneWork, PhoneHome, PhoneMob);

updateCommand = String.Format("UPDATE [UserTbl] SET [PhoneWork] = '{0}',

[PhoneHome] = '{1}',

[PhoneMob] = '{2}',

WHERE [EntityId] = '{3}'", PhoneWork, PhoneHome, PhoneMob);

If I wasn’t tired I couldn’t even write so, but here I have just forgotten to write {3} value.

$updateCommand = string.format("UPDATE [UserTbl] SET [PhoneWork] = '{0}',
[PhoneHome] = '{1}',
[PhoneMob] = '{2}',
WHERE [EntityId] = '{3}'", PhoneWork, PhoneHome, PhoneMob, EntityId);

$updateCommand = string.format("UPDATE [UserTbl] SET [PhoneWork] = '{0}',

[PhoneHome] = '{1}',

[PhoneMob] = '{2}',

WHERE [EntityId] = '{3}'", PhoneWork, PhoneHome, PhoneMob, EntityId);

So this post is for all tired developers.

10 August 2013, admin
Uncategorized
Comments: (0)

Fix error "Index (zero based) must be greater than or equal to zero and less than the size of the argument list"

No Comments »

Leave a comment

New posts