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

4 votes123 views1 answer
Bitmask c#
C#
1 vote120 views1 answer
In what occasions do you use void update and fixedupdate C# unity
C#
0 vote112 views1 answer
Unity time of day
C#
0 vote182 views1 answer
Adding number of day remaining to future date from now
C#
0 vote114 views1 answer
C# open config file by path
C#
0 vote156 views1 answer
Unity android plugin callback
C#Unity
0 vote119 views1 answer
Get Mac address of Device in Xamarin
C#
1 vote129 views2 answers
How to query items with any id in a list of ids linq c#
C#
0 vote109 views1 answer
Connection string of bulk insert with csv in c#
C#
30 votes149 views4 answers
Unity wait for seconds
C#Unity