Fixed the problem

[CW]

I didn't have
If !Page.IsPostBac k
//bind data source

in the code

"CW" <a> wrote in message news:um******** ******@TK2MSFTN GP12.phx.gbl...

I am taking the Commerce Starter Kit sample from asp.net and trying to add a page that allows user to edit product categories.

I am doing so via the use of a datagrid. html portion related to the data
grid is as per follows:

<asp:datagrid id=dgProductCat egories runat="server"
AutoGenerateCol umns="False" DataSource="<%# DataSet11 %>" Width="275px"
BorderColor="#9 99999" BorderStyle="No ne" BackColor="Whit e" CellPadding="3"
GridLines="Vert ical" BorderWidth="1p x" DataKeyField="C ategoryID"
DataMember="CMR C_Categories">
<SelectedItemSt yle Font-Bold="True" ForeColor="Whit e"
BackColor="#008 A8C"></SelectedItemSty le>
<AlternatingIte mStyle
BackColor="Gain sboro"></AlternatingItem Style>
<ItemStyle ForeColor="Blac k" BackColor="#EEE EEE"></ItemStyle> <HeaderStyle Font-Bold="True" ForeColor="Whit e"
BackColor="#000 084"></HeaderStyle>
<FooterStyle ForeColor="Blac k"
BackColor="#CCC CCC"></FooterStyle>
<Columns>
<asp:BoundColum n DataField="Cate goryID"
SortExpression= "CategoryID " ReadOnly="True"
HeaderText="ID" ></asp:BoundColumn >
<asp:BoundColum n DataField="Cate goryName"
SortExpression= "CategoryNa me" HeaderText="Cat egory Name"></asp:BoundColumn > <asp:EditComman dColumn ButtonType="Lin kButton"
UpdateText="Upd ate" HeaderText="Edi t" CancelText="Can cel"
EditText="Edit" ></asp:EditCommand Column>
<asp:ButtonColu mn Text="Delete" HeaderText="Del ete"
CommandName="De lete"></asp:ButtonColum n>
</Columns>
<PagerStyle HorizontalAlign ="Center" ForeColor="Blac k"
BackColor="#999 999" Mode="NumericPa ges"></PagerStyle>
</asp:datagrid>

The code behind that handles the Update command is as per follows:

Private Sub dgProductCatego ries_UpdateComm and(ByVal source As Object, ByVal e As System.Web.UI.W ebControls.Data GridCommandEven tArgs) Handles
dgProductCatego ries.UpdateComm and
Dim dr As DataSet1.CMRC_C ategoriesRow
dr =
Me.DataSet11.CM RC_Categories.F indByCategoryID (CInt(Me.dgProd uctCategories.I t ems(e.Item.Item Index).Cells(0) .Text))
Dim tbProductCatego ry As System.Web.UI.W ebControls.Text Box =
CType(e.Item.Ce lls(1).Controls (0), System.Web.UI.W ebControls.Text Box)
dr.Item(1) = tbProductCatego ry.Text
Me.SqlDataAdapt er1.Update(Me.D ataSet11)
Me.dgProductCat egories.EditIte mIndex = -1
Me.dgProductCat egories.DataBin d()
End Sub

e.Item.Cells(1) .Controls(0) supposed to the be the textbox when datagrid is in edit mode. However, in debug mode, I could tell that the value in the
text box is the original value, rather than the edited value. Of course this means that the edit operation would have no effect.

I also tried using
Me.dgProductCat egories.Items(e .Item.ItemIndex ).Cells(1).Cont rols(0) instead of e.Item.Cells(1) .Controls(0) in the code. However, it made no difference.
Any idea what's happening there?

Thanks in advance

CW