CREATE PROCEDURE my_pr1 (IN per VARCHAR(12), IN fd VARCHAR(60), IN fdo TEXT, IN pors INT)
BEGIN
INSERT INTO zakaz_active (persons, food, food_option, parth) VALUES (per, fd, fdo, tbln);END

using MySql.Data.MySqlClient;

namespace menu_mysql
{
public partial class menu : Form
{


    public menu()
    {
        InitializeComponent();
    }

    MySqlConnection connect = new MySqlConnection("datasource=localhost;port=3306;Initial Catalog='testmenu';username=root;password=");

    private void textBox1_TextChanged(object sender, EventArgs e)
    {

    }

    private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
    {

    }

    private void textBox2_TextChanged(object sender, EventArgs e)
    {

    }

    private void comboBox2_SelectedIndexChanged(object sender, EventArgs e)
    {

    }

    private void button1_Click(object sender, EventArgs e)
    {
        MySqlParameter[] spr = new MySqlParameter[4];
        spr[0] = new MySqlParameter("per", SqlDbType.VarChar);
        spr[0].Value = textBox1.Text;

        spr[1] = new MySqlParameter("fd", SqlDbType.VarChar);
        spr[1].Value = comboBox1.Text;

        spr[2] = new MySqlParameter("fdo", SqlDbType.Text);
        spr[2].Value = textBox2.Text;

        spr[3] = new MySqlParameter("pors", SqlDbType.Int);
        spr[3].Value = comboBox2.Text;

        MySqlCommand comand = new MySqlCommand();

        comand.Connection = connect;
        comand.CommandType = CommandType.StoredProcedure;
        comand.CommandText = "my_sp1";

        comand.Parameters.AddRange(spr);

        connect.Open();
        if (comand.ExecuteNonQuery() == 1)
        {
            MessageBox.Show("Yes");
        }
        else
        {
            MessageBox.Show("No");
        }
        connect.Close();
    }

if (comand.ExecuteNonQuery() == 1)