Use ODBC with a cursor adapter. But...I advise against doing what you want. It generally isn't done with SQL Server as it is set based, so you work with a set of records, say, all customers in Utah. You rarely pull back all the records.
>Hi,
>I want to write a program in VFP 9 to maintain the records in the database table in SQL server 2008.
>I need to browse and maintain the table record by record, such as which can move next record, previous record, go top, go bottom...etc.
>Is it using ADO recordset or other method like binding navigator in vb.net ?
>
>Please advise.
>
>Thanks.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer