How Do I Fill Datagrid At Runtime With Data I Fetch From My Database

See more:

C#

Visual-Studio

WPF

C#4.0

Kindly help the novice man,

I am all records from table 'PersonnelDetails'. this i want to display using datagrid at run time.
the datagrid is a child of a dockpanel in a WPF app. When i run this code i only see one culoumn of the datagrid without any label or data:

public void viewAllStaffMethod(object sender, RoutedEventArgs e)
            {
                var dGrid = new DataGrid { };


                DockPanel dockPanelmain = new DockPanel();
                dockPanelmain.Children.Add(dGrid);
                string conString = @"Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|\MOICIDB.mdf;Integrated Security=True";
                string cmdString = string.Empty;
                using (SqlConnection con = new SqlConnection(conString))
                {
                    cmdString = " select * from PersonnelDetails";
                    SqlCommand com = new SqlCommand(cmdString, con);
                    SqlDataAdapter sda = new SqlDataAdapter(com);
                    DataTable dt = new DataTable("PersonnelDetails");
                    sda.Fill(dt);
                    dGrid.ItemsSource = dt.DefaultView;

                }

plz note i dont want use databinding of WPF. I want to do it at run time with full control.

MAJ