I've done some looking around and im a bit confused


Here is an example of the data thats in the binding source




what i want to do is sort on the 3rd row ( 4 or 3) and then sort by the date ( to see if the record is before a certian time


my idea to do this was to

filter the BS
bs.count
then unfilter the BS


The problem i keep running into is that i cant say that i want Just 4 or Just 3


What ive come up with so far is

c# Code:
  1. private int deadlineCount(DateTime Time, int LeagueID)

  2.         {

  3.             int total = 0;

  4.             string league;

  5.             if (LeagueID == 99)

  6.             {

  7.                 league = "";

  8.             }

  9.             else

  10.             {

  11.                 league = LeagueID.ToString();

  12.             }

  13.  
  14.  
  15.  
  16.             BS.Filter = string.Format("LeagueID >= '{0}' and LeagueID <= '{0}'and [End] <#12/30/1899 {1}#", league, Time.ToString("h:mm tt"));

  17.             total = BS.Count;

  18.             BS.Filter = "";

  19.             

  20.             return total;

  21.         

  22.         }


But i keep running into problems that i cant use any operator ( like ,> ,= ,>=,) becuase it can not preform X onn system.int32 and system.string.


I've been looking around but all the example seem to be for strings or dates.