Member Avatar for sweetypie123

Hi,


is there a method check the number of records in data reader?
like the count of rows. ?

  • 3 Contributors
  • 2 Replies
  • 106 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by kvprajapati
Member Avatar for Lee21

hi sweetiepie, Ijust want to share something regarding the checking of rows returned from the database, I'm using datatable and sqldataadapter and i found out that it's much easier to use. Here's the code!

'sqlcon as sql connection
dt = New DataTable
        sda = New SqlDataAdapter("SELECT * FROM TABLENAME", sqlcon)
        sda.Fill(dt)
        If dt.Rows.Count = 0 Then
'write something
        Else
'write something
                    End If

Mark this thread as solved if this was helpful.

Member Avatar for kvprajapati 
SELECT Count(*) from TableName
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.