How to insert values from datatable to specific dgv columns

Question

0.00/5 (No votes)

See more:

i have a datatable updated from sql server, i want to fill specific columns from datatable into specific columns into datagridview
here is my code :

C#

foreach (DataRow row in usersInincident.Rows)
                        {
                            dataGridView5.AllowUserToAddRows = false;
                            dataGridView5.Rows.Add();

                            var v  = row["PuserNickname"].ToString();
                            var v1 = row["puserserialno"].ToString();
                            var v2 = row["puserfname"].ToString();
                            var v3 = row["puserlname"].ToString();
                            var v4 = row["gradename"].ToString();
                            var v5 = row["tokenname"].ToString();
                            var v6 = row["policeuserrole"].ToString();



                            foreach (DataGridViewRow gridRow in dataGridView5.Rows)
                            {
                                DataGridViewCell cell = gridRow.Cells[1] as DataGridViewCell;
                                DataGridViewCell cell1 = gridRow.Cells[2] as DataGridViewCell;
                                DataGridViewCell cell2 = gridRow.Cells[3] as DataGridViewCell;
                                DataGridViewCell cell3 = gridRow.Cells[4] as DataGridViewCell;
                                DataGridViewCell cell4 = gridRow.Cells[5] as DataGridViewCell;
                                DataGridViewCell cell5 = gridRow.Cells[6] as DataGridViewCell;
                                DataGridViewCell cell6 = gridRow.Cells[7] as DataGridViewCell;

                                cell.Value = v;
                                cell1.Value = v1;
                                cell2.Value = v2;
                                cell3.Value = v3;
                                cell4.Value = v4;
                                cell5.Value = v5;
                                cell6.Value = v6;

                            }
                        }

What I have tried:

it is giving me the same row when filling the dgv

Posted 9-Sep-16 6:04am

ramy nemer

Updated 9-Sep-16 7:29am

Maciej Los

v2

Add a Solution

Comments

[no name] 9-Sep-16 12:14pm

What does your debugger tell you when you step through this?

ramy nemer 9-Sep-16 12:26pm

it passes through the first foreach only one time once it enters the second foreach it loops through it until it finishes (values are not changing from the 1st foreach)

[no name] 9-Sep-16 12:43pm

Well then that is your answer. You are just filling the second grid with one row from the first grid. If that is not what you want to do then don't do that.

ramy nemer 9-Sep-16 12:54pm

the datatable have three rows,what its doing is its filling the dgv in three same rows,how should i fill them in dgv in specifying its columns ,without using databind

[no name] 9-Sep-16 13:13pm

Yes, that is exactly what you told it to do. Computers are stupid, they only do what you tell them to. Start by not filling the second grid. Only put the data into the second grid that you want to put there.

ramy nemer 9-Sep-16 12:29pm

its filling me the last record only in dgv

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)

Richard Deeming · Answer 1 · 2016-09-09T07:03:00

You need to learn to use the debugger! If you step through your code, the problem will be obvious.

Look again at what your code is doing:

for each row in the source:
    add a new row to the destination
    extract the values from the source row
    
    for each row in the destination, including all previously added rows
        set the columns to the values extracted from the source
    {end of inner loop}
{end of outer loop}

If your source has two rows, you add the first row to the destination and update it with the values from the first row in the source. Then, you add a second row to the destination, and update both destination rows with the values from the second row in the source.

The solution is also obvious: don't update every row in the destination; only update the row you've just added.

C#

foreach (DataRow row in usersInincident.Rows)
{
    int indexOfNewRow = dataGridView5.Rows.Add();
    DataGridRow gridRow = dataGridView5.Rows[indexOfNewRow];
    
    // Now copy the values from row to gridRow...
}