annandap
asked on
Use of the Grid
Hi,
Can the grid be programmed to a recordset rather than from a data control ??
I would like to retrieve the data manually and then programatically add it to the grid.
Regards...
Peter.
Can the grid be programmed to a recordset rather than from a data control ??
I would like to retrieve the data manually and then programatically add it to the grid.
Regards...
Peter.
ASKER
Sorry I should have put the reason why I wanted to do this. The data I am returning comes from 3 different databases. One database is a program database that holds queries, forms etc the second is a reference or lookup database that holds full description of items and the data database holds the data and uses the reference database to provide description of codes stored in the data database. Therefore I scan the data database to return records required and add them to an array, next I reference the lookup database to supply the description of the codes and update the array.
For example the data returned for an employee from the data database would have a location code of TAF01, lookinhg up the refence database would provide me with an address for that location which I would then replace in the array with the location address rather than the location code.
For example the data returned for an employee from the data database would have a location code of TAF01, lookinhg up the refence database would provide me with an address for that location which I would then replace in the array with the location address rather than the location code.
i would suggest writing the code to iterate through the three recordsets without using a grid control. your code will be a lot cleaner than the generated code.
i'll try and get some time to look into this over the weekend...
i'll try and get some time to look into this over the weekend...
ASKER
The reason I wanted to use the grid is I'm not to happy with a plain table, I originally loaded all the data into arrays and then produced the table, also I like the look of the grid rather than the borders on the table.
Regards..
Peter.
Regards..
Peter.
i couldn't find a way to do this. there is no way to set the grid control to pull from more than one recordset, and the one recordset it can pull from needs to be designated through DTC's, not the code itself.
as far as appearance goes, the grid is just html. view the source, and that should give you an idea of what to change to make it look the same.
as far as appearance goes, the grid is just html. view the source, and that should give you an idea of what to change to make it look the same.
ASKER
I have found another way to do this, there is a product called VbsDb (free) which is a series of ASP pages that load and format data from recordsets.
I will close off the question tomorrow.
Regards....
Peter.
I will close off the question tomorrow.
Regards....
Peter.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks, never even thought of trying that approach.
Regards
Peter..
Regards
Peter..
i don't use the DTC's in VI, and i don't recall how to do that, but i'll look into it.