Binding DataGrid Dynamically

See more:

C#

WPF

C#4.0

DataGrid

private void button1_Click(object sender, RoutedEventArgs e)
        {
             connectionstring = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:/Project/Book.accdb";
            connection = new OleDbConnection(connectionstring);
            sql = "Select*from Authors";
 

 
            DataGrid dg2 = new DataGrid();
 
            
 
          
            try
            {
                connection.Open();
                oledbAdapter = new OleDbDataAdapter(sql, connection);
                oledbAdapter.Fill(dt);
                dg2.DataContext = dt;
                connection.Close();
 

 
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }
 
            dg2.HorizontalAlignment = HorizontalAlignment.Left;
            dg2.VerticalAlignment = VerticalAlignment.Top;
            dg2.Height = 700;
            dg2.Width = 900;
            dg2.Background = Brushes.YellowGreen;
            grid1.Children.Add(dg2);
           
 
        }

this code instantiate a DataGrid dg2 and expected to show the content of Database Book . but only a Blank DataGrid form is shown. somewhere i have to do the DataBinding and how I can do it in the codebehind.

Any help will be appreaciated