Error while updating data

Question

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.

Priyaranjan K S · 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 · Answer

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} SivakasiFrancis); Console.WriteLine(str); Hope this helps!

Manas Mohapatra · Answer

Your UPDATE SQL statement looks incorrect. Please provide whole code-base.