WPF grid綁定資料

1，wpf建立一個window

拖一個dataGrid控件到正中央，适當調整grid大小

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