Couple of quick questions...
I'm working on a module in which I'm wanting to use a different stored procedure than the one initially used... I've changed out the proc name in the SQLDataProvider file for both of my objects, yet when I run the module on a page, I get an error which says it cannot find the stored procedure... 'Could not find stored procedure 'dbo.YourCompany_GetConferences'
Now, here's where it gets sticky... I'm not calling that procedure, anywhere... I've got through my module (based off of the C# module template) and I've changed the getConferences procedure to the one that I want. It's not named the same, obviously, nor can I rename it, as it's part of a preexisting data structure... I've also, I think, removed any code which tacks on the dbo or the YourCompany_, yet, it's still showing up... Is there some place other than in the SQLDataProvider file in the module where this stuff is being activated from? Cause, for the life of me, I think the changes I've made should have fixed this.
Thanks,
Brian
public override IDataReader GetConferences()
{
return (IDataReader)SqlHelper.ExecuteReader(StatsDBConnectionString, "ff_GetCollegeBasketBallConferences");
}
public override IDataReader GetTeamsByConference(string conferencename)
{
//return (IDataReader)SqlHelper.ExecuteReader(StatsDBConnectionString, GetFullyQualifiedName("ff_GetCollegeBasketBallConferenceTeams"), conferencename);
return (IDataReader)SqlHelper.ExecuteReader(StatsDBConnectionString, "ff_GetCollegeBasketBallConferenceTeams", conferencename);
}