''' ''' 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