view = (BindingListCollectionView)CollectionViewSource.GetDefaultView(this.DataContext);   

namespace firstWPF
{
    /// <summary>
    /// Логика взаимодействия для MainWindow.xaml
    /// </summary>
    public partial class MainWindow : Window
    {
        string connStr = @"Data Source=PC_LOCAL;Initial Catalog=tmp;Integrated Security=True";
        SqlConnection con;
        SqlDataAdapter da;
        DataTable dt;
        public MainWindow()
        {
            InitializeComponent();
            con = new SqlConnection(connStr);
            da = new SqlDataAdapter("select * from import", con);
            dt = new DataTable("import");
            da.Fill(dt);
        }
    }
}