I have used TemplateField and BoundField:
<asp:BoundField HeaderText="Fileno" DataField="fileno" />
we have used data field. in BoundField.
now for TemplateField
<asp:TemplateField HeaderText="Department_Name" >
<ItemTemplate>
<asp:Label runat="server" ID="lbldptname"></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox runat="server" ID="txtdptName"></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
I have used below query to populate gridview:
"(select fileno, Department_name , ...
Go to the complete details ...