Specified cast is not valid. in LINQ query.

Question

Hello, everyone please help me to solve my error.

 

Specified cast is not valid. in LINQ query. a code is given below

 

try
{
    var result = (from tbl1 in dsSearchdata.Tables[1].AsEnumerable()
                 join tbl2 in dsCategoryProducts.Tables[0].AsEnumerable()
                 on tbl1.Field<int>("ProductId") equals tbl2.Field<int>("ProductId")
    select tbl1);
    if (result.Count() > 0)
    {
        DataTable dt = new DataTable();
        dt = result.CopyToDataTable();
        dsSearchdata.Tables[i].Rows.Clear();
        dsSearchdata.Tables[i].Merge(dt, true);
    }
    else
    {
       dsSearchdata.Tables[i].Rows.Clear();
    }
}
catch (Exception ex)
{
}

It generate exeption 'Specified cast is not valid.'

 

Thanks in advance.