Add multiple new rows to datagrid

mike Delvotti

I'm trying to add more than one row in my bindingsource based on a number in a textbox.

For instance if textbox1 has a value of '50' and I click Add new row I want to prepare 50 new rows that can be populated in a datagrid then saved all in one go.

I'm using chequeBindingSource.AddNew(); to make 1 new row, but I would like to add as many new rows as the number in textbox1, is that possible?

Hope I've been clear.

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes12y ago
Accepted answer
BindingSource doesn't have an AddRange method or anything like that so I think you'll just have to call AddNew in a loop:

int numRows;
int.TryParse(textBox1.Text, out numRows);
if (numRows > 0)
{
for(int i = 1; i <= numRows; i++)
{
chequeBindingSource.AddNew();
}
}
0
mike Delvotti12y ago
Perfect,

Thanks Vulpes :-)
0
Vulpes12y ago
Sounds like you need something like this:

int numRows;
int chqNumber;
int.TryParse(textBox1.Text, out numRows);
int.TryParse(textBox2.Text, out chqNumber);

if (numRows > 0 && chqNumber > 0)
{
int rowCount = dataGridView1.RowCount;

for(int i = 0; i < numRows; i++)
{
chequeBindingSource.AddNew();
dataGridView1.Rows[rowCount + i].Cells[1].Value = chqNumber + i;
}
}

0
mike Delvotti12y ago
Vulpes - that is awesome! just the job.

I have another quick question that would be great, the above works fine so if I entered 10 in the textbox it adds 10 new rows as expected, basically in column [1] of my datagrid row.cells will be a cheque number.

I would like to do something similar with another textbox2 and enter 10005 then when the 10 new rows start (or whatever textbox1 value is) row.cells[1] populates with 10005 and increments up populating each line in row.cells[1] with 10006 then on next row 10007 filling up the 10 new rows.

so a user enters how many new rows they wish to start in textbox one then enters the starting cheque number in textbox2 if textbox1 is '10' then ten new rows start pre-populating row.cells with the cheque number incrementing up.

Hopefully you get the idea where I'm going with that ;-)
0
Bhabani Prasad12y ago
Follow the Link it will Help U
http://www.dreamincode.net/forums/topic/39260-adding-rows-to-a-data-grid-view/
0