<div style="border-style: solid solid solid solid; border-width: medium; overflow-x:scroll; border-color: #006699; padding: 15px;">
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
BackColor="LightGoldenrodYellow" BorderColor="Tan" BorderWidth="1px"
CellPadding="2" DataKeyNames="Id" DataSourceID="SqlDataSource1"
ForeColor="Black" GridLines="None" AllowPaging="True" PageIndex="10">
<AlternatingRowStyle BackColor="PaleGoldenrod" />
<Columns>
<asp:CommandField ShowDeleteButton="True" ShowEditButton="True">
<HeaderStyle CssClass="padd" Wrap="False" />
<ItemStyle CssClass="padd" Wrap="False" />
</asp:CommandField>
<asp:BoundField DataField="Id" HeaderText="Id" InsertVisible="False"
ReadOnly="True" SortExpression="Id" Visible="False" />
<asp:BoundField DataField="Name" HeaderText="Name"
SortExpression="Name">
<HeaderStyle CssClass="padd" Wrap="False" />
<ItemStyle CssClass="padd" Wrap="False" />
</asp:BoundField>
<asp:BoundField DataField="Mobile_No" HeaderText="Mobile No"
SortExpression="Mobile_No">
<HeaderStyle CssClass="padd" Wrap="False" />
<ItemStyle CssClass="padd" Wrap="False" />
</asp:BoundField>
<asp:BoundField DataField="Email_Id" HeaderText="Email Id"
SortExpression="Email_Id">
<HeaderStyle CssClass="padd" Wrap="False" />
<ItemStyle CssClass="padd" Wrap="False" />
</asp:BoundField>
<asp:BoundField DataField="Message" HeaderText="Message"
SortExpression="Message">
<HeaderStyle CssClass="padd" Wrap="False" />
<ItemStyle CssClass="padd" Wrap="False" />
</asp:BoundField>
<asp:BoundField DataField="Default_Date" HeaderText="Date"
SortExpression="Default_Date" >
<HeaderStyle CssClass="padd" Wrap="False" />
<ItemStyle CssClass="padd" Wrap="False" />
</asp:BoundField>
</Columns>
<FooterStyle BackColor="Tan" />
<HeaderStyle BackColor="Tan" Font-Bold="True" />
<PagerStyle BackColor="PaleGoldenrod" ForeColor="DarkSlateBlue"
HorizontalAlign="Center" />
<SelectedRowStyle BackColor="DarkSlateBlue" ForeColor="GhostWhite" />
<SortedAscendingCellStyle BackColor="#FAFAE7" />
<SortedAscendingHeaderStyle BackColor="#DAC09E" />
<SortedDescendingCellStyle BackColor="#E1DB9C" />
<SortedDescendingHeaderStyle BackColor="#C2A47B" />
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:admin %>"
DeleteCommand="DELETE FROM [Admin_Contact] WHERE [Id] = @Id"
InsertCommand="INSERT INTO [Admin_Contact] ([Name], [Email_Id], [Message], [Mobile_No], [Default_Date]) VALUES (@Name, @Email_Id, @Message, @Mobile_No, @Default_Date)"
SelectCommand="SELECT * FROM [Admin_Contact] ORDER BY [Default_Date] DESC"
UpdateCommand="UPDATE [Admin_Contact] SET [Name] = @Name, [Email_Id] = @Email_Id, [Message] = @Message, [Mobile_No] = @Mobile_No, [Default_Date] = @Default_Date WHERE [Id] = @Id">
<DeleteParameters>
<asp:Parameter Name="Id" Type="Int64" />
</DeleteParameters>
<InsertParameters>
<asp:Parameter Name="Name" Type="String" />
<asp:Parameter Name="Email_Id" Type="String" />
<asp:Parameter Name="Message" Type="String" />
<asp:Parameter Name="Mobile_No" Type="String" />
<asp:Parameter Name="Default_Date" Type="String" />
</InsertParameters>
<UpdateParameters>
<asp:Parameter Name="Name" Type="String" />
<asp:Parameter Name="Email_Id" Type="String" />
<asp:Parameter Name="Message" Type="String" />
<asp:Parameter Name="Mobile_No" Type="String" />
<asp:Parameter Name="Default_Date" Type="String" />
<asp:Parameter Name="Id" Type="Int64" />
</UpdateParameters>
</asp:SqlDataSource>
</div>
