<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="qwerty.aspx.cs" Inherits="Connection.qwerty" %> <!DOCTYPE html> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <title></title> </head> <body style="text-align: center; margin-left: 387px"> <form id="form1" runat="server"> <div> <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" BackColor="White" BorderColor="#999999" BorderStyle="None" BorderWidth="1px" CellPadding="3" DataKeyNames="Id" DataSourceID="SqlDataSource1" GridLines="Vertical"> <AlternatingRowStyle BackColor="#DCDCDC" /> <Columns> <asp:CommandField ShowDeleteButton="True" ShowEditButton="True" /> <asp:BoundField DataField="Id" HeaderText="Id" InsertVisible="False" ReadOnly="True" SortExpression="Id" /> <asp:BoundField DataField="CustomerName" HeaderText="CustomerName" SortExpression="CustomerName" /> <asp:BoundField DataField="CustomerAddress" HeaderText="CustomerAddress" SortExpression="CustomerAddress" /> <asp:BoundField DataField="CustomerDateTime" HeaderText="CustomerDateTime" SortExpression="CustomerDateTime" /> <asp:BoundField DataField="CustomerPhoneNo" HeaderText="CustomerPhoneNo" SortExpression="CustomerPhoneNo" /> </Columns> <FooterStyle BackColor="#CCCCCC" ForeColor="Black" /> <HeaderStyle BackColor="#000084" Font-Bold="True" ForeColor="White" /> <PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center" /> <RowStyle BackColor="#EEEEEE" ForeColor="Black" /> <SelectedRowStyle BackColor="#008A8C" Font-Bold="True" ForeColor="White" /> <SortedAscendingCellStyle BackColor="#F1F1F1" /> <SortedAscendingHeaderStyle BackColor="#0000A9" /> <SortedDescendingCellStyle BackColor="#CAC9C9" /> <SortedDescendingHeaderStyle BackColor="#000065" /> </asp:GridView> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" DeleteCommand="DELETE FROM [details] WHERE [Id] = @Id" InsertCommand="INSERT INTO [details] ([CustomerName], [CustomerAddress], [CustomerDateTime], [CustomerPhoneNo]) VALUES (@CustomerName, @CustomerAddress, @CustomerDateTime, @CustomerPhoneNo)" SelectCommand="SELECT * FROM [details]" UpdateCommand="UPDATE [details] SET [CustomerName] = @CustomerName, [CustomerAddress] = @CustomerAddress, [CustomerDateTime] = @CustomerDateTime, [CustomerPhoneNo] = @CustomerPhoneNo WHERE [Id] = @Id"> <DeleteParameters> <asp:Parameter Name="Id" Type="Int32" /> </DeleteParameters> <InsertParameters> <asp:Parameter Name="CustomerName" Type="String" /> <asp:Parameter Name="CustomerAddress" Type="String" /> <asp:Parameter Name="CustomerDateTime" Type="Int32" /> <asp:Parameter Name="CustomerPhoneNo" Type="String" /> </InsertParameters> <UpdateParameters> <asp:Parameter Name="CustomerName" Type="String" /> <asp:Parameter Name="CustomerAddress" Type="String" /> <asp:Parameter Name="CustomerDateTime" Type="Int32" /> <asp:Parameter Name="CustomerPhoneNo" Type="String" /> <asp:Parameter Name="Id" Type="Int32" /> </UpdateParameters> </asp:SqlDataSource> </div> <asp:HyperLink ID="HyperLink1" runat="server" NavigateUrl="~/A.aspx">HOME PAGE......</asp:HyperLink> </form> </body> </html>
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)