WPF中listview数据绑定

来源:互联网 发布:有些淘宝店一万多宝贝 编辑:程序博客网 时间:2024/05/01 19:23

xaml代码:

        <ListView Height="110" HorizontalAlignment="Left" Margin="210,41,0,0" Name="listView1" VerticalAlignment="Top" Width="259">
                <ListView.View>
                <GridView x:Name="grv">
                    <GridViewColumn Header="ID" DisplayMemberBinding="{Binding Path=id}"></GridViewColumn>
                    <GridViewColumn Header="name" DisplayMemberBinding="{Binding Path=name}"></GridViewColumn>
                    <GridViewColumn Header="number" DisplayMemberBinding="{Binding Path=number}"></GridViewColumn>
                   </GridView>
                </ListView.View>
            </ListView>

后台C#代码:

public partial class MainWindow : Window
    {
        public MainWindow()
        {
            InitializeComponent();
            getDate();
        }
        SqlDataAdapter sda;
        DataTable dt;
        //DataSet ds;
        void getDate() {
            SqlConnectionStringBuilder connbuilder = new SqlConnectionStringBuilder();
            connbuilder.DataSource = ".";//本地服务器
            connbuilder.IntegratedSecurity = true;//Windows集成验证
            connbuilder.InitialCatalog = "Test";
            SqlConnection conn = new SqlConnection(connbuilder.ConnectionString);
            sda = new SqlDataAdapter("select * from [user] ", conn);
            //SqlCommandBuilder commbuilder = new SqlCommandBuilder(sda);
            //sda.UpdateCommand = commbuilder.GetUpdateCommand();
            dt = new DataTable();
            //ds = new DataSet();

          //  sda.AcceptChangesDuringUpdate = true;
            sda.Fill(dt);
            //sda.Fill(ds);
            listView1.ItemsSource = dt.DefaultView;
           //this.listView1.ItemsSource= ds.Tables[0].DefaultView;
        }}}

原创粉丝点击