add new rows on sum output

Perfect :-)

Thank you Vulpes, I slightly strayed from my original question sorry. Thanks for the help.

OK, this assumes the labels have been placed directly on the form and not in some container such as a panel or groupbox (it's easy to change if they have):

row.text = String.Format("{0}.{1}", i + 1, this.Controls["label" + (i + 1).ToString()].Text);

Yes you are correct on the below:

"Actually reading it again, I don't think you do mean that - you want each label's Text property to appear in a separate row."

There won't be any more than 6 new rows added as the rows added can only be 6 due to the earlier sum process we done if that makes sense?

I'm using a resource scheduler, there's only 6 rows on it for each day and the rows are driven by the row: row.resindex which only goes up to 6.

Do you mean like this:

row.text = String.Format("1.{0}\r\n2.{1}\r\n3.{2}\r\n4.{3}\r\n5.{4}\r\n6.{5}", label1.Text, label2.Text, label3.Text, label4.Text, label5.Text, label6.text);

EDIT:

Actually reading it again, I don't think you do mean that - you want each label's Text property to appear in a separate row.

Bearing in mind there are 6 labels, what happens if there are more than 6 new lines added?

That is so close Thanks,

It's adding all the label values in every new row like belwow:

1. 8640,8640,8640,8640
2.8640,8640,8640,8640

could it be so each row only contains one label value like below, i.e 1, would label1 value, 2 would be label 2 value and so on:

1.8640
2.8640
3.8640

Thanks.

Yes, though you'll need to include the commas within a string.

Also you might want to include a divider between the 'i' and label1.Text.

Something like this perhaps:

row.text = String.Format("{0}:{1},{2},{3},{4},{5},{6}", i + 1, label1.Text, label2.Text, label3.Text, label4.Text, label5.Text, label6.text);

Wow - thanks Vulpes. That's awesome.

I want to do the same with row.text, to insert the label values on the form, would it be something like the below?

row.text = (i + label1.Text, label2.Text, label3.Text, label4.Text, label5.Text, label6.text)

Sure Mike, just change this line:

 row.resindex = "1";

to this:

 row.resindex = (i + 1).ToString();

Vulpes,

Awsome, thank you so much, I got it working using the below in the end:

for (int i = 0; i < num; i++)
                {
                    
                    DataSet.Table1Row row = DataSet.Table1.NewTable1Row();
                    DataSet.Table1.AddTable1Row(row);
                    row.start = dateTimePicker1.Value.ToString("dd/MM/yyyy HH:mm");
                    row.end = dateTimePicker2.Value.ToString("dd/MM/yyyy HH:mm");
                    row.text = "test";
                    row.resindex = "1";
                 }
I have one last cheeky question ;-)

It adds the new rows perfect with your example based on the sum, but you see my 'row.resindex' all the new rows get added with "1" is there a way I could step up so the 2nd new row would insert 'row.resindex = "2" the "3" and so on. if there's 3 new rows added of course.

Thank you.

I don't understand that error as the new rows have already been added with this line:

dataGridView1.Rows.Add(num);

Are you sure that you have i-- rather than i++ in the 'for' statement?

Thanks Vulpes, I got it working close with the below line in the end:

DataGridView.Rows[DataGridView.Rows.Count - i].Cells[2].Value = DateTime.Today.ToString();

But I get the error on the above line at the 'Value' part:
Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index

Thank you Vulpes - I knew you would have an answer :-)

I forgot to mention my datagridview fills and updates via a table adaptor, I'm getting the below error thrown:

'Rows cannot be programmatically added to the DataGridView's rows collection when the control is data-bound.
'
On this line:
table1DataGridView.Rows.Add(num);