WPF DataGrid 绑定数据库数据表

后台:

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.SqlClient;
using System.Data;

namespace ConnectDatabase
{
    /// <summary>
    /// Interaction logic for MainWindow.xaml
    /// </summary>
    public partial class MainWindow : Window
    {
        public MainWindow()
        {
            InitializeComponent();
            GetData();
        }
        string sqlstr = "Data Source=PC-201207031210;Initial Catalog=MyTest;Persist Security Info=True;User ID=sa;Password=zht@yeah";
        private void GetData()
        {
            using (SqlConnection sqlcnn=new SqlConnection(sqlstr))
            {
                using (SqlCommand sqlcmm=sqlcnn.CreateCommand())
                {
                    sqlcmm.CommandText = "select * from test1";
                    DataSet dt = new DataSet();
                    SqlDataAdapter adapter = new SqlDataAdapter(sqlcmm);
                    adapter.Fill(dt);
                    this.dataGrid1.ItemsSource = dt.Tables[0].DefaultView;
                }
            }
        }
    }
}

前台:

<Window x:Class="ConnectDatabase.MainWindow"
        xmlns="
http://schemas.microsoft.com/winfx/2006/xaml/presentation"
        xmlns:x="
http://schemas.microsoft.com/winfx/2006/xaml"
        Title="MainWindow" Height="800" Width="1000">
    <Grid>
        <DataGrid  AutoGenerateColumns="False" Height="Auto" HorizontalAlignment="Left" Margin="10,10,0,0" Name="dataGrid1" VerticalAlignment="Top" Width="Auto" IsReadOnly="True">
            <DataGrid.Columns>
                <DataGridTextColumn Header="用户编号" Binding="{Binding Path=id}"/>
                <DataGridTextColumn Header="用户姓名" Binding="{Binding Path=name}" />
                <DataGridTextColumn Header="所在学校" Binding="{Binding Path=school}"/>
                <DataGridTextColumn Header="所在家乡" Binding="{Binding Path=hometown}"/>
                <DataGridTextColumn Header="个人爱好" Binding="{Binding Path=hobby}"/>
            </DataGrid.Columns>
        </DataGrid>
    </Grid>
</Window>

评论 3
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值