<%@ Page Language="VB" AutoEventWireup="false" CodeFile="ModArch.aspx.vb" Inherits="ModArch" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "
[ Lien ]">
<html xmlns=" [ Lien ]" >
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div style="background-color: #d2dcea">
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" AutoGenerateEditButton="True"
DataKeyNames="ID_Arch" DataSourceID="AccessDataSource1" Height="137px" Width="457px" AutoGenerateDeleteButton="True">
<Columns>
<asp:BoundField DataField="ID_Arch" HeaderText="ID_Arch" InsertVisible="False" ReadOnly="True"
SortExpression="ID_Arch" />
<asp:BoundField DataField="ID_Client" HeaderText="ID_Client" SortExpression="ID_Client" />
<asp:BoundField DataField="Num_Compte" HeaderText="Num_Compte" SortExpression="Num_Compte" />
<asp:BoundField DataField="Nom_Arch" HeaderText="Nom_Arch" SortExpression="Nom_Arch" />
<asp:BoundField DataField="Desc_Arch" HeaderText="Desc_Arch" SortExpression="Desc_Arch" />
<asp:TemplateField>
<ItemTemplate>
<asp:FileUpload ID="FileUpload1" runat="server" Enabled='<%# Bind("fichier_scaner") %>'
Visible='<%# Bind("fichier_scaner") %>' />
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
<asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="~/archivage DB.mdb"
SelectCommand="SELECT [ID_Arch], [ID_Client], [Num_Compte], [Nom_Arch], [Desc_Arch], [fichier_scaner] FROM [Archive]" ConflictDetection="CompareAllValues" DeleteCommand="DELETE FROM [Archive] WHERE [ID_Archive] = ? AND [ID_Client] = ? AND [Num_Compte] = ? AND [Nom_Arch] = ? AND [Desc_Arch] = ? AND [fichier_scaner] = ?" InsertCommand="INSERT INTO [Archive] ([ID_Arch], [ID_Client], [Num_Compte], [Nom_Arch], [Desc_Arch], [fichier_scaner]) VALUES (?, ?, ?, ?, ?, ?)" OldValuesParameterFormatString="original_{0}" UpdateCommand="UPDATE [Archive] SET [ID_Client] = ?, [Num_Compte] = ?, [Nom_Arch] = ?, [Desc_Arch] = ?, [fichier_scaner] = ? WHERE [ID_Arch] = ? AND [ID_Client] = ? AND [Num_Compte] = ? AND [Nom_Arch] = ? AND [Desc_Arch] = ? AND [fichier_scaner] = ?">
<DeleteParameters>
<asp:Parameter Name="original_ID_Archive" Type="Int32" />
<asp:Parameter Name="original_ID_Client" Type="Int32" />
<asp:Parameter Name="original_Num_Compte" Type="Int32" />
<asp:Parameter Name="original_Nom_Arch" Type="String" />
<asp:Parameter Name="original_Desc_Arch" Type="String" />
<asp:Parameter Name="original_fichier_scaner" Type="Object" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="ID_Client" Type="Int32" />
<asp:Parameter Name="Num_Compte" Type="Int32" />
<asp:Parameter Name="Nom_Arch" Type="String" />
<asp:Parameter Name="Desc_Arch" Type="String" />
<asp:Parameter Name="fichier_scaner" Type="Object" />
<asp:Parameter Name="original_ID_Archive" Type="Int32" />
<asp:Parameter Name="original_ID_Client" Type="Int32" />
<asp:Parameter Name="original_Num_Compte" Type="Int32" />
<asp:Parameter Name="original_Nom_Arch" Type="String" />
<asp:Parameter Name="original_Desc_Arch" Type="String" />
<asp:Parameter Name="original_fichier_scaner" Type="Object" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="ID_Archive" Type="Int32" />
<asp:Parameter Name="ID_Client" Type="Int32" />
<asp:Parameter Name="Num_Compte" Type="Int32" />
<asp:Parameter Name="Nom_Arch" Type="String" />
<asp:Parameter Name="Desc_Arch" Type="String" />
<asp:Parameter Name="fichier_scaner" Type="Object" />
</InsertParameters>
</asp:AccessDataSource>
</div>
</form>
</body>
</html>