Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_ado_rds thread: Retreival of Recordset object from RDS Data Control


Message #1 by mail_nkkamath@y... on Sat, 25 Aug 2001 07:22:48

1)Is it possible to set a recordset obtained from RDS DataControl to 

another recordset object. 

e.g.

dsodata.URL = "RDSURLData.asp?TABLE=" + sFile    

dsoData.Refresh()     

Dim rsData

set rsData=CreateObject("ADODB.Recordset") /* On the client side */ 

rsdata=dsodata.Recordset 



Or is there any other method to do so...



2)Can't i bind the recordset returned from RDS to a design time control 

and not html element...

i have tried placing a design time control on a Page containing the object 

of RDS but it does not allow the dsodata object to get created...

i fail to understand this.



I am using the authors example of binding RDS to elements in a table cell 

and trying to modify it so as to suit my requirements...



please reply urgently...

Message #2 by "Ken Wilson" <kensan@n...> on Sun, 26 Aug 2001 00:10:13 +0100
Hi



This is something I've never tried, but don't see why it shouldn't be

possible.  I've been given a good RDS resource url - you might find

something there that helps, It is

http://www.able-consulting.com/RDS_Faq.htm



One thing I noticed in your code  - and this may be trivial - is that you've

writen



rsdata=dsodata.Recordset



which should possibly be



set rsdata=dsodata.Recordset.



You can bind an RDS recordset to a Seridan Datagrid control - this usualy

comes with VB Enterprise.  The file name of the control is SSDATB32.ocx and

its class id is



AC05DC80-7DF1-11d0-839E-00A024A94B3A



There may be newer versions of this control and there will be other controls

you should be able to bind RDS to, but you might need to pay for them.



I hope some of this helps a bit.



Regards



Ken Wilson





----- Original Message -----

From: <mail_nkkamath@y...>

To: "ASP_ADO_RDS" <asp_ado_rds@p...>

Sent: Saturday, August 25, 2001 7:22 AM

Subject: [asp_ado_rds] Retreival of Recordset object from RDS Data Control





>

> 1)Is it possible to set a recordset obtained from RDS DataControl to

> another recordset object.

> e.g.

> dsodata.URL = "RDSURLData.asp?TABLE=" + sFile

> dsoData.Refresh()

> Dim rsData

> set rsData=CreateObject("ADODB.Recordset") /* On the client side */

> rsdata=dsodata.Recordset

>

> Or is there any other method to do so...

>

> 2)Can't i bind the recordset returned from RDS to a design time control

> and not html element...

> i have tried placing a design time control on a Page containing the object

> of RDS but it does not allow the dsodata object to get created...

> i fail to understand this.

>

> I am using the authors example of binding RDS to elements in a table cell

> and trying to modify it so as to suit my requirements...

>

> please reply urgently...

  Return to Index