VCS/WpfDataGridTest - Sample is best!

開発環境	Microsoft Visual Studio Express 2013 for Windows Desktop
実行環境	Microsoft Windows 8.1 (64bit)
プロジェクトの種類	Visual C#／WPF アプリケーション
プロジェクト名	WpfDataGridTest

MainWindow.xaml

<Window x:Class="WpfDataGridTest.MainWindow"
        xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
        xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
        Title="MainWindow" Height="350" Width="525" Loaded="Window_Loaded">
    <Grid>
        <DataGrid Name="dataGrid1" AlternatingRowBackground="Wheat"/>
    </Grid>
</Window>
 

MainWindow.xaml.cs

using System.Data;
using System.Data.OleDb;
using System.IO;
using System.Windows;
 
namespace WpfDataGridTest
{
    /// <summary>
    /// MainWindow.xaml の相互作用ロジック
    /// </summary>
    public partial class MainWindow : Window
    {
        public MainWindow()
        {
            InitializeComponent();
        }
 
        private void Window_Loaded(object sender, RoutedEventArgs e)
        {
            var filename = @"C:\Projects\VC#\WpfDataGridTest\pc98.csv";
 
            var file = new FileInfo(filename);
            var constr =
                "Provider=Microsoft.Jet.OLEDB.4.0;" +
                "Data Source=\"" + file.DirectoryName + "\";" +
                "Extended Properties='text;HDR=Yes;FMT=Delimited(,)';";
            var con = new OleDbConnection(constr);
 
            var adp = new OleDbDataAdapter("select * from " + file.Name, con);
            var dt = new DataTable();
            adp.Fill(dt);
 
            dataGrid1.ItemsSource = dt.DefaultView;
        }
    }
}
 

pc98.csv

年,型番,CPU(クロック),RAM,HDD
1982,PC-9801,μPD8086(5MHz),128KB,なし
1983,PC-9801F1/F2,8086-2(8MHz),128KB,なし
1983,PC-9801E,8086-2(8MHz),128KB,なし
1984,PC-9801F3,8086-2(8MHz),256KB,10MB
1984,PC-9801M2,8086-2(8MHz),256KB,なし
1985,PC-9801M3,8086-2(8MHz),256KB,20MB
1985,PC-98XA model 1/2/3,80286(8MHz),512KB,なし～20MB
1985,PC-9801U2,V30(8MHz),128KB,なし
1985,PC-9801VF2,V30(8MHz),256KB,なし
1985,PC-9801VM0/VM2/VM4,V30(10MHz),384KB,なし～20MB