How to edit n update a row in GRID VIEW

Question

3.40/5 (2 votes)

See more:

Hi
In my application i have displayed data in the form of grid view. How can i edit a row and update it in the grid view??

Posted 16-May-12 1:09am

jagadeeshmn

Updated 16-May-12 2:26am

v2

Add a Solution

Comments

Mohamed Mitwalli 16-May-12 7:37am

This is for Comment if you want to add solution Go for Add a Solution button

MAKReddy 16-May-12 8:05am

ok thanks

Sandeep Mewara 16-May-12 8:15am

All the answers below are of ASP.NET. You have not tagged it as Web, you looking for Winforms?

7 solutions

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)

Mits Machhi · Answer 1 · 2012-05-16T01:29:00

Youu can use Rowedititng property..

XML

<Columns>
       <asp:TemplateField HeaderText="Filed">

            <ItemTemplate>
              <asp:Label runat="server" ID="category" Text='<%#Eval("field1") %>' />
            </ItemTemplate>

            <EditItemTemplate>
            <asp:TextBox runat="server" ID="txt1" Text='<%#Eval("filed1") %>' ValidationGroup="v1" />
            <asp:RequiredFieldValidator runat="server" ID="req1" ControlToValidate="txt1" ErrorMessage="*" ValidationGroup="v1" />
            </EditItemTemplate>


         </asp:TemplateField>

          <asp:TemplateField HeaderText="Action">

      <ItemTemplate>
      <asp:LinkButton ID="btnEdit" Text="Edit" runat="server" CommandName="Edit" />&nbsp;&nbsp;
      <asp:LinkButton ID="btnDelete"  Text="Delete" runat="server" CommandName="Delete" />
      </ItemTemplate>

      <EditItemTemplate>
      <asp:LinkButton ID="btnUpdate" Text="Update" runat="server" CommandName="Update" ValidationGroup="v1" />
      <asp:LinkButton ID="btnCancel" Text="Cancel" runat="server" CommandName="Cancel" />
      </EditItemTemplate>

              <ControlStyle ForeColor="#6600FF" />

              <ItemStyle Font-Size="Medium" />

      </asp:TemplateField>


       </Columns>

than in row_editing property.....

C#

GridView1.EditIndex = e.NewEditIndex;
       BindGridData();

in BindGridData youu can bind your grid with selected field.

now,row_Updating Property

protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        GridViewRow row = (GridViewRow)GridView1.Rows[e.RowIndex];
        
        TextBox txt1 = (TextBox)row.FindControl("txt1");
        GridView1.EditIndex = -1;
        string s="update query";
        Sqlcommand cmd=new Sqlcommand(s,connection object);
 cmd.executenonquery();

BindGridData();
}

Hope You Got it and Solve Your Problem.
Thanks..

Prasad_Kulkarni · Answer 2 · 2012-05-16T02:02:00

Solution 5

Please refer following threads:
Editable GridView in ASP.NET 2.0[^]
Full-featured Editable GridView Control[^]
Edit Individual GridView Cells in ASP.NET[^]
Userful GridView ASP.NET[^]

GridView Examples for ASP.NET[^]

Posted 16-May-12 2:02am

Prasad_Kulkarni

Member 8821727_GhostAnswer · Answer 3 · 2012-05-16T01:16:00

Solution 1

hi

I hope this link will be help full for you.

[edit and update grid example]

Posted 16-May-12 1:16am

Member 8821727_GhostAnswer

sravani.v · Answer 4 · 2012-05-16T01:32:00

Solution 3

Refer these:

http://devilswork.wordpress.com/2009/03/27/gridview-row-edit-delete-and-update/[^]

http://forums.asp.net/t/1255252.aspx/1[^]

Posted 16-May-12 1:32am

sravani.v

hunain.esh · Answer 5 · 2012-05-16T01:43:00

Solution 4

In gridview there is a property for update or delete you just have to set it true and add a link for update by adding a seperate column.I Hope it will help you out

Posted 16-May-12 1:43am

hunain.esh

Ganesh Thadishetti(HANAMKONDA) · Answer 6 · 2012-08-14T18:13:00

---source code---

XML

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
        AutoGenerateEditButton="True"
        onrowediting="GridView1_RowEditing" onrowupdating="GridView1_RowUpdating">
        <Columns>
            <asp:BoundField DataField="TEAMID" HeaderText="ID" SortExpression="TEAMID" />
            <asp:BoundField DataField="TEAMFIRSTNAME" HeaderText="NAME"
                SortExpression="TEAMFIRSTNAME" />
        </Columns>
    </asp:GridView>

------cs coding-------

C#

SqlConnection conn;
   protected void Page_Load(object sender, EventArgs e)
   {
       if (!(IsPostBack))
       {
           gridbind();
       }

   }
   public void gridbind()
   {
       conn = new SqlConnection("Data Source=KOMURAIAH\\SRIRAMA;Initial Catalog=IPL;user id=Ganesh_kuamrpally_hnk;password=Swathi_sbit_2009_civil_warangal");
       conn.Open();
       SqlDataAdapter da = new SqlDataAdapter("select * from team", conn);
       DataSet dset = new DataSet();
       da.Fill(dset, "team");
       GridView1.DataSource = dset.Tables[0];
       GridView1.DataBind();
   }

   protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
   {
       GridView1.EditIndex = e.NewEditIndex;
       gridbind();
   }

protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
   {

       string teamname =string.empty;

        TextBox txtemp =(TextBox)GridView1.Rows[e.RowIndex].Cells[1].Controls[0];
           int teamid= Convert.ToInt32(txtemp.Text);

         TextBox txtemp =(TextBox)GridView1.Rows[e.RowIndex].Cells[1].Controls[0];
           int teamid= Convert.ToInt32(txtemp.Text);
      //---or---
      //foreach (Control ctrl in GridView1.Rows[e.RowIndex].Cells[2].Controls)
      //{
      //TextBox txt = ctrl as TextBox;
      //teamname = txt.Text;
      //}

       conn = new SqlConnection("Data Source=KOMURAIAH\\SRIRAMA;Initial Catalog=IPL;user id=Ganesh_kuamrpally_hnk;password=Swathi_sbit_2009_civil_warangal");
       conn.Open();
       SqlCommand cmd = new SqlCommand("update team set teamid=" + teamid+ ",teamfirstname=' " + teamname + "' where teamid=" + teamid+ "", conn);
       cmd.ExecuteNonQuery();
       gridbind();
   }

Bhuvanesh Mohankumar · Answer 7 · 2013-11-04T18:10:00

Solution 9

This will also help.

Gridview-row-in-edit-mode[^]

Posted 4-Nov-13 18:10pm

Bhuvanesh Mohankumar