APEX True DBGrid vs. Sheridan DATA WIDGETS DBGrid
| Author |
Message |
|
Kouroche Sedaghatia
#1 / 8
|
 APEX True DBGrid vs. Sheridan DATA WIDGETS DBGrid Does anyone out there have experience with one or both of these DBGrids in
unbound mode? Do you have strong feelings about the quality of either
product?
I am currently using the APEX True DBGrid in unbound extended mode. I am
happy with the performance of the grid, but the code provided by APEX for
the _unboundDataReadEx event is not the easiest to understand. I downloaded
Sheridan's DBGrid and reviewed their code for the same event and it reads
very well. As a result, I am a little concerned about the maintainability
of my current DBGrid choice.
Anyone out their have any opinions?
Thanks
Kouroche
|
| Mon, 27 Nov 2000 03:00:00 GMT |
|
 |
|
Paul Soar
#2 / 8
|
APEX True DBGrid vs. Sheridan DATA WIDGETS DBGrid Hi -
I've been using the SSDBGrid and SSDBCombo now for about a
year and wouldn't give them up for the world...well, maybe a small
island... :-)
I don't have a lot of experience with the True DBGrid but I
can tell you that the Sheridan control is sooo easy to work with. YOu
can essentially work with the SSDBGrid in three modes: Bound, Unbound,
and AddItem. The AddItem mode works very similar to the standard
ListBox (or combo) but is far more flexible (i.e., you can have
multiple columns and reference each using the simple Columns
Collection). I highly recommend it.
Good luck,
Paul
On Thu, 11 Jun 1998 18:22:43 -0400, "Kouroche Sedaghatian"
Quote:
>Does anyone out there have experience with one or both of these DBGrids in >unbound mode? Do you have strong feelings about the quality of either >product? >I am currently using the APEX True DBGrid in unbound extended mode. I am
>happy with the performance of the grid, but the code provided by APEX for
>the _unboundDataReadEx event is not the easiest to understand. I downloaded
>Sheridan's DBGrid and reviewed their code for the same event and it reads
>very well. As a result, I am a little concerned about the maintainability
>of my current DBGrid choice.
>Anyone out their have any opinions?
>Thanks
>Kouroche
|
| Tue, 28 Nov 2000 03:00:00 GMT |
|
|
|
Hijac
#3 / 8
|
APEX True DBGrid vs. Sheridan DATA WIDGETS DBGrid I have used both Apex an Sheridan grids.
I like Apex a lot better. Easier to use, less bugs, faster etc...
Quote: > Does anyone out there have experience with one or both of these DBGrids in > unbound mode? Do you have strong feelings about the quality of either > product? > I am currently using the APEX True DBGrid in unbound extended mode. I am
> happy with the performance of the grid, but the code provided by APEX for
> the _unboundDataReadEx event is not the easiest to understand. I
downloaded
> Sheridan's DBGrid and reviewed their code for the same event and it reads
> very well. As a result, I am a little concerned about the
maintainability
> of my current DBGrid choice.
> Anyone out their have any opinions?
> Thanks
> Kouroche
|
| Tue, 28 Nov 2000 03:00:00 GMT |
|
|
|
A. Scott Taylo
#4 / 8
|
APEX True DBGrid vs. Sheridan DATA WIDGETS DBGrid Hey since we are talking about the data widgets grid...does anyone have a
good routine for handling column layout at run time? I have a database of
stored user queries, each of which has its own column layout but the routine
being used to set up the columns is lacking I think.
Also I wonder if anyone knows of an efficent way to store the column widths
a user sets for a query??
Scott Taylor
|
| Thu, 30 Nov 2000 03:00:00 GMT |
|
|
|
Jeff Mor
#5 / 8
|
APEX True DBGrid vs. Sheridan DATA WIDGETS DBGrid
Quote:
> Does anyone out there have experience with one or both of these DBGrids in > unbound mode? Do you have strong feelings about the quality of either > product? > I am currently using the APEX True DBGrid in unbound extended mode. I am
> happy with the performance of the grid, but the code provided by APEX for
> the _unboundDataReadEx event is not the easiest to understand. I downloaded
> Sheridan's DBGrid and reviewed their code for the same event and it reads
> very well. As a result, I am a little concerned about the maintainability
> of my current DBGrid choice.
I haven't used the APEX True DBGrid but I have used the Sheridan DBGrid. I would never recommend the Sheridan grid to anyone, unless they paid me to do it. Btw, these are all my experiences with using it in *unbound* mode. What's wrong with it?
No documentation comes in the box. There is a help file, but it *sucks*.
For example, you can place a drop-down combo in any column you like in the
Grid. And in the help file it explains that you must set the hWnd
property of the combo to that of the grid column (or something like that,
I forget). Anyway, what it doesn't tell you is that you have to fiddle
with another property of the drop-down or else is won't "drop down".
There was a separate FAQ which I had to go searching through to find the
answer. Its worthless documentation if one has to go searching through
multiple documents for information that should be logically grouped
together.
The grid is very finicky and seems to be missing some functionality.
First, there seems to be no way to clear the grid and repopulate from
scratch. I've tried using the .RemoveAll method in runtime, but it gives
me an error. I suppose I could create a new instance of the grid and
start from there, but why should I have to do this to begin with?
Secondly, the reason I even attempted to clear the grid to begin with was
because you can't populate the grid with data from a table with a
clustered index. If in updating data, you end up changing the physical
order of the recordset, the grid barfs because apparently it needs for the
records to to stay in the same order.
I suppose I could be wrong about all this and the grid can do everything
I've just said that it can't, but the Help Files being as bad as they are,
I've given up wasting time time trying to figure it out. I thought we
bought third-party controls to *save* us time?
|
| Thu, 21 Dec 2000 03:00:00 GMT |
|
|
|
John
#6 / 8
|
APEX True DBGrid vs. Sheridan DATA WIDGETS DBGrid I have used both grids in unbound mode. The great benefit you do get with
DBGridd, is that it has an AddItem method, whereby you dont have to deal
with the "Fetch Data" events. Its almost like a ListBox. You may also want
to first look at the ListView control in report mode, if you dont need in
grid editing. Additionally, if you choose the listview, you will probably
want to use the API calls to set the extended styles (such as grids, full
row select etc)
Quote: > I haven't used the APEX True DBGrid but I have used the Sheridan DBGrid. > I would never recommend the Sheridan grid to anyone, unless they paid me > to do it. Btw, these are all my experiences with using it in *unbound* > mode. > What's wrong with it?
...
|
| Fri, 22 Dec 2000 03:00:00 GMT |
|
|
|
Kell
#7 / 8
|
APEX True DBGrid vs. Sheridan DATA WIDGETS DBGrid There is another grid control out there you might want to check out.
It is called the VsFlex grid. It is an updated version of the grid
control that shipped with VB called the MsFlex. This control was made
by a company called Videosoft and you can download and test it for
free at www.videosoft.com. Good luck.
Kelly
Quote:
>> Does anyone out there have experience with one or both of these DBGrids in
>> unbound mode? Do you have strong feelings about the quality of either
>> product?
>> I am currently using the APEX True DBGrid in unbound extended mode. I am
>> happy with the performance of the grid, but the code provided by APEX for
>> the _unboundDataReadEx event is not the easiest to understand. I downloaded
>> Sheridan's DBGrid and reviewed their code for the same event and it reads
>> very well. As a result, I am a little concerned about the maintainability
>> of my current DBGrid choice.
>I haven't used the APEX True DBGrid but I have used the Sheridan DBGrid.
>I would never recommend the Sheridan grid to anyone, unless they paid me
>to do it. Btw, these are all my experiences with using it in *unbound*
>mode.
>What's wrong with it?
>No documentation comes in the box. There is a help file, but it *sucks*.
>For example, you can place a drop-down combo in any column you like in the
>Grid. And in the help file it explains that you must set the hWnd
>property of the combo to that of the grid column (or something like that,
>I forget). Anyway, what it doesn't tell you is that you have to fiddle
>with another property of the drop-down or else is won't "drop down".
>There was a separate FAQ which I had to go searching through to find the
>answer. Its worthless documentation if one has to go searching through
>multiple documents for information that should be logically grouped
>together.
>The grid is very finicky and seems to be missing some functionality.
>First, there seems to be no way to clear the grid and repopulate from
>scratch. I've tried using the .RemoveAll method in runtime, but it gives
>me an error. I suppose I could create a new instance of the grid and
>start from there, but why should I have to do this to begin with?
>Secondly, the reason I even attempted to clear the grid to begin with was
>because you can't populate the grid with data from a table with a
>clustered index. If in updating data, you end up changing the physical
>order of the recordset, the grid barfs because apparently it needs for the
>records to to stay in the same order.
>I suppose I could be wrong about all this and the grid can do everything
>I've just said that it can't, but the Help Files being as bad as they are,
>I've given up wasting time time trying to figure it out. I thought we
>bought third-party controls to *save* us time?
|
| Fri, 22 Dec 2000 03:00:00 GMT |
|
|
|
Tim Roman
#8 / 8
|
APEX True DBGrid vs. Sheridan DATA WIDGETS DBGrid I use both grids and think highly of them both. Haven't really had a chance to determine which of them is more efficient with very large tables, as I try to minimize the amount of data that comes back from the server to the client. It's easier with the Sheridan's grid to put a drop-down in a grid cell: that requires one line of code and (contrary to the posting below) is really a piece of cake; the Apex requires much more coding to get this feature. On the other hand, the Apex seems (to me) easier to configure using its property sheets (i.e. its visual properties) and the Apex documentation is superior. As far as I know, they're both freely available for evaluation. Tim Romano
Quote:
> I haven't used the APEX True DBGrid but I have used the Sheridan DBGrid.
> I would never recommend the Sheridan grid to anyone, unless they paid me
> to do it. Btw, these are all my experiences with using it in *unbound*
> mode.
> What's wrong with it?
> No documentation comes in the box. There is a help file, but it *sucks*.
> For example, you can place a drop-down combo in any column you like in the
> Grid. And in the help file it explains that you must set the hWnd
> property of the combo to that of the grid column (or something like that,
> I forget). Anyway, what it doesn't tell you is that you have to fiddle
> with another property of the drop-down or else is won't "drop down".
> [...]
|
| Sat, 23 Dec 2000 03:00:00 GMT |
|
| |
|
