Databases
StackOverflow2013
Postsdbo
POHow to populate a datagrid based on value in combobox
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow to populate a datagrid based on value in combobox
    primarykey
    data
    text
    <p>I am facing a question (maybe very basic). I have a combobox1 and it has filled values (say 1,2,3,4,5) from earlier controls.</p> <p>Now based on choosing a value from the combobox1, I want to populate the columns of a datagrid.</p> <p>Now, the datagrid has 4 columns, one DataGridcheckboxcolumn(value set to checked as default), one DataGridtextboxcolumn1 for autopopulation from the combobox1(the most important part), one DataGridTextBoxColumn2(to set as default value) and one DataGridComboBoxColumn(set to default value AVS_DB frm AVS,DB,AVS_DB).</p> <p>My question is very basic.</p> <p>How do I get the values in the datagrid populated.</p> <p>The xaml and the codebehind are as follows:</p> <pre><code>&lt;DataGrid Name="dtgQCNumbers" Width="400" AutoGenerateColumns="False" Grid.ColumnSpan="2" Height="100" Grid.RowSpan="5" Grid.Row="6" SelectionChanged="dtgQCNumbers_SelectionChanged" Grid.Column="1" Margin="3,10,125,15"&gt; &lt;DataGrid.Columns&gt; &lt;DataGridCheckBoxColumn Header="Enter_Choice" Width="100" Binding="{Binding Path=DataGridCheckBox_Option}" /&gt; &lt;DataGridTextColumn Header="QC_ID" Width="100" Binding="{Binding Path=DataGridTextBox_QCList1}" /&gt; &lt;DataGridTextColumn Header="Summary" Width="100" Binding="{Binding Path=DataGridTextBox_QCSummary}" /&gt; &lt;DataGridComboBoxColumn Header="ControlOption" Width="100" SelectedItemBinding="{Binding Path=DataGridComboxBox_Control}"&gt; &lt;DataGridComboBoxColumn.ItemsSource&gt; &lt;col:ArrayList&gt; &lt;sys:String&gt;AVS&lt;/sys:String&gt; &lt;sys:String&gt;DB&lt;/sys:String&gt; &lt;sys:String&gt;AVS_DB&lt;/sys:String&gt; &lt;/col:ArrayList&gt; &lt;/DataGridComboBoxColumn.ItemsSource&gt; &lt;/DataGridComboBoxColumn&gt; &lt;/DataGrid.Columns&gt; grid.ColumnWidth = new DataGridLength(100); &lt;/DataGrid&gt; </code></pre> <p><em>The code to populate the ComboBox (before the datagrid) is:</em></p> <pre><code>private void ddlCR_SelectionChanged(object sender, SelectionChangedEventArgs e) { btnSubmit.IsEnabled = true; ClearStatusMessages(); if (ddlCR.SelectedIndex &gt; 0) { PopulateQCIdList(); } } </code></pre> <p>Now the PopulateQCIdList() should populate the DataGrid Columns (all 4 Columns, 3 default values and value driven from what we choose from the combobox)</p> <p>The codebehind is what I want to know to populate data after the ComboBox has been populated, i.e. I want to know how exactly to fill the DataGrid using the PopulateQCIdList() method.</p> <p>Please edit/let me know if I missed any information</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USAshutosh
    1. USAshutosh
    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. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COWhat about binding the currently selected row to your controls ? Like in a master / detail view ?
      singulars
      1. POHow to populate a datagrid based on value in combobox
      1. USGameAlchemist
    2. COVincent, could you point me any example?
      singulars
      1. POHow to populate a datagrid based on value in combobox
      1. USAshutosh
    3. COI think I can bind a datatable to a the datagrid; in doing so, I can map all columns of the datatable to the corresponding columns in the datagrid. Please advise.
      singulars
      1. POHow to populate a datagrid based on value in combobox
      1. USAshutosh
 

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