Inline cell editing in ASP.NET grid view

Question

0.00/5 (No votes)

See more:

Hi folks,

I have to display grid which looks like excel and should perform inline cell editing i have added few lines of code to achieve this.

Please look into below image

Click Here for image

ASP.NET

<asp:GridView ID="gvLabTATList" runat="server" AutoGenerateColumns="False" CssClass="grid-view"
                            DataKeyNames="serviceid"  OnRowDataBound="gvLabTATList_RowDataBound" OnRowCommand="gvLabTATList_RowCommand" BorderColor="#222222" BorderStyle="Solid" BorderWidth="1px"
                            Width="54%"  
                            OnRowUpdating="gvLabTATList_RowUpdating" ShowFooter="True">
                            <Columns>
                             <asp:ButtonField Text="SingleClick" CommandName="SingleClick" Visible="False"/>
                                <asp:TemplateField HeaderText="S No">
                                    <ItemTemplate>
                                        <%# Container.DataItemIndex + 1 %>
                                        <asp:HiddenField ID="hdnServiceID" runat="server" Value='<%# Eval("serviceid") %>' />
                                        <asp:HiddenField ID="hdnID" runat="server" Value='<%# Eval("TATId") %>' />
                                    </ItemTemplate>
                                </asp:TemplateField>
                                <asp:TemplateField HeaderText="Service">
                                    <ItemTemplate>
                                        <asp:Label ID="txtServiceName" runat="server" Text='<%# Eval("servicename") %>'></asp:Label>
                                    </ItemTemplate>
                                </asp:TemplateField>
                                <asp:TemplateField HeaderText="NTDay">
                                    <ItemTemplate>
                                        <asp:TextBox ID="txtNTDay" runat="server" Text='<%# Eval("NTDay") %>'></asp:TextBox>
                                    </ItemTemplate>
                                </asp:TemplateField>
                                <asp:TemplateField HeaderText="NTHour">
                                    <ItemTemplate>
                                        <asp:TextBox ID="txtNTHour" runat="server" Text='<%# Eval("NTHour") %>'></asp:TextBox>
                                    </ItemTemplate>
                                </asp:TemplateField>
                                <asp:TemplateField HeaderText="UTHour">
                                    <ItemTemplate>
                                        <asp:TextBox ID="txtUTHour" runat="server" Text='<%# Eval("UTHour") %>'></asp:TextBox>
                                    </ItemTemplate>
                                </asp:TemplateField>
                                <asp:TemplateField HeaderText="UTMinutes">
                                    <ItemTemplate>
                                        <asp:TextBox ID="txtUTMinutes" runat="server" Text='<%# Eval("UTMinutes") %>'></asp:TextBox>
                                    </ItemTemplate>
                                </asp:TemplateField>
                            </Columns>
                        </asp:GridView>

it has to trigger

C#

protected void gvLabTATList_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
.....}

Thanks in advance..

What I have tried:

<asp:GridView ID="gvLabTATList" runat="server" AutoGenerateColumns="False" CssClass="grid-view"
DataKeyNames="serviceid" OnRowDataBound="gvLabTATList_RowDataBound" OnRowCommand="gvLabTATList_RowCommand" BorderColor="#222222" BorderStyle="Solid" BorderWidth="1px"
Width="54%"
OnRowUpdating="gvLabTATList_RowUpdating" ShowFooter="True">
<columns> <asp:ButtonField Text="SingleClick" CommandName="SingleClick" Visible="False"/>
<asp:TemplateField HeaderText="S No">
<itemtemplate>
<%# Container.DataItemIndex + 1 %>
<asp:HiddenField ID="hdnServiceID" runat="server" Value='<%# Eval("serviceid") %>' />
<asp:HiddenField ID="hdnID" runat="server" Value='<%# Eval("TATId") %>' />

<asp:TemplateField HeaderText="Service">
<itemtemplate>
<asp:Label ID="txtServiceName" runat="server" Text='<%# Eval("servicename") %>'>

<asp:TemplateField HeaderText="NTDay">
<itemtemplate>
<asp:TextBox ID="txtNTDay" runat="server" Text='<%# Eval("NTDay") %>'>

<asp:TemplateField HeaderText="NTHour">
<itemtemplate>
<asp:TextBox ID="txtNTHour" runat="server" Text='<%# Eval("NTHour") %>'>

<asp:TemplateField HeaderText="UTHour">
<itemtemplate>
<asp:TextBox ID="txtUTHour" runat="server" Text='<%# Eval("UTHour") %>'>

<asp:TemplateField HeaderText="UTMinutes">
<itemtemplate>
<asp:TextBox ID="txtUTMinutes" runat="server" Text='<%# Eval("UTMinutes") %>'>

Posted 12-Jul-16 1:11am

syedkhaleel

Updated 12-Jul-16 3:51am

v3

Add a Solution

Comments

Suvendu Shekhar Giri 12-Jul-16 7:32am

.. and what is the problem?

[no name] 12-Jul-16 7:37am

and after entering the data it is not triggering any event

Suvendu Shekhar Giri 12-Jul-16 7:40am

What trigger it should fire?
Save?

[no name] 12-Jul-16 7:48am

protected void gvLabTATList_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
.....}

Suvendu Shekhar Giri 12-Jul-16 7:52am

Put a breakpoint in this event and share your findings after debugging.

[no name] 12-Jul-16 8:40am

the event did not trigger after i enter the value in the text box

Suvendu Shekhar Giri 12-Jul-16 8:50am

there is no such facilities in ASP.Net application which can trigger the event on typing in a textbox. But yes, you can make use of textbox text changed event by pointing it to gridview row updating event.

[no name] 12-Jul-16 8:56am

event should trigger when pressed enter..i am keeping all rows in edit mode..can u pls provide some sample

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Vincent Maverick Durano · Accepted Answer · 2016-07-12T03:51:00

By default, a GridView data representation control will only allow you to edit one row at a time. Also the RowUpdating event will never fire on textchanged of a TextBox. Keep in mind that doing an auto update on textbox changed is quite expensive to do postback on every change you make. Perhaps using AJAX is doable to cater such feature but I believed that would take a lot of work/time for it to make it work.

As an alternative, you could implement a bulk edit or create a custom control extending GridView. Here are some references that you may want to look at:

[Dynamically Adding and Deleting Rows in GridView and Saving All Rows at Once]

[GridView Bulk Editing]