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 vote304 views1 answer
Unity 2D how to make top-down look controller
C#
0 vote305 views2 answers
Get the Default gateway address c#
C#
1 vote289 views1 answer
How to check if string can be converted to int c#
C#
0 vote311 views1 answer
Remove header visual studio android
C#
0 vote286 views1 answer
C# clear console read chache
C#
0 vote299 views1 answer
C# get the return value of a func
C#
2 votes320 views1 answer
C# actions
C#
-1 vote320 views3 answers
How to use var in c#
C#
1 vote296 views1 answer
Get properties and values from unknown object
C#
0 vote285 views1 answer
On collision enter by layer 2d unity
C#