Category / Section
How to import MS Access Database to the SfDataGrid?
1 min read
In the SfDataGrid, you can connect the MS Access Database through the OleDbConnection and set the Data table as a DataGrid’s ItemSource by using the DataSet as follows.
C#
//Creates a new OleDB connection.
System.Data.OleDb.OleDbConnection conn = new System.Data.OleDb.OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=EmployeeDatabase.accdb; Persist Security Info=True");
//Passes the Select statement and connection information to the initialization constructor for the OleDBDataAdapter.
System.Data.OleDb.OleDbDataAdapter myDataAdapter = new System.Data.OleDb.OleDbDataAdapter("SELECT * FROM Employee", conn);
//Creates a DataSet.
DataSet ds = new DataSet();
conn.Open();
myDataAdapter.Fill(ds, "Employee");
conn.Close();
//Sets the ItemSource.
datagrid.ItemsSource = ds.Tables["Employee"];
Note: You can create a Database in the MSAccess and save it in the following example location.
Sample Link:
WPF: http://www.syncfusion.com/downloads/support/directtrac/139270/ze/WPF-1978728792