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

1 vote174 views1 answer
The CodeDom provider type "Microsoft.CodeDom.Providers.DotNetCompilerPlatform.CSharpCodeProvider, Microsoft.CodeDom.Providers.DotNetCompilerPlatform, Version=2.0.1.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" could not be located.
C#
1 vote240 views1 answer
Get all devices connected using player input manager unity
C#Unity
1 vote267 views1 answer
Directory Entry c# get computer list
C#
9 votes200 views1 answer
Unity get layer of gameobject
C#
2 votes156 views1 answer
Camera follow player unity smooth
C#
0 vote162 views1 answer
Serial begin
C#
3 votes197 views2 answers
Unity Destroy gameObject upon collision
C#
101 votes284 views5 answers
How to generate a random number in c#
C#
2 votes250 views2 answers
Unity how get random color to material
C#Unity
2 votes226 views1 answer
C# datetime get number of week
C#