Problem:
System.FormatException was unhandled by user code
Message=Index (zero based) must be greater than or equal to zero and less than the size of the argument list.
Source=mscorlib
StackTrace:
at System.Text.StringBuilder.AppendFormat(IFormatProvider provider, String format, Object[] args)
at System.String.Format(IFormatProvider provider, String format, Object[] args)
at System.String.Format(String format, Object arg0)
at MultiThreadedDbSeeder.Program.<Main >b__0(Int32 i) in C:\xxxx\Program.cs:line 22
at System.Threading.Tasks.Parallel.<>c__DisplayClassf`1.b__c()
InnerException:
Offending Line:
SqlCommand cmd = new SqlCommand(string.Format(@"insert into table_1 (vch_value) values('{1}')", "the value of i is " + i));
Solution:
Don’t forget that string.Format uses a zero based index.
Fixed Code:
SqlCommand cmd = new SqlCommand(string.Format(@"insert into table_1 (vch_value) values('{0}')", "the value of i is " + i));
No comments:
Post a Comment