Member Avatar for sameera

hi,

i m novice to asp.i m using one stored procedure in sql server2000 which is using cursor.this is doing the following things

1) select the peticlur records from one table
2) insert the record in another table relavant to retireved ID
3) select the second table values

i m binding this code into asp page.

but it always gives a recordset error becos it is contianing multiple tables(select statements).

Same things i can do if i do upto first two steps by procedure and then directly select the table from view as another recordset.

tell me as i have multiple data tables then how to get perticular table from recordset(for example in asp.net i can take dataset.datatables(0) similarly how to do here?)

thnx.

  • 2 Contributors
  • 1 Reply
  • 115 Views
  • 3 Weeks Discussion Span
  • Latest Post Latest Post by chmonalisa
Member Avatar for chmonalisa

sameera,


you better use this..

dim rs

set rs = rs.nextrecordset

'' do ur operations

rs.movenext

thanks,
chaitanya.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.