i am connecting to a foxpro table using adodb connection . Using this I am trying to fill a datagrid values using binding. if any one know the syntax for binding source , please let me know
Here is what i tried with
I am getting exceptions
Here is what i tried with
VB.NET:
fcn = New ADODB.Connection
fcn.ConnectionString = "provider=VFPOLEDB.1;Data Source= D:\" & foldrname
fcn.Open()
rst = New ADODB.Recordset
rst.open("select * from table" ,fcn)
BindingSource1.DataSource = rst
DataGridFirst.ReadOnly = True
DataGridFirst.DataSource = BindingSource1
rst.Close()