<asp:GridView ID="Grid1" DataSourceID ="SqlDataSource1" runat="server" PageSize= "6"
DataKeyNames="id_pratica,telefono,fax,email,cellul are,NOTE,INDIRIZZO,residenza" OnRowCommand="Grid1_rowcommand" >
<Columns >
<asp:CommandField HeaderText="Opzioni" ShowDeleteButton="true" />
<asp:BoundField DataField="Ruolo" HeaderText="Ruolo" />
<asp:BoundField DataField="cognome" HeaderText="Cognome" />
<asp:BoundField DataField="Nome" HeaderText="Nome" />
<asp:BoundField DataField="dt_nascita" HeaderText="Nato il" />
<asp:BoundField DataField="Luogonascita" HeaderText="A " />
<asp:BoundField DataField="sesso" HeaderText="Sex" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ProviderName='<%$ ConnectionStrings:Cn_databaseprimario.ProviderName %>'
ConnectionString = '<%$ ConnectionStrings:Cn_databaseprimario %>'
SelectCommandType="StoredProcedure" CancelSelectOnNullParameter="False"
SelectCommand="S_anagrafica" DeleteCommand="ITA_IUD_ANAGRAFICHE_RUOLI" DeleteCommandType="StoredProcedure" >
<SelectParameters>
<asp:Parameter Name="id_pratica" />
<asp:Parameter Name="ope" DefaultValue="arp" />
<asp:Parameter Name="ID_RUOLO" ConvertEmptyStringToNull="true" />
</SelectParameters>
<DeleteParameters>
<asp:Parameter Name="ID_ANAGRAFICA_PRATICA_RUOLO" />
<asp:Parameter Name="ope" DefaultValue="del" />
</DeleteParameters>
</asp:SqlDataSource>