CBO not working - Getting Started

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

Home All Forums

2/3/2013 5:18 PM

phibud

Joined: 1/11/2007

Posts: 3

CBO not working

I'm writing on module for display songs for a good self-training exercise. Can anybody help me out? My CBO query isn't working, but the commented out query is. Can someone point me in the right direction?
Thanks
-Phil
public static List GetSongs(int portalId, string title)
{
//List l = new List();
//IDataReader dr = DataProvider.Instance().GetSongs(portalId, title);
//while (dr.Read())
//{
// Song t = new Song
// {
// Title = dr["Title"].ToString(),
// Artist = dr["Artist"].ToString()
// };
// l.Add(t);
//}
//return l;
return CBO.FillCollection(DataProvider.Instance().GetSongs(portalId, title));
}

2/4/2013 1:22 PM

Chris Hammond

www.christoc.com
Joined: 1/14/2003

Posts: 7319

Re: CBO not working

When you use CBO you need pass in what type of Object you are trying to fill. Check out some of the examples on the latest code I checked into the Task Manager project (been working on a new version for DNN7)

http://dnntaskmanager.codeplex.com/So...

Chris Hammond
Former DNN Corp Employee, MVP, Core Team Member, Trustee
Christoc.com Software Solutions DotNetNuke Module Development, Upgrades and consulting.
dnnCHAT.com a chat room for DotNetNuke discussions

2/5/2013 8:54 PM

phibud

Joined: 1/11/2007

Posts: 3

Re: CBO not working

public static List GetSongs(int portalId, string title)
{
//List l = new List();
//IDataReader dr = DataProvider.Instance().GetSongs(portalId, title);
//while (dr.Read())
//{
// Song t = new Song
// {
// Title = dr["Title"].ToString(),
// Artist = dr["Artist"].ToString()
// };
// l.Add(t);
//}
//return l;
return CBO.FillCollection(DataProvider.Instance().GetSongs(portalId, title));
}

So I have passed the object. Not sure why I didn't have that in my original posting. I'm still getting back a blank response when using the following in the front-end ascx:
DataBinder.Eval(Container.DataItem,"Artist")

However, the same works when using the commented code. Adding ToString() at the end of the DataBinder gives an error (probably due to object cast):
A critical error has occurred.An unexpected error has occurred

The cs file contains a call to the controller which returns a list of songs:
rptSongs.DataSource = SongController.GetSongs(PortalId, txtSearch.Text);

When using the CBO, it returns the correct number of records, but the fields are empty! Ahh!

2/6/2013 1:32 AM

Michael Tobisch

https://www.dnnwerk.at
Joined: 6/27/2005

Posts: 2083

Re: CBO not working Modified By Michael Tobisch on 2/6/2013 1:39:58 AM

phibud,

try using

return CBO.FillCollection< song >(DataProvider.Instance().GetSongs(portalId, title));

Are you trying to get one song or a list of songs? To get only one, you can use

return CBO.FillObject< song >(DataProvider.Instance().GetSong(songId));

(Don't use spaces between the angle brackets and the object's type, it's just to make it visible here in the forum)

Best wishes
Michael

Michael Tobisch
DNN★MVP

2/8/2013 9:03 PM

phibud

Joined: 1/11/2007

Posts: 3

Re: CBO not working

Bah. I think the forum cut out my < song >. The point is. I am using < song >. It returns the correct number of items. I am trying to get multiple results. I just don't get it. I'll use the commented out section til I can figure it out. It appears whatever I'm doing at least isn't blatantly obvious (which I guess is good).

Thanks for the input folks.

Page 1 of 1

These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
No Flaming or Trolling.
No Profanity, Racism, or Prejudice.
Site Moderators have the final word on approving / removing a thread or post or comment.
English language posting only, please.

Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

DNN Corp. (DotNetNuke)