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

0 vote205 views1 answer
Font dialog c# code
C#
6 votes246 views1 answer
C# date
C#
0 vote214 views1 answer
Unity random.insideunitcircle
C#
2 votes189 views1 answer
Fdifference between two date in hours c#
C#
5 votes188 views1 answer
C# or command
C#
2 votes188 views1 answer
Winforms messagebox with button
C#
0 vote200 views1 answer
.Net Core Bundling & minification : .net core The name 'Scripts' does not exist in the current context
C#
0 vote180 views1 answer
C# property attribute
C#
0 vote187 views1 answer
Tecla intro en unity
C#
0 vote199 views1 answer
C# Case insensitive Contains(string)
C#