C1 Community

I am using Visual Studio 2008.  I have create a DataLibrary with three DataSets (Menu, MenuGroup, and MenuItem).  Each row in Menu has linked items in MenuGroup.  The problem is that when I call .GetMENU_GROUPRows() I get a "Value does not fall within the expected range" error.

 Here is a snippet of code:

dsMenu.Fill();   // ds is a C1WebDataSet
C1.Data.C1DataTable ds = dsMenu.Tables["MENU"];
for (int i = 0; i < ds.Rows.Count; i++ )
{
     MENURow mrow = MENURow.Obj(ds.Rows[i]);
     C1WebMenu1.Items.Add(new C1WebMenuItem(mrow.Title));
     MENU_GROUPRow[] grow = mrow.GetMENU_GROUPRows();   // Error here: "Value does not fall within the expected range"

 I have absolutley no idea why this error happens.  Can you help?

Thanks

Mark

Ok I've figured this one out.

I originally had only the Menu table in the dataset.  When I added then MenuGroup table the call works perfectly.  Although I'm not sure why the method GetMENU_GROUPRRows() was created in the first place.

So lesson learned:  If you are going to use a dataset and you are going to ask for rows from a related table, make sure the related table is in the dataset - just being in the Schema is not good enough.

Mark