add new rows on sum output

Question

Guys I will try to explain this without being too confusing. I need to add new rows in my datagridview based on a sum output. Example I have a textbox and 6 labels that each have a fixed value. If the entered value in textbox is less than or equal to label1 it adds a new row in datagridview and inserts todays date in row.cells[2] of that new row. Now if the value in textbox is greater than label1 value it adds 2 new rows and inserting date value in cells[2] in new rows. Now it gets tricky if the textbox value is greater than label1 + label2 value it adds 4 new rows with the date value in cell[2] etc. this need to happen until the value has reached the value on all 6 labels. is it actually possible to do? the above would fire from a function or button click.

Vulpes · Answer

Try something like this ('top of head' so untested): private void ProcessValue() { int i1 = int.Parse(label1.Text); int i2 = int.Parse(label2.Text); int i3 = int.Parse(label3.Text); int i4 = int.Parse(label4.Text); int i5 = int.Parse(label5.Text); int i6 = int.Parse(label6.Text); int val; bool isValid = int.TryParse(textBox1.Text out val); if (!isValid) { MessageBox.Show(Not a valid integer. Please amend.); textBox1.Focus(); return; } int num = 0; if (val > (i1 + i2 + i3 + i4 + i5 + i6)) { num = 12; } else if (val > (i1 + i2 + i3 + i4 + i5)) { num = 10; } else if (val > (i1 + i2 + i3 + i4)) { num = 8; } else if (val > (i1 + i2 + i3)) { num = 6; } else if (val > (i1 + i2)) { num = 4; } else if (val > i1) { num = 2; } else if (val { num = 1; } if (num > 0) { dataGridView1.Rows.Add(num); for(int i = num; i >= 1; i--) { dataGridView1.Rows[dataGridView1.Rows.Count - i].Cells[2].Value = DateTime.Today; } } }

mike Delvotti · Answer

Perfect :-) Thank you Vulpes I slightly strayed from my original question sorry. Thanks for the help.

Vulpes · Answer

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);

mike Delvotti · Answer

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.

Vulpes · Answer

Do you mean like this: row.text = String.Format(1.{0}
2.{1}
3.{2}
4.{3}
5.{4}
6.{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?

mike Delvotti · Answer

That is so close Thanks It's adding all the label values in every new row like belwow: 1. 8640864086408640 2.8640864086408640 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.

Vulpes · Answer

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);

mike Delvotti · Answer

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)

Vulpes · Answer

Sure Mike just change this line: row.resindex = 1; to this: row.resindex = (i + 1).ToString();

mike Delvotti · Answer

Vulpes Awsome thank you so much I got it working using the below in the end: for (int i = 0; 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.

Vulpes · Answer

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?

mike Delvotti · Answer

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

Vulpes · Answer

If the DGV is bound to a datatable then you'll need to add the new rows to the datatable itself and then rebind. For example if 'dt' represents the datatable you'd need to replace: if (num > 0) { dataGridView1.Rows.Add(num); for(int i = num; i >= 1; i--) { dataGridView1.Rows[dataGridView1.Rows.Count - i].Cells[2].Value = DateTime.Today; } } with something like this: if (num > 0) { for(int i = 0; i { DataRow dr = dt.NewRow(); dr[2]= DateTime.Today; // assuming column type is DateTime dt.Rows.Add(dr); } dataGridView1.DataSource = dt; }

mike Delvotti · Answer

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);