界面:
<Window x:Class="WpfApplication1.MainWindow"
xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
Title="主窗口" Height="322" Width="528" Icon="/WpfApplication1;component/Images/app1_13.ico" Loaded="Window_Loaded">
<Grid>
<DataGrid AutoGenerateColumns="False" Margin="38,28,41,24" Name="dataGrid1" HorizontalGridLinesBrush="#41000000" VerticalGridLinesBrush="#33000000">
<DataGrid.Columns>
<DataGridTextColumn Binding="{Binding Path=apptext}" Header="名称" />
<DataGridTextColumn Header="网址" Binding="{Binding Path=appurl}" />
<DataGridTextColumn Header="应用类型" Binding="{Binding Path=apptype}" />
<DataGridTextColumn Header="显示类型" Binding="{Binding Path=urlform}" />
</DataGrid.Columns>
</DataGrid>
</Grid>
</Window>
代码:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Data;
using System.Windows.Documents;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Imaging;
using System.Windows.Navigation;
using System.Windows.Shapes;
using System.Data;
using Model;
namespace WpfApplication1
{
/// <summary>
/// MainWindow.xaml 的交互逻辑
/// </summary>
public partial class MainWindow : Window
{
public MainWindow()
{
InitializeComponent();
}
<Window x:Class="WpfApplication1.MainWindow"
xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
Title="主窗口" Height="322" Width="528" Icon="/WpfApplication1;component/Images/app1_13.ico" Loaded="Window_Loaded">
<Grid>
<DataGrid AutoGenerateColumns="False" Margin="38,28,41,24" Name="dataGrid1" HorizontalGridLinesBrush="#41000000" VerticalGridLinesBrush="#33000000">
<DataGrid.Columns>
<DataGridTextColumn Binding="{Binding Path=apptext}" Header="名称" />
<DataGridTextColumn Header="网址" Binding="{Binding Path=appurl}" />
<DataGridTextColumn Header="应用类型" Binding="{Binding Path=apptype}" />
<DataGridTextColumn Header="显示类型" Binding="{Binding Path=urlform}" />
</DataGrid.Columns>
</DataGrid>
</Grid>
</Window>
代码:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Data;
using System.Windows.Documents;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Imaging;
using System.Windows.Navigation;
using System.Windows.Shapes;
using System.Data;
using Model;
namespace WpfApplication1
{
/// <summary>
/// MainWindow.xaml 的交互逻辑
/// </summary>
public partial class MainWindow : Window
{
public MainWindow()
{
InitializeComponent();
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
DataTable dt = dbhelper.GetDataTable("select * from appmenu");
List<AppMenuModel> mlist = ModelConvertHelper<AppMenuModel>.ToList(dt);
//dataGrid1.ItemsSource = mlist; //绑定list
dataGrid1.ItemsSource = dt.DefaultView; //绑定datatable
}
{
DataTable dt = dbhelper.GetDataTable("select * from appmenu");
List<AppMenuModel> mlist = ModelConvertHelper<AppMenuModel>.ToList(dt);
//dataGrid1.ItemsSource = mlist; //绑定list
dataGrid1.ItemsSource = dt.DefaultView; //绑定datatable
}
}
}
}