ASP.Net C# - MySQLTransaction Multiple Inserts

Following on from my previous question posted here (Two insert queries with linked fields), why does the following code insert 4 new rows in the 'question_m' table when I want to i

Solution 1:

ExecuteScalar() is usually used to return/select some data from database. Use ExecuteNonQuery instead when you are executing any DDL queries.