Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I had a similar problem because the user was able to define the columns of the grid at runtime.</p> <p>I wrote a control containing the xam datagrid and exposing a DataSource dependency property to bind the model for the grid (i.e. a data table).</p> <p>Every time the source changed (you can add event listeners for PropertyChanged and the grids FieldLayoutInitializing event) the grid was dynamically re-rendered by clearing its datasource and resetting it:</p> <pre><code>private void ReRenderGrid() { XamDataGrid.FieldLayouts.Clear(); XamDataGrid.ClearValue(DataPresenterBase.DataSourceProperty); XamDataGrid.DataSource = DataSource.Data.DefaultView; } </code></pre> <p>The columns are re configured by an event handler on the following event which is raised by xamdatagrid after the grids datasource is reset:</p> <pre><code>XamDataGrid.FieldLayoutInitializing += LayoutInitializing; </code></pre> <p>Handler:</p> <pre><code>private void LayoutInitializing(object sender, FieldLayoutInitializingEventArgs e) { const string deletebuttonstyle = "DeleteButtonStyle"; const string requiredinputvalue = "RequiredInputValue"; const string optionalinputvalue = "OptionalInputValue"; const string outputvalue = "OutputValue"; var fieldLayout = e.FieldLayout; fieldLayout.Fields.Clear(); AddFields(DataSource.InColumns, requiredinputvalue, fieldLayout); AddSplitter(fieldLayout); AddFields(DataSource.OptionalInColumns, optionalinputvalue, fieldLayout); AddSplitter(fieldLayout); AddFields(DataSource.OutColumns, outputvalue, fieldLayout); AddUnboundField(fieldLayout, string.Empty, GetStyle(deletebuttonstyle)); } </code></pre> <p>In my case the datasource contained all columns the user configured. AddFields calls this method for each list entry:</p> <pre><code>private void AddField(string name, Style style, FieldLayout fieldLayout) { var field = new Field {Name = name}; field.Settings.LabelPresenterStyle = style; field.Settings.CellValuePresenterStyle = GetStyle("StandardCellValueStyle"); fieldLayout.Fields.Add(field); } </code></pre> <p>AddSplitter and AddUnboundField are implemented in a similar fashion. </p>
    singulars
    1. This table or related slice is empty.
    1. POMVVM - How to create columns at runtime for a xamdatagrid?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USZebi
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. COZebi, thank you very much for these code snipppets. I am sure its working and it looks indeed promising. However these are just code snippets. I cant follow the states. XamDataGrid.DataSource = DataSource.Data.DefaultView; What is Data in this case, I seem not to have it. The Method AddFields seem to have different signature than your AddField. It is really not clear yet to me how this should work. A simple working example would really be appreciated.
      singulars
      1. PO
      1. USHouman
    2. COThe DataSource Property in my example refers to a custom Type I made holding the data table (.Data property) and the columns the user defined (he can define 3 types of cols, input, optional input and output cols). You have to have some Data Table to use as datasource for your grid. Reset this table. I can not create a working example right now because the code is from a project at work. I'll see if I can do tomorrow.
      singulars
      1. PO
      1. USZebi
    3. COThanks Zebi, highly appreciated.
      singulars
      1. PO
      1. USHouman
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload