WPF grid绑定数据

1，wpf新建一个window

拖一个dataGrid控件到正中央，适当调整grid大小

   注意：如果没有设置grid的列，则需要设置grid的AutoGenerateColumns=true,它默认是false

2，在 window_loaded事件中写绑定代码 

private void Window_Loaded(object sender, RoutedEventArgs e)
        {
            string sConnStr = "server={0};database={1};uid={2};password={3}";
            sConnStr=string.Format(sConnStr,@"DB_IP","DB_Name","DB_UserName","DB_Pwd");
            string sSQL="select top 10 ContactorID,Abbreviation,ChineseName,CellPhone,City from tblAddressBook";
            DataTable dt=SqlHelper.ExecuteDataTable(sConnStr,CommandType.Text,sSQL);
            dataGrid1.ItemsSource = dt.DefaultView;
        }