DataTable - Select only find row where value is less than 10?

I'm having a really hard ti开发者_开发问答me trying to figure out what's going on with the Select method of DataTable. Here's the data that I got back in a DataTable, called VotePeriods:

PeriodID Description

11 Test 11

10 Test 10

9 Test 9

...

...

1 Test1

Here's the code to select the period based on PeriodID:

if (VotePeriods.Rows.Count > 0)
{
    DataRow[] vp = VotePeriods.Select("PeriodID = " + voteperiod);

    if (vp.Length > 0)
    {
        return vp[0];
    }
}

For some reason, if voteperiod is 9 or less, then I have the correct row selected. But if I pass in a 10 or 11, I have no data back, even though in my DataTable, PeriodID 10 and 11 exists. Any suggestion?

Thanks.

Hope below will work. Keep in mind to add single quotation for values always when using the select method with DataTable.

if (VotePeriods.Rows.Count > 0)
{
    DataRow[] vp = VotePeriods.Select("PeriodID = '" + voteperiod +"'");

    if (vp.Length > 0)
    {
        return vp[0];
    }
}

Have you tried using LINQ to select? I've had bad luck with a DataTable.Select before.

if(VotePeriods.Rows.Count > 0)
{

      var vp = from x in VotePeriods.AsEnumerable()
               where x["PeriodID"] == voteperiod
               select x;

}

Make sure the data type of your PeriodID column is numeric, like int:

VotePeriods.Columns.Add("PeriodID", typeof(int));