private void Window_Loaded(object sender, RoutedEventArgs e) { PatientMonitor.DatabaseDataSet databaseDataSet = ((PatientMonitor.DatabaseDataSet)(this.FindResource("databaseDataSet"))); // Load data into the table Patient. You can modify this code as needed. PatientMonitor.DatabaseDataSetTableAdapters.PatientTableAdapter databaseDataSetPatientTableAdapter = new PatientMonitor.DatabaseDataSetTableAdapters.PatientTableAdapter(); databaseDataSetPatientTableAdapter.Fill(databaseDataSet.Patient); System.Windows.Data.CollectionViewSource patientViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("patientViewSource"))); patientViewSource.View.MoveCurrentToFirst(); }
private void Window_Loaded(object sender, RoutedEventArgs e) { OleDbConnection dataConnection = new OleDbConnection(); DataTable dt = new DataTable(); dataConnection.ConnectionString = dataConnection.ConnectionString = (@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=..\..\..\database\\database.accdb"); OleDbDataAdapter adapt = new OleDbDataAdapter("select * from Patient order by BedNo asc", dataConnection); adapt.Fill(dt); patientDataGrid.DataContext = dt; PatientMonitor.DatabaseDataSet databaseDataSet = ((PatientMonitor.DatabaseDataSet)(this.FindResource("databaseDataSet"))); // Load data into the table Patient. You can modify this code as needed. PatientMonitor.DatabaseDataSetTableAdapters.PatientTableAdapter databaseDataSetPatientTableAdapter = new PatientMonitor.DatabaseDataSetTableAdapters.PatientTableAdapter(); databaseDataSetPatientTableAdapter.Fill(databaseDataSet.Patient); System.Windows.Data.CollectionViewSource patientViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("patientViewSource"))); patientViewSource.View.MoveCurrentToFirst(); }