how to display name in in grid view

See more:

C#

how to display name in in grid view ..i have drop down in my form but when i select the item from drop down the id is inserted into database but when i am loading the grid the same id is displayed in the grid ..how to get the name of that particular id in my grid view ...i am new to this field please help me

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false"
onrowediting="GridView1_RowEditing" onsorting="GridView1_Sorting"
DataKeyNames ="pk_crm_leadid" Width="722px" AllowPaging="True"
BorderStyle="Ridge" CssClass="TDClass" GridLines="Horizontal"
onpageindexchanging="GridView1_PageIndexChanging" CellPadding="2">
<columns> <asp:TemplateField HeaderText="pk_crm_leadid" Visible = "false">
<itemtemplate>
<asp:Label ID="pk_crm_leadid" runat="server" Text='<%# Bind("pk_crm_leadid") %>'>



<asp:TemplateField HeaderText="Customer Name" >
<itemtemplate>
<asp:Label ID="txtpartyname" runat="server" Text='<%# Bind("crm_customername") %>'>



<asp:TemplateField HeaderText="Address " >
<itemtemplate>
<asp:Label ID="txtadd1" runat="server" Text='<%# Bind("crm_address") %>'>



<asp:TemplateField HeaderText="Telephone " >
<itemtemplate>
<asp:Label ID="txttel" runat="server" Text='<%# Bind("crm_telephone") %>'>



<asp:TemplateField HeaderText="Fax No" >
<itemtemplate>
<asp:Label ID="txtfaxno" runat="server" Text='<%# Bind("crm_faxno") %>'>



<asp:TemplateField HeaderText="Mobile" >
<itemtemplate>
<asp:Label ID="txtmbl" runat="server" Text='<%# Bind("crm_mobile") %>'>



<asp:TemplateField HeaderText="Email Id" >
<itemtemplate>
<asp:Label ID="txtemailid" runat="server" Text='<%# Bind("crm_emailid") %>'>



<asp:TemplateField HeaderText="Website" >
<itemtemplate>
<asp:Label ID="txtwebsite" runat="server" Text='<%# Bind("crm_website") %>'>



<asp:TemplateField HeaderText="Contact Name" >
<itemtemplate>
<asp:Label ID="txtcontactname" runat="server" Text='<%# Bind("crm_contactname") %>'>



<asp:TemplateField HeaderText="Assign To" >
<itemtemplate>
<asp:Label ID="drdnlist_emp" runat="server" Text='<%# Bind("fk_crm_assignto") %>'>




<asp:TemplateField HeaderText="Edit">
<itemtemplate>
<asp:LinkButton ID="lnkbtnedit" runat="server" CommandName="edit">Edit

<%--<edititemtemplate>
<asp:LinkButton ID="lnkbtncancel" runat="server" CommandName="Cancel">Cancel
<asp:LinkButton ID="lnkbtnupdate" runat="server" CommandName="Update">Update
--%>





this is my grid view and this is the code in which i want to bind empname (<asp:Label ID="drdnlist_emp" runat="server" Text='<%# Bind("fk_crm_assignto") %>'>) but when i am joining the query am getting error

this is the select query i am using to fill grid SELECT a.pk_crm_leadid,a.crm_customername ,a.crm_address,a.crm_telephone,a.crm_faxno,a.crm_mobile,a.crm_emailid,a.crm_website,a.crm_contactname,a.fk_crm_assignto,b.empname FROM crm_lead a,employee b where b.empno = a.fk_crm_assignto