How to embed a FoxPro 9 table into a C# form?

I have a simple form in MS C# .NET 2003 designer. I also created a table in FoxPro 9 designer. What I want to do is to have the table appear as a part of my form. I have done it many times in a different platform: Visual dBASE and I am sure it can be done here but how I tried many tricks. In tools I selected odbcConnection and dropped it on the form. In the properties for this data object there are windows for "database" and "DataSource." They allow me to neither paste nor manually enter the path to the table which is in another directory. Those two fields appear disabled.

I tried "DataView" with the same result. oleDbConnection does not allow me to work with it either.

Finally I dropped a dataGrid object on the form and it stays there but I cannot make a connection with the table. Thus when I execute the form it appears as an empty gap and nothing else.

Please, help.

Thanks.


Answer this question

How to embed a FoxPro 9 table into a C# form?

  • subdigital

    I just managed to create a dataTable with columns I need in my Form class. I've connected it with a dataView instance and the latter is now connected with a grid. It appears almost all I need at this point. When I run the form I see the table columns in the grid.

    The only thing I still cannot grasp is how to save this table which still exists only during the run time.

    Makes sense

    Thanks you.

  • How to embed a FoxPro 9 table into a C# form?