Move Selected Gridview Rows to Another Gridview in Asp.net

By: Suresh Dasari May 8, 2013

Introduction:

Here I will explain how to move or transfer selected checkbox gridview rows to another gridview in asp.net using c#, vb.net or copy one gridview row to another gridview in asp.net using c#, vb.net.

Description:

In previous posts I explained Display images in gridview from database in asp.net, Enable/Disable checkbox in gridview based on condition, asp.net gridview examples and bind data to textbox control in gridview, Bind data to dropdownlist in gridview and many articles relating to asp.net, c#, vb.net, c#, vb.net. Now I will explain how to move selected rows from one gridview to another gridview in asp.net using c#, vb.net.

To implement this first we need to write the code in aspx page like this

<head>

<title>Tranfer selected gridview rows to another gridview in Asp.net</title>

</head>

<body>

<div>

<asp:GridView ID="gvDetails" AutoGenerateColumns="false" CellPadding="5" runat="server">

<asp:TemplateField>

<asp:CheckBox ID="chkSelect" runat="server" AutoPostBack="true" OnCheckedChanged="chkSelect_CheckChanged" />

</ItemTemplate>

</asp:TemplateField>

<asp:BoundField HeaderText="UserId" DataField="UserId" />

<asp:BoundField HeaderText="UserName" DataField="UserName" />

<asp:BoundField HeaderText="Education" DataField="Education" />

<asp:BoundField HeaderText="Location" DataField="Location" />

</Columns>

</asp:GridView>

<br />

<b>Second Gridview Data</b>

<asp:GridView ID="gvTranferRows" AutoGenerateColumns="false" CellPadding="5" runat="server" EmptyDataText="No Records Found">

<asp:BoundField HeaderText="UserId" DataField="UserId" />

<asp:BoundField HeaderText="UserName" DataField="UserName" />

<asp:BoundField HeaderText="Education" DataField="Education" />

<asp:BoundField HeaderText="Location" DataField="Location" />

</Columns>

</asp:GridView>

</div>

</form>

</body>

</html>

Now add following namespaces in codebehind

C# Code

using System;

using System.Data;

using System.Web.UI.WebControls;

After that add following code in code behind

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

BindGridview();

BindSecondGrid();

}

protected void BindGridview()

{

DataTable dt = new DataTable();

dt.Columns.Add("UserId", typeof(Int32));

dt.Columns.Add("UserName", typeof(string));

dt.Columns.Add("Education", typeof(string));

dt.Columns.Add("Location", typeof(string));

DataRow dtrow = dt.NewRow(); // Create New Row

dtrow["UserId"] = 1; //Bind Data to Columns

dtrow["UserName"] = "SureshDasari";

dtrow["Education"] = "B.Tech";

dtrow["Location"] = "Chennai";

dt.Rows.Add(dtrow);

dtrow = dt.NewRow(); // Create New Row

dtrow["UserId"] = 2; //Bind Data to Columns

dtrow["UserName"] = "MadhavSai";

dtrow["Education"] = "MBA";

dtrow["Location"] = "Nagpur";

dt.Rows.Add(dtrow);

dtrow = dt.NewRow(); // Create New Row

dtrow["UserId"] = 3; //Bind Data to Columns

dtrow["UserName"] = "MaheshDasari";

dtrow["Education"] = "B.Tech";

dtrow["Location"] = "Nuzividu";

dt.Rows.Add(dtrow);

gvDetails.DataSource = dt;

gvDetails.DataBind();

}

protected void chkSelect_CheckChanged(object sender, EventArgs e)

{

GetSelectedRows();

BindSecondGrid();

}

protected void BindSecondGrid()

{

DataTable dt = (DataTable)ViewState["GetRecords"];

gvTranferRows.DataSource = dt;

gvTranferRows.DataBind();

}

private void GetSelectedRows()

