WPF访问数据库的小例子

来源：互联网发布：聚合色情直播软件编辑：程序博客网时间：2024/06/05 18:26

        private void button1_Click(object sender, RoutedEventArgs e)
        {
            string SQl = "select top 20 * from tb_Test";
            DataTable dt = ReadTable(SQl);
            dataGrid1.ItemsSource = dt.DefaultView;
        }
        public DataTable ReadTable(String strSql)
        {
            string strConn = " Data Source=IP;Initial Catalog=DBname;User ID=sa;Password=pwd"; 　　
            DataTable dt = new DataTable();
            SqlConnection Conn = new SqlConnection(strConn);
            Conn.Open();
            SqlDataAdapter Cmd = new SqlDataAdapter(strSql, Conn);
            Cmd.Fill(dt);
            Conn.Close();
            return dt;
        }

xaml内容：

<Window x:Class="WpfAppAccessDB.MainWindow"
        xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
        xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
        Title="MainWindow" Height="350" Width="525">
    <Grid>
        <DataGrid AutoGenerateColumns="False" Height="200" HorizontalAlignment="Left" Margin="42,0,0,70" Name="dataGrid1" VerticalAlignment="Bottom" Width="150" ItemsSource="{Binding}" IsReadOnly="True">
            <DataGrid.Columns>
                <DataGridTextColumn Header="客户别" Binding="{Binding SOLDTO }" ></DataGridTextColumn>
                <DataGridTextColumn Header="品牌" Binding="{Binding BRAND}"></DataGridTextColumn>
            </DataGrid.Columns>
        </DataGrid>
        <Button Content="Button" Height="23" HorizontalAlignment="Left" Margin="42,12,0,0" Name="button1" VerticalAlignment="Top" Width="75" Click="button1_Click" />
    </Grid>
</Window>
注意：加粗体的SOLDTO和BRAND必须和tb_Test的列名一摸一样，并且是区分大小写的。