Gridview and Select query
<p>Begging for help about gridview and tables, been doing this for a week but no luck at all. I am using c# and asp.net. Assuming I have 2 tables, lets just name it Profiles and Info. In table profiles lets just say i have fields with p_Id, FirstName, LastName and in Transaction I have I_Id, childsID, fathersID, mothersID. </p>

<p>This is what my tables looks like:</p>

<p>Profile</p>

<pre><code>| p_Id | FirstName | LastName |

| 1    | Jack      | Cole     | 
| 2    | Cynthia   | Cole     | 
| 3    | Robert    | Cole     |  
</code></pre>

<p>Info</p>

<pre><code>| I_Id | childsID | fathersID | mothersID |

| 1    | 1        | 3         | 2         |
</code></pre>

<p>Now in my gridview I have to display FirstName, LastName, Father and Mother. But I need to display their names not their ID's.</p>

<p>For now my gridview looks like this:</p>

<pre><code>First Name | Last Name | Father| Mother |

Jack       | Cole      | 3     | 2      |
</code></pre>

<p>what I want is like this:</p>

<pre><code>First Name | Last Name | Father      | Mother       |

Jack       | Cole      | Robert Cole | Cynthia Cole |
</code></pre>

<p>Please can you please help me? Many thanks in advance. God bless </p>
