1 2 3 4 5 6 7 8 9 10 11 12 13
|
<asp:AccessDataSource ID="cheval" runat="server" DataFile="~/App_Data/esire.mdb" DataSourceMode="DataSet"
SelectCommand="SELECT [CHE_NUCHEVAL], [CHE_ANNAIS], [CHE_NOCHEVAL],[CHE_POANGL],[CHE_NOSURNOM], [CHE_POARAB], PAYS.[PAYS_NAISSA], SEXE.[SEX_LMSEXE], ROBE.[ROB_LMROBE]
FROM [CHEVAL], [SEXE], [ROBE],[PAYS] where SEXE.[SEX_COSEXE]=CHEVAL.[CHE_COSEXE] AND ROBE.[ROB_COROBE]=CHEVAL.[CHE_COROBE] AND PAYS.[PAYS_COPAYS]=CHEVAL.[CHE_COPAYSNAIS] AND CHE_NUCHEVAL=@CHE_NUCHEVAL"
InsertCommand="INSERT INTO [CHEVAL]([CHE_NUCHEVAL],[CHE_NOCHEVAL],[CHE_ANNAIS], [CHE_POANGL],[CHE_NOSURNOM],[CHE_POARAB],SEXE.[SEX_LMSEXE],ROBE.[ROB_LMROBE]) VALUES (@CHE_NUCHEVAL,@CHE_NOCHEVAL,@CHE_ANNAIS,@CHE_POARAB,@CHE_POARAB,@SEX_LMSEXE,@ROB_LMROBE) ">
<SelectParameters>
<asp:QueryStringParameter Name="CHE_NUCHEVAL" QueryStringField="CHE_NUCHEVAL" Type="string" />
</SelectParameters>
<UpdateParameters>
<asp:Parameter Name="CHE_NUCHEVAL" Type="string" />
<asp:Parameter Name="CHE_NOCHEVAL" Type="string" />
</UpdateParameters>
</asp:AccessDataSource> |
Partager