xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
xmlns:c="clr-namespace:WpfApplication1"
Title="ADODataSetSample" Loaded="OnInit" Background="White" Height="250" Width="450">
Converter={StaticResource MyConverter}}"/>
ItemsSource="{Binding Path=BookTable}"
ItemTemplate ="{StaticResource BookItemTemplate}"/>
Add Record
//File:Window.xaml.cs
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.OleDb;
using System.IO;
using System.Globalization;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Data;
using System.Windows.Documents;
using System.Collections.Generic;
namespace WpfApplication1
{
public partial class Window1 : Window
{
public Window1()
{
this.InitializeComponent();
}
DataSet myDataSet;
private void OnInit(object sender, EventArgs e)
{
OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\\BookData.mdb");
OleDbDataAdapter adapter = new OleDbDataAdapter("SELECT * FROM BookTable;", conn);
myDataSet = new DataSet();
adapter.Fill(myDataSet, "BookTable");
myListBox.DataContext = myDataSet;
}
private void OnClick(object sender, RoutedEventArgs e)
{
DataTable myDataTable = myDataSet.Tables["BookTable"];
DataRow row = myDataTable.NewRow();
row["Title"] = "A";
row["ISBN"] = "0-1111-1111-2";
row["NumPages"] = 1;
myDataTable.Rows.Add(row);
}
}
public class IntColorConverter : IValueConverter
{
public object Convert(object value, Type targetType, object parameter, CultureInfo culture)
{
int numValue = (int)value;
if (numValue < 50)
return System.Windows.Media.Brushes.Green;
else
return System.Windows.Media.Brushes.Red;
}
public object ConvertBack(object value, Type targetType, object parameter, CultureInfo culture)
{
return null;
}
}
}