Mysql Out Parameters Don't Return Data

Hello,

When the method workerAgentContactInfo_DoWork is ran is executes fine.  All the data I need to be returned is returned including the Out parameter in the mysqlComm object.  However, when the method GetContactInformation is ran the Out parameters don't have data in them.  I have ran its Stored Procedure in Query Browser and it returns information as I expect.  I read of a bug where ExecuteNonQuery() would fill Out params but ExecuteReader() wouldn't.  I have attempted this fix and it didn't work.

In both cases the command is set to a Stored Procedure.  The parameters are set as they need to be as far as input/output is concerened.  What you see below as the parameters being Input/Output was a desperation measure trying to do a catch-all on the parameters but that didn't work either.  What could be wrong?

Thanks.

private void workerAgentContactInfo_DoWork(object sender, DoWorkEventArgs e)
        {
            DataTable agentsContacts = new DataTable();
            agentsContacts.Columns.Add("Homepage", typeof(string));
            agentsContacts.Columns.Add("ContactName", typeof(string));
            agentsContacts.Columns.Add("ContactDepartment", typeof(string));
            agentsContacts.Columns.Add("ContactType", typeof(string));
            agentsContacts.Columns.Add("ContactInfo", typeof(string));
 
            MySqlCommand mysqlComm = new MySqlCommand("tiger_getAgentContacts");
            mysqlComm.CommandType = CommandType.StoredProcedure;
            mysqlComm.Connection = mysqlConn;
 
            MySqlParameter param = new MySqlParameter("_agentId", MySqlDbType.Int32);
            param.Direction = ParameterDirection.Input;
            param.Value = agentId;
 
            mysqlComm.Parameters.Add(param);
 
            param = new MySqlParameter("_homepage", MySqlDbType.String);
            param.Direction = ParameterDirection.Output;
 
            mysqlComm.Parameters.Add(param);
 
            MySqlDataAdapter adapter = new MySqlDataAdapter(mysqlComm);
 
            try
            {
                adapter.Fill(agentsContacts);
            }
            catch (Exception ex)
            {
                switch (MessageBox.Show(ex.Message, "Database Error", MessageBoxButtons.OKCancel))
                {
                    case DialogResult.OK:
                        // do nothing
                        break;
                    case DialogResult.Cancel:
                        Application.Exit();
                        break;
                }
            }
            finally
            {
                if (mysqlConn.State != ConnectionState.Closed)
                    mysqlConn.Close();
            }
 
            TabPage page = tabControlCalls.TabPages["homeTab"];
 
            if (agentsContacts.Rows.Count > 0)
            {
                FillContactsPanel(page, agentsContacts);
            }
 
            homeTabUrlBase = mysqlComm.Parameters["_homepage"].Value.ToString();
            homeTabUrlBase = homeTabUrlBase.Replace("[AGENTID]", agentId);
 
            if (homeTabUrlBase.Length == 0)
                homeTabUrlBase = "About:No Web Information is Available for Agent " + agentId;
 
            NavigatePanelBrowser(page, homeTabUrlBase);
        }
 
private void GetContactInformation()
        {
            try
            {
                TabPage page = (TabPage)this.Invoke(new DelegateTabPageString(GetTabPage), new object[] { pageNameInfo });
                Label lblCallerId = (Label)page.Controls.Find("CallerIdName", false)[0];
 
                int indexOfColon = lblCallerId.Text.IndexOf(":");
 
                bool hasId = false;
 
                if (indexOfColon != -1)
                    hasId = true;
 
                if (hasId)
                {
                    string identifier = lblCallerId.Text.Substring(0, indexOfColon);
 
                    dtContacts.Rows.Clear();
 
                    MySqlCommand mysqlComm = new MySqlCommand("tiger_getCallerContacts");
                    mysqlComm.CommandType = CommandType.StoredProcedure;
                    mysqlComm.Connection = mysqlConn;
 
                    MySqlParameter param = new MySqlParameter("_asteriskId", MySqlDbType.String);
                    param.Direction = ParameterDirection.InputOutput;
                    param.Value = identifier;
 
                    mysqlComm.Parameters.Add(param);
 
                    param = new MySqlParameter("_companyId", MySqlDbType.Int32);
                    param.Direction = ParameterDirection.InputOutput;
 
                    mysqlComm.Parameters.Add(param);
 
                    param = new MySqlParameter("_companyName", MySqlDbType.String);
                    param.Direction = ParameterDirection.InputOutput;
 
                    mysqlComm.Parameters.Add(param);
 
                    param = new MySqlParameter("_webpopurl", MySqlDbType.String);
                    param.Direction = ParameterDirection.InputOutput;
 
                    mysqlComm.Parameters.Add(param);
 
                    param = new MySqlParameter("_callinnumber", MySqlDbType.Int32);
                    param.Direction = ParameterDirection.InputOutput;
 
                    mysqlComm.Parameters.Add(param);
 
                    MySqlDataAdapter adapter = new MySqlDataAdapter(mysqlComm);
 
                    try
                    {
                        adapter.Fill(dtContacts);
                    }
                    catch (Exception ex)
                    {
                        ErrorReporting.Reporter.DumpError(ex);
                    }
                    finally
                    {
                        if (mysqlConn.State != ConnectionState.Closed)
                            mysqlConn.Close();
                    }
 
                    string url = mysqlComm.Parameters["_webpopurl"].Value.ToString();
                    url = url.Replace("[AGENTID]", agentId);
                    url = url.Replace("[CALLERIDNUM]", identifier);
                    url = url.Replace("[COMPANYCODE]", identifier);
 
                    if (url.Length == 0)
                        url = "About:No page for the identifier, '" + identifier + "', was found";
 
                    this.Invoke(new DelegateVoidTabPageString(NavigatePanelBrowser), new object[] { page, url });
 
                    string callNumber = mysqlComm.Parameters["_callinnumber"].Value.ToString();
 
                    this.Invoke(new DelegateVoidTabPageString(AppendCallInNumberToTab), new object[] { page, callNumber });
 
                    for (int i = 0; i < dtContacts.Rows.Count; i++)
                    {
                        dtContacts.Rows[i]["CompanyName"] = mysqlComm.Parameters["_companyName"].Value.ToString();
                        dtContacts.Rows[i]["WebPopUrl"] = mysqlComm.Parameters["_webpopurl"].Value.ToString();
                    }
 
                    if (dtContacts.Rows.Count > 0)
                    {
                        this.Invoke(new DelegateVoidTabPageDataTable(FillContactsPanel), new object[] { page, dtContacts });
                        txtForward.Clear();
                    }
                }
                else
                {
                    this.Invoke(new DelegateVoidTabPageString(NavigatePanelBrowser), 
                        new object[] { page, "About:Company Identifier Not Found" });
                }
            }
            catch (Exception ex)
            {
                ErrorReporting.Reporter.DumpError(ex);
            }
        }

Select allOpen in new window