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

25 votes142 views2 answers
Time delay C# unity
C#Unity
0 vote113 views6 answers
For
C#
0 vote109 views1 answer
Change color of object unity
C#
0 vote115 views1 answer
How to update custom package in unity
C#
0 vote97 views1 answer
Detect location from ip address .net core
C#
0 vote106 views1 answer
C# binding add combobox with enum values
C#
16 votes100 views2 answers
Unity destroy
C#
0 vote110 views1 answer
C# generate guid from hash
C#
8 votes109 views2 answers
.net core identity get user id
C#
9 votes144 views3 answers
Unity how to create 2d object from script
C#Unity