Combine consecutive rows of Datatable if the rows meet certain criteria –C# WINFORM application

Question

0.00/5 (No votes)

See more:

I am writing a Winform application with C# 4.0.
My DataTable structure:

Name: Event1
Columns:
RunTime
TimeInterval
Value1
Value2
Value3
Iterations
Mode
Resource

HTML

Example Data:(all strings)
RunTime |TimeInterval | Value1 | Value2|Value3|Iterations|Mode|Resource
0.00 | .25 | 30 | 9 | A | 1 | 300 | Run1
.25 | .005 | | | | | |Run1Delay
.255 | .25 | 30 | 9 | A | 1 | 300 | Run1
.505 | .25 | 30 | 7 | A | 50 | 100 | Run2
13.005 | .005 | | | | | | Run2Delay
13.010 | .25 | 30 | 7 | B | 1 | 100 | Run3
13.260 | .25 | 30 | 7 | B | 1 | 100 | Run3
13.51 | .25 | 30 | 7 | B | 1 | 100 | Run3
13.76 | .1 | | | | | | Run3Delay

for a any Row with iteration of 1 and followed by a delay("resource like %Delay% or Iteration is null)
Alter the row by adding time interval value from the delay and Delete the Delay row.

Any and all recommendations welcomed.

Posted 22-Apr-15 6:06am

Katy Starkey

Updated 22-Apr-15 6:33am

v4

Add a Solution

Comments

virusstorm 22-Apr-15 13:48pm

Can you provide an example of what the final data should look like?

Katy Starkey 22-Apr-15 14:10pm

Datatable after changes:
RunTime |TimeInterval | Value1 | Value2|Value3|Iterations|Mode|Resource
0.00 | .255 | 30 | 9 | A | 1 | 300 | Run1
.255 | .25 | 30 | 9 | A | 1 | 300 | Run1
.505 | .25 | 30 | 7 | A | 50 | 100 | Run2
13.005 | .005 | | | | | | Run2Delay
13.010 | .25 | 30 | 7 | B | 1 | 100 | Run3
13.260 | .25 | 30 | 7 | B | 1 | 100 | Run3
13.51 | .35 | 30 | 7 | B | 1 | 100 | Run3

Thank You! :-)

Gideon van Dyk 22-Apr-15 21:28pm

Best would be to cycle throw the rows and per row that matches the iteration = 1 check do a check on the following row and then combine the values and remove the following row.

This might mean you would have to create a new target datatable.

2 solutions

Solution 2

To change the control statement I did the following:

DataTable dt1 = dt.Clone();
DataRow dr1;
for (int i = 0; i < dt.Rows.Count; i++)
{
string delay = Convert.ToString(dt.Rows[i]["Resource"]);

if (delay.IndexOf("eXDly") != -1 {
int RowIndex = dt1.Rows.Count - 1;
double SumValue = Convert.ToDouble(dt1.Rows[RowIndex]["TimeInteral"]) + Convert.ToDouble(dt.Rows[i]["TimeInteral"]);
dt1.Rows[RowIndex]["TimeInteral"] = SumValue.ToString();
}

Posted 27-Apr-15 8:25am

Katy Starkey

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)

Manoj Kumar Mandal · Accepted Answer · 2015-04-22T22:03:00

Try this
DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("Runtime"));
dt.Columns.Add(new DataColumn("TimeInteral"));
dt.Columns.Add(new DataColumn("value1"));
dt.Columns.Add(new DataColumn("value2"));
dt.Columns.Add(new DataColumn("value3"));
dt.Columns.Add(new DataColumn("iteration"));
dt.Columns.Add(new DataColumn("Mode"));
dt.Columns.Add(new DataColumn("Resource"));

DataRow dr = dt.NewRow();
dr["Runtime"] = "0.00";
dr["TimeInteral"] = ".25";
dr["value1"] = "30";
dr["value2"] = "9";
dr["value3"] = "A";
dr["iteration"] = "1";
dr["Mode"] = "300";
dr["Resource"] = "Run1";

dt.Rows.Add(dr);

dr = dt.NewRow();
dr["Runtime"] = "0.25";
dr["TimeInteral"] = ".005";
dr["value1"] = "";
dr["value2"] = "";
dr["value3"] = "";
dr["iteration"] = "";
dr["Mode"] = "";
dr["Resource"] = "Run1Delay";
dt.Rows.Add(dr);

dr = dt.NewRow();
dr["Runtime"] = "0.255";
dr["TimeInteral"] = ".25";
dr["value1"] = "30";
dr["value2"] = "9";
dr["value3"] = "A";
dr["iteration"] = "1";
dr["Mode"] = "300";
dr["Resource"] = "Run1";
dt.Rows.Add(dr);

DataTable dt1 = dt.Clone();
DataRow dr1;
for (int i = 0; i < dt.Rows.Count; i++)
{
if (dt.Rows[i]["Resource"].Equals("Run1Delay"))
{
int RowIndex = dt1.Rows.Count - 1;
double SumValue = Convert.ToDouble(dt1.Rows[RowIndex]["TimeInteral"]) + Convert.ToDouble(dt.Rows[i]["TimeInteral"]);
dt1.Rows[RowIndex]["TimeInteral"] = SumValue.ToString();
}
else
{
dr1 = dt1.NewRow();
dr1["Runtime"] = dt.Rows[i]["Runtime"];
dr1["TimeInteral"] = dt.Rows[i]["TimeInteral"];
dr1["value1"] = dt.Rows[i]["value1"];
dr1["value2"] = dt.Rows[i]["value2"];
dr1["value3"] = dt.Rows[i]["value3"];
dr1["iteration"] = dt.Rows[i]["iteration"];
dr1["Mode"] = dt.Rows[i]["Mode"];
dr1["Resource"] = dt.Rows[i]["Resource"];
dt1.Rows.Add(dr1);
}

}