Binding Seridan SSDBGrid to ADO Recordset

Can Anyone suggest a way to bind Seridan SSDBGrid (part of Seridan Data Widgets 3) directly to ADODB.Recordset bypassing any data controls, please?
Who is Participating?

Improve company productivity with a Business Account.Sign Up

vindevogelConnect With a Mentor Commented:
You can not link the Recordset of the non-OLEDB Sheridan to a ADO Datacontrol, and visa versa .....  They are not the same.  The normal VB Datacontrol expects a DAO Recordset, you should of course use the ADO Datacontrol if you're using the OLEDB version of Sheridan.
if you want to BIND it, then of course you'll use a data control.

if you don't want to bind it you can use ado.
tbbrhunAuthor Commented:
With MS Dbgrid, it's possible to to bind the grid directly to ado recordset. I was also told that it might be possible to do it with other grids (?using ICursor object or other techniques?). That's what I'm looking for.

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Éric MoreauSenior .Net ConsultantCommented:
You might need to update your control. Not all controls accept ADO recordset as source.
Valliappan ANSenior Tech ConsultantCommented:
You could go for Sheridan OLEDB grids, instead of Sheridan DB Grids. They support ADO.
Use a DataControl anyway.

Just put it on the form, don't specify anything.
Then link the Sheridan Grid to the datacontrol

In code you can open your ado recordset, with all the possibilities from ado

The last line should be then
  Set DataControl.Recordset = YourADORecordset

This automatically populates the grid ...

This may not be what you want, but it gives you the best of both worlds.
tbbrhunAuthor Commented:
I'm going to explore both options in the next couple of hours, but I'm rather inclined to use a more advanced grid than use a Data control anyway. On the other hand I wonder if it's possible to cast ADO recordset into something like an object exposed by the data control?
>> On the other hand I wonder if it's possible to cast ADO
recordset into something like an object exposed by the data control?

Try it out ... works fine with ADO Datacontrol and ADO Sheridan Grid, worked fine with DAO and old style Sheridan.

The Datacontrol is a set of references towards other objects.  The datacontrol.recordset is nothing more than what you would call a "pointer" in C.
tbbrhunAuthor Commented:
Many Thanks!!! I'll go with the data control as a temp solution  meanwhile looking for other options
thanks for the points
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.