Erro de Update

[Lab Design 0]

O numreg chega mas o quant só chega valor 1 lá no class.

 

<asp:GridView ID="GrdPedidoItens"

DataSourceID="srcEditPedido"

DataKeyNames="numreg"

AutoGenerateColumns="False"

GridLines="None"

CssClass="grid"

width="100%"

Style="background-color: #6699cc; font-weight: bolder; color: white"

runat="server" ShowFooter="true"

OnRowDataBound="grdPedidoItens_RowDataBound"

OnRowUpdating="grdPedidoItens_OnRowEditing">

<Columns>

<asp:CommandField ShowEditButton="true" EditText="<img src='Images/edit.png' border='0' alt='Alterar Registro'/>"

CancelText="<img src='Images/Undo.png' border='0' alt='Gravar Alteração'/>"

UpdateText="<img src='Images/Update.png' border='0' alt='Cancelar Alteração'/>"/>

<asp:BoundField DataField="numcat" HeaderText="Código" ReadOnly="true"/>

<asp:BoundField DataField="descricao" HeaderText="Descrição" ItemStyle-HorizontalAlign="Left" ReadOnly="true"/>

<asp:BoundField DataField="modelo" HeaderText="Mod." ReadOnly="true"/>

<asp:BoundField DataField="quant" HeaderText="Quant" ItemStyle-HorizontalAlign="Center" ControlStyle-CssClass="edValores" />

<asp:BoundField DataField="preco" HeaderText="Preço" ItemStyle-HorizontalAlign="Right" ReadOnly="true"/>

<asp:BoundField DataField="total" HeaderText="Total R$" ItemStyle-HorizontalAlign="Right" ReadOnly="true"/>

<asp:TemplateField>

<ItemTemplate>

<asp:LinkButton ID="btnDel" Text="<img src='Images/delete.png' border='0'>" CommandName="Delete" runat="server"

OnClientClick="return confirm('Você tem certeza ?');" Visible="true"/>

</ItemTemplate>

</asp:TemplateField>

</Columns>

<EmptyDataTemplate>

Nenhum Pedido aberto no momento.

</EmptyDataTemplate>

</asp:GridView>

 

<asp:ObjectDataSource ID="srcEditPedido" TypeName="Ridgid.Pedidos" SelectMethod="SelectItens"

UpdateMethod="Update" runat="server" DeleteMethod="Delete" OnDeleted="grdPedidoItens_Deleted">

 

<SelectParameters>

<asp:SessionParameter Name="idPedido" SessionField="pedId" Type="Int32" />

</SelectParameters>

</asp:ObjectDataSource>

Class

[system.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjec

tMethodType.Update, false)]

public static void Update(int numreg, int quant)

{

int _quant;

try

{

_quant = Convert.ToInt32(quant);

}

catch (Exception)

{

return;

}

 

// Initialize command

SqlConnection con = new SqlConnection(_connectionString);

SqlCommand cmd = new SqlCommand("PedidoItens_Update", con);

cmd.CommandType = CommandType.StoredProcedure;

 

cmd.Parameters.AddWithValue("@numreg", numreg);

cmd.Parameters.AddWithValue("@quant", _quant);

cmd.Parameters.Add("@ret", SqlDbType.Int).Value = 0;

cmd.Parameters["@ret"].Direction = ParameterDirection.Output;

using (con)

{

con.Open();

cmd.ExecuteNonQuery();

int ret = Convert.ToInt32(cmd.Parameters["@ret"].Value.ToString());

}

// return (ret);

}

[quintelab 91]

Movido Plataforma .NET http://forum.imasters.com.br/public/style_emoticons/default/seta.gif Plataforma .NET » Web Applications