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 vote153 views1 answer
Getset c#
C#
0 vote164 views1 answer
CS0234 compile error c# unity fix scene managment
C#
0 vote148 views1 answer
Unity animation missing gameobject replace
C#
0 vote169 views1 answer
Cannot convert string to long c#
C#
2 votes137 views1 answer
Change dot net core web api routing
C#
0 vote189 views1 answer
Open API support for ASP.NET Core Minimal API
C#
1 vote165 views1 answer
C# serviceCollection AddLogging
C#
0 vote106 views1 answer
Radiobutton in asp.net
C#
0 vote146 views1 answer
Encrypt with public key and decrypt with private key c#
C#
0 vote158 views2 answers
C# how to get a securestring from string
C#