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

2 votes242 views1 answer
Rigidbody2d freeze position
C#
0 vote271 views1 answer
Handle several buttons' click events
C#
0 vote253 views1 answer
How to detect ajax request in asp.net core
C#
0 vote256 views1 answer
Remove compoennt unity
C#
3 votes284 views1 answer
Spawn a object with unity
C#Unity
2 votes243 views2 answers
Unity rotate around axis
C#
3 votes253 views1 answer
Create line in unity
C#
0 vote228 views1 answer
C# executing assembly path
C#
0 vote253 views1 answer
Unity C# add torque to rigidbody
C#
0 vote270 views1 answer
Formula resto divisão c#
C#