How to msaccess databse connect to datagridview control

Hi

How to msaccess database records show in datagrid.
use coding to connect, not use controls.

vb.net




Answer this question

How to msaccess databse connect to datagridview control

  • ClintTredway

    Hi,

    Try this ..

    Dim sConnectionString As String
    sConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:myDatabase.mdb"
    Dim objConn As New System.Data.OleDb.OleDbConnection(sConnectionString)
    objConn.Open()

    Dim dadap As New System.Data.OleDb.OleDbDataAdapter("Table1", objConn)
    Dim dsset As New DataSet("AccessDS")
    dadap.Fill(dsset, "AccessTable")
    DataGrid1.SetDataBinding(dsset, "AccessTable")
    objConn.Close()

    Regards

    Sidheshwar N


  • Amit Patankar

    Thanks for given a code

    But last line will error. this line error

    DataGrid1.SetDataBinding(dsset, "AccessTable")

    setdatabinding is not for a member in datagridview

    i am using visual studio 2005.

    please help me.


  • How to msaccess databse connect to datagridview control