Tuesday, 29 July 2014

ASP.NET DetailsView and SqlDataSource example – Using Insert, Edit

DetailsView and SqlDataSource example: Using Insert, Edit

  1. <%@ Page Language=“C#” %>

  3. <!DOCTYPE html PUBLIC “-//W3C//DTD XHTML 1.0 Transitional//EN” “http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd”>

  5. <script runat=“server”>

  7. </script>

  9. <html xmlns=“http://www.w3.org/1999/xhtml”>
  10. <head runat=“server”>
  11.     <title>DetailsView and SqlDataSource example: Using Insert, Edit</title>
  12. </head>
  13. <body>
  14.     <form id=“form1″ runat=“server”>
  15.     <div>

  17.         <asp:DetailsView ID=“DetailsView1″ runat=“server” AllowPaging=“True”
  18.             AutoGenerateRows=“False” DataKeyNames=“CustomerID”
  19.             DataSourceID=“SqlDataSource1″ Height=“50px” Width=“125px”>
  20.             <Fields>
  21.                 <asp:BoundField DataField=“CustomerID” HeaderText=“CustomerID” ReadOnly=“True”
  22.                     SortExpression=“CustomerID” />
  23.                 <asp:BoundField DataField=“CompanyName” HeaderText=“CompanyName”
  24.                     SortExpression=“CompanyName” />
  25.                 <asp:BoundField DataField=“ContactName” HeaderText=“ContactName”
  26.                     SortExpression=“ContactName” />
  27.                 <asp:BoundField DataField=“ContactTitle” HeaderText=“ContactTitle”
  28.                     SortExpression=“ContactTitle” />
  29.                 <asp:BoundField DataField=“Address” HeaderText=“Address”
  30.                     SortExpression=“Address” />
  31.                 <asp:BoundField DataField=“City” HeaderText=“City” SortExpression=“City” />
  32.                 <asp:BoundField DataField=“Region” HeaderText=“Region”
  33.                     SortExpression=“Region” />
  34.                 <asp:BoundField DataField=“PostalCode” HeaderText=“PostalCode”
  35.                     SortExpression=“PostalCode” />
  36.                 <asp:BoundField DataField=“Country” HeaderText=“Country”
  37.                     SortExpression=“Country” />
  38.                 <asp:BoundField DataField=“Phone” HeaderText=“Phone” SortExpression=“Phone” />
  39.                 <asp:BoundField DataField=“Fax” HeaderText=“Fax” SortExpression=“Fax” />
  40.                 <asp:CommandField ShowDeleteButton=“False” ShowEditButton=“True”
  41.                     ShowInsertButton=“True” />
  42.             </Fields>
  43.         </asp:DetailsView>
  44.         <asp:SqlDataSource ID=“SqlDataSource1″ runat=“server”
  45.             ConflictDetection=“CompareAllValues”
  46.             ConnectionString=“<%$ ConnectionStrings:NorthwindConnectionString %>”
  47.             InsertCommand=“INSERT INTO [Customers] ([CustomerID], [CompanyName], [ContactName], [ContactTitle], [Address], [City], [Region], [PostalCode], [Country], [Phone], [Fax]) VALUES (@CustomerID, @CompanyName, @ContactName, @ContactTitle, @Address, @City, @Region, @PostalCode, @Country, @Phone, @Fax)”
  48.             OldValuesParameterFormatString=“original_{0}”
  49.             SelectCommand=“SELECT * FROM [Customers]“
  50.             UpdateCommand=“UPDATE [Customers] SET [CompanyName] = @CompanyName, [ContactName] = @ContactName, [ContactTitle] = @ContactTitle, [Address] = @Address, [City] = @City, [Region] = @Region, [PostalCode] = @PostalCode, [Country] = @Country, [Phone] = @Phone, [Fax] = @Fax WHERE [CustomerID] = @original_CustomerID AND [CompanyName] = @original_CompanyName AND [ContactName] = @original_ContactName AND [ContactTitle] = @original_ContactTitle AND [Address] = @original_Address AND [City] = @original_City AND [Region] = @original_Region AND [PostalCode] = @original_PostalCode AND [Country] = @original_Country AND [Phone] = @original_Phone AND [Fax] = @original_Fax”>
  51.             <UpdateParameters>
  52.                 <asp:Parameter Name=“CompanyName” Type=“String” />
  53.                 <asp:Parameter Name=“ContactName” Type=“String” />
  54.                 <asp:Parameter Name=“ContactTitle” Type=“String” />
  55.                 <asp:Parameter Name=“Address” Type=“String” />
  56.                 <asp:Parameter Name=“City” Type=“String” />
  57.                 <asp:Parameter Name=“Region” Type=“String” />
  58.                 <asp:Parameter Name=“PostalCode” Type=“String” />
  59.                 <asp:Parameter Name=“Country” Type=“String” />
  60.                 <asp:Parameter Name=“Phone” Type=“String” />
  61.                 <asp:Parameter Name=“Fax” Type=“String” />
  62.                 <asp:Parameter Name=“original_CustomerID” Type=“String” />
  63.                 <asp:Parameter Name=“original_CompanyName” Type=“String” />
  64.                 <asp:Parameter Name=“original_ContactName” Type=“String” />
  65.                 <asp:Parameter Name=“original_ContactTitle” Type=“String” />
  66.                 <asp:Parameter Name=“original_Address” Type=“String” />
  67.                 <asp:Parameter Name=“original_City” Type=“String” />
  68.                 <asp:Parameter Name=“original_Region” Type=“String” />
  69.                 <asp:Parameter Name=“original_PostalCode” Type=“String” />
  70.                 <asp:Parameter Name=“original_Country” Type=“String” />
  71.                 <asp:Parameter Name=“original_Phone” Type=“String” />
  72.                 <asp:Parameter Name=“original_Fax” Type=“String” />
  73.             </UpdateParameters>
  74.             <InsertParameters>
  75.                 <asp:Parameter Name=“CustomerID” Type=“String” />
  76.                 <asp:Parameter Name=“CompanyName” Type=“String” />
  77.                 <asp:Parameter Name=“ContactName” Type=“String” />
  78.                 <asp:Parameter Name=“ContactTitle” Type=“String” />
  79.                 <asp:Parameter Name=“Address” Type=“String” />
  80.                 <asp:Parameter Name=“City” Type=“String” />
  81.                 <asp:Parameter Name=“Region” Type=“String” />
  82.                 <asp:Parameter Name=“PostalCode” Type=“String” />
  83.                 <asp:Parameter Name=“Country” Type=“String” />
  84.                 <asp:Parameter Name=“Phone” Type=“String” />
  85.                 <asp:Parameter Name=“Fax” Type=“String” />
  86.             </InsertParameters>
  87.         </asp:SqlDataSource>

  89.     </div>
  90.     </form>
  91. </body>
  92. </html>

Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)