{

DataTable dt;

if (ViewState["GetRecords"] != null)

dt = (DataTable)ViewState["GetRecords"];

else

dt = CreateTable();

for (int i = 0; i < gvDetails.Rows.Count; i++)

{

CheckBox chk = (CheckBox)gvDetails.Rows[i].Cells[0].FindControl("chkSelect");

if (chk.Checked)

{

dt = AddGridRow(gvDetails.Rows[i], dt);

}

else

{

dt = RemoveRow(gvDetails.Rows[i], dt);

}

ViewState["GetRecords"] = dt;

}

private DataTable CreateTable()

{

DataTable dt = new DataTable();

dt.Columns.Add("UserId");

dt.Columns.Add("UserName");

dt.Columns.Add("Education");

dt.Columns.Add("Location");

dt.AcceptChanges();

return dt;

}

private DataTable AddGridRow(GridViewRow gvRow, DataTable dt)

{

DataRow[] dr = dt.Select("UserId = '" + gvRow.Cells[1].Text + "'");

if (dr.Length <= 0)

{

dt.Rows.Add();

int rowscount = dt.Rows.Count - 1;

dt.Rows[rowscount]["UserId"] = gvRow.Cells[1].Text;

dt.Rows[rowscount]["UserName"] = gvRow.Cells[2].Text;

dt.Rows[rowscount]["Education"] = gvRow.Cells[3].Text;

dt.Rows[rowscount]["Location"] = gvRow.Cells[4].Text;

dt.AcceptChanges();

}

return dt;

}

private DataTable RemoveRow(GridViewRow gvRow, DataTable dt)

{

DataRow[] dr = dt.Select("UserId = '" + gvRow.Cells[1].Text + "'");

if (dr.Length > 0)

{

dt.Rows.Remove(dr[0]);

dt.AcceptChanges();

}

return dt;

}

VB.NET Code

Imports System.Data

Imports System.Web.UI.WebControls

Partial Class VBCode

Inherits System.Web.UI.Page

Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load

If Not IsPostBack Then

BindGridview()

BindSecondGrid()

End If

End Sub

Protected Sub BindGridview()

Dim dt As New DataTable()

dt.Columns.Add("UserId", GetType(Int32))

dt.Columns.Add("UserName", GetType(String))

dt.Columns.Add("Education", GetType(String))

dt.Columns.Add("Location", GetType(String))

Dim dtrow As DataRow = dt.NewRow()

' Create New Row

dtrow("UserId") = 1

'Bind Data to Columns

dtrow("UserName") = "SureshDasari"

dtrow("Education") = "B.Tech"

dtrow("Location") = "Chennai"

dt.Rows.Add(dtrow)

dtrow = dt.NewRow()

' Create New Row

dtrow("UserId") = 2

'Bind Data to Columns

dtrow("UserName") = "MadhavSai"

dtrow("Education") = "MBA"

dtrow("Location") = "Nagpur"

dt.Rows.Add(dtrow)

dtrow = dt.NewRow()

' Create New Row

dtrow("UserId") = 3

'Bind Data to Columns

dtrow("UserName") = "MaheshDasari"

dtrow("Education") = "B.Tech"

dtrow("Location") = "Nuzividu"

dt.Rows.Add(dtrow)

gvDetails.DataSource = dt

gvDetails.DataBind()

End Sub

Protected Sub chkSelect_CheckChanged(ByVal sender As Object, ByVal e As EventArgs)

GetSelectedRows()

BindSecondGrid()

End Sub

Protected Sub BindSecondGrid()

Dim dt As DataTable = DirectCast(ViewState("GetRecords"), DataTable)

gvTranferRows.DataSource = dt

gvTranferRows.DataBind()

End Sub

Private Sub GetSelectedRows()

Dim dt As DataTable

If ViewState("GetRecords") IsNot Nothing Then

dt = DirectCast(ViewState("GetRecords"), DataTable)

Else

dt = CreateTable()

End If

For i As Integer = 0 To gvDetails.Rows.Count - 1

Dim chk As CheckBox = DirectCast(gvDetails.Rows(i).Cells(0).FindControl("chkSelect"), CheckBox)

If chk.Checked Then

dt = AddGridRow(gvDetails.Rows(i), dt)

Else

dt = RemoveRow(gvDetails.Rows(i), dt)

End If

End Sub

Private Function CreateTable() As DataTable

Dim dt As New DataTable()

dt.Columns.Add("UserId")

dt.Columns.Add("UserName")

dt.Columns.Add("Education")

dt.Columns.Add("Location")

dt.AcceptChanges()

Return dt

End Function

Private Function AddGridRow(ByVal gvRow As GridViewRow, ByVal dt As DataTable) As DataTable

Dim dr As DataRow() = dt.[Select]("UserId = '" & gvRow.Cells(1).Text & "'")

If dr.Length <= 0 Then

dt.Rows.Add()

Dim rowscount As Integer = dt.Rows.Count - 1

dt.Rows(rowscount)("UserId") = gvRow.Cells(1).Text

dt.Rows(rowscount)("UserName") = gvRow.Cells(2).Text

dt.Rows(rowscount)("Education") = gvRow.Cells(3).Text

dt.Rows(rowscount)("Location") = gvRow.Cells(4).Text

dt.AcceptChanges()

End If

Return dt

End Function

Private Function RemoveRow(ByVal gvRow As GridViewRow, ByVal dt As DataTable) As DataTable

Dim dr As DataRow() = dt.[Select]("UserId = '" & gvRow.Cells(1).Text & "'")

If dr.Length > 0 Then

dt.Rows.Remove(dr(0))

dt.AcceptChanges()

End If

Return dt

End Function

End Class

Demo

Download Sample Code Attached

If you enjoyed this post, please support the blog below. It's FREE!

Get the latest Asp.net, C#.net, VB.NET, jQuery, Plugins & Code Snippets for FREE by subscribing to our Facebook, Twitter, RSS feed, or by email.

Subscribe by RSS

Subscribe by Email

19 comments :

Ravikumar said...: Very nice ...; May 8, 2013 at 8:29 PM
Anonymous said...: Mr suresh.. What are you trying to show me.. What us gvChildGrid.

Please use names properly.. plzzzzzzzzzz; May 8, 2013 at 10:01 PM
@k@nksh@ Singh said...: very nice article; May 8, 2013 at 10:02 PM
Anonymous said...: I don't think so your code will show the output you are showing in the Demo.gif

protected void gvUserInfo_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
con.Open();
GridView gv = (GridView)e.Row.FindControl("gvChildGrid");
int CountryId = Convert.ToInt32(e.Row.Cells[1].Text);
SqlCommand cmd = new SqlCommand("select * from State where CountryID=" + CountryId, con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
con.Close();
gv.DataSource = ds;
gv.DataBind();
}
}; May 8, 2013 at 10:06 PM
@k@nksh@ Singh said...: very nice article; May 8, 2013 at 10:07 PM
Anonymous said...: The code you have provided in C# is totally wrong. Don't confuse learners plzz; May 8, 2013 at 10:30 PM
Irtekaz Ahmed Khan said...: i have of your certify.
good logic in data collection; May 8, 2013 at 10:36 PM
Unknown said...: hi,
how to add a Header Panel in GridView Asp.Net
Ex:http://examples1.ext.net/#/GridPanel/ArrayGrid/Simple/
Please can any one Help in Developing this type of Grid View; May 8, 2013 at 10:58 PM
Suresh Dasari said...: @Comment 2, 4 and 6..
Sorry guys mistakenly i written code. Now I updated the code. Please check it once.; May 9, 2013 at 4:31 AM
Anonymous said...: test; May 12, 2013 at 12:37 PM
Unknown said...: very nic article; July 18, 2013 at 3:20 AM
Anonymous said...: i tried this it's not working for me; April 10, 2014 at 6:20 AM
manju said...: Hello,
I created a page with som textboxes and gridview with checkboxes. what ever the data i am selected in the gridview that data along with the textbox fields should be converted to pdf. Can you help me regarding this.; May 9, 2014 at 12:12 AM
Anonymous said...: Nice Artice...; May 21, 2014 at 6:17 AM
Vignesh P said...: display only serialno in gridview just any one serialno click after serialno datas display in second gridview from sqlserver database; August 5, 2014 at 2:24 AM
Vignesh P said...: display only serialno in gridview just any one serialno click after serialno datas display in second gridview from sqlserver database using asp.net vblanguage; August 5, 2014 at 2:25 AM
Unknown said...: How will I insert the selected data from the second gridview to database?; October 8, 2014 at 8:45 AM
Unknown said...: hi sir I have used your codings for my projects it is very usefull to me.........
please upload the codings for copy selected rows from datalist to gridview using the checkbox control in c# asp.net; November 13, 2014 at 5:55 AM
Anonymous said...: is not working on same client id record; January 29, 2016 at 12:09 AM