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

8 votes229 views3 answers
Unity get component in parent
C#Unity
0 vote190 views1 answer
How to save a dictionary as a csv file in c#
C#
16 votes120 views2 answers
Time.deltatime unity
C#
2 votes219 views2 answers
Inactive after active with press key unity
C#Unity
0 vote154 views1 answer
Display array elemetns to text box c#
C#
0 vote166 views1 answer
Asp.net 5 iis HTTP Error 500.19 - Internal Server Error
C#
14 votes167 views3 answers
C# array to list
C#
47 votes161 views5 answers
Remove last character from stringbuilder c#
C#
0 vote160 views1 answer
C# get all occurrences of a string
C#
16 votes128 views1 answer
For loop on enum c#
C#