How to add data to DataGridView

how to add column in datagridview in c# dynamically
c# datagridview add row programmatically datasource
adding rows to datagridview with existing columns in c#
c# datagridview add column
how to add rows in datagridview in c# dynamically
add datarow to datagridview c#
how to show data in datagridview in c#
how to add rows to datagridview programmatically c#

I'm having a Structure like

 X={ID="1", Name="XX",
    ID="2", Name="YY" };

How to dump this data to a DataGridView of two columns

The gridView is like

ID | Name

Can we use LINQ to do this. I'm new to DataGridView Pleaese help me to do this..

Thanks in advance

first you need to add 2 columns to datagrid. you may do it at design time. see Columns property. then add rows as much as you need.

this.dataGridView1.Rows.Add("1", "XX");

How can I manually add data to a dataGridView?, There are 0 cells in the newly created row, that's why you are getting that exception. You cannot use statements like row.Cells[0].Value = i. datagridview2.Rows.Add(a + b); you will actually add 5 empty rows. If you call Rows.Add() with an int as a parameter it consider the number to be the number of rows to add. This is all moot if you haven't added any columns to your datagridview.

Let's assume you have a class like this:

public class Staff
    public int ID { get; set; }
    public string Name { get; set; }

And assume you have dragged and dropped a DataGridView to your form, and name it dataGridView1.

You need a BindingSource to hold your data to bind your DataGridView. This is how you can do it:

private void frmDGV_Load(object sender, EventArgs e)
    //dummy data
    List<Staff> lstStaff = new List<Staff>();
    lstStaff.Add(new Staff()
        ID = 1,
        Name = "XX"
    lstStaff.Add(new Staff()
        ID = 2,
        Name = "YY"

    //use binding source to hold dummy data
    BindingSource binding = new BindingSource();
    binding.DataSource = lstStaff;

    //bind datagridview to binding source
    dataGridView1.DataSource = binding;

Datagridview add data by Manuel in c#, C# DataGridView Add Columns and Rows. The DataGridView control is designed to be a complete solution for displaying tabular data with Windows Forms. The DataGridView control is used to display data from a variety of external data sources. Alternatively, you can add rows and columns to the control and manually populate it with data. The following source code shows how to manually create Columns and Rows in a DataGridView.

My favorite way to do this is with an extension function called 'Map':

public static void Map<T>(this IEnumerable<T> source, Action<T> func)
    foreach (T i in source)

Then you can add all the rows like so:

X.Map(item => this.dataGridView1.Rows.Add(item.ID, item.Name));

C# DataGridView Add Columns and Rows, The DataGridView control is used to display data from a variety of external data sources. Alternatively, you can add rows and columns to the control and manually  To connect a DataGridView control to data: Implement a method to handle the details of retrieving the data. The following code example implements a GetData method that initializes a SqlDataAdapter, In the form's Load event handler, bind the DataGridView control to the BindingSource, and call

LINQ is a "query" language (thats the Q), so modifying data is outside its scope.

That said, your DataGridView is presumably bound to an ItemsSource, perhaps of type ObservableCollection<T> or similar. In that case, just do something like X.ToList().ForEach(yourGridSource.Add) (this might have to be adapted based on the type of source in your grid).

DataGridView adding rows and columns in VB.NET, On each button click, you are creating a new DataTable to bind it to the DataGridView . Instead, check if a datasource already exists for the grid  All cells in a DataGridView control derive from the DataGridViewCell base class. You can access the DataGridView control's columns by using the Columns collection and DataGridView control's rows by using the Rows collection. The following C# source code shows how to manually. create Columns and Rows in a DataGridView.

you shoud do like this form your code

DataGridView.DataSource = yourlist;


[Solved] how to add data dynamically to DataGridview?, Add and insert new rows into data grid using DataGridView for C# WinForms Applications. Data Entry in the Windows Forms DataGridView Control Provides topics that describe how to change the way users add and modify data in the control. Selection and Clipboard Use with the Windows Forms DataGridView Control Provides topics that describe the cell, row, and column selection features in the control.

Adding and Inserting Rows using DataGridView for C# Windows , › › Windows Forms › Windows Forms controls Adding new row to a DataGridView control programmatically is useful when you want to pull some data from another table to a Bound DataSet with another table. A good example of this is the Payroll system .

datagridview add data manually - MSDN, How to: Bind data to the Windows Forms DataGridView control SQL update, insert, and // delete commands based on selectCommand. I'm trying to take some basic form data (item and quantity), from a form where this sort of information is filled out by a user, and after the user clicks "ADD", the entered info is moved to a DataGridView on a different page.

Bind data to DataGridView Control, cs code and add the System.Data and System.Data.SqlClient namespaces. frmMain.cs Code. using System 

  • webforms? winforms? wpf? silverlight?
  • I've added two columns at the design time. now i need to display the data in that grid view
  • Thank you ... I need to iterate through the structure. So i've to use for or foreach loop. can we use LAMBDA expression for this?
  • yes. there are many options. I guess you may use databinding as the best one
  • You don't need a binding source. You can assign the list directly to the grids DataSource.
  • Yes we don't need a binding source, we can bind the list to grid's Datasource directly. The advantage of using bindingsource is that we can refresh binding source later if the list has changed/updated. The grid will get the refresh as well.
  • Use a System.ComponentModel.BindingList so the list informs the DataGridView that an item was added etc.