how to ?

[SSN]

as in VB 6.0 we have recordset.movelast what is it in asp.net using C# where database is sql server 2005?

[Ashfield]

There is no equivilent in ADO.NET, it works in an entirely different way. Your best bet is to Google ADO.NET and read up on datareaders and datasets. Hope this helps

Bob Ashfield Consultants Ltd

[dealon]

The SqlDataReader has no such method, please take a look at this below: SqlDataAdapter s = new SqlDataAdapter("...sql...", Conn); DataTable dt = new DataTable(); ; s.Fill(dt); DataRow dr = dt.Rows[dt.Rows.Count - 1]; Hope it's usefull for you!

Regards, Dealon Impossible is nothing!