<Page.Resources>
        <ObjectDataProvider x:Key="EnterpriseDataProvider"
            ObjectType="{x:Type local:EnterpriseDataProvider}"/>
        <ObjectDataProvider x:Key="Enterprise"
          ObjectInstance="{StaticResource EnterpriseDataProvider}"
          MethodName="GetEnterprises"/>
        <ObjectDataProvider x:Key="TuedogDataProvider"
           ObjectType="{x:Type local:TuedogDataProvider}"/>
        <ObjectDataProvider x:Key="Tuedog1" MethodName="GetTuedogByEnterprice"
                ObjectInstance="{StaticResource TuedogDataProvider}">
            <ObjectDataProvider.MethodParameters>
                <system:String>2085</system:String>
            </ObjectDataProvider.MethodParameters>
        </ObjectDataProvider> 
    </Page.Resources>
    <Grid>
        <Grid.RowDefinitions>
            <RowDefinition Height="*"/>
            <RowDefinition Height="*"/>
        </Grid.RowDefinitions>
        <Grid.ColumnDefinitions>
            <ColumnDefinition Width="*"/>
        </Grid.ColumnDefinitions>
        <DataGrid ItemsSource="{Binding Source={StaticResource Enterprise}}"  Height="189" HorizontalAlignment="Left" Name="dataGrid1" VerticalAlignment="Top" 
                  Width="800" SelectionChanged="dataGrid1_SelectionChanged" />
        <DataGrid Grid.Row="1"
              ItemsSource="{Binding Source={StaticResource Tuedog1}}"/>
    </Grid>

    class TuedogDataProvider
    {
        private MainDataSetTableAdapters.TUEDOGTableAdapter adapter;

        private MainDataSet dataset;

        public TuedogDataProvider()
        {
            dataset = new MainDataSet();
            adapter = new MainDataSetTableAdapters.TUEDOGTableAdapter();
            adapter.FillBy(dataset.TUEDOG, 0);

            dataset.TUEDOG.TUEDOGRowChanged +=
                new MainDataSet.TUEDOGRowChangeEventHandler(TuedogRowModified);
            
            dataset.TUEDOG.TUEDOGRowDeleted +=
                new MainDataSet.TUEDOGRowChangeEventHandler(TuedogRowModified);
        }

        public DataView GetTuedog()
        {
            return dataset.TUEDOG.DefaultView;
        }

        void TuedogRowModified(object sender, MainDataSet.TUEDOGRowChangeEvent e)
        {
            adapter.Update(dataset.TUEDOG);
        }

        public DataView GetTuedogByEnterprice(String pkdog)
        {
            if (pkdog == null || pkdog == string.Empty)
            {
                return null;
            }
            if (pkdog != "")
            {
                dataset = new MainDataSet();

                adapter.FillBy(dataset.TUEDOG, Convert.ToDecimal(pkdog.ToString())); // здесь выполняется перезапрос к БД
                dataset.TUEDOG.TUEDOGRowChanged +=
                    new MainDataSet.TUEDOGRowChangeEventHandler(TuedogRowModified);

                dataset.TUEDOG.TUEDOGRowDeleted +=
                    new MainDataSet.TUEDOGRowChangeEventHandler(TuedogRowModified);
            }
            DataView view = dataset.TUEDOG.DefaultView;
/*          if (pkdog != null && pkdog != String.Empty) 
            {
                view.RowFilter = string.Format("KDOG=" + pkdog); // выбирает нужные строки из таблицы (не выполняется запроса к БД)
            }*/
            return view;
        }
    }

select *
from tuedog
where kdog = :p_kdog