Sorting Data.

I bet you never expected me to post another question again, right? haha. Okay, here is what I have:
  A GridView that displays 10 Games from the tblGames in the Games db.
  Here is what I need:
  A GridView that displays 10 Games from the tblGames in the Games db if these Games haven't been played within the last 30 days (which is stored in the Games db in the tblLastPlayed).
  Here is my current (and non-working or I wouldn't be posting this) code:
Dim varUserName As String = Profile.UserName.ToString
Dim varDate As Date = Date.Now
varDate.AddDays(-30)
SqlDataSource1.SelectCommand = "SELECT TOP " & CInt(Profile.GamesConfig.NumofGames).ToString() & " ID, Title, Popularity, Type, [Last Played] FROM GAME WHERE '" & varUserName & "' <> LastPlayed.uID AND LastPlayed.LastPlayedDate > '" & varDate & "'"
   My current problem appears to be that LastPlayed.uID and LastPlayed.LastPlayedDate are not bound and cannot be bound. Any help would be appreciated.
David.

Well, I think I have figured out most of it. Basically, my problem at this point is that the SQL statement doesn't appear capable of comparing two strings to each other using the <> operators. Here is my new code:
SqlDataSource1.SelectCommand = "SELECT TOP " & CInt(Profile.GamesConfig.NumofGames).ToString() & " ID, Title, Popularity, Type, [Last Played] FROM GAME JOIN LastPlayed ON ('" & varUserName & "' <> LastPlayed.uID) AND (LastPlayed.LastPlayedDate > '" & varDate & "')"
I get an error that "The data types varchar and text are incompatible in the not equal to operator."
varUserName is a String and LastPlayed.uID is defined in SQLServer as Text.

Got it all figured out now. Here is the final code:
Dim varNumofGames As String = CInt(Profile.GamesConfig.NumofGames).ToString()
Dim varUserName As String = Profile.UserName.ToString
Dim varDate As Date = Date.Now
varDate.AddDays(-30)
SqlDataSource1.SelectCommand = "SELECT * FROM Game G LEFT OUTER JOIN LastPlayed LP ON G.ID = LP.gID WHERE (LP.gID IS NULL) OR (LP.LastPlayedDate > '" & varDate & "') AND (LP.uID LIKE '" & varUserName & "')"