Transfer Data From One Datagridview To Another

Question

I have a two datagridview as

datagridview1
datagridview2

datagridview1 has a checkbox columns which check the rowindex and transfer the same row to another datagridview2

datagridview1 is a databound control and having columns as below:

checkbox Column,Name and Amount

where as datagridview2 also having same column accept checkbox column.

I wants to transfer data of datagridview1.selected rows to another datagridview2 by click on checkbox column.

How to do?.

Sudhakar Chaudhary · Answer

on transfer key click. it works on select row in datagridview1. in both case like one row selected or all row selected. try { dataGridView2.Rows.Clear(); for (int i = 0; i { if (Convert.ToBoolean(dataGridView1.Rows[i].Cells[0].Value) == true) { dataGridView2.Rows.Add(); dataGridView2.Rows[i].Cells[0].Value = true; dataGridView2.Rows[i].Cells[1].Value = dataGridView1.Rows[i].Cells[1].Value; } } } catch (Exception ) { }

rashmi kc · Answer

Sir here I hav attached my project Once i select the main from combo and press the random generatingbutton  after that clicking on select button and press the Transfer button the data from the grid view should transfer to another gridview How to transfer??

Sudhakar Chaudhary · Answer

try this...

rashmi kc · Answer

Sir can u show this by showing data from the database Sql or access

mahesh waghela · Answer

hi Ashish Fine it's works but there is little problem that if you bind the datagridview1 by sql server table that it's won't work it will throw compile Error :- programatically rows cannot insert on databound control So normally if you bind the table by datatable it will works but not by sql binding.

Ashish Doshi · Answer

Use the following code snippet... Have a Windows Form and place two DataGridViews onto the same and name the same as DataGridView1 and DataGridView2 The same works......[I have tested the same on Win 2003 Server with Visual Studio 2005] ***************************************************************** using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; namespace TransferRowBetweenDGView { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void Form1_Load(object sender EventArgs e) { LoadData(); } private void LoadData() { //Start -- Load data in to a temporary data table - // The same to be used as Data Source for SOURCE DATAGRIDVIEW System.Data.DataTable dtSource = new DataTable(); dtSource.Columns.Add(new DataColumn(Sel typeof(bool))); dtSource.Columns.Add(new DataColumn(Name typeof(String))); dtSource.Columns.Add(new DataColumn(Amount typeof(double))); DataRow drData; for (int iCtr = 1; iCtr { drData = dtSource.NewRow(); drData[Name] = Name  + iCtr.ToString(); drData[Amount] = (100 * iCtr); dtSource.Rows.Add(drData); } BindingSource bs = new BindingSource(); bs.DataSource = dtSource; this.DataGridView1.DataSource = bs; //Completed binding data to Source Data Grid //Start -- Create columns in the second / destination datagridview DataGridView2.Columns.Add(Name Name); DataGridView2.Columns.Add(Amount Amount); } private void DataGridView1_CellClick(object sender DataGridViewCellEventArgs e) { if (DataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].ValueType.Name == Boolean && e.ColumnIndex == 0) { int rowIndex = DataGridView2.Rows.Add(); for (int colCtr = 1; colCtr { DataGridView2.Rows[rowIndex].Cells[colCtr - 1].Value = DataGridView1.Rows[e.RowIndex].Cells[colCtr].Value; } DataGridView2.Rows[rowIndex].Visible = true; } } } } *****************************************************************

mahesh waghela · Answer

hi Zoran I wants to transfer datagridview1 row to another by click event of checkbox column or datagridview1_CellClick Event

Zoran Horvat · Answer

Do you want to handle click on the column header or change in checkbox state or something else? I.E. what is the event on which you wish to transfer rows to another gridview? Zoran