Hi again :)
Thanx again for being so quick in answering back :)
I've read your post about radgrid and stored procedures and I've made a small example to play with but unfortunatly something goes wrong..
Here is my simple webform (sorry for the italian :P ) :
<radG:RadGrid ID="rg_nazioni" runat="server" DataSourceID="sql_nazioni" AllowSorting="true" EnableAJAX="true"
AllowAutomaticDeletes="true" AllowAutomaticInserts="true" AllowAutomaticUpdates="true" ShowStatusBar="true">
<ClientSettings>
<Scrolling AllowScroll="True" UseStaticHeaders="True" />
</ClientSettings>
<MasterTableView AutoGenerateColumns="False" DataKeyNames="id" DataSourceID="sql_nazioni" CommandItemDisplay="TopAndBottom">
<EditFormSettings>
<EditColumn CancelText="Cancella" EditText="Modifica" InsertText="Inserisci" UpdateText="Aggiorna">
</EditColumn>
</EditFormSettings>
<Columns>
<radG:GridEditCommandColumn UniqueName="EditCommandColumn" ButtonType="LinkButton" />
<radG:GridBoundColumn DataField="id" HeaderText="id" SortExpression="id" UniqueName="id" ReadOnly="true" />
<radG:GridBoundColumn DataField="c_cod" HeaderText="Codice nazione" SortExpression="c_cod" UniqueName="c_cod" />
<radG:GridBoundColumn DataField="c_cod_lingua" HeaderText="Traduzione" SortExpression="c_cod_lingua" UniqueName="c_cod_lingua"/>
<radG:GridBoundColumn DataField="c_nome" HeaderText="Nazione" SortExpression="c_nome" UniqueName="c_nome"/>
<radG:GridBoundColumn DataField="c_descrizione" HeaderText="Descrizione" SortExpression="c_descrizione" UniqueName="c_descrizione"/>
<radG:GridButtonColumn UniqueName="ButtonColumn" Text="Elimina" CommandName="Delete" ButtonType="linkButton"/>
</Columns>
<NoRecordsTemplate>
Nessuna nazione presente
</NoRecordsTemplate>
</MasterTableView>
</radG:RadGrid>
<asp:SqlDataSource ID="sql_nazioni" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
SelectCommandType="StoredProcedure"
SelectCommand="SP_RECUPERA_NAZIONI"
InsertCommandType="StoredProcedure"
InsertCommand="SP_INSERISCI_NAZIONE"
UpdateCommandType="StoredProcedure"
UpdateCommand="SP_MODIFICA_NAZIONE"
DeleteCommandType="StoredProcedure"
DeleteCommand="SP_ELIMINA_NAZIONE">
<InsertParameters>
<asp:Parameter Name="COD" Type="string" />
<asp:Parameter Name="COD_LINGUA" Type="string" />
<asp:Parameter Name="NOME" Type="string" />
<asp:Parameter Name="DESCRIZIONE" Type="string" />
</InsertParameters>
<UpdateParameters>
<asp:Parameter Name="COD" Type="string" />
<asp:Parameter Name="COD_LINGUA" Type="string" />
<asp:Parameter Name="NOME" Type="string" />
<asp:Parameter Name="DESCRIZIONE" Type="string" />
</UpdateParameters>
</asp:SqlDataSource>
What hapens is that, when I click on Insert in the insert form I get an error saying that I've specified too many arguments for the insert stored procedure. I really can't see the error in this code any how even the stored procedure is simple:
CREATE PROCEDURE [dbo].[SP_INSERISCI_NAZIONE]
@COD AS NVARCHAR(50),
@COD_LINGUA AS NCHAR(3),
@NOME AS NVARCHAR(50),
@DESCRIZIONE AS TEXT
AS
INSERT INTO tb_nazioni (c_cod, c_cod_lingua, c_nome, c_descrizione)
VALUES (@COD, @COD_LINGUA, @NOME, @DESCRIZIONE)
GO
Please help me out! :)