How to fill a DataTable with the result of a LINQ?
<p>I have a method that calls a stored procedure. It uses the employee number as a parameter to retrieve the data of a particular employee and then fills the data table with the result.</p>

<pre><code>protected DataTable CreateDT(string empNo)
        {
            DataTable dataTable = null;
            try
            {
                SqlCommand cmd = new SqlCommand("FIND_EMPLOYEE_BY_EMPNO", pl.ConnOpen());
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Parameters.Add(new SqlParameter("@EMPNO", (object)empNo));
                SqlDataAdapter da = new SqlDataAdapter(pl.cmd);
                dataTable = new DataTable("dt");
                da.Fill(dt);
            }
            catch (Exception x)
            {
                MessageBox.Show(x.GetBaseException().ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
            finally
            {
                pl.MySQLConn.Close();
            }
            return dt;
        }
</code></pre>

<p>What I'm trying to accomplish is convert this code to LINQ, but I don't know how get the result and fill it to my data table. See below:</p>

<p><img src="http://a.imageshack.us/img706/9017/testki.jpg" alt="alt text"></p>

<pre><code>protected DataTable CreateDT(string empNo)
        {
            DataTable dataTable = null;
            try
            {
                DataClasses1DataContext dataClass1 = new DataClasses1DataContext();
                // I tried to cast it to DataTable, but it doesn't work...
                dataTable = (DataTable)dataClass1.findEmployeeByID(empNo);
            }
            catch (Exception x)
            {
                MessageBox.Show(x.GetBaseException().ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
            finally
            {
                pl.MySQLConn.Close();
            }
            return dt;
        }
</code></pre>

<p>Please guide me how to properly do this... Thanks in advance..</p>
