<%@Page Language="C#" MasterPageFile="~/MasterPage.master" debug="true"%>

<script runat="server">

public void Page_Load(object sender, EventArgs e)
{
fview1.DataSourceID = "dvs1";
}

public void CheckDelete(object oSender, FormViewDeleteEventArgs oArgs)
{

int iKey = Convert.ToInt32(oArgs.Keys[0]);
if (iKey < 4)
{
oArgs.Cancel = true;
lblError.Text = "Cannot delete the original rows from the table";
}
}

</script>

<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
<asp:FormView id="fview1" DataSourceID="dvs1" runat="server"
DataKeyNames="id" AllowPaging="True"
PagerSettings-Mode="Numeric"
OnItemDeleting="CheckDelete">

<ItemTemplate>
<table border="0" cellpadding="5">
<tr>
<td>
<asp:Label ID="Image1"

runat="server"

Text='<%# Eval("u_nome") %>' />
</td>
<td>
<b><%# Eval("u_nome") %></b><p />
<%# Eval("u_cognome") %><p />

</td>
</tr>
</table>
<asp:LinkButton id="btnEdit" runat="server"
CommandName="Edit" Text="Edit Details" />
<br />
<asp:LinkButton id="btnDelete" runat="server"
CommandName="Delete" Text="Delete Shipper" />
<br />
<asp:LinkButton id="btnInsert" runat="server"
CommandName="New" Text="Add New Shipper" />
</ItemTemplate>

<EditItemTemplate>
<table border="0" cellpadding="5">
<tr>
<td align="right">ShipperID:</td>
<td><asp:label id="lblShipperID" runat="server"
Text='<%# Eval("id") %>' /></td>
</tr>
<tr>
<td align="right">Nome:</td>
<td>
<asp:TextBox id="txtnome" runat="server"
Text='<%# Eval("u_nome") %>' />
</td>
</tr>
<tr>
<td align="right">Cognome</td>
<td>
<asp:TextBox id="txtcognome" runat="server" TextMode="MultiLine"
Columns="40" Text='<%# Eval("u_cognome") %>' />
</td>
</tr>

<tr>
<td colspan="2">
<asp:LinkButton id="btnUpdate" CommandName="Update"
Text="Update" runat="server" />
<asp:LinkButton id="btnCancel" CommandName="Cancel"
Text="Cancel" runat="server" />
</td>
</tr>
</table>
</EditItemTemplate>

<InsertItemTemplate>
<table border="0" cellpadding="5">
<tr>
<td align="right">Nome</td>
<td>
<asp:TextBox id="txtnome" runat="server"
/>
</td>
</tr>
<tr>
<td align="right">Cognome</td>
<td>
<asp:TextBox id="txtcognome" runat="server"
/>
</td>
</tr>

<tr>
<td colspan="2">
<asp:LinkButton id="btnAdd" CommandName="Insert"
Text="Add" runat="server" />
<asp:LinkButton id="btnAbandon" CommandName="Cancel"
Text="Cancel" runat="server" />
</td>
</tr>
</table>
</InsertItemTemplate>
<EmptyDataTemplate>
<asp:LinkButton id="btnInsert" runat="server"
CommandName="New" Text="Add New Shipper" />
</EmptyDataTemplate>

</asp:FormView>

<p><asp:Label id="lblError" runat="server" /></p>

<asp:SqlDataSource id=dvs1 runat="server"
InsertCommand="INSERT INTO utenti(u_nome, u_cognome) VALUES (?,?)"
DeleteCommand="DELETE FROM utenti WHERE (id = ?)"
UpdateCommand="UPDATE utenti SET u_nome =?, u_cognome =? WHERE (id=?)"
SelectCommand="SELECT utenti.* FROM utenti"
ConnectionString="<%$ ConnectionStrings:ConnectionString %>" ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>">
<DeleteParameters>
<asp:Parameter Type="Int32" Name="id"></asp:Parameter>
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Type="String" Name="txtnome"></asp:Parameter>
<asp:Parameter Type="String" Name="txtcognome"></asp:Parameter>
<asp:Parameter Type="Int32" Name="id"></asp:Parameter>
</UpdateParameters>
<InsertParameters>
<asp:Parameter Type="Int32" Name="txtnome"></asp:Parameter>
<asp:Parameter Type="Int32" Name="txtcognome"></asp:Parameter>
</InsertParameters>
</asp:SqlDataSource>

</asp:content>