Connection DataGrid to Access database

Rado · April 25th, 2005, 04:29 AM

Hi,
I'm fairly new to .NET and I have question:
How can I connect datagrid to the Access database? How can I do it? Is It possible?

Thank you.
Rado

Prashant.k.m · April 25th, 2005, 04:59 AM

Surely, sample C# code below

Code:

        string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Ole DB Services=-4; Data Source=C:\\db1.mdb";
        System.Data.IDbConnection dbConnection = new System.Data.OleDb.OleDbConnection(connectionString);

        string queryString = "SELECT [test].* FROM [test]";
        System.Data.IDbCommand dbCommand = new System.Data.OleDb.OleDbCommand();
        dbCommand.CommandText = queryString;
        dbCommand.Connection = dbConnection;

        System.Data.IDbDataAdapter dataAdapter = new System.Data.OleDb.OleDbDataAdapter();
        dataAdapter.SelectCommand = dbCommand;
        System.Data.DataSet dataSet = new System.Data.DataSet();
        dataAdapter.Fill(dataSet);

        Datagrid1.DataSource= dataSet.Tables[0];
        Datagrid1.DataBind