home *** CD-ROM | disk | FTP | other *** search
/ PC Pro 2005 June (DVD) / DPPRO0605DVD.iso / dotNETSDK / SETUP.EXE / netfxsd1.cab / FL_ADOCS_aspx________.3643236F_FC70_11D3_A536_0090278A1BB8 < prev    next >
Encoding:
Text File  |  2001-07-02  |  6.4 KB  |  190 lines
  1. <%@ Assembly Name ="ADODB"%>
  2. <%@ Import Namespace="ADODB"%>
  3. <%@ Import Namespace="System.Data" %>
  4. <%@ Import Namespace="System.Data.OleDb" %>
  5. <%@ Import Namespace="System.Web.UI.HtmlControls" %>
  6. <%@ Import Namespace="System.Text.RegularExpressions" %>  
  7.  
  8.  
  9. <html>
  10. <script language="C#" src="InteropADOCS.cs" runat="server"/>
  11.  
  12. <body BGCOLOR="aquamarine" topmargin="10" leftmargin="10"> 
  13. <font size="4" face="Arial, Helvetica">
  14.  
  15. This page imports the unmanaged msado15.dll using TITLES table from the pubs database
  16.     
  17.  
  18.  
  19. <form runat="server" Name="myForm">
  20.  
  21.  
  22. <span id = "Message1" MaintainState="false" style="font:arial 11pt;" runat="server"/><p>
  23. <asp:DataGrid
  24.     ID="MyDataGrid"
  25.     BorderColor = "black"
  26.     BorderWidth = "1"
  27.     GridLines = "both"
  28.     
  29.     CellSpacing = "0"
  30.     Font-Name = "Verdana"
  31.     Font-Size = "8pt"
  32.     MaintainState = "false"
  33.     runat="server"
  34.     OnEditCommand="MyDataGrid_Edit"
  35.           OnCancelCommand="MyDataGrid_Cancel"
  36.           OnUpdateCommand="MyDataGrid_Update"
  37.     OnDeleteCommand = "MyDataGrid_Delete"
  38.  
  39.           DataKeyField="title_id"
  40.  
  41.  
  42.         AutoGenerateColumns="false">
  43.         
  44.     <Columns>
  45.     
  46.     <asp:EditCommandColumn EditText="Edit" CancelText="Cancel" UpdateText="Update"  ItemStyle-Wrap="false"/>
  47.     <asp:ButtonColumn HeaderText = "Delete Item"
  48. ButtonType = "LinkButton"
  49. Text = "Delete"
  50. CommandName = "Delete">
  51. </asp:ButtonColumn >
  52.         <asp:BoundColumn HeaderText="Title ID" ReadOnly="True" DataField="title_id" ItemStyle-Wrap="false"/>
  53.     
  54.     <asp:TemplateColumn HeaderText="Title" >
  55.                 <ItemTemplate>
  56.                     <asp:Label id=txtTitle runat="server" 
  57.                         Text='<%# DataBinder.Eval(Container.DataItem, "title") %>'
  58.                         
  59.                         />
  60.                 </ItemTemplate>
  61.         <EditItemTemplate>
  62.                <asp:TextBox id ="edit_title" runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "title") %>' Wrap="false"/>
  63.                    </asp:TextBox>
  64.               </EditItemTemplate>
  65.     </asp:TemplateColumn>
  66.  
  67.  
  68.     <asp:TemplateColumn HeaderText="Type" >
  69.                 <ItemTemplate>
  70.                     <asp:Label id=txtType runat="server" 
  71.                         Text='<%# DataBinder.Eval(Container.DataItem, "type") %>'
  72.                         
  73.                         />
  74.                 </ItemTemplate>
  75.         <EditItemTemplate>
  76.                <asp:TextBox id ="edit_type" runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "type") %>' Wrap="false"/>
  77.                    </asp:TextBox>
  78.               </EditItemTemplate>
  79.     </asp:TemplateColumn>
  80.  
  81.     <asp:TemplateColumn HeaderText="Pub ID" >
  82.                 <ItemTemplate>
  83.                     <asp:Label id=txtPub_iD runat="server" 
  84.                         Text='<%# DataBinder.Eval(Container.DataItem, "pub_id") %>'
  85.                         
  86.                         />
  87.                 </ItemTemplate>
  88.         <EditItemTemplate>
  89.             <asp:DropDownList runat="server" DataSource="<%# PublisherID %>" SelectedIndex='<%# GetPubIndex((String)((DataRowView)Container.DataItem)["pub_id"]) %>' id="edit_pubID">
  90.                    </asp:DropDownList>
  91.               </EditItemTemplate>
  92.     </asp:TemplateColumn>
  93.     
  94.     <asp:TemplateColumn HeaderText="Price" >
  95.                 <ItemTemplate>
  96.                     <asp:Label id=txtPrice runat="server" 
  97.                         Text='<%# DataBinder.Eval(Container.DataItem, "price") %>'
  98.                         
  99.                         />
  100.                 </ItemTemplate>
  101.         <EditItemTemplate>
  102.                <asp:TextBox id ="edit_price" runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "price") %>' Wrap="false"/>
  103.                    </asp:TextBox>
  104.               </EditItemTemplate>
  105.     </asp:TemplateColumn>
  106.  
  107.  
  108.     
  109.     <asp:TemplateColumn HeaderText="Advance" >
  110.                 <ItemTemplate>
  111.                     <asp:Label id=txtAdvance runat="server" 
  112.                         Text='<%# DataBinder.Eval(Container.DataItem, "advance") %>'
  113.                         
  114.                         />
  115.                 </ItemTemplate>
  116.         <EditItemTemplate>
  117.                <asp:TextBox id ="edit_advance" runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "advance") %>'/>
  118.                    </asp:TextBoxt>
  119.               </EditItemTemplate>
  120.     </asp:TemplateColumn>
  121.  
  122.     
  123.     <asp:TemplateColumn HeaderText="Royalty" >
  124.                 <ItemTemplate>
  125.                     <asp:Label id=txtRoyalty runat="server" 
  126.                         Text='<%# DataBinder.Eval(Container.DataItem, "royalty") %>'
  127.                         
  128.                         />
  129.                 </ItemTemplate>
  130.         <EditItemTemplate>
  131.                <asp:TextBox id ="edit_royalty" runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "royalty") %>' />
  132.                    </asp:TextBox>
  133.               </EditItemTemplate>
  134.     </asp:TemplateColumn>
  135.  
  136.     
  137.     <asp:TemplateColumn HeaderText="YearToDateSale" >
  138.                 <ItemTemplate>
  139.                     <asp:Label id=txtYtdSale runat="server" 
  140.                         Text='<%# DataBinder.Eval(Container.DataItem, "ytd_sales") %>'
  141.                         
  142.                         />
  143.                 </ItemTemplate>
  144.         <EditItemTemplate>
  145.                <asp:TextBox id ="edit_ytd_sales" runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "ytd_sales") %>'/>
  146.                    </asp:TextBox>
  147.               </EditItemTemplate>
  148.     </asp:TemplateColumn>
  149.     
  150.     <asp:TemplateColumn HeaderText="Notes" >
  151.                 <ItemTemplate>
  152.                     <asp:Label id=txtNotes runat="server" 
  153.                         Text='<%# DataBinder.Eval(Container.DataItem, "notes") %>'
  154.                         
  155.                         />
  156.                 </ItemTemplate>
  157.         <EditItemTemplate>
  158.                <asp:TextBox id ="edit_notes" runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "notes") %>' />
  159.                    </asp:TextBox>
  160.               </EditItemTemplate>
  161.     </asp:TemplateColumn>
  162.     
  163.     
  164.     <asp:TemplateColumn HeaderText="PubDate" >
  165.                 <ItemTemplate>
  166.                     <asp:Label id=txtPubdate runat="server" 
  167.                         Text='<%# DataBinder.Eval(Container.DataItem, "pubdate") %>'
  168.                         
  169.                         />
  170.                 </ItemTemplate>
  171.         <EditItemTemplate>
  172.                <asp:TextBox id ="edit_pubdate" runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "pubdate") %>' />
  173.                    </asp:TextBox>
  174.               </EditItemTemplate>
  175.     </asp:TemplateColumn>
  176.         
  177.             
  178.          </Columns>
  179.  
  180.  
  181.  
  182. </asp:DataGrid>
  183.  
  184.  
  185. </form>
  186. </Body> 
  187.  
  188. </html>
  189.  
  190.