selected record in gridview move to another table?

Hi,

You need to iterate the grid after selecting some rows in the main grid.

If the items are selected then it should be identified and added those results into the datatable.

DataTable dt = new DataTable();

DataColumn dColumn;

dColumn = new DataColumn("ID");

dt.Columns.Add(dColumn);

dColumn = new DataColumn("Name");

dt.Columns.Add(dColumn);

dColumn = new DataColumn("Address");

dt.Columns.Add(dColumn);

dColumn = new DataColumn("City");

dt.Columns.Add(dColumn);

DataRow dRow;

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

{

GridViewRow gRow = gvMainGrid.Rows[i];

CheckBox chkItem = (CheckBox)gRow.FindControl("chkItem");

if (chkItem.Checked)

{

Label lblID = (Label)gRow.FindControl("lblID");

Label lblName = (Label)gRow.FindControl("lblName");

Label lblAddress = (Label)gRow.FindControl("lblAddress");

Label lblCity = (Label)gRow.FindControl("lblCity");

dRow = dt.NewRow();

dRow["ID"] = lblID.Text.Trim();

dRow["Name"] = lblName.Text.Trim();

dRow["Address"] = lblAddress.Text.Trim();

dRow["City"] = lblCity.Text.Trim();

dt.Rows.Add(gRow);

}

}

After adding all the selected rows, you need to bind it into another gridview control.

gvSubGrid.DataSource = dt;
gvSubGrid.DataBind();

Hope this help you.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Veera Chenna14y ago
take a look at this article, it has complete tutorial on how to copy one or more checked rows from gridview to a destination table in SQL Server.

http://technico.qnownow.com/2012/04/10/copy-rows-from-asp-net-gridview-control-to-a-sql-server-table/
Senthilkumar14y ago
Hi,

You need to iterate the grid after selecting some rows in the main grid.

If the items are selected then it should be identified and added those results into the datatable.

DataTable dt = new DataTable();
DataColumn dColumn;

dColumn = new DataColumn("ID");
dt.Columns.Add(dColumn);

dColumn = new DataColumn("Name");
dt.Columns.Add(dColumn);

dColumn = new DataColumn("Address");
dt.Columns.Add(dColumn);

dColumn = new DataColumn("City");
dt.Columns.Add(dColumn);

DataRow dRow;

for (int i = 0; i < gvMainGrid.Rows.Count; i++)
{
GridViewRow gRow = gvMainGrid.Rows[i];
CheckBox chkItem = (CheckBox)gRow.FindControl("chkItem");
if (chkItem.Checked)
{
Label lblID = (Label)gRow.FindControl("lblID");
Label lblName = (Label)gRow.FindControl("lblName");
Label lblAddress = (Label)gRow.FindControl("lblAddress");
Label lblCity = (Label)gRow.FindControl("lblCity");

dRow = dt.NewRow();
dRow["ID"] = lblID.Text.Trim();
dRow["Name"] = lblName.Text.Trim();
dRow["Address"] = lblAddress.Text.Trim();
dRow["City"] = lblCity.Text.Trim();

dt.Rows.Add(gRow);
}
}

After adding all the selected rows, you need to bind it into another gridview control.

gvSubGrid.DataSource = dt;
gvSubGrid.DataBind();

Hope this help you.