MySql stored procedure not exist with C# .NET

I try connected MySql stored procedure from c# .Net via MySqlDataAdapter but when i fill data to datatable or dataset has error "Additional information: FUNCTION demo.loadtable does not exist".

My stored

DELIMITER $$
USE `demo`$$
DROP PROCEDURE IF EXISTS `loadtable`$$
CREATE DEFINER=`root`@`localhost` PROCEDURE `loadtable`()
BEGIN
SELECT * FROM tablesx;
END$$
DELIMITER ;

My code

1. loadData method

public void loadData(tables model)
{
connect();
ds= new DataSet();
MySqlParameter[] prams = {
MakeInParam("@id",MySqlDbType.Int32,4,model.id)
};
RunProcDS("loadtable", prams, out ds);
}

2. RunProcDS method

public int RunProcDS(string procName, MySqlParameter[] prams, out DataSet dataSet)
{
DataSet ds;
MySqlCommand cmd = CreateCommand(procName, prams);
MySqlDataAdapter dad = new MySqlDataAdapter(cmd);
MySqlCommandBuilder cb = new MySqlCommandBuilder(dad);
ds = new DataSet();
dad.Fill(ds, "CurrentItems");
dataSet = ds;
this.Close();
return (int)cmd.Parameters["ReturnValue"].Value;
}

Has error att line 08 " dad.Fill(ds, "CurrentItems"); "

3. CreateCommand method

private MySqlCommand CreateCommand(string procName, MySqlParameter[] prams)
{
Open();
MySqlCommand cmd = new MySqlCommand(procName, con);
if (cmd.Parameters.Count > 0)
{
cmd.Parameters.Clear();
}
cmd.CommandType = CommandType.StoredProcedure;
if (prams != null)
{
foreach (MySqlParameter parameter in prams)
cmd.Parameters.Add(parameter);
}
cmd.Parameters.Add(
new MySqlParameter("ReturnValue", MySqlDbType.Int32, 4,
ParameterDirection.ReturnValue, false, 0, 0,
string.Empty, DataRowVersion.Default, null));
return cmd;
}

Please help.

Thanks,

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Gokhul Varman9y ago
Your RPC completed only means that the batch submitted to SQL Server was correct and completed. It doesn't mean the stored procedure ran and executed OK.
It will be (don't argue, check) one of:
- wrong permissions
- wrong database context
- wrong server
- stored proc is in a different database
To ensure that things are the same
```
SELECT    @@SERVERNAME,     SUSER_SNAME(),     DB_NAME(),     USER_NAME(),     OBJECT_ID('dbo.yaf_prov_upgrade')
```
The OBJECT_ID will be NULL if the stored proc doesn't exist in that database or you don't have permissions.
0
Vu Hong Trieu9y ago
Thanks Sundar,
I checked flow your step (all correct)
If using CommandText to qurey data is loaded.
0
Sundaram Subramanian9y ago
Checklist the followings,

1) Check your are calling correct database path in all methods
2) Your Stored Procedure Exsist

3) Schema name is correct in calling method.
0