How can I merge Two tables in C#
<p>I have some problem in datatable merging. When i merge two tables like </p>

<pre><code>            DataTable table1 = dataGridView3.DataSource as DataTable;
            DataTable table2 = dataGridView2.DataSource as DataTable;
            table2.Merge(table1);
            dataGridView1.DataSource = table2;
</code></pre>

<p>this code output like that </p>

<pre><code>        firstname             last name         fullname

        ABC                   CDE
        ABC                   CDE
                                                MMMM
                                                MMMM
</code></pre>

<hr>

<pre><code>        ABC                   CDE               MMMM
        ABC                   CDE               MMMM
</code></pre>

<p>but i want to show data like last two rows</p>
