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)
- {
- }
Thanks in advance.
Ruchi SharavatPosted May 4, 2018, 2:55 AM
Bhavesh JadavPosted May 4, 2018, 2:01 AM
Ruchi SharavatPosted Apr 24, 2018, 12:17 AM