Hilmar,
I'm not 100% sure about this, but I don't think you have to change that at all. All you have to do is change the query. The literal Student in line 4 is telling the data adapter what to call the data table created by the query and line 6 is telling the grid which data table to use from the data set. Line 4 would be comparable to this in VFP with SPT:
SQLEXEC(handle, query, 'Student')
So, it doesn't really matter what you call as long as you use the same thing in both places.
HTH,
Chad
>I have loaded a grid with data from a single table, and would like to know what adaptations are required to use a multi-table join.
>
>What I have is something like this:
>
>
>String query = "select * from Student order by LastName";
>da = new OleDbDataAdapter(query, Cn);
>ds = new DataSet();
>da.Fill(ds, "Student");
>this.dataGrid.DataSource = ds;
>this.dataGrid.DataMember = "Student";
>
>
>Data is stored in Access. I don't think I would have trouble with the JOIN (unless Access syntax is significantly different from Visual FoxPro), but:
>
>What should I replace for "Student" in lines 4 and 6, if the query spans 2 or more tables?
>
>TIA,
>
>Hilmar.
_________________________________
There are 2 types of people in the world: