asked on

determine last record in a recordset

I am using classic ASP.

I am looping through a recordset and I need to know when I have reached the last record.

Is there an easy way to do this? Like say use rs.EOF -1

Thanks

junkymail1

When I am getting data from a database I just use the microsoft tools to get the data and loop through the count that way. Here is an example:

string SelectString = "SELECT NAME FROM PEOPLE WHERE NAME = 'Steve'";

SqlConnection SqlConnect = new SqlConnection(GetConnectString());
SqlDataAdapter da = new SqlDataAdapter(SelectString, SqlConnect);

DataSet ds = new DataSet();
da.Fill(ds);
SqlConnect.Close();

DataTable dataTable = ds.Tables[0];
DataRow[] dataRow = dataTable.Select();

if (dataTable.Rows.Count > 0)
{
	for (int indx = 0; indx < dataTable.Rows.Count; indx++)
	{
		string Name = dataRow[indx]["NAME"].ToString();
	}
}

Open in new window

nickgross19

ASKER

Can you do this stuff in classic ASP, I am not using asp.net?

junkymail1

Yes, many of the SQL classes are in ASP. I ported this code over from an original ASP project.

junkymail1

I also came across an example I used a few years ago about classic ASP and an Access Database. I have attached the sources. It is also in VB. I used the

Do While not rsGuestbook.EOF

for testing the database records. In the attached file I had to change the .asp files to aspx, or the website would not let me attach the zip file. Let me know if you have any questions.
example.zip

ASKER CERTIFIED SOLUTION

pateljitu

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial