i have used msaccess as backend and front end as .net
i want to check status of records (i.e EOF and BOF)
i don't know how to check?
using DAtASET or ADO.net
if ADO.net how to do it

For a dataaset, to check for rows, you can just use

if (MyDataSet.Tables[0].Rows.Count > 0)
{
    // then the DataSet has rows
}

thnks minaki. thanks for u r kind consideration

There are many ways to do this

with dataset

it is just the same

if(dataset.tables.rows.count > 0)

with datareader

it

objreader.hasrows

In fact, if you only need to read through every record without modifying their contents, you may consider using datareader because its performance is faster than using dataset in general.

e.g.

[Visual Basic]
Dim myReader As SqlDataReader = myCommand.ExecuteReader()
.....
If myReader.HasRows Then
Do While myReader.Read()
Console.WriteLine(vbTab & "{0}" & vbTab & "{1}", myReader.GetInt32(0), myReader.GetString(1))
Loop
Else
Console.WriteLine("No rows returned.")
End If
myReader.Close()

[C#]
SqlDataReader myReader = myCommand.ExecuteReader();
.....
if (myReader.HasRows)
while (myReader.Read())
Console.WriteLine("\t{0}\t{1}", myReader.GetInt32(0), myReader.GetString(1));
else
Console.WriteLine("No rows returned.");
myReader.Close();