Bonjour,
Je suis débutant en asp.net et visual studio, g crée une BD pour des contacts via sql server et aimerais rajouter des contacts via mon fichier repertoire.aspx
j'ai crée le fichier ascx dans lequel j'ai réjouté le "SqlDatasource"
et le ObjectDatasource dans le fichier repertoire
mais je ne sai spas comment faire après...
Merci
//repertoire.aspx
<%@ Register Src="WebUserControl.ascx" TagName="WebUserControl" TagPrefix="uc1" %>
<uc1:WebUserControl ID="WebUserControl1" runat="server" />
<asp:objectdatasource id="ObjectDataSource1" runat="server" deletemethod="Delete"
insertmethod="Insert" oldvaluesparameterformatstring="original_{0}" selectmethod="GetData"
typename="DataSet1TableAdapters.RepertoireTableAdapter" updatemethod="Update"><DeleteParameters>
<asparameter Type="Int32" Name="Original_id_contact"></asparameter>
</DeleteParameters>
<UpdateParameters>
<asparameter Type="String" Name="prenom"></asparameter>
<asparameter Type="String" Name="nom"></asparameter>
<asparameter Type="String" Name="telephone"></asparameter>
<asparameter Type="String" Name="email"></asparameter>
<asparameter Type="Int32" Name="Original_id_contact"></asparameter>
</UpdateParameters>
<InsertParameters>
<asparameter Type="String" Name="prenom"></asparameter>
<asparameter Type="String" Name="nom"></asparameter>
<asparameter Type="String" Name="telephone"></asparameter>
<asparameter Type="String" Name="email"></asparameter>
</InsertParameters>
</asp:objectdatasource>
//le fichier ascx
<%@ Control Language="C#" AutoEventWireup="true" Debug="true" CodeFile="WebUserControl.ascx.cs" Inherits="Pages_WebUserControl" %>
<form id="Form1" runat="server">
<div>
<p> <big> Contacts à enregistrer dans le repertoire </big></p>
</div>
<table width="350px" title="Repertoire" id="table1">
<tr>
<td>
<asp:Image id="Image1" runat="server" ImageUrl="~/App_Themes/phone.gif"/>
</td>
</tr>
<tr>
<td><asp:Label id="prenom" runat="server" Text="Prénom "></asp:Label></td>
<td><asp:TextBox id="TextBox_prenom" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td><asp:Label id="nom" runat="server" Text="Nom "></asp:Label></td>
<td><asp:TextBox id="TextBox_nom" runat="server"></asp:TextBox></td>
</tr>
<tr>
<td><asp:Label id="telephone" runat="server" Text="Téléphone "></asp:Label></td>
<td><asp:TextBox id="TextBox_telephone" runat="server"></asp:TextBox></td>
</tr>
<tr>
<td><asp:Label id="email" runat="server" Text="Email"></asp:Label></td>
<td><asp:TextBox id="TextBox_email" runat="server"></asp:TextBox></td>
</tr>
<tr>
<asp:Button id="enregistrer" runat="server" Style="z-index: 100; left: 153px; position: absolute;
top: 350px" Text="Enregistrer" />
</tr>
</table>
<br />
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:TestConnectionString2 %>"
DeleteCommand="DELETE FROM [Repertoire] WHERE [id_contact] = @id_contact" InsertCommand="INSERT INTO [Repertoire] ([prenom], [nom], [telephone], [email]) VALUES (@prenom, @nom, @telephone, @email)"
SelectCommand="SELECT * FROM [Repertoire]" UpdateCommand="UPDATE [Repertoire] SET [prenom] = @prenom, [nom] = @nom, [telephone] = @telephone, [email] = @email WHERE [id_contact] = @id_contact">
<DeleteParameters>
<asparameter Name="id_contact" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asparameter Name="prenom" Type="String" />
<asparameter Name="nom" Type="String" />
<asparameter Name="telephone" Type="String" />
<asparameter Name="email" Type="String" />
<asparameter Name="id_contact" Type="Int32" />
</UpdateParameters>
<InsertParameters>
<asparameter Name="prenom" Type="String" />
<asparameter Name="nom" Type="String" />
<asparameter Name="telephone" Type="String" />
<asparameter Name="email" Type="String" />
</InsertParameters>
</asp:SqlDataSource>
</form>
Partager