accès à une BD SQL à travers un fichier aspx
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>
<asp:Parameter Type="Int32" Name="Original_id_contact"></asp:Parameter>
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Type="String" Name="prenom"></asp:Parameter>
<asp:Parameter Type="String" Name="nom"></asp:Parameter>
<asp:Parameter Type="String" Name="telephone"></asp:Parameter>
<asp:Parameter Type="String" Name="email"></asp:Parameter>
<asp:Parameter Type="Int32" Name="Original_id_contact"></asp:Parameter>
</UpdateParameters>
<InsertParameters>
<asp:Parameter Type="String" Name="prenom"></asp:Parameter>
<asp:Parameter Type="String" Name="nom"></asp:Parameter>
<asp:Parameter Type="String" Name="telephone"></asp:Parameter>
<asp:Parameter Type="String" Name="email"></asp:Parameter>
</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>
<asp:Parameter Name="id_contact" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="prenom" Type="String" />
<asp:Parameter Name="nom" Type="String" />
<asp:Parameter Name="telephone" Type="String" />
<asp:Parameter Name="email" Type="String" />
<asp:Parameter Name="id_contact" Type="Int32" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="prenom" Type="String" />
<asp:Parameter Name="nom" Type="String" />
<asp:Parameter Name="telephone" Type="String" />
<asp:Parameter Name="email" Type="String" />
</InsertParameters>
</asp:SqlDataSource>
</form>
