private void button2_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";
try
{
connection.Open();
oledbAdapter = new OleDbDataAdapter(sql, connection);
oledbAdapter.Fill(dt);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
DataGrid dg2 = new DataGrid();
dg2.Height = 200;
dg2.Width = 200;
dg2.AutoGenerateColumns = true;
dg2.AlternatingRowBackground = Brushes.Black;
dg2.Background = Brushes.Red;
dg2.BorderBrush = Brushes.Pink;
dg2.HorizontalGridLinesBrush = Brushes.Black;
dg2.DataContext = dt;
stackPanel1.Children.Add(dg2);
}
it is expected that the code should display the DataGrid with its underlying Data. but it is not happening.
it gives only a Red back ground. no data at all .No Grid lines also. I am missing something very seriously. please i request somebody help
Regards
Iqbal
NB: I am just started learning