Code Snippet : SQLDataSource
<asp:SqlDataSource ID="***********" runat="server"
ConnectionString="<%$ ConnectionStrings:OLEDB.********* %>"
ProviderName="<%$ ConnectionStrings:OLEDB.*******.ProviderName %>"
SelectCommand="SELECT * FROM [*********$] WHERE ([CP] = @CP)"
UpdateCommand="UPDATE [********$] SET [COMMERCIAL] = @COMMERCIAL, [COMMENTAIRES VISITES] = @commentaire WHERE [CP] = @CodePostal">
<SelectParameters> <asp:QueryStringParameter Name="CP" QueryStringField="CP" Type="String" />
</SelectParameters>
<UpdateParameters>
<asp:FormParameter FormField="COMMERCIAL"/>
<asp:FormParameter FormField="COMMENTAIRES VISITES" name="commentaire"/>
<asp:QueryStringParameter Name="CodePostal" QueryStringField="CP" Type="Double" />
</UpdateParameters>
</asp:SqlDataSource>