Error while updating data

Sharat Jadhav

11y877.NET

HI Everyone!!i have a problem in updating data...plz help me....

This is my SQl Query and i m using sql server R2 and Visual Studio 2012(MVC 4)

**update tbl_Showroom set (Showroom_Name,Contact_No,Email_Id,Contact_Person) VALUES ('{1}','{2}','{3}','{4}') where Showroom_Code = " + "'{0}'";

This is error i m getting

**Index (zero based) must be greater than or equal to zero and less than the size of the argument list.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Priyaranjan K S11y ago
Accepted answer
There are ony 4 parameter and you have mentioned 5 substititions using {} . Check the parameter count .

Thanks,
Priyan

If you found this useful Please mark this as Answer
Francis Susaimichael11y ago
This is because there is a mismatch (in terms of count)between the parameters expected and parameter you sent. Hope you are using "String.Format()" function.

The below lines throw the same error:

String str = String.Format("My name is {1} and from {0}", "Francis");
Console.WriteLine(str);

Since it expect 2 strings, but i sent only one alone. At that time it will throw the error you mentioned in your post.

The below code works fine:

String str = String.Format("My name is {1} and from {0}", "Sivakasi","Francis");
Console.WriteLine(str);

Hope this helps!
Manas Mohapatra11y ago
Your UPDATE SQL statement looks incorrect. Please provide whole code-base.