
02/07/2008, 16:26
|
| | Fecha de Ingreso: octubre-2007
Mensajes: 18
Antigüedad: 17 años, 6 meses Puntos: 0 | |
Respuesta: Ayuda aca les dejo el codigo de mi index.aspx donde se encuentra el formulario para que completen los datos.
Código:
<asp:AccessDataSource runat="server" id="AccessDataSource1" DataFile="App_Data/Basededatosweb02_prueva.mdb" SelectCommand="SELECT * FROM [cliente]" DeleteCommand="DELETE FROM [cliente] WHERE [Id] = ?" InsertCommand="INSERT INTO [cliente] ([Nombre], [Apellido], [Localidad], [Pais], [CPostal], [Correo], [Nota], [Acepta_email]) VALUES (?, ?, ?, ?, ?, ?, ?, ?)" UpdateCommand="UPDATE [cliente] SET [Nombre] = ?, [Apellido] = ?, [Localidad] = ?, [Pais] = ?, [CPostal] = ?, [Correo] = ?, [Nota] = ?, [Acepta_email] = ? WHERE [Id] = ?">
<DeleteParameters>
</DeleteParameters>
<UpdateParameters>
</UpdateParameters>
<DeleteParameters>
<asp:parameter Name="Id" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:parameter Name="Nombre" Type="String" />
<asp:parameter Name="Apellido" Type="String" />
<asp:parameter Name="Localidad" Type="String" />
<asp:parameter Name="Pais" Type="String" />
<asp:parameter Name="CPostal" Type="String" />
<asp:parameter Name="Correo" Type="String" />
<asp:parameter Name="Nota" Type="String" />
<asp:parameter Name="Acepta_email" Type="Boolean" />
<asp:parameter Name="Id" Type="Int32" />
</UpdateParameters>
<InsertParameters>
<asp:parameter Name="Nombre" Type="String" />
<asp:parameter Name="Apellido" Type="String" />
<asp:parameter Name="Localidad" Type="String" />
<asp:parameter Name="Pais" Type="String" />
<asp:parameter Name="CPostal" Type="String" />
<asp:parameter Name="Correo" Type="String" />
<asp:parameter Name="Nota" Type="String" />
<asp:parameter Name="Acepta_email" Type="Boolean" />
</InsertParameters>
</asp:AccessDataSource>
<asp:FormView runat="server" id="FormView1" DataSourceID="AccessDataSource1" Width="374px">
<EditItemTemplate>
Nro_cliente:
<asp:TextBox Text='<%# Bind("Nro_cliente") %>' runat="server" id="Nro_clienteTextBox" />
<br />
Localidad:
<asp:TextBox Text='<%# Bind("Localidad") %>' runat="server" id="LocalidadTextBox" />
<br />
CPostal:
<asp:TextBox Text='<%# Bind("CPostal") %>' runat="server" id="CPostalTextBox" />
<br />
Pais:
<asp:TextBox Text='<%# Bind("Pais") %>' runat="server" id="PaisTextBox" />
<br />
Correo:
<asp:TextBox Text='<%# Bind("Correo") %>' runat="server" id="CorreoTextBox" />
<br />
Nota:
<asp:TextBox Text='<%# Bind("Nota") %>' runat="server" id="NotaTextBox" />
<br />
Acepta_email:
<asp:CheckBox Checked='<%# Bind("Acepta_email") %>' runat="server" id="Acepta_emailCheckBox" />
<br />
<asp:LinkButton runat="server" Text="Actualizar" CommandName="Update" id="UpdateButton" CausesValidation="True" />
<asp:LinkButton runat="server" Text="Cancelar" CommandName="Cancel" id="UpdateCancelButton" CausesValidation="False" />
</EditItemTemplate>
<InsertItemTemplate>
<span class="style8"><span class="style8" id="span1"><br>
<fieldset name="Group1">
<legend class="style12">Información:</legend>
<span class="style8" id="span27">
<table style="width: 100%" class="style12">
<tr>
<td style="width: 107px" class="style11">Nombre:</td>
<td style="width: 217px">
<asp:TextBox Text='<%# Bind("Nombre") %>' runat="server" id="NombreTextBox" Font-Size="X-Small" />
</td>
<td style="width: 65px"><span class="style11">Apellido:</span></td>
<td style="width: 252px">
<asp:TextBox Text='<%# Bind("Apellido") %>' runat="server" id="ApellidoTextBox" Font-Size="X-Small" />
</td>
</tr>
<tr>
<td style="width: 107px; height: 17px;">
<span class="style11" id="span29">Localidad:</span></td>
<td style="height: 17px; width: 217px;">
<asp:TextBox Text='<%# Bind("Localidad") %>' runat="server" id="LocalidadTextBox0" Font-Size="X-Small" />
</td>
<td style="height: 17px; width: 65px;">
<span class="style11">País</span><span class="style8"><span class="style11" id="span30">:</span></span></td>
<td style="height: 17px; width: 252px;">
<asp:TextBox Text='<%# Bind("Pais") %>' runat="server" id="PaisTextBox0" Font-Size="X-Small" />
</td>
</tr>
<tr>
<td style="width: 107px"><span class="style11">C. Postal</span><span class="style8"><span class="style11" id="span31">:</span></span></td>
<td style="width: 217px">
<asp:TextBox Text='<%# Bind("CPostal") %>' runat="server" id="CPostalTextBox0" Font-Size="X-Small" />
</td>
<td style="width: 65px"><span class="style11">Correo</span><span class="style8"><span class="style11" id="span32">:</span></span></td>
<td style="width: 252px">
<asp:TextBox Text='<%# Bind("Correo") %>' runat="server" id="CorreoTextBox0" Font-Size="X-Small" />
</td>
</tr>
</table>
</span></fieldset><span class="style12"><br />
<br>
<fieldset name="Group1">
<legend class="style12">Referencias Foto:</legend>
<span class="style8"><span class="style8" id="span33">
<span class="style8" id="span34">
<table style="width: 100%" class="style12">
<tr>
<td style="width: 107px" class="style11">Tema:</td>
<td style="width: 217px">
<asp:TextBox Text='<%# Bind("Tema") %>' runat="server" id="NombreTextBox0" Font-Size="X-Small" />
</td>
<td style="width: 65px">Lugar<span class="style11">:</span></td>
<td style="width: 252px">
<asp:TextBox Text='<%# Bind("Lugar") %>' runat="server" id="ApellidoTextBox0" Font-Size="X-Small" />
</td>
</tr>
</table>
</span></span></span></fieldset></br></span></br></span></span>
<span class="style12"><br />
</span><fieldset name="Group1">
<legend class="style12">Nota:</legend>
<asp:TextBox Text='<%# Bind("Nota") %>' runat="server" id="NotaTextBox0" Width="527px" Height="168px" Font-Size="X-Small" ForeColor="#A4997D" />
</fieldset><span class="style12"><br />
</span> <span class="style12"><br />
</span><fieldset name="Group1">
<legend class="style12">Acepta al Email</legend>
<span class="style12">Acepta email: </span>
<asp:CheckBox Checked='<%# Bind("Acepta_email") %>' runat="server" id="Acepta_emailCheckBox0" Font-Size="X-Small" ForeColor="#A4997D" />
</fieldset><span class="style11"><span class="style13"><br />
<br />
</span></span>
<asp:LinkButton runat="server" Text="Enviar" CommandName="Insert" id="InsertButton" Font-Size="X-Small" ForeColor="#A4997D" PostBackUrl="index-6a.aspx" />
<asp:LinkButton runat="server" Text="Cancelar" CommandName="Cancel" id="InsertCancelButton" CausesValidation="False" Font-Size="X-Small" ForeColor="#A4997D" />
</InsertItemTemplate>
<ItemTemplate>
<span class="style6"><em>
<asp:LinkButton runat="server" Text="Ingrese sus Datos" CommandName="New" id="NewButton" CausesValidation="False" Font-Names="Verdana" Font-Size="X-Small" ForeColor="#A4997D" />
<br>
</br></em></span><span class="style12"><br />
</span><fieldset name="Group1">
<legend class="style12">Información:</legend>
<span class="style11"><span class="style13">Nombre y Apellido: <br />
Localidad: <br />
País: <br />
C. Postal: <br />
Correo: <br>
Tema: referente a la foto<br>
Lugar: referente a la foto</br></br></span></span></fieldset><span class="style12"><br />
</span><fieldset name="Group1">
<legend class="style12">Nota:</legend>
<span class="style12">Nota/Comentario sobre la foto en cuestión
</span></fieldset><span class="style12"><br />
</span><fieldset name="Group1">
<legend class="style12">Acepta al Email:</legend>
<span class="style12">Acepta_email: </span>
<asp:CheckBox Checked='<%# Bind("Acepta_email") %>' runat="server" id="Acepta_emailCheckBox1" Enabled="false" Font-Size="X-Small" ForeColor="#A4997D" />
</fieldset><span class="style12"><br />
</span><br />
</ItemTemplate>
</asp:FormView>
espero que sea esto lo que me piden :( |