title: join two datatable and return the result in another data table
body: <p>Q:</p>
  
  <p>I have two data tables and i wanna to inner join the and return the result in a another datatable through LINQ.</p>
  
  <pre><code>DataTable dt1 = StaffCVDAL.getCourses(int.Parse(Session["emp_num"].ToString()));
  DataTable dt2 = cc1lectcrsfilesDAL.ListFiles(int.Parse(Session["emp_num"].ToString()), int.Parse(Session["permission_code"].ToString()));
  DataTable dt = from t1 in dt1.AsEnumerable()
                 join t2 in dt2.AsEnumerable()
                        on t1["crsnum"] equals t2["crsnum"]
                 select new { t1["crsname"],t2["group"] }; //the problem is here .
  </code></pre>