Hi Team
I need help and want to improve my back end logic, when debugging its not displaying the data to the grid.
public void PopulateGrid() { Managers.BatchMaterialManager.SetAdriotConnection(); var dtBatchRecipe = Managers.BatchMaterialManager.GetBatcherMatAndWbMat(); DataView dv = dtBatchRecipe.DefaultView; Managers.BatchMaterialManager.SetDefaultConnection(); /*try { dv.RowFilter = string.Format("CONVERT({0}, System.String) not like %PREMIX%"); View.GridMacroRecipe.ItemsSource = dv; DataView dvPremix = dtBatchRecipe.DefaultView; dvPremix.RowFilter = string.Format("CONVERT({0}, System.String) like %PREMIX"); }catch(Exception ex) { } */ } //user load control private void UserControl_Loaded(object sender, RoutedEventArgs e) { LoadControl(); presenter.PopulateGrid(); } // loads data to the server public void LoadControl() { Managers.BatchMaterialManager.SetAdriotConnection(); presenter.PopulateComboBox(); Properties.Settings.Default.Process = "Recipes"; string[] arrayOil = RecipeName.Split('/'); string OilIndicator = string.Empty; if (arrayOil.Length > 1) { OilIndicator = arrayOil[arrayOil.Length - 2].ToString(); } else { // Handle the case where there is no '/' in RecipeName OilIndicator = ""; // Or set it to some default value or throw an exception } string LastDigit = string.Empty; if (RecipeName.Length > 1) { LastDigit = RecipeName[RecipeName.Length - 2].ToString(); } else { // Handle the case where RecipeName is too short LastDigit = ""; // Or set it to some default value or throw an exception } if (OilIndicator == "2") { txtBagWeight.IsEnabled = false; } } // front end wpf grid <!--GataGrid name on top--> <Label Content="Macros" FontWeight="SemiBold" HorizontalAlignment="Left" HorizontalContentAlignment="Center" VerticalAlignment="Top" Width="780" BorderBrush="#FFBEBEBE" Background="#FFE3E3E3" BorderThickness="1.5" Foreground="Black" Height="35" VerticalContentAlignment="Center" FontSize="14" Margin="14,460,0,0"/> <!---Name of the screen on top--> <Label Content="Premix-Batch Management" BorderThickness="1.5" BorderBrush="#FF0B0B0B" Background="#FF383838" Foreground="White" FontSize="18" HorizontalContentAlignment="Center" VerticalAlignment="Top" Margin="10,10,0,0" FontWeight="SemiBold" /> <!--Data Grid columns names--> <DataGrid x:Name="dgvMacroRecipe" VerticalScrollBarVisibility="Visible" SelectedCellsChanged="dgvMacroRecipe_SelectedCellsChanged" CellEditEnding="dgvMacroRecipe_CellEditEnding" VerticalAlignment="Top" HorizontalGridLinesBrush="#FFBBBBBB" AutoGenerateColumns="False" CanUserDeleteRows="False" HeadersVisibility="Column" GridLinesVisibility="Horizontal" FontWeight="Normal" BorderBrush="#FF767676" Margin="12,497,0,0" HorizontalAlignment="Left" FontSize="12" Width="780" > <DataGrid.Resources> <Style TargetType="{x:Type DataGridCell}"> <Style.Triggers> <Trigger Property="IsSelected" Value="True"> <Setter Property="Background" Value="Blue" /> <Setter Property="BorderBrush" Value="Blue"/> </Trigger> </Style.Triggers> </Style> </DataGrid.Resources> <DataGrid.ColumnHeaderStyle> <Style TargetType="{x:Type DataGridColumnHeader}"> <Setter Property="FontWeight" Value="SemiBold"/> <Setter Property="TextElement.FontSize" Value="14"/> <Setter Property="Background" Value="#FF383838"/> <Setter Property="Foreground" Value="White"/> <Setter Property="HorizontalContentAlignment" Value="Center"/> <Setter Property="Height" Value="30"/> <Setter Property="SeparatorVisibility" Value="Visible"/> </Style> </DataGrid.ColumnHeaderStyle> <DataGrid.Columns> <DataGridTextColumn Visibility="Visible" Width="5"> <DataGridTextColumn.ElementStyle> <Style TargetType="{x:Type TextBlock}"> <Setter Property="HorizontalAlignment" Value="Center" /> <Setter Property="VerticalAlignment" Value="Center"/> </Style> </DataGridTextColumn.ElementStyle> </DataGridTextColumn> <DataGridTextColumn Binding="{Binding idx}" Header="IDX" Width="Auto" IsReadOnly="True" Visibility="Hidden"> <DataGridTextColumn.ElementStyle> <Style TargetType="{x:Type TextBlock}"> <Setter Property="HorizontalAlignment" Value="Left" /> <Setter Property="VerticalAlignment" Value="Center"/> </Style> </DataGridTextColumn.ElementStyle> </DataGridTextColumn> <!--IDX column--> <DataGridTextColumn Binding="{Binding idx1}" Header="IDX" Width="Auto" IsReadOnly="True"> <DataGridTextColumn.ElementStyle> <Style TargetType="{x:Type TextBlock}"> <Setter Property="HorizontalAlignment" Value="Left" /> <Setter Property="VerticalAlignment" Value="Center"/> </Style> </DataGridTextColumn.ElementStyle> </DataGridTextColumn> <DataGridTextColumn Visibility="Visible" Width="5"> <DataGridTextColumn.ElementStyle> <Style TargetType="{x:Type TextBlock}"> <Setter Property="HorizontalAlignment" Value="Center" /> <Setter Property="VerticalAlignment" Value="Center"/> </Style> </DataGridTextColumn.ElementStyle> </DataGridTextColumn> <!---RM Code column--> <DataGridTextColumn Binding="{Binding RM_Code}" Header="RM Code" Width="Auto" IsReadOnly="True" FontSize="8"> <DataGridTextColumn.ElementStyle> <Style TargetType="{x:Type TextBlock}"> <Setter Property="HorizontalAlignment" Value="Left" /> <Setter Property="VerticalAlignment" Value="Center"/> </Style> </DataGridTextColumn.ElementStyle> </DataGridTextColumn> <DataGridTextColumn Visibility="Visible" Width="5"> <DataGridTextColumn.ElementStyle> <Style TargetType="{x:Type TextBlock}"> <Setter Property="HorizontalAlignment" Value="Center" /> <Setter Property="VerticalAlignment" Value="Center"/> </Style> </DataGridTextColumn.ElementStyle> </DataGridTextColumn> <!---Stock Code column--> <DataGridTemplateColumn Header="Stock Code"> <DataGridTemplateColumn.CellTemplate> <DataTemplate> <TextBlock x:Name="txtStockCode" Text="{Binding [Stock Code]}"/> </DataTemplate> </DataGridTemplateColumn.CellTemplate> <DataGridTemplateColumn.CellEditingTemplate> <DataTemplate> <ComboBox Height="22" Width="auto" x:Name="cbxMacroStockType" ItemsSource="{Binding Source={StaticResource StockCode}}" DisplayMemberPath="Code" SelectedValue="Code" SelectedValuePath="idx1" IsSynchronizedWithCurrentItem="True" DropDownClosed="cbxMacroStockType_DropDownClosed" /> </DataTemplate> </DataGridTemplateColumn.CellEditingTemplate> </DataGridTemplateColumn> <DataGridTextColumn Visibility="Visible" Width="5"> <DataGridTextColumn.ElementStyle> <Style TargetType="{x:Type TextBlock}"> <Setter Property="HorizontalAlignment" Value="Center" /> <Setter Property="VerticalAlignment" Value="Center"/> </Style> </DataGridTextColumn.ElementStyle> </DataGridTextColumn> <!---Stock Description column--> <DataGridTextColumn Binding="{Binding [Stock Description]}" Header="Stock Description" Width="auto" IsReadOnly="True" FontWeight="SemiBold"> <DataGridTextColumn.ElementStyle> <Style TargetType="{x:Type TextBlock}"> <Setter Property="TextAlignment" Value="Center" /> <Setter Property="VerticalAlignment" Value="Center" /> <Style.Triggers> <Trigger Property="Text" Value="Yes"> <Setter Property="Background" Value="LightGreen"/> </Trigger> <Trigger Property="Text" Value="No"> <Setter Property="Background" Value="#FFFF6969"/> </Trigger> </Style.Triggers> </Style> </DataGridTextColumn.ElementStyle> </DataGridTextColumn> <DataGridTextColumn Visibility="Visible" Width="5"> <DataGridTextColumn.ElementStyle> <Style TargetType="{x:Type TextBlock}"> <Setter Property="HorizontalAlignment" Value="Center" /> <Setter Property="VerticalAlignment" Value="Center"/> </Style> </DataGridTextColumn.ElementStyle> </DataGridTextColumn> <!---Percentage column--> <DataGridTextColumn Binding="{Binding Percentage}" Header="Percentage" Width="auto" FontWeight="SemiBold"> <DataGridTextColumn.ElementStyle> <Style TargetType="{x:Type TextBlock}"> <Setter Property="TextAlignment" Value="Center" /> <Setter Property="VerticalAlignment" Value="Center" /> <Style.Triggers> <Trigger Property="Text" Value="Yes"> <Setter Property="Background" Value="LightGreen"/> </Trigger> <Trigger Property="Text" Value="No"> <Setter Property="Background" Value="#FFFF6969"/> </Trigger> </Style.Triggers> </Style> </DataGridTextColumn.ElementStyle> </DataGridTextColumn> <DataGridTextColumn Visibility="Visible" Width="5"> <DataGridTextColumn.ElementStyle> <Style TargetType="{x:Type TextBlock}"> <Setter Property="HorizontalAlignment" Value="Center" /> <Setter Property="VerticalAlignment" Value="Center"/> </Style> </DataGridTextColumn.ElementStyle> </DataGridTextColumn> <!---Kilograms--> <DataGridTextColumn Binding="{Binding Kilograms}" Header="Kilograms" Width="Auto" IsReadOnly="True" FontWeight="SemiBold"> <DataGridTextColumn.ElementStyle> <Style TargetType="{x:Type TextBlock}"> <Setter Property="HorizontalAlignment" Value="Left" /> <Setter Property="VerticalAlignment" Value="Center"/> </Style> </DataGridTextColumn.ElementStyle> </DataGridTextColumn> <DataGridTextColumn Visibility="Visible" Width="5"> <DataGridTextColumn.ElementStyle> <Style TargetType="{x:Type TextBlock}"> <Setter Property="HorizontalAlignment" Value="Center" /> <Setter Property="VerticalAlignment" Value="Center"/> </Style> </DataGridTextColumn.ElementStyle> </DataGridTextColumn> </DataGrid.Columns> </DataGrid>