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()
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
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.