I am working in VB6.I have used Third Party Sheridon controls like SSGrid,SSCombo before,which has sufficient properties.But now i want to move to Windows7.For that i dont have serials for that third party and they will not provide support that product now a days.Rebind and Refresh property not works in inbuilt VB6 datagrid.I need a another third party Grid and Combobox for VB6.Please anyone suggest me the component link..eighter free or cost not a problem..
The Grid should have DataSource property and Rebind property..
Thanks in Advance,
Last edited by si_the_geek; Aug 26th, 2010 at 11:18 AM.
Reason: removed email address so it isn't picked up by spam bots - other members can contact you via the forums
Try using MSFlexgrid and/or MSHFlexGrid instead - much better grid controls than ordinary DataGrid.
You may also follow one of relevant links in my signature if you need some sample code.
Thanks for response,
I have tested MSFlexGrid also.But its like matrix code to connect Grid with ADODC.I want to connect with DataSource property simply..Please suggest me any other with DataSource property,and should work for Rebind and Refresh.
If my post was helpful to you, then express your gratitude using Rate this Post.
And if your problem is SOLVED, then please Mark the Thread as RESOLVED (see it in action - video) My system: AMD FX 6100, Gigabyte Motherboard, 8 GB Crossair Vengance, Cooler Master 450W Thunder PSU, 1.4 TB HDD, 18.5" TFT(Wide), Antec V1 Cabinet Social Group:VBForums - Developers from India
The FlexGrid controls are meant as "display" controls (i.e. they're output-only).
The DataGrid control is actually quite powerful and can save you lots of coding when you want to offer users a spreadsheet-like "table view" of data. There are also the companion ADO Data, DataList, DataCombo, and DataRepeater controls. MSHFlexGrid is usually considered a part of this group as well because it offers the same powerful ADO data binding capabilities. This group of controls was meant to replace the older Sheridan controls.
In all of my tests these work just fine in Vista and Win7.
Just be sure to avoid the more ancient DAO-oriented controls that were a holdover from VB4/5 to make porting old programs to VB6 easier. Those are named things like DBList and DBCombo, the old DBGrid isn't normally installed with VB6 .
The FlexGrid controls are meant as "display" controls (i.e. they're output-only)...
Absolutely not, they are not read-only - you can easily use either (especially Hierarchical grid that can be bound to a recordset) to manipulate data.
However, data bound controls are not something commercial app would use - they give nothing more than a good headach.
Absolutely not, they are not read-only - you can easily use either (especially Hierarchical grid that can be bound to a recordset) to manipulate data.
However, data bound controls are not something commercial app would use - they give nothing more than a good headach.
I disagree. A user cannot enter data or update values using the FlexGrids. A programmer is forced to "hover" another control over the top of the grid to simulate this at significant expense of hand coding.
The DataGrid control automates this so direct entry is possible with no extra code.
Many people have trouble with data binding and run from it and cast aspersions upon it. To each his own, but this thread was specifically asking for help with bound controls.
The FlexGrid controls are meant as "display" controls (i.e. they're output-only).
The DataGrid control is actually quite powerful and can save you lots of coding when you want to offer users a spreadsheet-like "table view" of data. There are also the companion ADO Data, DataList, DataCombo, and DataRepeater controls. MSHFlexGrid is usually considered a part of this group as well because it offers the same powerful ADO data binding capabilities. This group of controls was meant to replace the older Sheridan controls.
In all of my tests these work just fine in Vista and Win7.
Just be sure to avoid the more ancient DAO-oriented controls that were a holdover from VB4/5 to make porting old programs to VB6 easier. Those are named things like DBList and DBCombo, the old DBGrid isn't normally installed with VB6 .
MSHFlexGrid doesnt have rebind property.please suggest me with Rebind,Refresh property.Thanks
It is hard to guess what you mean by deleting through a command button. Are you calling the Delete method on the same Recordset? Doing a Delete through another Recordset? Another Recordset on another Connection?
When I add an extra button and the code:
Code:
Private Sub Command1_Click()
rsTable.Delete
DataGrid1.Refresh
End Sub
Everything works fine here.
You normally only need ReBind when the underlying data source changes. Just call Refresh to update the displayed rows.