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的列名一摸一样,并且是区分大小写的。