How to add a new row with different row value ?

Question

0.00/5 (No votes)

See more:

foreach (DataRow row in dt.Rows)
        {
            lstData.Add(new Tablelist() { FileName=csv,  process = row["process"] + "", Event = row["Event"] + "", status = row["status"] + "" });
 
        }
    }
        DataTable dtoutput = new DataTable();
       var columnNames =  lstData.Select(k => k.FileName).Distinct();
       foreach (string columnName in columnNames)       
           dtoutput.Columns.Add(columnName, typeof(string));
       DataRow newrowPassCount = dtoutput.NewRow();
         foreach (string columnName in columnNames) {
            int count = lstData.Where(k=> k.FileName == columnName).Count(k => k.status == "Pass");
            newrowPassCount[columnName] = count; 
        }
         dtoutput.Rows.Add(newrowPassCount);

HI...currently the last code dtoutput.Rows.Add(newrowPassCount);
will create just one row with the (newrowpasscount) value....after second loop I need another row to be created with a different (newrowpasscount) value.. what it does now it will overwrite the previous row..I've been trying this

 foreach (DataRow row in dtoutput.Rows)
{
    dtoutput.Rows.Add(newrowPassCount);
}

but it doesn't work...

Posted 13-Jan-14 17:29pm

acing wei

Updated 13-Jan-14 17:31pm

JoCodes

v2

Add a Solution

3 solutions

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)

Suk@nta · Answer 1 · 2014-01-13T17:50:00

Solution 2

In below code u have put FileName=csv as static value and

C#

var columnNames =  lstData.Select(k => k.FileName).Distinct();

always returns one value of "csv".
so every time it set the value to same column name. and u needs to
keep

C#

DataRow newrowPassCount = dtoutput.NewRow();

inside foreach loop

let me know if its help or not.

Posted 13-Jan-14 17:50pm

Suk@nta

Updated 13-Jan-14 18:22pm

v2

Comments

acing wei 14-Jan-14 1:13am

foreach (DataRow row in dtoutput.Rows)
{
DataRow newrowPassCount = dtoutput.NewRow();
dtoutput.Rows.Add(newrowPassCount);
}
it doesnt work.. the newrowpasscount in redline cannot be declared in the scope..

acing wei 14-Jan-14 1:21am

i think should be my foreach loop problem.. what should I use i want this (newrowpasscount) "row Value" first looping store in first new row , second looping store in another row.. any other way?

Suk@nta 14-Jan-14 1:55am

number of fileName always returns 1 name because in first foreach loop u are assinging same value for FileName.
so it will add one row only.

acing wei 14-Jan-14 1:58am

ehm beside that i also try this to create a new datatable..
for (int i = 1; i < dtoutput.Rows.Count; i++)
{
var tempRow = dtoutput.Rows[i];
var temp = dtoutput.Rows[i][0];
for (int j = 1; j < dtoutput.Rows.Count; j++)
{
DataRow rows = dtoutput.Rows[j];
if (temp == rows[0].ToString())
{
dtoutput.NewRow();
dtoutput.Rows.Add(tempRow[0], tempRow[1]);

}

}
}
but it endless looping ...i use for loop to keep my first loop first value in var then create a table for that row.. but i still stuck

Suk@nta 14-Jan-14 3:27am

var tempRow = dtoutput.Rows[i];
u can not assign a row to a simple variable. u have to assign to a datatrow variable.

use the below code snippet

DataTable dt = new DataTable();
for (int i = 1; i < dtoutput.Rows.Count; i++)
{
DataRow tempRow = dtoutput.Rows[i];
var temp = tempRow[0];
var temp1 = tempRow[1];
dt.Rows.Add(temp, temp1);

}
//bind the daatatable to grid

acing wei 14-Jan-14 4:15am

It can't work the way i want..
dtoutput.Rows.Add(newrowPassCount);
int j = 1;
var tempRow = dtoutput.Rows[j];
for (int i = 1; i < dtoutput.Rows.Count; i++)
{

tempdatatable.NewRow();
if (i == 1)
{

dtoutput.Rows.Add(tempRow[0], tempRow[1]);
}
if (i == 2)
{

dtoutput.Rows.Add(tempRow[0], tempRow[1]);
}

}
this code giving me a second row and third row same row value as my newrowPassCount ..but i got problems is for second and third time loop the newrowpasscount value should't be the same as first row..because the idea is the newrowpasscount keep changing..

JoCodes · Answer 2 · 2014-01-13T18:05:00

Solution 3

You need to move the dtoutput.NewRow(); to the foreach loop so that each time the new row created are added to the collection.

Posted 13-Jan-14 18:05pm

JoCodes

