Copying DatagridView1 value to Datagridview2 and Add

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));
}
}
}
}

6 Replies

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

James Axsom8y ago
Accepted 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));
            }
        }
    }
}
+1
Praveen Maurya8y ago
THANKS JAMES

YOU SAVE ME
0
Praveen Maurya8y ago
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

0
James Axsom8y ago
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!
0
Praveen Maurya8y ago
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
0
Shubham Kule8y ago

You want this type of output right?
0