C# insert from with bind array

using(var connection = new MySqlConnection("your connection string"))
{
    using(var command = new MySqlCommand("INSERT INTO programs (name, id) VALUES (?name, ?id)", connection))
    {
        var nameParameter = new MySqlParameter("name");
        var idParameter = new MySqlParameter("id");

        command.Parameters.Add(nameParameter);
        command.Parameters.Add(idParameter);

        connection.Open();

        for(int i = 0; i < name.Length; i++)
        {
             nameParameter.Value = name[i];
             idParameter.Value = id[i];

             command.ExecuteNonQuery();             
        }

        connection.Close(); //Dispose being called by the using should close connection, but it doesn't hurt to close it here/sooner either.         
    }
}

Source: stackoverflow.com

Similar codes

8 votes256 views1 answer
Unity how to convert mouse screen position to world position
C#Unity
0 vote223 views1 answer
C# get out of for loop
C#
17 votes261 views4 answers
Random class
C#
11 votes224 views1 answer
Hello world program in c#
C#
0 vote269 views1 answer
Gridview column cell alignment form c#
C#
1 vote240 views1 answer
Create gaps / headers between variables in the unity inspector
C#Unity
1 vote245 views1 answer
How to stop a coroutine unity c#
C#Unity
22 votes238 views3 answers
Unity change text color
C#Unity
1 vote234 views2 answers
Unity change material at runtime
C#
0 vote250 views1 answer
Uninitialized array c#
C#