How to get related data in datagridview2 in a new form, whenever a row is selected in datagridview1 in the first form

Question

0.00/5 (No votes)

See more:

So basically i have two window forms which in the first form i have my datagridview1 that show data from a database, i would like to pop out another datagridview2 in a new form2, that will show related data according to the datagridview1 row i clicked. Is it possible to do so? I have done creating datagridview1 and i would like to show its connected data in datagridview form2. For example i have [id, name, location] displayed in form1, and when i select the row, form2 pop out and display [types, date_installed], with both id = same.

ps: i have already created a class named myClass that contains the connection string to my database.

Here are my codes in form1:

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using Oracle.DataAccess.Client;

namespace MyTask
{
    public partial class Form1 : Form
    {
        private myClass myCls;
       
        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            myCls = new myClass();
            dataGridView1.AutoGenerateColumns = false;
            dataGridView1.DataSource = myCls.QueryData(@"select * from my_database ordered by database_id);

            dataGridView1.Refresh();

        }
 private void button1_Click(object sender, EventArgs e)
        {
           
        }

        private void dataGridView1_CellContentClick_1(object sender, DataGridViewCellEventArgs e)
        {
             Form2 form2 = new Form2();
            form2.Show();
            form2.Refresh();
            dataGridView2.DataSource = dataGridView1.SelectedRows
            dataGridView2.Refresh();
        }

        private void label1_Click(object sender, EventArgs e)
        {

        }
    }
}

What I have tried:

Well i tried this in my dataGridView1...

C#

private void dataGridView1_CellContentClick_1(object sender, DataGridViewCellEventArgs e)
        {
             Form2 form2 = new Form2();
            form2.Show();
            form2.Refresh();
            dataGridView2.DataSource = dataGridView1.SelectedRows
            dataGridView2.Refresh();
        }

Posted 9-May-18 1:08am

Member 13815395

Updated 9-May-18 22:10pm

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2018-05-09T22:12:00

The problem is that anything on Form2 is it's "Property" and your "parent form" should not be able to access it. If Form1 can access controls on Form2, then you can;t make any changes to Form2 in future without considering very carefully what affects that may have on existing code in Form1, Form3, or whatever might be using Form2!

Instead, use properties and / or constructors in Form2 to pass the information and let it deal with displaying what it wants, how it wants.
See here: Transferring information between two forms, Part 1: Parent to Child[^]
All you need to pass the Form2 is the ID value: it collects what infor it needs to from the DB, and displays it without Form1 needing to know how it works:

private void dataGridView1_CellContentClick_1(object sender, DataGridViewCellEventArgs e)
    {
    DataGridView dgv = sender as DataGridView;
    if (dgv != null && e.RowIndex >= 0)
        {
        int id = (int)dgv.Rows[e.RowIndex].Cells["ID"].Value;
        Form2 form2 = new Form2(id);
        form2.Show();
        }
    }

Or

private void dataGridView1_CellContentClick_1(object sender, DataGridViewCellEventArgs e)
    {
    DataGridView dgv = sender as DataGridView;
    if (dgv != null && e.RowIndex >= 0)
        {
        int id = (int)dgv.Rows[e.RowIndex].Cells["ID"].Value;
        Form2 form2 = new Form2();
        form2.ID = id;
        form2.Show();
        }
    }