Adding data by column name to DataGridView in C#

[SimonHeffer]

I've added a DataGridView and added some columns in the designer, now I want to add some rows with data applied via column name.

Having done some web trawling I've ended up with this:

private void AddRow(string thing,string thingdesc)
{
            DataGridViewRow row = new DataGridViewRow();
            row.CreateCells(MyGrid);     // #1
            row.Cells[0].Value = "Add";  // #2 this makes it work
            MyGrid.Rows.Add(row);       // #3 need this before adding data
            row.Cells["Selected"].Value = "Add";
            row.Cells["Model"].Value = thing;
            row.Cells["Description"].Value = thingdesc;
            row.Cells["Scenario"].Value = "Basic";
            row.Cells["ModelLoop"].Value = "1";
            row.Cells["LaunchCount"].Value = "1";
}
 

Apparently I need lines marked # above for it to work. Without #2 the lines after #3 come back with System.Argument OutOfRangeExcep tion. It seems that without #2, CreateCells() doesn't.

Also the data has to be added after #3. Putting it between #2 & #3 gives e.g. Column named Selected cannot be found.

I would have thought #1 was sufficient to allow me to add the data.

Any thoughts?

Simon

[Plater]

There is a slightly quicker way, "MyGrid" is your datagridview?

private void AddRow(string thing,string thingdesc)
{
   int idx = MyGrid.Rows.Add();
   DataGridViewRow row = MyGrid.Rows[idx];
   row.Cells["Selected"].Value = "Add";
   row.Cells["Model"].Value = thing;
   row.Cells["Description"].Value = thingdesc;
   row.Cells["Scenario"].Value = "Basic";
   row.Cells["ModelLoop"].Value = "1";
   row.Cells["LaunchCount"].Value = "1";
}
 

[SimonHeffer]

Excellent! Works a treat.

Many thanks.

[rameshb106]

I've added a DataGridView and added some columns in the designer, now I want to add some rows with data applied via column name.

Having done some web trawling I've ended up with this:

private void AddRow(string thing,string thingdesc)
{
            DataGridViewRow row = new DataGridViewRow();
            row.CreateCells(MyGrid);     // #1
            row.Cells[0].Value = "Add";  // #2 this makes it work
            MyGrid.Rows.Add(row);       // #3 need this before adding data
            row.Cells["Selected"].Value = "Add";
            row.Cells["Model"].Value = thing;
            row.Cells["Description"].Value = thingdesc;
            row.Cells["Scenario"].Value = "Basic";
            row.Cells["ModelLoop"].Value = "1";
            row.Cells["LaunchCount"].Value = "1";
}
 

Apparently I need lines marked # above for it to work. Without #2 the lines after #3 come back with System.Argument OutOfRangeExcep tion. It seems that without #2, CreateCells() doesn't.

Also the data has to be added after #3. Putting it between #2 & #3 gives e.g. Column named Selected cannot be found.

I would have thought #1 was sufficient to allow me to add the data.

Any thoughts?

Simon

HEllo
DO One Thing
private void AddRow(string thing,string thingdesc)
{
string [] row1 = { comumn1(Value), comumn2(Value), ........}
string [] row2= { comumn1(Value), comumn2(Value), .........}

datatgridView1. add(row1);
datatgridView1. add(row2);

}


Thats all
Hope This will help You

Regards
Ramesh