WPF 利用Binding 查询数据库 遍历前台控件
<UniformGrid Rows="2" Margin=" 10 0 0 100" Name="PersonalDataPanel">
<ItemsControl Name="PersonalDataPanel1" ItemsSource="{Binding Path=All}">
<ItemsControl.ItemTemplate>
<DataTemplate>
<Border Style="{StaticResource DataBorder}" HorizontalAlignment="Left">
<Border Margin="2 2 2 2" Width="360" Background="#FFBDBDBD" BorderThickness="1" BorderBrush="#FFA2A2A2">
<DockPanel Background="White">
<TextBlock DockPanel.Dock="Top" Style="{ StaticResource TextblockName}" Text="{Binding Path=Admin_Name}"/>
<Image Margin="15 0 0 0" DockPanel.Dock="Left" Source="/image/上海.jpg" Height="160" Width="120" Stretch="Fill"/>
<StackPanel Margin="35 12 0 0">
<TextBlock FontSize="18" FontFamily="幼圆" Foreground="#FF999999">详细地址:</TextBlock>
<TextBlock Margin="0 6 0 15" Text="{Binding Path=Address}"></TextBlock>
<TextBlock FontSize="18" FontFamily="幼圆" Foreground="#FF999999" >联系方式:</TextBlock>
<TextBlock Margin="0 6 0 15" Text="{Binding Path=Tel}"></TextBlock>
<TextBlock FontSize="18" FontFamily="幼圆" Foreground="#FF999999" >E-mail:</TextBlock>
<TextBlock Margin="0 6 0 15" Text="{Binding Path=E_mail}"></TextBlock>
</StackPanel>
</DockPanel>
</Border>
public string Admin_Name { get; set; }
public string Address { get; set; }
public string Tel { get; set; }
public string E_mail { get; set; }
public string Image { get; set; }
public List<Personaldata> All { get; set; }
public Personaldata()
{
All = new List<Personaldata>();
}
}
<ItemsControl Name="PersonalDataPanel1" ItemsSource="{Binding Path=All}">
<ItemsControl.ItemTemplate>
<DataTemplate>
<Border Style="{StaticResource DataBorder}" HorizontalAlignment="Left">
<Border Margin="2 2 2 2" Width="360" Background="#FFBDBDBD" BorderThickness="1" BorderBrush="#FFA2A2A2">
<DockPanel Background="White">
<TextBlock DockPanel.Dock="Top" Style="{ StaticResource TextblockName}" Text="{Binding Path=Admin_Name}"/>
<Image Margin="15 0 0 0" DockPanel.Dock="Left" Source="/image/上海.jpg" Height="160" Width="120" Stretch="Fill"/>
<StackPanel Margin="35 12 0 0">
<TextBlock FontSize="18" FontFamily="幼圆" Foreground="#FF999999">详细地址:</TextBlock>
<TextBlock Margin="0 6 0 15" Text="{Binding Path=Address}"></TextBlock>
<TextBlock FontSize="18" FontFamily="幼圆" Foreground="#FF999999" >联系方式:</TextBlock>
<TextBlock Margin="0 6 0 15" Text="{Binding Path=Tel}"></TextBlock>
<TextBlock FontSize="18" FontFamily="幼圆" Foreground="#FF999999" >E-mail:</TextBlock>
<TextBlock Margin="0 6 0 15" Text="{Binding Path=E_mail}"></TextBlock>
</StackPanel>
</DockPanel>
</Border>
</Border>
定义一个类
public class Personaldata
{public string Admin_Name { get; set; }
public string Address { get; set; }
public string Tel { get; set; }
public string E_mail { get; set; }
public string Image { get; set; }
public List<Personaldata> All { get; set; }
public Personaldata()
{
All = new List<Personaldata>();
}
}
绑定方法
private void Window_Loaded(object sender, RoutedEventArgs e)
{
List<Personaldata> list = new List<Personaldata>();
foreach (DataRow items in dt.Rows)
{
list.Add(new Personaldata() { Admin_Name = items["Admin_Name"].ToString(), Address = items["Address"].ToString(), Tel = items["Tel"].ToString(), E_mail = items["Eamil"].ToString(), Image = items["Image"].ToString() });
}
PersonalDataPanel1.ItemsSource = list;
}
相当于 web上面的 遍历前台控件 根据数据量