How to add a new row to datagridview programmatica

2018-12-31 12:26发布

问题:

if add row to DataTable

DataRow row = datatable1.NewRow();
row[\"column2\"]=\"column2\";
row[\"column6\"]=\"column6\";
datatable1.Rows.Add(row);

How about DataGridView??

回答1:

You can do:

DataGridViewRow row = (DataGridViewRow)yourDataGridView.Rows[0].Clone();
row.Cells[0].Value = \"XYZ\";
row.Cells[1].Value = 50.2;
yourDataGridView.Rows.Add(row);

or:

DataGridViewRow row = (DataGridViewRow)yourDataGridView.Rows[0].Clone();
row.Cells[\"Column2\"].Value = \"XYZ\";
row.Cells[\"Column6\"].Value = 50.2;
yourDataGridView.Rows.Add(row);

Another way:

this.dataGridView1.Rows.Add(\"five\", \"six\", \"seven\",\"eight\");
this.dataGridView1.Rows.Insert(0, \"one\", \"two\", \"three\", \"four\");

From: http://msdn.microsoft.com/en-us/library/system.windows.forms.datagridview.rows.aspx



回答2:

Like this:

var index = dgv.Rows.Add();
dgv.Rows[index].Cells[\"Column1\"].Value = \"Column1\";
dgv.Rows[index].Cells[\"Column2\"].Value = 5.6;
//....


回答3:

Like this:

 dataGridView1.Columns[0].Name = \"column2\";
 dataGridView1.Columns[1].Name = \"column6\";

 string[] row1 = new string[] { \"column2 value\", \"column6 value\" };
 dataGridView1.Rows.Add(row1);

Or you need to set there values individually use the propery .Rows(), like this:

 dataGridView1.Rows[1].Cells[0].Value = \"cell value\";


回答4:

Lets say you have a datagridview that is not bound to a dataset and you want to programmatically populate new rows...

Here\'s how you do it.

// Create a new row first as it will include the columns you\'ve created at design-time.

int rowId = dataGridView1.Rows.Add();

// Grab the new row!
DataGridViewRow row = dataGridView1.Rows[rowId];

// Add the data
row.Cells[\"Column1\"].Value = \"Value1\";
row.Cells[\"Column2\"].Value = \"Value2\";

// And that\'s it! Quick and painless... :o)


回答5:

Adding a new row in a DGV with no rows with Add() raises SelectionChanged event before you can insert any data (or bind an object in Tag property).

Create a clone row from RowTemplate is safer imho:

//assuming that you created columns (via code or designer) in myDGV
DataGridViewRow row = (DataGridViewRow) myDGV.RowTemplate.Clone();
row.CreateCells(myDGV, \"cell1\", \"cell2\", \"cell3\");

myDGV.Rows.Add(row);


回答6:

If the grid is bound against a DataSet / table its better to use a BindingSource like

var bindingSource = new BindingSource();
bindingSource.DataSource = dataTable;
grid.DataSource = bindingSource;

//Add data to dataTable and then call

bindingSource.ResetBindings(false)    


回答7:

This is how I add a row if the dgrview is empty: (myDataGridView has two columns in my example)

DataGridViewRow row = new DataGridViewRow();
row.CreateCells(myDataGridView);

row.Cells[0].Value = \"some value\";
row.Cells[1].Value = \"next columns value\";

myDataGridView.Rows.Add(row);

According to docs: \"CreateCells() clears the existing cells and sets their template according to the supplied DataGridView template\".



回答8:

If you need to manipulate anything aside from the Cell Value string such as adding a Tag, try this:

DataGridViewRow newRow = (DataGridViewRow)mappingDataGridView.RowTemplate.Clone();
newRow.CreateCells(mappingDataGridView);

newRow.Cells[0].Value = mapping.Key;
newRow.Cells[1].Value = ((BusinessObject)mapping.Value).Name;
newRow.Cells[1].Tag = mapping.Value;

mappingDataGridView.Rows.Add(newRow);


回答9:

here is another way to do such

 private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
    {
        dataGridView1.ColumnCount = 3;

        dataGridView1.Columns[0].Name = \"Name\";
        dataGridView1.Columns[1].Name = \"Age\";
        dataGridView1.Columns[2].Name = \"City\";

        dataGridView1.Rows.Add(\"kathir\", \"25\", \"salem\");
        dataGridView1.Rows.Add(\"vino\", \"24\", \"attur\");
        dataGridView1.Rows.Add(\"maruthi\", \"26\", \"dharmapuri\");
        dataGridView1.Rows.Add(\"arun\", \"27\", \"chennai\"); 
    }


回答10:

yourDGV.Rows.Add(column1,column2...columnx); //add a row to a dataGridview
yourDGV.Rows[rowindex].Cells[Cell/Columnindex].value = yourvalue; //edit the value

you can also create a new row and then add it to the DataGridView like this:

DataGridViewRow row = new DataGridViewRow();
row.Cells[Cell/Columnindex].Value = yourvalue;
yourDGV.Rows.Add(row);


回答11:

An example of copy row from dataGridView and added a new row in The same dataGridView:

DataTable Dt = new DataTable();
Dt.Columns.Add(\"Column1\");
Dt.Columns.Add(\"Column2\");

DataRow dr = Dt.NewRow();
DataGridViewRow dgvR = (DataGridViewRow)dataGridView1.CurrentRow;
dr[0] = dgvR.Cells[0].Value; 
dr[1] = dgvR.Cells[1].Value;              

Dt.Rows.Add(dR);
dataGridView1.DataSource = Dt;


回答12:

Consider a Windows Application and using Button Click Event put this code in it.

dataGridView1.Rows
                .Add(new object[] { textBox1.Text, textBox2.Text, textBox3.Text });


回答13:

//Add a list of BBDD
var item = myEntities.getList().ToList();
//Insert a new object of type in a position of the list       
item.Insert(0,(new Model.getList_Result { id = 0, name = \"Coca Cola\" }));

//List assigned to DataGridView
dgList.DataSource = item; 


回答14:

//header
dataGridView1.RowCount = 50;
dataGridView1.Rows[0].HeaderCell.Value = \"Product_ID0\";


//add row by cell 
 dataGridView1.Rows[1].Cells[0].Value = \"cell value\";


回答15:

If you´ve already defined a DataSource, You can get the DataGridView´s DataSource and cast it as a Datatable.

Then add a new DataRow and set the Fields Values.

Add the new row to the DataTable and Accept the changes.

In C# it would be something like this..

DataTable dataTable = (DataTable)dataGridView.DataSource;
DataRow drToAdd = dataTable.NewRow();

drToAdd[\"Field1\"] = \"Value1\";
drToAdd[\"Field2\"] = \"Value2\";

dataTable.Rows.Add(drToAdd);
dataTable.AcceptChanges();


回答16:

string[] splited = t.Split(\'>\');
int index = dgv_customers.Rows.Add(new DataGridViewRow());
dgv_customers.Rows[index].Cells[\"cust_id\"].Value=splited.WhichIsType(\"id;\");

But be aware, WhichIsType is the extension method I created.