C# Inner join error

[emajka21]

ASp 2.0, C#, Access 2000 database

Ok I have a weird problem. I am trying to do a c# innerjoin and I am getting an error. Here is the inner join code:

OleDbCommand TenMileCmd = new OleDbCommand("SELECT Race.RaceTime FROM (Race INNER JOIN Registered ON Race.BibNum = Registered.BibNum AND Race.RaceYear = Registered.RaceYear)WHERE Race.RaceYear = @RaceYear AND Registered.RunnerID = @RunnerID AND Race.RaceNum = @RaceNum", conn);

TenMileCmd.Parameters.Add("@RaceYear", OleDbType.Integer);
TenMileCmd.Parameters["@RaceYear"].Value = ddlRaceYear.Text;
TenMileCmd.Parameters.Add("@RunnerID", OleDbType.Integer);
TenMileCmd.Parameters["@RunnerID"].Value = lblRunnerID.Text;
TenMileCmd.Parameters.Add("@RaceNum", OleDbType.Integer);
TenMileCmd.Parameters["@RaceNum"].Value = 10;

The error I get is: Input string was not in a correct format.

The weird thing is if I create this as an Access Data Source it works (granted the @fields are ? that I point to the proper controls.)

So if this is the correct syntax in the access data source why doesn't it work when I put it in the code behind file?

I'm lost here. Any help would be greatly appreciated!! Thanks!

[emajka21]

Never Mind. I figured it out. It had nothing to do with my SQL statement but my parameters.