Hi Deon,

The most common cause of a problem like this is the Band Keys. When you set up your bands and columns at design-time, you must make sure that the key of each band matches the key of the data source you are assigning at run-time. The key of a child band is the name of the Relationship in the DataSet, not the table.

What I would do is go into the InitializeLayout event of your grid and loop through the band and the write out the Key of each band in the collection. Then go into the grid designer and make sure your design-time structure is using the same keys.

Hi Mike,

I have an ultragrid with 3 bands defined, and all column headers etc for the bands are set up using the designer. I retrieve 3 datatables, add them to a dataset, add parent-child relations and bind them to the grid. All columns in the grid are unbound.

My problem is that only the first band retains the designer-generated column settings, the second and third do not - columns hidden in the designer are shown, and the column headers are the column names from the datatable.

I could write code to manually set up the 2nd and 3rd bands, but is there a way for the grid to retain and bind the columns that have already been set up in the designer?

Thanks

Deon

Easiest way to achieve multiple bands is adding relation between or amongst DataTables in DataSet.  Once it is done, assign parent DataTable as DataSource to UltraGrid:

Example:

businessDataset.Relations.Add("data_relation_key", 

     businessDataset.Tables("parent_table").Columns("column_name"), 

     businessDataset.Tables("child_table").Columns("column_name"))
 
MyUltraGrid.DataSource = Nothing
MyUltraGrid.DataSource = businessDataset.Tables(0)
MyUltraGrid.DataBind()

ok...I find it...so answer to myself...

forgot datamember Initialization...
mygrid.datamember = "myparentTable"...

bla bla bla.. ;)

Hi !

I have a very simple dataset with 2 tables... and just a relation, Parent-child.

The datasource contains the 2 tables and if I look the relation i'm able to see it..

when I assign the dataset at datasource  property,I manage the settings grid about InitializeLayout.

And here happens the error : The controls havent 2 bands !

And if i look inside Band Members i see (All = 1... ) and the table current is the child table .

At the end of this speech...seems like that a table  isn't loaded into the bands... into ultragrid.

And this is the code..

It's crash 'cause the table parent isn't in datasource's grid  but when i assign via code  

mygrd.datasource = mydataset (in dataset i have really 2 tables with 1 relation)!

private void ultraGridRilievi_InitializeLayout(object sender, InitializeLayoutEventArgs e)
        {
            try
            {
                string s = ultraGridRilievi.DisplayLayout.Bands[0].Key;

                ultraGridRilievi.DisplayLayout.Bands[0].Columns["NomeGruppo"].Hidden = false;
                ultraGridRilievi.DisplayLayout.Bands[0].Columns["Misura"].Hidden = false;
                ultraGridRilievi.DisplayLayout.Bands[0].Columns["Documento"].Hidden = true;
                ultraGridRilievi.DisplayLayout.Bands[0].Columns["GruppoRilievo"].Hidden = true;


                ultraGridRilievi.DisplayLayout.Bands[1].Columns["Documento"].Hidden = true;
                ultraGridRilievi.DisplayLayout.Bands[1].Columns["Nome"].CellActivation = Activation.AllowEdit;
                ultraGridRilievi.DisplayLayout.Bands[1].Columns["ObjIDRilievo"].Hidden = true;
                ultraGridRilievi.DisplayLayout.Bands[1].Columns["GruppoRilievo"].Hidden = true;

            }
            catch (System.Exception er)
            {
                MessageBox.Show("Error in ultraGridRilievi_InitializeLayout " + er.Message);
            }

        }

any idea ?

of course the grid  is multiband..