<asp:GridView ID="GridView1" AllowSorting="true" AllowPaging="true" Runat="server" DataSourceID="SqlDataSource1" AutoGenerateEditButton="true" DataKeyNames="id" AutoGenerateColumns="False" > <Columns> <asp:BoundField HeaderText="ID" DataField="id" ItemStyle-HorizontalAlign="Center" HeaderStyle-HorizontalAlign="Center" HeaderStyle-Width="20px" ItemStyle-Width="20px"/> <asp:BoundField HeaderText="First Name" DataField="au_fname" ItemStyle-HorizontalAlign="Center" HeaderStyle-HorizontalAlign="Center" HeaderStyle-Width="20px" ItemStyle-Width="20px"/> <asp:BoundField HeaderText="Phone" DataField="phone" ItemStyle-HorizontalAlign="Center" HeaderStyle-HorizontalAlign="Center" HeaderStyle-Width="20px" ItemStyle-Width="20px"/> <asp:BoundField HeaderText="City" DataField="city" ItemStyle-HorizontalAlign="Center" HeaderStyle-HorizontalAlign="Center" HeaderStyle-Width="20px" ItemStyle-Width="20px"/> <asp:BoundField HeaderText="Start Date" DataField="s_Date" ItemStyle-HorizontalAlign="Center" HeaderStyle-HorizontalAlign="Center" HeaderStyle-Width="50px" ItemStyle-Width="50px"/> <asp:BoundField HeaderText="End Date" DataField="e_Date" ItemStyle-HorizontalAlign="Center" HeaderStyle-HorizontalAlign="Center" HeaderStyle-Width="50px" ItemStyle-Width="50px"/> </Columns></asp:GridView>
<asp:BoundField HeaderText="Start Date" DataField="s_date" /> <HeaderStyle HorizontalAlign="Center" Width="50px" /> <ItemStyle HorizontalAlign="Center" Width="50px" /></asp:BoundField>