selected record in gridview move to another table?

Question

Hi exterts,

my req is in my gridview i have some records and each record having checkbox. if i want to select 1 checkbox and click on button that record move into another table.......

give me reply..

bye

Veera Chenna · Answer

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/

Senthilkumar · Answer

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 { 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.

selected record in gridview move to another table?

Answers (2)