I've posted this yesterday on asp forum but no one replied so perhaps I'll have better luck here.
For some reason the OnUpdating method does not pull new values from the grid which is in edit mode. I've search and have come across several blogs and sites, some sugesting that an ObjectDataSource is required in order to use the "e.NewValue" construct others provide code to the contrary.
I don't get any errors - the variables in the code file would contain the old values rather then new ones.
I don't want to use the ODS way of manipulating the data. My delete method works but not the update one. Can you suggest what is wrong with the code? Here is what I've got:
aspx file:
<asp:GridView ID="gvBlack" runat="
server" AutoGenerateColumns="False" OnRowUpdating="gvBlack_OnUpdating" OnRowEditing="gvBlack_RowEditing">
<Columns>
<%--<asp:BoundField DataField="Ident_Black" ReadOnly="True" visible="false" />--%>
<asp:TemplateField ItemStyle-Width="1px">
<EditItemTemplate>
<asp:Label ID="lblIdent_Black" runat="
server" Text='<%# Bind("Ident_Black") %>' Visible="false" />
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Model" >
<ItemTemplate>
<asp:Label ID="lblModel_Black" runat="
server" Text='<%# Bind("Model_Black") %>' width="130px" />
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtModel_Black" runat="
server" Text='<%# Eval("Model_Black") %>' width="100px" />
<asp:RequiredFieldValidator ID="rfvModel_Black" runat="
server" ControlToValidate="txtModel_Black"
SetFocusOnError="true" ErrorMessage="*" ValidationGroup="CurrentMfg" ForeColor="Red" Font-Bold="true" />
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Description" >
<ItemTemplate>
<asp:Label ID="lblDesc_Black" runat="
server" Text='<%# Bind("Desc_Black") %>' width="200px" />
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtDesc_Black" runat="
server" Text='<%# Eval("Desc_Black") %>' width="170px" />
<span></span>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Qty" >
<ItemTemplate>
<asp:Label ID="lblQty_Black" runat="
server" Text='<%# Bind("Qty_Black") %>' width="35px" />
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtQty_Black" runat="
server" Text='<%# Eval("Qty_Black") %>' width="35px" />
<asp:RequiredFieldValidator ID="rfvQty_Black" runat="
server" ControlToValidate="txtQty_Black"
SetFocusOnError="true" ErrorMessage="*" ValidationGroup="CurrentMfg" ForeColor="Red" Font-Bold="true" />
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Reorder<br />Limit">
<ItemTemplate>
<asp:Label ID="lblBlack_Reorder_Limit" runat="
server" Text='<%# Bind("Black_Reorder_Limit") %>' width="35px" />
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtBlack_Reorder_Limit" runat="
server" Text='<%# Eval("Black_Reorder_Limit") %>' width="35px" />
<asp:RequiredFieldValidator ID="rfvBlack_Reorder_Limit" runat="
server" ControlToValidate="txtBlack_Reorder_Limit"
SetFocusOnError="true" ErrorMessage="*" ValidationGroup="CurrentMfg" ForeColor="Red"
Font-Bold="true" />
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Notes">
<ItemTemplate>
<asp:Label ID="lblNotes" runat="
server" Text='<%# Bind("Notes") %>' width="200px" />
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtNotes" runat="
server" Text='<%# Eval("Notes") %>' width="170px" />
<span></span>
</EditItemTemplate>
</asp:TemplateField>
<asp:CommandField ShowEditButton="True" ShowDeleteButton="false" ValidationGroup="CurrentToner" />
</Columns>
</asp:GridView>
aspx.cs file:
protected void Page_Load(object sender, EventArgs e)
{
LoadData_TonerBlack();
}
private void LoadData_TonerBlack()
{
dalConsumables_TonerBlack drTonerBlack = new dalConsumables_TonerBlack();
gvBlack.DataSource = drTonerBlack.GetListTonersBlack();
gvBlack.DataBind();
}
protected void gvBlack_OnUpdating(object sender, GridViewUpdateEventArgs e)
{
//GridView gvBlack = (GridView)sender;
//GridViewRow gvBlackRow = (GridViewRow)gvBlack.Rows[e.RowIndex];
int _Ident_Black = Convert.ToInt32(gvBlack.DataKeys[e.RowIndex].Values[0].ToString());
TextBox _txtModel_Black = (TextBox)gvBlack.Rows[e.RowIndex].FindControl("txtModel_Black");
TextBox _txtDesc_Black = (TextBox)gvBlack.Rows[e.RowIndex].FindControl("txtDesc_Black");
TextBox _txtQty_Black = (TextBox)gvBlack.Rows[e.RowIndex].FindControl("txtQty_Black");
TextBox _txtBlack_Reorder_Limit = (TextBox)gvBlack.Rows[e.RowIndex].FindControl("txtBlack_Reorder_Limit");
TextBox _txtNotes = (TextBox)gvBlack.Rows[e.RowIndex].FindControl("txtNotes");
string _updatedBy = Request.ServerVariables["AUTH_USER"].ToString();
dalConsumables_TonerBlack updateTonerBlack = new dalConsumables_TonerBlack();
updateTonerBlack.UpdateTonerBlack(_Ident_Black,
_txtModel_Black.Text,
_txtDesc_Black.Text,
Convert.ToInt32(_txtQty_Black.Text),
Convert.ToInt32(_txtBlack_Reorder_Limit.Text),
_txtNotes.Text,
_updatedBy);
gvBlack.EditIndex = -1;
LoadData_TonerBlack();
}
protected void gvBlack_RowEditing(object sender, GridViewEditEventArgs e)
{
gvBlack.EditIndex = e.NewEditIndex;
LoadData_TonerBlack();
}
Thanks in advance!
Risho
