Проектирование базы данных

        {

            var dlg = new OpenFileDialog();

            dlg.Filter = "Image files: *.jpg, *.png, *.bmp | *.jpg; *.png; *.bmp";

 

            if (dlg.ShowDialog() == System.Windows.Forms.DialogResult.OK)

            {

                System.Drawing.Image img = System.Drawing.Image.FromFile(dlg.FileName);

                BitmapImage bitmap = new BitmapImage();

 

                bitmap.BeginInit();

                MemoryStream ms = new MemoryStream();

                img.Save(ms, System.Drawing.Imaging.ImageFormat.Png);

                ms.Seek(0, SeekOrigin.Begin);

                bitmap.StreamSource = ms;

                bitmap.EndInit();

               

                if (_infoMaterial.Image == null)

                    _infoMaterial.Image = new InfoMat_Image();

                _infoMaterial.BitmapSource = bitmap;

                RefreshDataSource();

            }

        }

 

    }

       }

InfoMaterialsFilterWindow.xaml

<Window x:Class="WpfRDB.InfoMaterialsFilterWindow"

   xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"

   xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"

   xmlns:dxe="http://schemas.devexpress.com/winfx/2008/xaml/editors"

   Title="Фильтрация информационных материалов" Icon="Images/yinyang.png" Height="588" Width="639" xmlns:dxg="http://schemas.devexpress.com/winfx/2008/xaml/grid" xmlns:dx="clr-namespace:DevExpress.Wpf.Utils.Themes;assembly=DevExpress.Wpf.Core.v9.3">

    <Grid dx:ThemeManager.ThemeName="Office2007Blue">

        <Grid.RowDefinitions>

            <RowDefinition Height="120" />

            <RowDefinition Height="4" />

            <RowDefinition Height="285*" />

        </Grid.RowDefinitions>

        <Grid>

            <Grid.RowDefinitions>

                <RowDefinition Height="4" />

                <RowDefinition Height="18" />

                <RowDefinition Height="8" />

                <RowDefinition Height="18" />

                <RowDefinition Height="4" />

                <RowDefinition Height="18" />

                <RowDefinition Height="4" />

                <RowDefinition Height="18" />

                <RowDefinition Height="4" />

                <RowDefinition Height="18" />

            </Grid.RowDefinitions>

            <Grid.ColumnDefinitions>

                <ColumnDefinition Width="7" />

                <ColumnDefinition Width="120" />

                <ColumnDefinition Width="10" />

                <ColumnDefinition Width="140" />

                <ColumnDefinition Width="40" />

                <ColumnDefinition Width="120" />

                <ColumnDefinition Width="10" />

                <ColumnDefinition Width="140" />

                <ColumnDefinition Width="7*" />

            </Grid.ColumnDefinitions>

            <Image Grid.Column="1" Grid.ColumnSpan="1" Grid.Row="1" Grid.RowSpan="1" Width="16" Height="16" VerticalAlignment="Center" HorizontalAlignment="Left" Stretch="Fill">

                <Image.Source>pack://application:,,,/Images/funnel_preferences.png</Image.Source>

            </Image>

         <TextBlock Grid.Column="1" Grid.ColumnSpan="5" Grid.Row="1" Text="Параметры фильтрации информационных материалов" Margin="22,0,0,0" VerticalAlignment="Center" />           

            <Border Grid.Column="0" Grid.ColumnSpan="7" Grid.Row="2" VerticalAlignment="Center" Height="0.5" BorderThickness="0.5" BorderBrush="Navy"></Border>

            <TextBlock Grid.Column="1" Grid.ColumnSpan="1" Grid.Row="3" Grid.RowSpan="1" Text="Название:"/>

            <dxe:TextEdit Grid.Column="3" Grid.Row="3" Grid.RowSpan="1" Name="txtName" />

            <dxe:CheckEdit Grid.Column="1" Grid.Row="5" Name="chkRating" Content="Рейтинг" IsChecked="True" Checked="RatingAndViewCount_Checked" Unchecked="RatingAndViewCount_Unchecked" />

            <dxe:CheckEdit Grid.Column="3" Grid.Row="5" Name="chkViewCount" Content="Популярность" ToolTip="Количество просмотров" Checked="RatingAndViewCount_Checked" Unchecked="RatingAndViewCount_Unchecked" />