Copying DatagridView1 value to Datagridview2 and Add

Question

HI In my project I want to transfer the data of Gridview1 to Gridview2 and add them in this form i want that when i click the button upeer datagridview value to be add in below datagridview some one please guide me

James Axsom · Answer

Oh my!!! I just costed the corporation millions of dollars for not implementing requirements. Bad Programmer! I got this! Application Start Post Button Click Code: using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Data.SqlClient; using System.Drawing; using System.Linq; using System.Text; using System.Threading.Tasks; using System.Windows.Forms; namespace Sandbox2 { public partial class MyMainForm : Form { DataGridViewTextBoxColumn txtInteger1 = null ; DataGridViewTextBoxColumn txtInteger2 = null ; public MyMainForm() { InitializeComponent(); } private void MyMainForm_Load( object sender, EventArgs e) { // Give each datagridview a column txtInteger1 = new DataGridViewTextBoxColumn(); txtInteger1.Name = "VariableX" ; txtInteger1.HeaderText = "Number" ; dgvVariableOfX.Columns.Add(txtInteger1); txtInteger2 = new DataGridViewTextBoxColumn(); txtInteger2.Name = "SumOfXY" ; txtInteger2.HeaderText = "Number/Sum" ; dgvSumOfXY.Columns.Add(txtInteger2); PopulateVariablesWithNumbers(); } private DataGridViewRow NewRow( int number) { // create a row from scratch or from the bottom up DataGridViewRow row = new DataGridViewRow(); DataGridViewTextBoxCell cell = new DataGridViewTextBoxCell(); cell.Value = number; row.Cells.Add(cell); return row; } private void PopulateVariablesWithNumbers() { // This is the first datagridview on the left dgvVariableOfX.Rows.Add(NewRow(0)); dgvVariableOfX.Rows.Add(NewRow(1)); dgvVariableOfX.Rows.Add(NewRow(33)); // This is the second datagridview on the right dgvSumOfXY.Rows.Add(NewRow(5)); dgvSumOfXY.Rows.Add(NewRow(1)); dgvSumOfXY.Rows.Add(NewRow(3)); } private int GetloopCount( int grid1, int grid2) { // don't allow more loops than the least of amount of rows // in any single grid int count = 0; if (grid1 if (grid1.Equals(grid2)) { count = grid1 = grid2; } // kind of silly if (grid1>grid2) { count = grid2; } return count; } private int GetSum( int x, int y) { int result = x + y; return result; } private void btnSum_Click( object sender, EventArgs e) { // setup a temporary datasource to collect the sums List int > sum = new List int >(); // get row counts set for for-loop int gridLeftRowCount = dgvVariableOfX.Rows.Count; int gridRightRowCount = dgvSumOfXY.Rows.Count; int loopCount = GetloopCount(gridLeftRowCount, gridRightRowCount)-1; // IMPORTANT!! >>> Don't change the values on the right grid // during an iteration. Collect the values first into a list for ( int x=0; x { int leftGridNumber = ( int ) dgvVariableOfX.Rows[x].Cells[ "VariableX" ].Value; int rightGridNumber = ( int )dgvSumOfXY.Rows[x].Cells[ "SumOfXY" ].Value; sum.Add(GetSum(leftGridNumber, rightGridNumber)); } // reset datasource with sums dgvSumOfXY.Rows.Clear(); // can't use a datasource // the list require a collection of struct or class object with properties // the properties hook up to the DisplayMember and ValueMember // our list has nothing but numbers as opposed to structs or classes //dgvSumOfXY.DataSource = sum; foreach ( int x in sum) { dgvSumOfXY.Rows.Add(NewRow(x)); } } } }

Praveen Maurya · Answer

THANKS JAMES YOU SAVE ME

Praveen Maurya · Answer

hi James it was a great Post by you but my query is at button click both the columns value should be add please refer the snaps when the page loads it shows this screen after button click i want this output show in this screen

James Axsom · Answer

Hi Praveen. I uploaded a project that moves data from one grid to another grid. Developed using Visual Studio Community Edition 2017 Visual Studio Community Edition can be downloaded free of charge from Microsoft's website. Here are some screen prints showing application operations: Application Loads and I am going to select some countries in column 1 (Country) Each country will populate column 2 (City) with that county's cities. We pick Kolkata, India and click Travel To. Kolkata, India transfers to the other grid. Project included! Have Fun!

Praveen Maurya · Answer

Hi shubham i want both the grid to be add Column wise like 1st grid is having a 33 in 3rd column and it shoud be add in 2nd grid 3rd column and the output should be 36 as in 2nd grid there is "3" in 3rd Column

Shubham Kule · Answer

You want this type of output right?