Finding beginning or ending of database

OK, to find out if you are at the end or beginning of a database after an sql you would use say:

VB Code:

if objrs.bof or objrs.eof then
      alert("Record was not found.", "No Record", vbokonly)
else
      'do something here
end if

How do you accomplish this in say VB.NET or ASP.NET?

In .NET you'd have a DataSet which is just a collection of Tables and Rows, so once you have it you can use the Count property of the Rows collection for the Table in question to see if any results were returned, i.e.

VB Code:

If theDataSet.Tables(0).Rows.Count > 0 Then
  ' Results Found
Else
  ' No Results Found
End If

This would depend on the code your using to pull the data from the databse.... but generally it would look like this:

VB Code:

If MyDataSet.Tables("TableName").Rows.Count = 0 Then
      'ASP.NEt
      Response.WriteLine("Record was not found.")
Else
      'Do Something
End If

Edit: Dammit... i got beat :p

actually this is what i got that gives the same effect using an OLEDBConnection, OLEDBCommand, OLEDBDataReader:

VB Code:

dim objconn, sql, objcomm, objreader
        objconn = New OLEDBConnection("Provider=Microsoft.Jet.OLEDB.4.0; data source=" & server.MapPath("users.mdb"))
        objconn.open()
        sql = "SELECT * FROM Employeelist"
        objcomm  = new OLEDBCommand(sql, objconn)
        objreader = objcomm.ExecuteReader()
        try
            if objreader.read = false
            label1.text = "Nothing Found"
            objreader.close()
            objconn.close()
        else
        carcat.datasource = objreader
        carcat.databind()
        objreader.close()
        objconn.close()
        label1.text = "Data Found"
        end if
            catch ex as exception
                msgbox(ex.message)
        end try

I thought I would post my answer in case anyone else wondered about it. I actually found it in another recent post. I couldn't find it until after I post my question. It gives the exact same efffect as the .BOF and .EOF. :D

This is for an ASP.NET page.

Oh, By the way, sorry for not thanking you guys.
Thanks for the help!! :wave:

ASP.Net isnt like ASP, you need to declare your variable types

VB Code:

Dim objconn as OLEDBConnection
Dim sql as String = "SELECT * FROM Employeelist"
Dim objcomm as OLEDBCommand
Dim objreader as OLEDBDataReader
 
        objconn = New OLEDBConnection("Provider=Microsoft.Jet.OLEDB.4.0; data source=" & server.MapPath("users.mdb"))
        objconn.open()
    
        objcomm  = new OLEDBCommand(sql, objconn)
        objreader = objcomm.ExecuteReader()
        try
            if objreader.read = false
            label1.text = "Nothing Found"
            objreader.close()
            objconn.close()
        else
        carcat.datasource = objreader
        carcat.databind()
        objreader.close()
        objconn.close()
        label1.text = "Data Found"
        end if
            catch ex as exception
                                'No MsgBox in ASP.nEt
                Response.Write(ex.message)
        end try

it still worked though.
i declared the variable then set it as an object. I tested it and it works. That's how the .NET tutorials on W3Cschools did it.

Just because you can jam a sandwich in a vcr doesnt mean its proper... (at least here its not :p)

You should always type your variables, otherwise you will not get proper member lists (the drop down thingys in Visual Studio)

You may not get excally what you want...

Its just bad programming.

to help you out put "Option Explicit On" at the very top of all your code pages (this will insure that you cant do a Dim Myvar, you need to do a Dim Myvar as Object)

Appreciate it. I tried doing the option explicit on, but i'm coding in Dreamweaver actually, because i'm having issues trying to get VS.NET projects to work on my server, anyway, everytime I try to put option explicit on at the top of the page, it tells me I have to put it before any Page or Import statements. It tells me that everytime whether I put it before or not.

I will try to declare them as objects every time though, but someone should write W3Cschools and tell them to do it the right way, because that was misleading :cry:

ok, so i don't think i'm going to be able to use my method, because it doesn't return the first record in the database when I use the objreader.read = false to check for eof. maybe, is there a way to tell the DataReader to place the cursur at the first record then execute? I would rather not use the DataSet object.