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

9 votes329 views1 answer
You have the following c# code. stringbuilder sb = new stringbuilder(really long string); the really long string variable is a string in which a very long string is stored.
C#
6 votes436 views1 answer
Unity rotate vector
C#Unity
1 vote364 views1 answer
Swaggergen add service not getting info in .net core
C#
0 vote360 views1 answer
How to concatenate two arrays
C#
1 vote396 views1 answer
Unity character controller ignore collision
C#Unity
6 votes350 views2 answers
C# read all files in a directory
C#
0 vote377 views1 answer
Unity get prefabs from folder
C#Unity
1 vote318 views1 answer
Toggle unity c#
C#
2 votes308 views1 answer
Dynamic convert type c#
C#
10 votes319 views3 answers
Unity C# instantiate prefab
C#