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

Question

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.

Buddhabhushan Kamble · Accepted Answer · 2017-05-02 06:04:49Z

5

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();
    }

answered May 2, 2017 at 6:04

Buddhabhushan Kamble

2901 silver badge7 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Mohammad · Accepted Answer · 2017-05-02 05:58:46Z

0

consider using list of MySqlParameter like this:

    var sqlParameters = new List<MySqlParameter>();
    sqlParameters.Add(new MySqlParameter { MySqlDbType = MySqlDbType.Int32, ParameterName = "@valuename", Value = textbox1 });
        .
        .
    cmd.Parameters.AddRange(sqlParameters.ToArray());

answered May 2, 2017 at 5:58

Mohammad

2,7647 gold badges35 silver badges58 bronze badges

Collectives™ on Stack Overflow

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

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related