How to call MySQL stored procedure with multiple input values from ASP.NET

.net, asp.net, c#, mysql, stored-procedures

Solution

You can add mutiple parameters in command.Parameters, refer the below code for the same.

        var connectionString = ""; // Provide connecction string here.
    using (var connection = new MySqlConnection(connectionString))
    {
        MySqlCommand command = new MySqlCommand("InsertIntotblStudent", connection);
        command.CommandType = CommandType.StoredProcedure;
        command.Parameters.Add(new MySqlParameter("PStudentId", TextBox1.Text));
        command.Parameters.Add(new MySqlParameter("PStudentName", TextBox2.Text));
        command.Connection.Open();
        var result = command.ExecuteNonQuery();
        command.Connection.Close();
    }

Problem

This is my MySQL stored procedure. ``` create procedure InsertIntotblStudentProc (PStudentId VARCHAR(10), PStudentName VARCHAR(10)) begin insert into tblStudent (StudentId, StudentName) values (PStudentId, PStudentName); end; ``` Here's my ASP code. ``` `MySqlCommand cmd = new MySqlCommand("InsertIntotblStudent", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("PStudentId", TextBox1.Text);` ``` I stopped here as I want to call procedure with two parameters and my other parameter is in TextBox2. Help me with suggestions.

Original source