Filtering a datagridview on two fields

[wjburke2]

I am hoping someone can help me. I am converting a Winform app to WPF. Sounded simple when my boss told me that's what I was going to do. But I have already ran into a problem. On the window below I have a DataGridview. The user selects a Category and the datagridview shows all the Campaigns for that Category. There are four types of entries Standard\Test\Control\Notes also Campaigns begin and end so the user only wants to see campaigns the were active for the date they enter. So what I need to do is figure out how to get the Datagridview to only show them what they want. I have included what code I have. I have read a lot about CollectionViewSource filtering but am fussy on how I apply it. I hope someone can help. Thanks

<Window x:Class="MainWindow"
        xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
        xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
        xmlns:d="http://schemas.microsoft.com/expression/blend/2008"
        xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"
        xmlns:local="clr-namespace:WpfApp1"
        mc:Ignorable="d"
        Title="MainWindow" Height="450" Width="800">
    <Window.Resources>
        <local:Inq_FULF_DataDataSet x:Key="Inq_FULF_DataDataSet"/>
        <CollectionViewSource x:Key="CategoryViewSource" Source="{Binding Category, Source={StaticResource Inq_FULF_DataDataSet}}"/>
        <CollectionViewSource x:Key="CategoryCampaignViewSource" Source="{Binding FK_Campaign_Category, Source={StaticResource CategoryViewSource}}"/>
    </Window.Resources>


    <Grid DataContext="{StaticResource CategoryCampaignViewSource}" Margin="0,1,0,-1">
        <Grid x:Name="Grid1" DataContext="{StaticResource CategoryViewSource}" HorizontalAlignment="Left" Margin="33,12,0,0" VerticalAlignment="Top" Width="591">

            <Label Content="CAT Category:" Grid.Column="0" HorizontalAlignment="Left" Margin="3" Grid.Row="0" VerticalAlignment="Center"/>
            <ComboBox x:Name="CAT_CategoryComboBox" DisplayMemberPath="CAT_Category" HorizontalAlignment="Left" Height="Auto" ItemsSource="{Binding}" Margin="94,6,0,4" Grid.Row="0" VerticalAlignment="Center" Width="487">
                <ComboBox.ItemsPanel>
                    <ItemsPanelTemplate>
                        <VirtualizingStackPanel/>
                    </ItemsPanelTemplate>
                </ComboBox.ItemsPanel>
            </ComboBox>
        </Grid>

        <!-- Select Date  R T L B -->
        <DatePicker x:Name="dtpSelDate" SelectedDate="2000-12-31" SelectedDateFormat="Short" Margin="644,61,34,323"/>

        <!-- Campaign Type -->
        <GroupBox Header="Campaign Type" Margin="36,51,440,308" BorderBrush="Black" BorderThickness="1">
            <Grid Margin="0,-2,0,2" >
                <Grid.ColumnDefinitions>
                    <ColumnDefinition Width="53*"/>
                    <ColumnDefinition Width="2*"/>
                </Grid.ColumnDefinitions>

                <RadioButton x:Name="rbStandard"    Content="Standard" GroupName="CampType" HorizontalAlignment="Left"  Margin="0,10,0,2"     VerticalAlignment="Center" Height="16" Width="73" RenderTransformOrigin="-0.562,1.8"/>
                <RadioButton x:Name="rbTest"            Content="Test"         GroupName="CampType" HorizontalAlignment="Left"  Margin="74,10,0,2"   VerticalAlignment="Center" Height="16" Width="51"/>
                <RadioButton x:Name="rbControl"       Content="Control"    GroupName="CampType" HorizontalAlignment="Left"  Margin="124,10,0,2" VerticalAlignment="Center" Height="16" Width="70" RenderTransformOrigin="-1.5,-1.667"/>
                <RadioButton x:Name="rbNote"           Content="Note"        GroupName="CampType" HorizontalAlignment="Left"  Margin="194,10,0,2" VerticalAlignment="Center" Height="16" Width="55"/>

            </Grid>
        </GroupBox>

        <DataGrid x:Name="CampaignDataGrid" AutoGenerateColumns="False" EnableRowVirtualization="True" ItemsSource="{Binding}" Margin="36,116,34,103" RowDetailsVisibilityMode="VisibleWhenSelected" IsReadOnly="True">
            <DataGrid.Columns>
                <DataGridTextColumn x:Name="CM_Cat_IDColumn" Binding="{Binding CM_Cat_ID}" Header="CM Cat ID" Width="SizeToHeader" Visibility="Hidden"/>
                <DataGridTextColumn x:Name="Cam_IDColumn" Binding="{Binding Cam_ID}" Header="Cam ID" IsReadOnly="True" Width="SizeToHeader" Visibility="Hidden"/>
                <DataGridTextColumn x:Name="CM_TestFlagColumn" Binding="{Binding CM_TestFlag}" Header="CM Test Flag" Width="SizeToHeader" Visibility="Hidden"/>
                <DataGridTextColumn x:Name="TestFlagLitColumn" Binding="{Binding TestFlagLit}" Header="S\T" IsReadOnly="True" Width="50"/>
                <DataGridTextColumn x:Name="CM_CampaignColumn" Binding="{Binding CM_Campaign}" Header="CM Campaign" Width="250"/>
                <DataGridTextColumn x:Name="CM_CamTypeColumn" Binding="{Binding CM_CamType}" Header="CM Cam Type" Width="250"/>
                <DataGridTextColumn x:Name="CM_BDateColumn" Binding="{Binding CM_BDate, StringFormat='MM/dd/yyy'}" Header="CM BDate" Width="80"/>
                <DataGridTextColumn x:Name="CM_EDateColumn" Binding="{Binding CM_EDate, StringFormat='MM/dd/yyy'}" Header="CM EDate" Width="80"/>
            </DataGrid.Columns>
        </DataGrid>

    </Grid>
</Window>

Class MainWindow
    Private Sub Window_Loaded(sender As Object, e As RoutedEventArgs) Handles MyBase.Loaded

        Dim Inq_FULF_DataDataSet As WpfApp1.Inq_FULF_DataDataSet = CType(Me.FindResource("Inq_FULF_DataDataSet"), WpfApp1.Inq_FULF_DataDataSet)
        'Load data into the table Category. You can modify this code as needed.
        Dim Inq_FULF_DataDataSetCategoryTableAdapter As WpfApp1.Inq_FULF_DataDataSetTableAdapters.CategoryTableAdapter = New WpfApp1.Inq_FULF_DataDataSetTableAdapters.CategoryTableAdapter()
        Inq_FULF_DataDataSetCategoryTableAdapter.Fill(Inq_FULF_DataDataSet.Category)
        Dim CategoryViewSource As System.Windows.Data.CollectionViewSource = CType(Me.FindResource("CategoryViewSource"), System.Windows.Data.CollectionViewSource)
        CategoryViewSource.View.MoveCurrentToFirst

        'Load data into the table Campaign. You can modify this code as needed.
        Dim Inq_FULF_DataDataSetCampaignTableAdapter As WpfApp1.Inq_FULF_DataDataSetTableAdapters.CampaignTableAdapter = New WpfApp1.Inq_FULF_DataDataSetTableAdapters.CampaignTableAdapter()
        Inq_FULF_DataDataSetCampaignTableAdapter.Fill(Inq_FULF_DataDataSet.Campaign)
        Dim CategoryCampaignViewSource As System.Windows.Data.CollectionViewSource = CType(Me.FindResource("CategoryCampaignViewSource"), System.Windows.Data.CollectionViewSource)
        CategoryCampaignViewSource.View.MoveCurrentToFirst

    End Sub
End Class