<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %>
koden kommer her. Jeg har lavet en fast parameter i dette eksempel "?ID=2" hvor to tallet skal følge den angivne ID.
wildthing
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "
http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="
http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>ProductDB - List</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True"
AutoGenerateColumns="False" CellPadding="4" DataSourceID="AccessDataSource1"
EmptyDataText="There are no data records to display." ForeColor="#333333" GridLines="None"
Style="z-index: 100; left: 0px; position: absolute; top: 0px">
<FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
<Columns>
<asp:BoundField DataField="ID" HeaderText="ID" InsertVisible="False" SortExpression="ID" />
<asp:BoundField DataField="t_dsca" HeaderText="Product group" SortExpression="t_dsca" />
<asp:BoundField DataField="ProductType" HeaderText="Product Type" SortExpression="ProductType" />
<asp:HyperLinkField DataTextField="ProductDescription" NavigateUrl="~/Details.aspx?ID=2"
Target="_blank" Text="Productdescription" HeaderText="Product description" />
<asp:BoundField DataField="Version" HeaderText="Ver." SortExpression="Version" />
<asp:BoundField DataField="Responsable" HeaderText="Responsable" SortExpression="Responsable" />
<asp:BoundField DataField="LifeTimeStatus" HeaderText="Life Time Status" SortExpression="LifeTimeStatus" />
<asp:BoundField DataField="Signal" HeaderText="Signal" SortExpression="Signal" />
<asp:CheckBoxField DataField="PriceList" HeaderText="Price List" SortExpression="PriceList" />
<asp:BoundField DataField="CaseIPU" HeaderText="CaseIPU" SortExpression="Case IPU" />
<asp:BoundField DataField="Resource" HeaderText="In Charge" SortExpression="Resource" />
<asp:BoundField DataField="ExpRelDate" HeaderText="Exp.Rel." SortExpression="ExpRelDate" />
</Columns>
<RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
<EditRowStyle BackColor="#999999" />
<SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
<PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
<HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
<AlternatingRowStyle BackColor="White" ForeColor="#284775" />
</asp:GridView>
<asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="\\neptun\dbroot\ProductDB\ProductDB.mdb"
DeleteCommand="DELETE FROM `Main` WHERE `ID` = ?" InsertCommand="INSERT INTO `Main` (`ID`, `ProductGroup`, `ProductType`, `ProductDescription`, `Responsable`, `LifeTimeStatus`, `LastEdit`, `PriceList`, `Signal`, `Version`, `Case`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
SelectCommand="SELECT dbo_ttcmcs0442001.t_dsca, Main.ProductType, Main.ProductDescription, Main.Version, Main.Responsable, Main.LifeTimeStatus, Main.Signal, Main.PriceList, Main.CaseIPU, Tasks.Resource, Tasks.ExpRelDate, Main.ID FROM ((dbo_ttcmcs0442001 INNER JOIN Main ON dbo_ttcmcs0442001.t_csgp = Main.ProductGroup) LEFT OUTER JOIN Tasks ON Main.CaseIPU = Tasks.IpuNumber) WHERE (Tasks.RevisionContCur = yes) AND (Main.CaseIPU > 0) OR (Main.CaseIPU IS NULL)"
UpdateCommand="UPDATE `Main` SET `ProductGroup` = ?, `ProductType` = ?, `ProductDescription` = ?, `Responsable` = ?, `LifeTimeStatus` = ?, `LastEdit` = ?, `PriceList` = ?, `Signal` = ?, `Version` = ?, `Case` = ? WHERE `ID` = ?">
<DeleteParameters>
<asp:Parameter Name="ID" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="ProductGroup" Type="String" />
<asp:Parameter Name="ProductType" Type="String" />
<asp:Parameter Name="ProductDescription" Type="String" />
<asp:Parameter Name="Responsable" Type="String" />
<asp:Parameter Name="LifeTimeStatus" Type="String" />
<asp:Parameter Name="LastEdit" Type="DateTime" />
<asp:Parameter Name="PriceList" Type="Boolean" />
<asp:Parameter Name="Signal" Type="String" />
<asp:Parameter Name="Version" Type="String" />
<asp:Parameter Name="Case" Type="String" />
<asp:Parameter Name="ID" Type="Int32" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="ID" Type="Int32" />
<asp:Parameter Name="ProductGroup" Type="String" />
<asp:Parameter Name="ProductType" Type="String" />
<asp:Parameter Name="ProductDescription" Type="String" />
<asp:Parameter Name="Responsable" Type="String" />
<asp:Parameter Name="LifeTimeStatus" Type="String" />
<asp:Parameter Name="LastEdit" Type="DateTime" />
<asp:Parameter Name="PriceList" Type="Boolean" />
<asp:Parameter Name="Signal" Type="String" />
<asp:Parameter Name="Version" Type="String" />
<asp:Parameter Name="Case" Type="String" />
</InsertParameters>
</asp:AccessDataSource>
</div>
</form>
</body>
</html>
