IsEmpty with a dataset?

[bencooke]

Hi,

I am trying to test whether a table in a dataset is empty or not using an IF statement. ie has the SQL query retrieved any results or not. the table is called myLinks as below:

<%# IF myLinks.IsEmpty() THEN %>
<asp:Repeater id="myLinks" runat="server">

...

...

</asp:Repeater>


<% End If %>

Is there such a thing as IsEmpty with these if not how do I perform such a test?


I appreciate any help I can get, thanks,

beNcooKe

[Wokawidget]

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        Dim woof As DataSet
        'do stuff to dataset
        If woof.Tables.Count = 0 Then
            MessageBox.Show("No tables found in dataset")
        Else
            If woof.Tables.Item(0).Rows.Count = 0 Then
                MessageBox.Show("No rows found in 1st table")
            Else
                MessageBox.Show("Rows were found...Boooooooooo")
 
            End If
        End If
    End Sub

Hope that helps.

Woof

[bencooke]

Ive tried a few combinations including

<%# IF objDataSet.Tables.Item(1).Rows.Count <> 0 THEN %>

but im afraid i just get the following error:

"BC30201: Expression expected"

Any other ideas??

cheers,

beN

[Wokawidget]

The base index is 0 not 1.
I think it's Item(0) you want...

Woka

[Wokawidget]

You could always do:

Public Class MyDataSet
    Inherits System.Data.DataSet
 
    Public Function IsTableEmpty(ByVal Index As Integer) As Boolean
        Return (MyBase.Tables.Item(Index).Rows.Count = 0)
    End Function
End Class

Then you can do:

Dim Woof As MyDataSet
   'code to deal with woof
  If Woof.IsTableEmpty(0) Then
 
  End If

Although for one function I feel this may be overkill.

Woka

[bencooke]

i have another table already in the dataset called "myResults" which is added first. I treid different index numbers and even putting the table name eg ("myLinks") in the parenthesese like when you refer to column names.

all gave me the same error message as mentioned above,

beN

[Wokawidget]

Why on earth are you placing all that scripting code into the web page? .NET should handle all this in it's class...

Why not have that code in the ASP.NET Page_Load event and not some VBScript code or whatever it is.

Woka

[venerable bede]

Woka's right (as usual). Are you not using VS.net. In line code is a bit of a nightmare.

Woof

[bencooke]

i have another table already in the dataset called "myResults" which is added first. I treid different index numbers and even putting the table name eg ("myLinks") in the parenthesese like when you refer to column names.

all gave me the same error message as mentioned above,

beN

[bencooke]

well im still in development at the moment, at a later date all the code will be put into a seperate file and where possible things procedureised more and more.

The essence of what im trying to do is there, this IsEmpty thing is getting a bit boggling though

beN

[Wokawidget]

The thing is that that error doesn't look like a .NET error
I have not seen that before.
You arn't using VS so it's a little hard for us to figure out what is wrong.
I don't think it's to do with the .NET coding, more to do with you <&*% blah blah stuff...dunno what it's called.

Woka

venerable bede: I am right as usual??? 99% of the time I talk crap and am wrong

[bencooke]

the tags <%# ... %> are needed to create selective page content depending on user selections, page variables and the contents of SQL results.

The page will be part of a much larger corporate site.

Any further pointers?

cheers

beN