wpf将表中数据显示到datagrid示例

a.在.xaml文件中拖入一个datagrid,然后添加列名，使用binding="{binding 数据库中的列名称}"，如下： 

<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>

b.首先把要显示的数据查询后放入datatable中  

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;