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 vote243 views1 answer
Asp.net data annotations double
C#
0 vote292 views2 answers
Winforms reportviewer.print report
C#
0 vote294 views1 answer
Color' does not contain a definition for red' c#
C#
1 vote272 views1 answer
C# remove accents
C#
0 vote277 views2 answers
C sharp type in word and calculate how much a letter is inside that word
C#
1 vote284 views1 answer
Swaggergen add service not getting info in .net core
C#
0 vote263 views1 answer
C# find process by name
C#
0 vote286 views1 answer
How to set the value of a textbox textmode=date asp.net c#
C#
24 votes242 views6 answers
Convert to base64 c#
C#
0 vote274 views1 answer
How to get the screen size in Tao.Freeglut
C#