try this its an example
and use dataField same as you database table columns
<asp:GridView ID="grd_InterviewCategoryList" AllowPaging="true" PageSize="10" DataKeyNames="iID" runat="server" Width="60%"
GridLines="none" AllowSorting="true" AutoGenerateColumns="False" EmptyDataText="No Records Found"
EmptyDataRowStyle-ForeColor="red" EmptyDataRowStyle-HorizontalAlign="Center"
AlternatingRowStyle-BackColor="#F7F7F7" CellPadding="4" CellSpacing="4" OnSelectedIndexChanged="grd_InterviewCategoryList_SelectedIndexChanged"
OnRowDeleting="grd_InterviewCategoryList_RowDeleting" OnPageIndexChanging="grd_InterviewCategoryList_PageIndexChanging"
OnSorting="grd_InterviewCategoryList_Sorting">
<HeaderStyle HorizontalAlign="Center" />
<Columns>
<asp:TemplateField HeaderText="SR.NO.">
<ItemTemplate>
<%# (grd_InterviewCategoryList.PageSize * grd_InterviewCategoryList.PageIndex) + Container.DataItemIndex + 1%>
</ItemTemplate>
<ItemStyle Width="20%" HorizontalAlign="Center" />
</asp:TemplateField>
<asp:BoundField DataField="strCategoryName" HeaderText="Name" SortExpression="strCategoryName">
<ItemStyle Width="30%" HorizontalAlign="Center" />
</asp:BoundField>
<asp:BoundField DataField="Date" HeaderText="Date" SortExpression="Date">
<ItemStyle Width="20%" HorizontalAlign="Center"/>
</asp:BoundField>
</Columns>
</asp:GridView>