Gridview mode not changing back to Readonly after Update

stefbek97

Hello All,

I am having Trouble with a Gridview control In my asp.net/C# application. It contains Some boundFields and one checkbox field. My gridview allows Editing. It succesfully enters edit mode and when i hit update the Datasource updates but the control will not return to readonly mode. I have gone far enough to figure out the problem is caused by the Checkbox field.The checkbox works and passes the correct true/false value to the datasource but will not bind after update When I Make it readonly and remove that value from my Stored Procedure the Gridview control works normal. Please help.

Frinavale

I don't understand what you're doing.

You have a GridView that has a checkbox field.
You Edit a record in the Grid view and update the database.

Now what what are you doing??

What is the problem?

stefbek97

Usually when you have a Gridview than can be edited you click the edit button and all the editable fields become Textboxes and the Checkbox is Enabled. I change the values and click update but the gridview stays in Edit mode instead of canging back to Readonly and displaying the new results. If i hit cancel the Grid changes modes and i see the new values. Usually the gridview returns to readonly after update's. I figured out this problem is caused by the Checkbox field . Once i remove this field from my gridview it works (changes modes back and forth) Is there an alternative to the Checkbox that will return true/false?

Frinavale

Once you're finished updating have you tried setting the GridView's EditIndex property to -1?

Like (vb):

Expand|Select|Wrap|Line Numbers

 
 Private Sub myGridView_RowUpdated(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewUpdatedEventArgs) Handles myGridView.RowUpdated

        myGridView.DataSource = _source

        myGridView.EditIndex = -1

        myGridView.DataBind()

End Sub

(C#)

Expand|Select|Wrap|Line Numbers

 
 Private void myGridView_RowUpdated(Object sender,  System.Web.UI.WebControls.GridViewUpdatedEventArgs e) 

{

        myGridView.DataSource = _source;

        myGridView.EditIndex = -1;

        myGridView.DataBind();

}

stefbek97

Yes I have tried that. Sorry I should have posted. That does not resolve the problem.
Thanks

Frinavale

Please post the ASP code for your GridView and post your C# code for the GridView's Update method.

stefbek97

Expand|Select|Wrap|Line Numbers

 <asp:GridView ID="gvModules" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSourceModulesManage"

 EmptyDataText="No Modules" SkinID="GridViewSmall" Visible="False" DataKeyNames="ModuleId" onrowupdated="gvModules_RowUpdated">

                    <Columns>

                        <asp:CommandField ShowDeleteButton="True" ShowSelectButton="True" ButtonType="Button" />

                        <asp:BoundField DataField="Number" HeaderText="Number" SortExpression="Number" />

                        <asp:BoundField DataField="MODName" HeaderText="MODName" ReadOnly="True" SortExpression="MODName" />

                        <asp:BoundField DataField="ModuleSubType" HeaderText="ModuleSubType" ReadOnly="True"

                            SortExpression="ModuleSubType" />

                        <asp:BoundField DataField="ModelName" HeaderText="ModelName" ReadOnly="True" SortExpression="ModelName" />

                        <asp:BoundField DataField="TargetParticipantUseDays" HeaderText="TargetParticipantUseDays"

                            SortExpression="TargetParticipantUseDays" />

                        <asp:CheckBoxField DataField="NeedsParticipantCompliance" HeaderText="NeedsParticipantCompliance"

                             SortExpression="NeedsParticipantCompliance" />

                        <asp:BoundField DataField="AcceptableWeekDays" HeaderText="AcceptableWeekDays" 

                            SortExpression="AcceptableWeekDays" />

                        <asp:BoundField DataField="AcceptableWeekendDays" HeaderText="AcceptableWeekendDays"

                            SortExpression="AcceptableWeekendDays" />

                        <asp:BoundField DataField="AcceptableHours" HeaderText="AcceptableHours"

                            SortExpression="AcceptableHours" />

                    </Columns>

 </asp:GridView>

I am using SqlDataSource and do not have C# code for update. The onrowupdated code is exactly like to code you posted earlier.

Frinavale

...then where are you setting the GridView's EditIndex = -1?

stefbek97

I set EditIndex to -1 in the Properties window in design mode.

Frinavale

Try implementing a method that handles the GridView's RowUpdated event.
In that method set the EditIndex to -1.

stefbek97

As i mentioned earlier i am using the OnRowUpdated Code like you posted earlier in the OnRowUpdated Event Handler and settint the EditIndex to -1 and Calling the Gridview.DataBind() Method.

Frinavale

Please post that code then :)

stefbek97

Expand|Select|Wrap|Line Numbers

 protected void gvModules_RowUpdated(object sender, GridViewUpdatedEventArgs e)

    {

        gvModules.DataSourceID = "SqlDataSourceModulesManage";

        gvModules.EditIndex = -1;

        gvModules.DataBind();
 
    }

Frinavale

Hi stefbek97,

Something in your question is not adding up.

I took your GridView, created an ObjectDataSource that matched the Fields that the GridView was displaying and bound the GridView to it so that I can see what you're "seeing".

What I discovered is that you only have a Select and a Delete Button.

There is no control in the GridView that you posted used for "Updating".

So how can you be having a problem with the GridView Mode change after an "Update" occurs.

Your question doesn't make any sense.

stefbek97

Hello Frinavale,

I understand your concern. I tried to delete and create the gridview over and over to see if there are any errors I made. I changed it from Template fields to boundFields. From CommandField to Buttons "Edit","Update","Delete" with matching Command Name's. My fault i submitted the code and did not verify it. If you and the ShowEditButton="true" please let me know if you can see what i am seeing.

Frinavale

Please post your current version of the ASP code for your GridView and I will try to understand your problem again based on your most current version.

Gridview mode not changing back to Readonly after Update

re: Gridview mode not changing back to Readonly after Update

re: Gridview mode not changing back to Readonly after Update

re: Gridview mode not changing back to Readonly after Update

re: Gridview mode not changing back to Readonly after Update

re: Gridview mode not changing back to Readonly after Update

re: Gridview mode not changing back to Readonly after Update

re: Gridview mode not changing back to Readonly after Update

re: Gridview mode not changing back to Readonly after Update

re: Gridview mode not changing back to Readonly after Update

re: Gridview mode not changing back to Readonly after Update

re: Gridview mode not changing back to Readonly after Update

re: Gridview mode not changing back to Readonly after Update

re: Gridview mode not changing back to Readonly after Update

re: Gridview mode not changing back to Readonly after Update

re: Gridview mode not changing back to Readonly after Update

Similar ASP.NET bytes

/bytes/development

/bytes/it

/bytes/about