Send GridView Row Values to Another Page and Update Record Values

This article explains how to send GridView row values to another page and update the record values and return to the original GridView page using ASP.NET.

1. Go to Start, then All Programs and open Microsoft Visual Studio 2013.
2. Now, click "File" -> "New" -> "Project..." then click on Visual C#. Then select ASP.NET Web Application, Empty and click on OK.

3. Provide the web application name and location as you wish. I named my web application UpdateGridviewRowValuesInSecondPage.

4. Now the project will be opened. Right-click on the web application name, add a New Item and select Web Form. Then click on Add.

5. Add the following code between the <form> tags of the WebForm1.aspx page as in the following:

<div>
            <asp:GridView ID="GridView1" HeaderStyle-BackColor="#3AC0F2" HeaderStyle-ForeColor="White" runat="server" AutoGenerateColumns="false" OnRowCommand="GridView1_RowCommand">
                <Columns>
                    <asp:BoundField DataField="EmpNo" HeaderText="EmpId" />
                    <asp:BoundField DataField="EmpName" HeaderText="EmpName" />
                    <asp:BoundField DataField="Job" HeaderText="Job" />
                    <asp:BoundField DataField="Sal" HeaderText="EmpSalary" />
                    <asp:BoundField DataField="Dept" HeaderText="Department" />
                    <asp:TemplateField>
                        <ItemTemplate>
                            <asp:Button ID="btnEdit" runat="server" Width="60" Text="Edit" CommandName="EditButton" CommandArgument="<%# ((GridViewRow) Container).RowIndex %>" />
                        </ItemTemplate>
                    </asp:TemplateField>
                </Columns>
            </asp:GridView>
        </div>

6. Add the following code to the page load event of the WebForm1.aspx.cs page.

protected void Page_Load(object sender, EventArgs e)
{
    if (!this.IsPostBack)
    {
        BindGridView();
    }
}

private void BindGridView()
{
    string constr = ConfigurationManager.ConnectionStrings["con"].ConnectionString;
    SqlConnection con = new SqlConnection(constr);
    SqlCommand cmd = new SqlCommand("select * from Emp",con);
    DataTable dt = new DataTable();
    SqlDataAdapter da = new SqlDataAdapter(cmd);
    da.Fill(dt);
    GridView1.DataSource = dt;
    GridView1.DataBind();
}

7. The following is the GridView1_RowCommand event method of the WebForm1.aspx.cs page.

protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
    if (e.CommandName == "EditButton")
    {
        int index = Convert.ToInt32(e.CommandArgument);
        GridViewRow row = GridView1.Rows[index];
        Response.Redirect("~/UpdateGridView.aspx?EmpNo=" + row.Cells[0].Text);
    }
}

8. Add another webform to the project and name it as you wish. I named it UpdateGridView.aspx.

9. Add the following code between the <form> tags of the UpdateGridView.aspx page.

<div>
   <table>
       <tr>
           <td>EmpId</td>
           <td>
               <asp:TextBox ID="txtEmpId" runat="server" ReadOnly="true" />
           </td>
       </tr>
       <tr>
           <td>EmpName</td>
           <td>
               <asp:TextBox ID="txtEmpName" runat="server" />
           </td>
       </tr>
       <tr>
           <td>Job</td>
           <td>
               <asp:TextBox ID="txtJob" runat="server" />
           </td>
       </tr>
       <tr>
           <td>EmpSalary</td>
           <td>
               <asp:TextBox ID="txtEmpSalary" runat="server" />
           </td>
       </tr>
       <tr>
           <td>Department</td>
           <td>
               <asp:TextBox ID="txtDept" runat="server" />
           </td>
       </tr>
       <tr>
           <td align="center">
                <asp:Button ID="btnUpdate" runat="server" Text="Update" OnClick="btnUpdate_Click" />
           </td>
           <td align="center">
               <asp:Button ID="btnCancel" runat="server" Text="Cancel" OnClick="btnCancel_Click" />
           </td>
       </tr>
   </table>
lt;/div>

10. The following is the page load event of the UpdateGridView.aspx.cs page.

int empno = 0;
protected void Page_Load(object sender, EventArgs e)
{
    empno = Convert.ToInt32(Request.QueryString["EmpNo"].ToString());
    if (!IsPostBack)
    {
        BindTextBoxvalues();
    }
}

private void BindTextBoxvalues()
{
    string constr = ConfigurationManager.ConnectionStrings["con"].ConnectionString;
    SqlConnection con = new SqlConnection(constr);
    SqlCommand cmd = new SqlCommand("select * from Emp where EmpNo=" + empno, con);
    DataTable dt = new DataTable();
    SqlDataAdapter da = new SqlDataAdapter(cmd);
    da.Fill(dt);
    txtEmpId.Text = dt.Rows[0][0].ToString();
    txtEmpName.Text = dt.Rows[0][1].ToString();
    txtJob.Text = dt.Rows[0][2].ToString();
    txtEmpSalary.Text = dt.Rows[0][3].ToString();
    txtDept.Text = dt.Rows[0][4].ToString();
}

11. The following is the btnUpdate_Click event method of the UpdateGridView.aspx page.

protected void btnUpdate_Click(object sender, EventArgs e)
{
    string constr = ConfigurationManager.ConnectionStrings["con"].ConnectionString;
    SqlConnection con = new SqlConnection(constr);
    SqlCommand cmd = new SqlCommand("update Emp set EmpName='" + txtEmpName.Text + "',Job='" + txtJob.Text + "',Sal=" + txtEmpSalary.Text + ",Dept='" + txtDept.Text + "' where EmpNo=" + empno, con);
    con.Open();
    int result = cmd.ExecuteNonQuery();
    con.Close();
    if (result == 1)
    {
        ScriptManager.RegisterStartupScript(this, this.GetType(), "ShowSuccess", "javascript:alert('Record Updated Successfully');", true);
    }
    Response.Redirect("~/WebForm1.aspx");
}

12. The following is the btnCancel_Click event method of the UpdateGridView.aspx page.

protected void btnCancel_Click(object sender, EventArgs e)
{
    Response.Redirect("~/WebForm1.aspx");
}

13. Now run the application and you can see it in your browser.

 

  

14. The following shows updating the employee salary of the EmpId 4 record from 39000 to 49000.

 

  

15. After the update, check the GridView page for whether the update is done or not.