As shown in the screenshot, I was trying to insert data into a table. The 1st iteration works fine, but the 2nd iteration throws an error/exception.
What is wrong with my code?
Below is the code.
SqlConnection sqlconn = new SqlConnection(sqlconnectionstring);
// sqlconn.Open();
string InsertData = "INSERT INTO AUStagAPITestData ([TestSuite], [TestCase],[Status], [Info], [Time], [IsArchived], [DateTime]) VALUES (@TestSuite, @TestCase, @Status, @Info, @Time, @IsArchived, @DateTime)";
SqlCommand Insertcmd = new SqlCommand(InsertData, sqlconn);
for (int j = 1; j < TDData.Length; j +=5)
{
sqlconn.Open();
string TestSuite = TDData[j];
string TestCase = TDData[j+1];
string Status = TDData[j + 2];
string Info = TDData[j + 3];
string Time = TDData[j + 4];
Insertcmd.Parameters.AddWithValue("@TestSuite", TestSuite);
Insertcmd.Parameters.AddWithValue("@TestCase", TestCase);
Insertcmd.Parameters.AddWithValue("@Status", Status);
Insertcmd.Parameters.AddWithValue("@Info", Info);
Insertcmd.Parameters.AddWithValue("@Time", Time);
Insertcmd.Parameters.AddWithValue("@IsArchived", "1");
Insertcmd.Parameters.AddWithValue("@DateTime", DateTime.Now);
Insertcmd.ExecuteNonQuery();
sqlconn.Close();
}

.AddWithValue()- it can lead to unexpected and surprising results...