WPF数据绑定(3) 绑定到数据库

根据MSDN示例修改.

XMAL文件代码

<Window x:Class="WpfApplication1.Window11"    xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"    xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"    xmlns:local="clr-namespace:WpfApplication1"    Title="Window11" Height="300" Width="300" Loaded="Window_Loaded">    <Window.Resources>        <local:MyConvert x:Key="convert"/>//自定义转换类        <DataTemplate x:Key="Data">//自定义模板            <Grid>                <Grid.ColumnDefinitions>                    <ColumnDefinition/>                    <ColumnDefinition/>                    <ColumnDefinition/>                </Grid.ColumnDefinitions>                <TextBlock Grid.Column="0" Text="{Binding Path=Address1}"/>                <TextBlock Grid.Column="1" Text="{Binding Path=City}"/>                <TextBlock Grid.Column="2" Background="{Binding Path=ResourceID,Converter={StaticResource convert}}"   Text="{Binding Path=ResourceID}" />            </Grid>        </DataTemplate>    </Window.Resources>    <Grid>        <ListBox Name="mylist" Height="50" Width="200" ItemsSource="{Binding Path=Book}" ItemTemplate="{StaticResource Data}"/>    </Grid></Window>

后台代码

public partial class Window11 : Window    {        public Window11()        {            InitializeComponent();        }        DataSet ds = new DataSet();        private void Window_Loaded(object sender, RoutedEventArgs e)        {            string Conn = @"Data Source=.;Initial Catalog=Test;Integrated Security=True";                        using (SqlConnection cn = new SqlConnection(Conn))            {                cn.Open();                string sql = "select * from UserAddress";                                using (SqlDataAdapter adp = new SqlDataAdapter(sql, cn))                {                    adp.Fill(ds,"Book");                }            }            this.mylist.DataContext = ds;//为listbox设置绑定源        }    }
 
 
自定义转换类

namespace WpfApplication1//记住命名空间，在XMAL文件中使用该类，必须引入该命名空间{   public  class MyConvert:IValueConverter     {        public object Convert(object value, Type TargetType, object parameter, CultureInfo cultrue)        {            string i = value.ToString();            int numvalue = int.Parse(i);            if (numvalue  > 350)            {                return System.Windows.Media.Brushes.Red;            }            else            {                return System.Windows.Media.Brushes.Blue ;            }        }        public object ConvertBack(object value, Type TargetType, object parameter, CultureInfo cultrue)        {            return null;        }    }}