Cannot find procedure GetAdvertReport

Hi Mates

I am trying to develop a report as pdf, i get thrown for an error saying "Cannot find the store procedure" . But there is a store procedure on the database table name 'Tbl_TrainingAcademy'.

// Repository
using System;
using System.Collections.Generic;
using System.Linq;
using System.Data.SqlClient;
using System.Configuration;
using System.Web;
using ContentManagementSystem.Models;
using System.Data;
namespace ContentManagementSystem.Repository
{
public class ReportsMaster : IlReports
{
public DataSet Generate_AdvertDetailsReport()
{
using(SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["eNtsaOnlineRegistrationDB"].ToString()))
{
con.Open();
DataSet ds = new DataSet();
// Handling Exception
try
{
SqlCommand cmd = new SqlCommand("GetAdvertReport", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
da.Fill(ds);
if(ds.Tables.Count > 0)
{
return ds;
}
else
{
return ds = null;
}
}
catch(Exception )
{
throw; // Exception states cant find the store procedure 'GetAdvertReport'
}
finally
{
ds.Dispose();
}
}
}
}
}

// ConnectionString from Web.config
"eNtsaOnlineRegistrationDB" connectionString="Data Source=(LocalDb)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\eNtsaOnlineRegistrationDB.mdf;Initial Catalog=eNtsaOnlineRegistrationDB; Integrated Security=True" providerName="System.Data.SqlClient" />

2 Replies

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

Jignesh Kumar6y ago
Accepted answer
Hi ,

Please run sp_helptext GetAdvertReport on your query windo if it gives then store procedure is there else you need to create store procedure in you database
Guest User6y ago
The object 'GetAdvertReport' does not exist in database 'master' or is invalid for this operation.