'''
''' List the forums that belong to that category.
'''
''' The categoryID.
'''
''' Lists all of the forums that belong to that category id.
'''
Public Function ListCategory(ByVal CategoryID As Integer) As DataTable
Using cmd As SqlCommand = sdc.CreateCommand()
cmd.Parameters.AddWithValue("@CategoryID", CategoryID)
Dim table As DataTable
Try
If CategoryID = Nothing Or CategoryID.ToString.Trim() = "" Then
cmd.CommandText = "SELECT CategoryID, Name, SortOrder FROM bx_Category ORDER BY SortOrder"
Using dr As SqlDataReader = cmd.ExecuteReader()
table = New DataTable()
table.Load(dr)
End Using
Else
cmd.CommandText = "SELECT CategoryID, Name, SortORder FROM bx_Category WHERE CategoryID=@CategoryID"
Using dr As SqlDataReader = cmd.ExecuteReader()
table = New DataTable()
table.Load(dr)
End Using
End If
Catch ex As SqlException
Throw ex
Finally
cmd.Connection.Close()
End Try
Return table
End Using
End Function