Hi everyone,

I having a problem with linq. The following line

Emp objEmp = tblEmps.SingleOrDefault(p => p.empno ==Int32.Parse(this.txtEmpno.Text));

generates the following error message:

System.InvalidCastException was caught
Message=Specified cast is not valid.
Source=System.Data.Linq
StackTrace:
at System.Data.Linq.SqlClient.SqlProvider.Execute(Exp ression query, QueryInfo queryInfo, IObjectReaderFactory factory, Object[] parentArgs, Object[] userArgs, ICompiledSubQuery[] subQueries, Object lastResult)
at System.Data.Linq.SqlClient.SqlProvider.ExecuteAll( Expression query, QueryInfo[] queryInfos, IObjectReaderFactory factory, Object[] userArguments, ICompiledSubQuery[] subQueries)
at System.Data.Linq.SqlClient.SqlProvider.System.Data .Linq.Provider.IProvider.Execute(Expression query)
at System.Data.Linq.Table`1.System.Linq.IQueryProvide r.Execute[TResult](Expression expression)
at System.Linq.Queryable.SingleOrDefault[TSource](IQueryable`1 source, Expression`1 predicate)
at SampleCS.CRUD.btnSearch_Click(Object sender, EventArgs e) in p:\JIMMY PROGRAMMING IN 2010\Linq_Samples\CRUD.aspx.cs:line 48
InnerException:

------------------

Please let me know how to fix this problem. Thanks.

Cecilia