WPF DataGrid、ListView 简单绑定

  DataGrid运行效果:

  

 

  xaml 代码:

       < DataGrid Name= "dtgData"   ItemsSource= "{Binding}"   AutoGenerateColumns= "False">
            < DataGrid.Columns>
                < DataGridTextColumn Binding= "{Binding Path=id}"  Header= "ID"  HeaderStringFormat= "id" />
                < DataGridTextColumn Binding= "{Binding Path=name }"  Header= "名称"  HeaderStringFormat= "name"  />
                < DataGridTextColumn Binding= "{Binding Path=level }"  Header= "等级"  HeaderStringFormat= "level"  />
            < /DataGrid.Columns>
        < /DataGrid>

  cs 代码:

        private  void BindData()
        {
            SqlConnection conn =  new SqlConnection();
            conn.ConnectionString =  "server=192.168.....;database=hospital;uid=sa;pwd=123456";
            SqlCommand comm =  new SqlCommand();
             string  strSql= "select * from address";
            comm.CommandType = CommandType.Text;
             DataTable dt =  new  DataTable();
            conn.Open();
            SqlDataAdapter sda =  new SqlDataAdapter(strSql, conn);
            sda.Fill(dt);
            dtgData.ItemsSource = dt.DefaultView;
        }

  ListView 运行效果:

  

 

  xaml 代码:

        < ListView  Name= "ltvData">
            < ListView.View >
                < GridView x:Name= "gvw1">
                    < GridViewColumn  Header= "ID"   DisplayMemberBinding= "{Binding Path=id}">< /GridViewColumn>
                    < GridViewColumn  Header= "名称"  DisplayMemberBinding= "{Binding Path=name}">< /GridViewColumn>
                    < GridViewColumn  Header= "等级"  DisplayMemberBinding= "{Binding Path=level}">< /GridViewColumn>
                < /GridView>
            < /ListView.View>
        < /ListView>

  cs 代码:

   //数据绑定
         private  void BindData( string strSql)
        {
            SqlConnection conn =  new SqlConnection();
            conn.ConnectionString =  "server=.;database=hospital;uid=sa;pwd=123456";
            SqlCommand comm =  new SqlCommand();
            comm.CommandType = CommandType.Text;
             DataTable dt =  new  DataTable();
            conn.Open();
            SqlDataAdapter sda =  new SqlDataAdapter(strSql, conn);
            sda.Fill(dt);
            ltvData.ItemsSource = dt.DefaultView;
        }         

  本文来自zhangqynuli的博客,原文地址:http://hi.baidu.com/zhangqynuli/blog/item/f96d41c9236a6359f31fe707.html

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值