Comments

acing wei 14-Jan-14 1:10am

gives me this error"Collection was modified; enumeration operation might not execute".
foreach (DataRow row in dtoutput.Rows)
{
dtoutput.NewRow();
dtoutput.Rows.Add(newrowPassCount);
}
it doesn't work..

acing wei 14-Jan-14 3:07am

i also try to use for loop like this
for (int i = 1; i < dtoutput.Rows.Count; i++)
{

var tempRow = dtoutput.Rows[i];

if (i == 1)
{
dtoutput.NewRow();
dtoutput.Rows.Add(tempRow);
}
}
but doesn't seems work...

JoCodes 14-Jan-14 3:11am

Try this for (int i = dtoutput.Rows.Count - 1; i >= 0; i--)
{
}

acing wei 14-Jan-14 4:09am

It cannot work the way i want, i still stick with this
foreach (DataRow row in dtoutput.Rows)
{
dtoutput.NewRow();
dtoutput.Rows.Add(newrowPassCount);
}
but I keep receive error gives me this error"Collection was modified; enumeration operation might not execute". the idea is something like this create row put in the newrowpasscount, create another row put in another newrowpasscount..

acing wei 14-Jan-14 4:18am

I need to save my newrowpasscount when the first loop is done bind in a row of table, then in a second loop save the newrowpasscount again and bine to the following row...

JoCodes 14-Jan-14 5:38am

if you use foreach there the problem is that the modification will be tried while its enumerating. so that in that case you can use for loop.its looping reverse iteration.create the new row inside the for loop with the new count and add it .

acing wei 14-Jan-14 5:57am

Can you help me with the code.. just now the code that you asked me try what should I put in the loop.I have tried but cannot work... I'm just a student , still learning, I really appreciate all your help.....

JoCodes 14-Jan-14 6:05am

Can you post that full method here in a formatted way. i ll try to modify it or suggest

acing wei 14-Jan-14 6:18am

This is what I tried just now.. it will get the new rowpasscount value but second row and third row will follow the value of first row... What I want is not a same value as first row..I need the newrowpasscount to save once create row, save twice Crete row..
dtoutput.Rows.Add(newrowPassCount);
int j = 1;
var tempRow = dtoutput.Rows[j];
for (int i = 1; i <dtoutput.Rows.Count; i++)
{

tempdatatable.NewRow();
if (i == 1)
{

dtoutput.Rows.Add(tempRow[0], tempRow[1]);
}
if (i == 2)
{

dtoutput.Rows.Add(tempRow[0], tempRow[1]);
}

}

JoCodes 14-Jan-14 6:38am

the above code with for loop incremental iteration wont work . since the row count will be increased each time when you add row. You have to use decremental for loop or just add to new table adding with foreach.

acing wei 14-Jan-14 6:51am

for (int i = dtoutput.Rows.Count - 1; i >= 0; i--)
{
dtoutput.NewRow();
dtoutput.Rows.Add(newrowPassCount);
}
so what you mean is i can just simply us this code above to try?

JoCodes 14-Jan-14 6:58am

Yes , but the newrowPassCount assigning part should be also inside the loop or it will add same row.

acing wei 14-Jan-14 7:28am

DataTable dtoutput = new DataTable();
var columnNames = lstData.Select(k => k.FileName).Distinct();
foreach (string columnName in columnNames)
dtoutput.Columns.Add(columnName, typeof(string));
for (int i = dtoutput.Rows.Count - 1; i >= 0; i--)
{
DataRow newrowPassCount = dtoutput.NewRow();
foreach (string columnName in columnNames) {
int count = lstData.Where(k=> k.FileName == columnName).Count(k => k.status == "Pass");
newrowPassCount[columnName] = count;
}
dtoutput.NewRow();
dtoutput.Rows.Add(newrowPassCount);
}
the whole table disappear...it will escape my
foreach (string columnName in columnNames) {
it will not go inside here..hence the table disappear

acing wei 15-Jan-14 1:09am

I'm still trying but it doesn't work..it will skip what is in the for loop...

acing wei 14-Jan-14 6:30am

Do I even need a new data table to bind a new datarow from newrowpasscount, .I actually have a select command on top, select from dropdownlist.. and everytime selected change it will refresh the page before datatable bind... I don't know if I still can use for loop...

Gitanjali Singh · Answer 3 · 2014-01-13T17:42:00

Solution 1

C#

DataTable dtoutput = new DataTable();

// generate the data you want to insert
   DataRow toInsert = ...;

// insert in the desired place
dt.Rows.InsertAt(toInsert, index);

Give it a try.This may help.

Posted 13-Jan-14 17:42pm

Gitanjali Singh