Display datagridview selected row or cell in a new datagridview

Question

0.00/5 (No votes)

See more:

In my sql database i have this table
tblEmployees
EmplName Dept Designation salary
John Smith IT Research Research Analyst 23000.00
John Michael IT Operations Manager 25000.00
Will Smith IT Support Manager 13000.00
Lames Brown IT Support Manager 1000.00
Will Emi Support Sales 14000.00
Sam Diva IT Support Manager Assistant 17000.00

In my winForms, i two datagridviews (dgv1 & dgv2). The EmplName column is displayed (showing all names)in dgv1. Now i want to display the columns (Dept, Designation, salary, etc..) in the second datagridview (dgv2) IF a cell / row Content is clicked. And this shd apply for all EmplNames from dgv1 when selected or clicked.(dynamic)

Thatz what i have so far:

//dgv1 cellcontentclick event
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
//Connection string
string C = (@"Data Source=…… ");
SqlConnection con = new SqlConnection(C);

// TSQL sp to choose tables dynamic
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = ("select * from " + selected cellcontent"");

SqlDataAdapter ada = new SqlDataAdapter(cmd);

try
{
// Open connection
con.Open();

DataTable dt = new DataTable();
ada.Fill(dt);
//dgv2
dataGridView2.AutoGenerateColumns = true;
dataGridView2.DataSource = dt;

}

catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
con.Close();
}

Posted 6-Nov-14 22:28pm

mikybrain1

Updated 6-Nov-14 22:31pm

v2

Add a Solution

Comments

Laiju k 7-Nov-14 5:57am

what is your issue

mikybrain1 7-Nov-14 5:59am

Where don't u understand? Data from one gridview if selected to another

Laiju k 7-Nov-14 6:17am

Have you written the query,are you having problem with binding ,gridview1 selectedindexchanging

mikybrain1 7-Nov-14 6:42am

Yes i have written the query which populates my dgv1 with just one column (EmplName) from the table in the database. Now i want to populate the second dgv2 with the entire colums (Dept, Designation and salary) if the cell with the EmplName is clicked.

I have tried this codes BUT it's showing me the same record in the dgv1

private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value != null)
{
MessageBox.Show(dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString());
}

listBox1.Items.Add(dataGridView1.Rows[e.RowIndex].Cells["EmplName"].Value.ToString());

I'm expecting a result like this:
John Smith IT Research Research Analyst 23000.00
Is it possible?

Laiju k 7-Nov-14 6:46am

as you already said you are binding dgv1 with just one column (EmplName) from the table in the database.then how can you get that result

mikybrain1 7-Nov-14 6:59am

I thougt if i select or click a cell Content like eg. John Smith which is the only column in of dgv1, i can then open a connection, write a query and get the entire colums relating to John Smith and display in dgv2.
Something like this:
cmd.CommandText = ("select * from [dbo].[tblEmployees] where [EmplName] = selected cell);
??

Laiju k 7-Nov-14 7:01am

yeah you can do that.

mikybrain1 7-Nov-14 7:03am

Can u please help me out with an illustration? i have tried a several times without any reasonable result

Laiju k 7-Nov-14 7:02am

you can selectedindex change of gridview and take values.

mikybrain1 7-Nov-14 7:16am

Unfortunately i don' have this event. And the results shd show in dgv2.

Laiju k 7-Nov-14 7:21am

SelectedIndexChanged

mikybrain1 7-Nov-14 7:23am

Thatz what am try now. Do have an idea how the query shd be? Or a better approach?
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{

if (dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value != null)
{
//Connection string
string C = (@"Data Source= ");
SqlConnection con = new SqlConnection(C);

// TSQL sp to choose Content selected dynamic
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = ("");
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
try
{
// Open connection
con.Open();

// Save the results in the DT. Call the adapter statement and fill it in the DT
DataTable dt = new DataTable();
adapter.Fill(dt);
dataGridView2.AutoGenerateColumns = true;
dataGridView2.DataSource = dt;

}

catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
con.Close();
}

Laiju k 7-Nov-14 7:34am

have you got the value from first grid.

mikybrain1 7-Nov-14 7:38am

The tbl looks like this:
tblEmployees
EmplName DeptDesignation salary
John Smith IT Research Research Analyst 23000.00
John Michael IT Operations Manager 25000.00
Will Smith IT Support Manager 13000.00
Lames Brown IT Support Manager 1000.00
Will Emi Support Sales 14000.00
Sam Diva IT Support Manager Assistant 17000.00

And the values from dgv1 looks like:
EmplName
John Smith
John Michael
Will Smith
Lames Brown
Will Emi
Sam Diva

Laiju k 7-Nov-14 7:38am

sorry man I have to go.

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)

Laiju k · Answer 1 · 2014-11-07T01:07:00

C#

protected void dataGridView1_SelectedIndexChanged(object sender, EventArgs e)
{
    //Accessing BoundField Column
    string name = GridView1.SelectedRow.Cells[0].Text;

    //Accessing TemplateField Column controls
    string country = (GridView1.SelectedRow.FindControl("lblCountry") as Label).Text;

    lblValues.Text = "<b>Name:</b> " + name + " <b>Country:</b> " + country;
}

can you try like this.event is there is events part in properties