Best way to show fields from multiple tables on one grid


Author
Message
lastcanary
lastcanary
StrataFrame User (227 reputation)StrataFrame User (227 reputation)StrataFrame User (227 reputation)StrataFrame User (227 reputation)StrataFrame User (227 reputation)StrataFrame User (227 reputation)StrataFrame User (227 reputation)StrataFrame User (227 reputation)StrataFrame User (227 reputation)
Group: StrataFrame Users
Posts: 81, Visits: 270
I have two tables:



exchange(exc_code,exc_desc) (Exchange code and exchange description)



exchange_rate(exr_code, exr_valu, exr_date) (Exchange code, excange rate value, exchange rate date)





I want to display on one grid the following information: (exr_code is a foreign key to exc_code)



exr_code,exc_desc,exr_valu,exr_date





What is the best way to achive this? I tried to read the forms and manages to create a new custom field on a BO but still it cannot be displayed in the grid.



Could you please give me a simple example?



Best Regards

Reply
lastcanary
lastcanary
StrataFrame User (227 reputation)StrataFrame User (227 reputation)StrataFrame User (227 reputation)StrataFrame User (227 reputation)StrataFrame User (227 reputation)StrataFrame User (227 reputation)StrataFrame User (227 reputation)StrataFrame User (227 reputation)StrataFrame User (227 reputation)
Group: StrataFrame Users
Posts: 81, Visits: 270
I am trying to add a custom field to my custom BO which is created in custom BBS wizard. I checked the strataflix example and tried to use the same technique but it seems I am missing some point.



In strataflix example in "People Profile Report" there is PeopleBO, in this BO to add custom fields:



In region " Private Fields " the following line is added:

private static MovieCastBBS _MovieCast = new MovieCastBBS();



In region " Protected Methods " the following line is added:

r.Add(new ReflectionPropertyDescriptor("MovieCast", typeof(PeopleBO)));



In region " Public Properties " the following lines are added:

public MovieCastBBS MovieCast

{

   get

   {

   //-- Make sure that records exists prior to filter

      if (this.Count > 0)

      {

         //-- Filter out the movie cast records for the current person

         _MovieCast.SourceBO.Filter = "mc_pl_pk = " + this.pl_pk.ToString();

      }



                  

   return _MovieCast;

}

}



I added the similar lines to my example but I am receiving the following error:



Error   2   Inconsistent accessibility: property type 'deneme.test.dovizBBS' is less accessible than property 'deneme.test.kurlar.deneme'   E:\DENEME\DENEME\Multi Table Grid\deneme\kurlarBO.cs   68   25   deneme



Could you please help?
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...





Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search