MySQL DataReader not working RRS feed

  • Question

  • User1177026165 posted


    I have a MySQL stored procedure that returns a varchar and I have tested the sql, and it does return the correct results. However, when I call the Stored Procedure from my C# code the data reader has no results, and is empty. My Stored Procedure compiles without error, too. Here is my C# code, and I would welcome some help, please:

     MySqlCommand cmd = new MySqlCommand("get_menu", connection);
                    cmd.CommandType = CommandType.StoredProcedure;
                    cmd.Parameters.Add(new MySqlParameter("username", "ariome"));
                    cmd.Parameters.Add("menulist", MySqlDbType.VarChar);
                    cmd.Parameters["menulist"].Direction = ParameterDirection.Output;
                    MySqlDataReader dr = cmd.ExecuteReader();

                    List<MenuItems> MenubarList = new List<MenuItems>();
                    while (dr.Read())
                        MenuItems items = new MenuItems();
                        items.ItemName = Convert.ToString(dr["itemname"]);

                    return MenubarList;

    Friday, September 23, 2011 4:49 PM

All replies

  • User269602965 posted

    Show your stored procedure as well.

    Saturday, September 24, 2011 10:54 PM
  • User-809550105 posted

    First you should open the connection before passing parameters....

    MySqlCommand cmd = new MySqlCommand("get_menu", connection);


    Secondly, Dispose the objects of command and connection before returning.....



    return MenubarList;

    Sunday, September 25, 2011 1:14 PM
  • User1177026165 posted

    Wrong answer I am afraid, but the problem I found was in the stored procedure itself, which I have fixed.


    Tuesday, September 27, 2011 12:16 PM
  • User-809550105 posted

    You did not given us the whole code with stored procedure thats why i use some other option to solve this problem.


    Tuesday, September 27, 2011 12:46 PM