score:1

Accepted answer
for (int i = 0; i < dt_allpage.rows.count; i++)
       {
           model_name = dt_allpage.rows[i][0].tostring();

           dataset ds_selecttblram = dal.selecttblram();
           datatable dt_selecttblram = ds_selecttblram.tables[0];


           datarow row1 = dt_selecttblram.asenumerable().firstordefault(r => r.field<string>("sku").contains(model_name));
           foreach (datarow row2 in dt_selecttblram.rows)
           {
               if (row1 != null)
               {
                   int model_id = (from datarow dr in dt_selecttblram.rows
                                   where (string)dr["sku"] == model_name
                                   select (int)dr["id"]).firstordefault();
               }

           }



           string price = dt_allpage.rows[i][1].tostring();
           model_name = dt_allpage.rows[i][0].tostring();

       }

Related Query

More Query from same tag