Sql server error

[kishorenandamuddada]

Hi,
I coverted my asp project into asp.net and database from Ms-access to sql server. Now getting this error .

Exception Details: System.Runtime. InteropServices .COMException: Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.

Plz provide me solution for this

[KentBill]

While you are use ASP, it use ADO to read and write data from database, But you must use ADO.NET to read and write data from database in ASP.NET.
In ADO, you can use a loop to read and/or write data from a RecordSet, in ADO.NET, it haven't RecordSet, it provided DataSet, DataSet contains some DataTables, the DataTable look like RecordSet, it stored data too, but it different from RecordSet, you can not use MoveFirst, MoveNext, etc. And it have not EOF and BOF properties.
If you want to read data like RecordSet in your code, use DataReader, and use WHILE loop to read data from it.

[KentBill]

So, I think you can not convert the code what used to read and write data from ASP to ASP.NET directly.