WPF odbc DataSet

索引サイト
最短＆お手軽、データチェック用 DataGrid





<StackPanel Grid.Column="1" Grid.Row="1" Margin="5" >

    <StackPanel Margin="5" Orientation="Horizontal" Height="30">

        <TextBlock Width="150" Name="textBlock01" Text="2011/01" Margin="5" />

        <Button  Name="Button01" Width="50" Margin="5" Click="Button01_Click" Content="Read" />

    </StackPanel>

    <DataGrid AutoGenerateColumns="True" Name="dataGrid01" Margin="5" Height="170" />

</StackPanel>





{

    System.Data.DataSet w_dsWPF = new System.Data.DataSet();

    String S_SQL = "select ThCode,sum(Goukei) as Goukei";

    S_SQL = S_SQL + " from table";

    S_SQL = S_SQL + " where Date > '" + this.textBlock01.Text + "/00'";

    S_SQL = S_SQL + " and   Date < '" + this.textBlock01.Text + "/99'";

    S_SQL = S_SQL + " and   (Kubun = '01' or Kubun = '02')";

    S_SQL = S_SQL + " group by ThCode";

    S_SQL = S_SQL + " order by ThCode";

    System.Data.Odbc.OdbcDataAdapter w_odbcAdapter = new System.Data.Odbc.OdbcDataAdapter(S_SQL, z_odbcDataBase);

    System.Data.DataSet w_dataset = new System.Data.DataSet();

    w_odbcAdapter.Fill(w_dsWPF, "Rset");

    this.dataGrid01.ItemsSource = w_dsWPF.Tables[0].DefaultView;

}




AX