Re: Get 1st record in ADO.Net

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

sam,

If you want to do the same as a recordset, than you have to look at a
datatable.

Now you are using a sequential datareader, which gives you the records one
by one, however does not store those in a table as it is with the recordset
and the datatable.

I hope this helps,

Cor


.

Relevant Pages

  • Re: display recordset values
    ... Sam ... "Al Reid" wrote: ... >> assign the values in the record to PName? ... But I'm not sure how to use the recordset. ...
    (microsoft.public.vb.database.ado)
  • Re: SqlConnection question
    ... if you supply a name that's not a table but a stored procedure ... If there are multiple tables with the same name you ... check the recordset for a record. ... > Hi Sam, ...
    (microsoft.public.data.ado)
  • return values from function
    ... returning a recordset? ... I would like to make a public function so that ... Prev by Date: ...
    (microsoft.public.access.modulesdaovba)
  • Re: check if field exists
    ... > I open an ADODB recordset rs and want to determine if a particular field ... > present in the recordset. ... Prev by Date: ...
    (microsoft.public.vb.database.ado)
  • Re: Recordset in Memory
    ... I don't know of a way to do it all in memory - unless you save all ... the fields in the recordset as a variable, then you aren't creating a new ... just a bunch of variables. ... Prev by Date: ...
    (microsoft.public.access.modulesdaovba)