Question

wpf中如何将datagrid控件绑定到数据库上呀

Answer 1

xaml中绑定：
<DataGrid Name="dataGrid1" >
<DataGridTextColumn Header="日期" Binding="{Binding Path=Date}"/>//table表中的字段
</DataGrid>
xaml.cs：
string con = "Provider=System.Data.SqlClient;Data Source=.;database=logistics;User ID=sa;Password=sa123";
SqlConnection sCon = new SqlConnection(con);
sCon .Open();
string sql = "select * from table";
DataTable dt = new DataTable();
SqlDataAdapter da=new SqDataAdapter(sql,sCon );
DataSet ds=new DataSet();
ds.Fill(ds,"dtName");
dataGrid1.ItemsSource = ds.Tables["dtName"].DefaultView;