<DataGrid AutoGenerateColumns="False" Height="438"HorizontalAlignment="Left" Margin="23,278,0,0" Name="dataGrid1"  VerticalAlignment="Top" Width="1249">                <DataGrid.Columns>                    <DataGridTextColumn Width="100" FontSize="15" Header="编号" Binding="{Binding id}"/>                               <DataGridTextColumn Width="140" Header="名称" FontSize="15"  Binding="{Binding name}"/>                     </DataGrid.Columns>        </DataGrid>

public DataTable Show() {            DataTable dt = new DataTable();            try            { if (DBHelper.connection.State == ConnectionState.Closed)                    DBHelper.connection.Open();                string sql = "查询语句";                DataSet ds = new DataSet();                SqlDataAdapter sda = new SqlDataAdapter(sql,DBHelper.connection);                sda.Fill(ds, "虚拟表名");                dt= ds.Tables["虚拟表名"];            }            catch (Exception ex)            {                MessageBox.Show(ex.Message);            }            return dt;        } //注意：该方法中的虚拟表名就是一个自己定义的表名称 c.然后在后台代码编辑处将datatable中的数据与datagrid绑定  dataGrid1.ItemsSource = Show().DefaultView;