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 vote212 views3 answers
C sharp convert string time into 24 hours time
C#
0 vote184 views1 answer
Linq query to fetch parent child data from same table in c#
C#
32 votes206 views3 answers
Unity reload current scene
C#
-1 vote192 views1 answer
1. Write a program that will determine the multiples of 7 from 1 to 100 in C# looping
C#
0 vote187 views1 answer
How to make font factory text to bold in c#
C#
11 votes208 views2 answers
How to check if an integer is in array c#
C#
7 votes195 views1 answer
For loop unity
C#Unity
25 votes204 views3 answers
If get key down unity
C#
2 votes197 views1 answer
C# enum default
C#
0 vote192 views1 answer
How to use open hardware monitor in c#
C#