Databases
StackOverflow2013
Postsdbo
POData is not displaying in datagrid wpf
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POData is not displaying in datagrid wpf
    text
    copied!<p>i have a Data Grid to display the data coming form database, Data is coming from two tables using foreign key.But problem is that data is not displaying in the grid but rows are displaying but rows are empty without data. can any one point out my mistake where i am wrong</p> <pre><code> &lt;DataGrid AutoGenerateColumns="False" Name="SParts_grid" HorizontalAlignment="Center" Margin="32,127,32,0" VerticalAlignment="Top" Height="161" Width="530" &gt; &lt;DataGrid.Columns&gt; &lt;DataGridTextColumn Header="Part Code" Width="89" Binding="{Binding Path=SPartCode, Mode=OneWay}" /&gt; &lt;DataGridTextColumn Header="Part Name" Width="140" Binding="{Binding Path=SPartName, Mode=OneWay}" /&gt; &lt;DataGridTextColumn Width="90" Header="Part Price" Binding="{Binding Path=SPartSalePrice, Mode=OneWay}" /&gt; &lt;DataGridTextColumn Header="Model" Width="90" Binding="{Binding Path=ModelName, Mode=OneWay}" /&gt; &lt;DataGridTextColumn Header="Location" Width="60" Binding="{Binding Path=SPartLocation, Mode=OneWay}" /&gt; &lt;DataGridCheckBoxColumn Header="Active" Width="58" Binding="{Binding Path=SPartActive, Mode=OneWay}" /&gt; &lt;/DataGrid.Columns&gt; &lt;/DataGrid&gt; </code></pre> <p>So i used a class to assign the database data into the class</p> <pre><code>private void Window_Loaded(object sender, RoutedEventArgs e) { LoadParts(); } public class PartsListObjects { public int partid; public string SPartName; public string SPartCode; public string SPartLocation; public bool SPartActive; public string ModelName; public string SPartSalePrice; } private void LoadParts() { RST_DBDataContext conn = new RST_DBDataContext(); List&lt;PartsListObjects&gt; AllParts = (from s in conn.TblSpareParts join m in conn.TblBikeModels on s.ModelID equals m.ModelID select new PartsListObjects() { SPartName = s.SPartName, SPartCode = s.SPartCode, SPartLocation = s.SPartLocation, SPartSalePrice = s.SPartSalePrice.ToString(), ModelName = m.ModelName, SPartActive = s.SPartActive }).ToList(); SParts_grid.ItemsSource = AllParts; SParts_grid.Items.Refresh(); } </code></pre>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

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