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 vote164 views2 answers
2d look at unity
C#
13 votes162 views1 answer
What does static mean in c#
C#
0 vote206 views1 answer
How to full screen login form using C# MVC
C#
0 vote225 views1 answer
Disable Debug.log Unity
C#Unity
29 votes188 views3 answers
Online embedded c compiler
C#
0 vote167 views1 answer
Convert number of days into months c#
C#
0 vote170 views1 answer
Convert json to list object c#
C#
-1 vote178 views1 answer
Write text in C#
C#
0 vote153 views1 answer
If entity.is Transient() Update Mvc 5 c#
C#
32 votes175 views4 answers
Textmesh pro text unity
C#