C#.Net GridView Edit Problem

[kageyone]

I am trying to use the .net 2.0 gridview control where I programmatically set the datasource to an xml file read into a dataset. I am able to use the commandfield for the edit button and it puts me in edit mode. I have a template field with an EditItemTemplate textbox. I change the text in this textbox and click the update button. The RowUpdating event fires and my handler takes over. When I try to get the changed text in that textbox, I get the original data only. What am I doing wrong???

The grid:

<asp:GridView ID="dg1" runat="server" CssClass="GridBorder" HeaderStyle-CssClass="THGRID" 
                DataKeyNames="code" AutoGenerateColumns="false" CellPadding="3" 
                Font-Size="8pt" GridLines="Both" Showfooter="false" 
                PageSize="10"  PagerSettings-PageButtonCount="15" PagerSettings-Mode="NextPreviousFirstLast"
                BorderWidth="1px" BorderStyle="Solid" BorderColor="black"
                OnRowEditing="dg1_OnRowEditing"
                OnRowCancelingEdit="dg1_RowCancelingEdit"
                OnRowUpdating="dg1_RowUpdating">
              <Columns>
                    <asp:CommandField ShowEditButton="True" />
                    <asp:CommandField ShowDeleteButton="True" />
                    <asp:BoundField DataField="code" HeaderText="Code" readonly="true" />
                    <asp:TemplateField HeaderText="Name">
                        <ItemTemplate>
                            <asp:Label ID="lblName" runat="server"                       Text='<%# Eval("Name") %>'>                            </asp:Label>                            </ItemTemplate>
                        <EditItemTemplate>                        <asp:textbox ID="txtName" runat="server" Width="250px"
 * * * * *          Text='<%# Bind("Name")%>'>                    </asp:textbox>
            </EditItemTemplate>        
                    </asp:TemplateField>                             
              </Columns>
</asp:GridView>
 

RowUpdating event handler

   protected void dg1_RowUpdating(Object sender, GridViewUpdateEventArgs e)
 
    {
            int i = dg1.Rows[e.RowIndex].DataItemIndex;
            TextBox txtName = dg1.Rows[e.RowIndex].Cells[2].FindControl("txtName") as TextBox;
            string newname = txtName.Text;
 

// The value of the txtName textbox is always the original value...never the new value that I put in the field. What am I doing Wrong???


Ken

[Frinavale]

I am trying to use the .net 2.0 gridview control where I programmatically set the datasource to an xml file read into a dataset. I am able to use the commandfield for the edit button and it puts me in edit mode. I have a template field with an EditItemTemplate textbox. I change the text in this textbox and click the update button. The RowUpdating event fires and my handler takes over. When I try to get the changed text in that textbox, I get the original data only. What am I doing wrong???
...
RowUpdating event handler
protected void dg1_RowUpdating(Object sender, GridViewUpdateEventArgs e)
{
int i = dg1.Rows[e.RowIndex].DataItemIndex;
TextBox txtName = dg1.Rows[e.RowIndex].Cells[2].FindControl("txtName") as TextBox;
string newname = txtName.Text;

// The value of the txtName textbox is always the original value...never the new value that I put in the field. What am I doing Wrong???


Ken

Make sure that when you create the data source for your GridView that it is only done when it is not postback. Otherwise your GridView's data source will be reset to what it was originally before you can grab the new stuff.

-Frinny

[kageyone]

Make sure that when you create the data source for your GridView that it is only done when it is not postback. Otherwise your GridView's data source will be reset to what it was originally before you can grab the new stuff.

-Frinny

Of course. I am embarrassed. That took care of it...however, I had to cache the dataset so that my bind's would work. Thanks!

[Frinavale]

Of course. I am embarrassed. That took care of it...however, I had to cache the dataset so that my bind's would work. Thanks!

That's right :)
I forgot to mention that you should store and retrieve the Grid View's data source in session or something.

Good stuff!

-Frinny

[jappenzeller]

Are you binding the data before you hit the handler? That will reset the value before you get a chance to see the new text value.

I am trying to use the .net 2.0 gridview control where I programmatically set the datasource to an xml file read into a dataset. I am able to use the commandfield for the edit button and it puts me in edit mode. I have a template field with an EditItemTemplate textbox. I change the text in this textbox and click the update button. The RowUpdating event fires and my handler takes over. When I try to get the changed text in that textbox, I get the original data only. What am I doing wrong???

The grid:

<asp:GridView ID="dg1" runat="server" CssClass="GridBorder" HeaderStyle-CssClass="THGRID" 
                DataKeyNames="code" AutoGenerateColumns="false" CellPadding="3" 
                Font-Size="8pt" GridLines="Both" Showfooter="false" 
                PageSize="10"  PagerSettings-PageButtonCount="15" PagerSettings-Mode="NextPreviousFirstLast"
                BorderWidth="1px" BorderStyle="Solid" BorderColor="black"
                OnRowEditing="dg1_OnRowEditing"
                OnRowCancelingEdit="dg1_RowCancelingEdit"
                OnRowUpdating="dg1_RowUpdating">
              <Columns>
                    <asp:CommandField ShowEditButton="True" />
                    <asp:CommandField ShowDeleteButton="True" />
                    <asp:BoundField DataField="code" HeaderText="Code" readonly="true" />
                    <asp:TemplateField HeaderText="Name">
                        <ItemTemplate>
                            <asp:Label ID="lblName" runat="server"                       Text='<%# Eval("Name") %>'>                            </asp:Label>                            </ItemTemplate>
                        <EditItemTemplate>                        <asp:textbox ID="txtName" runat="server" Width="250px"
 * * * * *          Text='<%# Bind("Name")%>'>                    </asp:textbox>
            </EditItemTemplate>        
                    </asp:TemplateField>                             
              </Columns>
</asp:GridView>
 

RowUpdating event handler

   protected void dg1_RowUpdating(Object sender, GridViewUpdateEventArgs e)
 
    {
            int i = dg1.Rows[e.RowIndex].DataItemIndex;
            TextBox txtName = dg1.Rows[e.RowIndex].Cells[2].FindControl("txtName") as TextBox;
            string newname = txtName.Text;
 

// The value of the txtName textbox is always the original value...never the new value that I put in the field. What am I doing Wrong???


Ken

[Frinavale]

Are you binding the data before you hit the handler? That will reset the value before you get a chance to see the new text value.

They were resetting the data source of the GridView every postback...when you do this, you lose the data that the user entered and replace it with what was in the original data soruce.