how to populate two columns of a grid view from single database column programmatically

See more:

SQL-Server-2005

ASP.NET

, +

Hi,
I am creating a gridview for customer and their introducer.I have created a grid view and populated it with the database values.But i need the introducer name in my grid view along with their no.But i have a seperate column for intoducer id only.I have to get the name of introducer by their member ID.I don'T know how to populate that column .Kindly help me.

And my code is

Member_status.aspx

<asp:GridView ID="bussgrid" runat="server" AutoGenerateColumns="False"
                     BorderColor="Aqua" Width="520px" Height="143px" >
                       <Columns>
                           <asp:BoundField DataField="Member_Name" HeaderText="Name" HeaderStyle-BorderColor="Aqua" HeaderStyle-Font-Names="verdana" HeaderStyle-Font-Size="7" HeaderStyle-ForeColor="Purple"
                               SortExpression="Member_Name" />
                           <asp:BoundField DataField="CombinedId" HeaderText="MemberID" ReadOnly="True" HeaderStyle-BorderColor="Aqua" HeaderStyle-Font-Names="verdana" HeaderStyle-Font-Size="7" HeaderStyle-ForeColor="Purple"
                               SortExpression="CombinedId" />
                           <asp:BoundField DataField="IntroducerID" HeaderText="IntroducerID"  HeaderStyle-BorderColor="Aqua" HeaderStyle-Font-Names="verdana" HeaderStyle-Font-Size="7" HeaderStyle-ForeColor="Purple"
                               SortExpression="IntoducerID" />
                           <asp:BoundField DataField="Placement_Side" HeaderText="Position" HeaderStyle-BorderColor="Aqua" HeaderStyle-Font-Names="verdana" HeaderStyle-Font-Size="7" HeaderStyle-ForeColor="Purple"
                               SortExpression="Placement_Side" />
                           <asp:TemplateField HeaderText="Introducer Name">
                         <ItemTemplate>
                            <asp:Label ID="Intro_Name" runat="server"></asp:Label>
                            <%--<asp:Literal ID="Intro_Name" runat="server" />--%>
                    </ItemTemplate>
                    </asp:TemplateField>
                       </Columns>
                       </asp:GridView>

member_status.aspx.cs

protected void Button1_Click(object sender, EventArgs e)
    {
        string text = "select Member_Name,CombinedId,Gender,Member_DOB,[Placement_Side],[City],[Join_Date],IntroducerID,SponsorID from Member_registration where IntroducerID='" + TextBox1.Text + "' ";
        string text1 = text + " select Member_Name from Member_Registration where CombinedID='"+ TextBox1.Text +"'";
        SqlCommand cmd = new SqlCommand(text1, connection);
        connection.Open();
        SqlDataAdapter sda = new SqlDataAdapter(cmd);
        DataTable dt = new DataTable();
        sda.Fill(dt);
        bussgrid.DataSource = dt;
        bussgrid.DataBind();
        
       
    }
    protected void bussgrid_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            


        }