Code Format RSS

• • Reply
  

  e_screw

  All-Star

  19530 Points

  3894 Posts

  Code Format

  Jun 16, 2007 06:22 PM|LINK

   

  <%@ Page Language="C#" MasterPageFile="~/MasterPage01.master" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %> <asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server"> <table id="tblMain" style="width: 100%; height: 100%" cellpadding="15">    <tr style="height: 3.0em">        <th style="width: 45%" align="left">CUSTOMER ID MASTER LIST</th>        <th style="width: 55%" align="left">CUSTOMER DETAIL</th>    </tr>    <tr>        <td valign="top">            <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="CustomerID"                DataSourceID="SqlDataSource1" AllowPaging="True" AllowSorting="True" CellPadding="10" SelectedIndex="0">                <Columns>                    <asp:BoundField DataField="CustomerID" HeaderText="Customer ID" ReadOnly="True" SortExpression="CustomerID" />                    <asp:CommandField HeaderText="Select" ShowSelectButton="True" />                </Columns>            </asp:GridView>            <br />            <asp:Label ID="lblTitleSort" runat="server" Text="Enter CustomerID to find:"></asp:Label><asp:TextBox ID="txtTitleSort" runat="server" Width="132px"></asp:TextBox><br />            <asp:Button ID="btnEnter" runat="server" Text="Enter" /><br />            <br />            <asp:Label ID="lblStatus" runat="server"></asp:Label>            <br />            <asp:Label ID="lblNumRecords" runat="server"></asp:Label>            <br />            <asp:Label ID="lblCacheTable" runat="server"></asp:Label><br />            <asp:Label ID="lblSessionCnt" runat="server"></asp:Label><br />            <asp:Label ID="lblCookieLastTime" runat="server"></asp:Label>        </td>        <td valign="top">            <asp:DetailsView ID="DetailsView1" runat="server" AutoGenerateRows="False" CellPadding="10"                DataKeyNames="CustomerID" DataSourceID="SqlDataSource2" Height="50px">                <Fields>                    <asp:BoundField DataField="CustomerID" HeaderText="CustomerID" ReadOnly="True" SortExpression="CustomerID" />                    <asp:BoundField DataField="CompanyName" HeaderText="CompanyName" SortExpression="CompanyName" />                    <asp:BoundField DataField="ContactName" HeaderText="ContactName" SortExpression="ContactName" />                    <asp:BoundField DataField="ContactTitle" HeaderText="ContactTitle" SortExpression="ContactTitle" />                    <asp:BoundField DataField="Address" HeaderText="Address" SortExpression="Address" />                    <asp:BoundField DataField="City" HeaderText="City" SortExpression="City" />                    <asp:BoundField DataField="Region" HeaderText="Region" SortExpression="Region" />                    <asp:BoundField DataField="PostalCode" HeaderText="PostalCode" SortExpression="PostalCode" />                    <asp:BoundField DataField="Country" HeaderText="Country" SortExpression="Country" />                    <asp:BoundField DataField="Phone" HeaderText="Phone" SortExpression="Phone" />                    <asp:BoundField DataField="Fax" HeaderText="Fax" SortExpression="Fax" />                    <asp:CommandField ShowDeleteButton="True" ShowEditButton="True" ShowInsertButton="True" />                </Fields>            </asp:DetailsView>                </td>    </tr></table>    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:cnNORTHWND %>"        SelectCommand="SELECT [CustomerID] FROM [Customers] WHERE ([CustomerID] LIKE '%' + @CustomerID + '%')" OldValuesParameterFormatString="original_{0}" ConflictDetection="CompareAllValues" DeleteCommand="DELETE FROM [Customers] WHERE [CustomerID] = @original_CustomerID" InsertCommand="INSERT INTO [Customers] ([CustomerID]) VALUES (@CustomerID)">        <SelectParameters>            <asp:ControlParameter ControlID="txtTitleSort" DefaultValue="%" Name="CustomerID"                PropertyName="Text" Type="String" />        </SelectParameters>        <DeleteParameters>            <asp:Parameter Name="original_CustomerID" Type="String" />        </DeleteParameters>        <InsertParameters>            <asp:Parameter Name="CustomerID" Type="String" />        </InsertParameters>    </asp:SqlDataSource>    <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConflictDetection="CompareAllValues"        ConnectionString="<%$ ConnectionStrings:cnNORTHWND %>" DeleteCommand="DELETE FROM [Customers] 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"        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)"        OldValuesParameterFormatString="original_{0}" SelectCommand="SELECT * FROM [Customers] WHERE ([CustomerID] = @CustomerID)"        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">        <DeleteParameters>            <asp:Parameter Name="original_CustomerID" Type="String" />            <asp:Parameter Name="original_CompanyName" Type="String" />            <asp:Parameter Name="original_ContactName" Type="String" />            <asp:Parameter Name="original_ContactTitle" Type="String" />            <asp:Parameter Name="original_Address" Type="String" />            <asp:Parameter Name="original_City" Type="String" />            <asp:Parameter Name="original_Region" Type="String" />            <asp:Parameter Name="original_PostalCode" Type="String" />            <asp:Parameter Name="original_Country" Type="String" />            <asp:Parameter Name="original_Phone" Type="String" />            <asp:Parameter Name="original_Fax" Type="String" />        </DeleteParameters>        <UpdateParameters>            <asp:Parameter Name="CompanyName" Type="String" />            <asp:Parameter Name="ContactName" Type="String" />            <asp:Parameter Name="ContactTitle" Type="String" />            <asp:Parameter Name="Address" Type="String" />            <asp:Parameter Name="City" Type="String" />            <asp:Parameter Name="Region" Type="String" />            <asp:Parameter Name="PostalCode" Type="String" />            <asp:Parameter Name="Country" Type="String" />            <asp:Parameter Name="Phone" Type="String" />            <asp:Parameter Name="Fax" Type="String" />            <asp:Parameter Name="original_CustomerID" Type="String" />            <asp:Parameter Name="original_CompanyName" Type="String" />            <asp:Parameter Name="original_ContactName" Type="String" />            <asp:Parameter Name="original_ContactTitle" Type="String" />            <asp:Parameter Name="original_Address" Type="String" />            <asp:Parameter Name="original_City" Type="String" />            <asp:Parameter Name="original_Region" Type="String" />            <asp:Parameter Name="original_PostalCode" Type="String" />            <asp:Parameter Name="original_Country" Type="String" />            <asp:Parameter Name="original_Phone" Type="String" />            <asp:Parameter Name="original_Fax" Type="String" />        </UpdateParameters>        <SelectParameters>            <asp:ControlParameter ControlID="GridView1" Name="CustomerID" PropertyName="SelectedValue"                Type="String" />        </SelectParameters>        <InsertParameters>            <asp:Parameter Name="CustomerID" Type="String" />            <asp:Parameter Name="CompanyName" Type="String" />            <asp:Parameter Name="ContactName" Type="String" />            <asp:Parameter Name="ContactTitle" Type="String" />            <asp:Parameter Name="Address" Type="String" />            <asp:Parameter Name="City" Type="String" />            <asp:Parameter Name="Region" Type="String" />            <asp:Parameter Name="PostalCode" Type="String" />            <asp:Parameter Name="Country" Type="String" />            <asp:Parameter Name="Phone" Type="String" />            <asp:Parameter Name="Fax" Type="String" />        </InsertParameters>    </asp:SqlDataSource>    </asp:Content>

   
  Thanks

  Mark post(s) as "Answer" that helped you
  
  Electronic Screw
  Website||Blog||Dub@i.net