I looked in the .NET documentation and a book I have, but couldn't find a way to do that. Although I have not tried this yet, I think you can create a Linked Server in SQL Server to the FoxPro data. However, I am not sure if that would help with your dynamic joins between the SQL and FoxPro data.
>I am trying to join a FoxPro table with an SQL table. I can get both tables into the same dataset, now I want to create some views (I guess) that join these tables so I can bind the view to a datagrid. The I was hoping to build a view as a select against both tables and not not use relation objects since the join scenerio is dynamic.
>
>DataSet ds = new DataSet();
>ds.Tables.Add(DataClass.GetFoxTable("select * from books"));
>ds.Tables.Add(DataClass.GetSqlTable("select * from bookprices"));
>
>The problem is that I cannot find where I can run a select statement against my dataset...
>
>Please help!
Chris McCandless
Red Sky Software