ASP.Net Error: Could not find stored procedure up_DinamicQuery using C#

Last Reply 11 months ago By pvermacs

Posted 11 months ago

error code in this source Could not find stored procedure up_DinamicQuery

public int ExecuteNonQuery(string ExecCommand)
{
    int iReturn = -1;
    try
    {
        DbCommandWrapper = GetRetrieveCommand();
        string sqlQuery = Db.GetParameterValue(DbCommandWrapper, "@sqlQuery").ToString();
        Db.SetParameterValue(DbCommandWrapper, "@sqlQuery", ExecCommand);
 
        Db.ExecuteNonQuery(DbCommandWrapper);
        return (int)DbCommandWrapper.UpdatedRowSource;
    }
    catch (Exception ex)
    {
        bool rethrow = ExceptionPolicy.HandleException(ex, "Facade Policy");
        if (rethrow)
        {
            throw;
        }
    }
    finally
    {
        if (DbCommandWrapper is System.Data.SqlClient.SqlCommand)
        {
            DbCommandWrapper.CommandTimeout = 30;
        }
 
    }
    return iReturn;
}

i using sql, same eror if i cant use password and user name

You are viewing reply posted by: pvermacs 11 months ago.
Posted 11 months ago

Please check  the database if it contains the stored procedure

sp_helptext [procedurename]

if  it  returns defination  that means it is in database.