PVH095
March 29th, 2001, 11:04 PM
Hi,
I have an application that creates an sql querry & pass it on to an ADODC control.
The original Idea was to set the datasource of an MSFLEXGRID to the adodc control & then show the results. Clicking on one of the cells of the grid
triggered another program to give more detailed info on that record.
Everything worked fine except for the fact that if the qeurry was over 2049 records, only the first 2049 records where shown.
I tried to force the mshflexgrid by setting the mshflexgrid.rows = adodc1.recordset.recordcount
I have now more then 2049 rows, but only the first 2049 are filled with data the rest is empty.
Someone suggest I should change to the Datagrid Control. I did & this works better, but I can't seem to figure out how I can control on wich column I'm clicking in the grid.
Also I have some trouble with the grid click event. Everytime I click on a cell, the msgbox datagrid.text give me the cell text from the previous click.
So if anybody could help me with one of these problems, that would be appreciated. My boss thinks the solution is simple, he might be right, but then again he only knows that you can put out a computer by disconnecting the plug...
I have an application that creates an sql querry & pass it on to an ADODC control.
The original Idea was to set the datasource of an MSFLEXGRID to the adodc control & then show the results. Clicking on one of the cells of the grid
triggered another program to give more detailed info on that record.
Everything worked fine except for the fact that if the qeurry was over 2049 records, only the first 2049 records where shown.
I tried to force the mshflexgrid by setting the mshflexgrid.rows = adodc1.recordset.recordcount
I have now more then 2049 rows, but only the first 2049 are filled with data the rest is empty.
Someone suggest I should change to the Datagrid Control. I did & this works better, but I can't seem to figure out how I can control on wich column I'm clicking in the grid.
Also I have some trouble with the grid click event. Everytime I click on a cell, the msgbox datagrid.text give me the cell text from the previous click.
So if anybody could help me with one of these problems, that would be appreciated. My boss thinks the solution is simple, he might be right, but then again he only knows that you can put out a computer by disconnecting the plug...