How to bind a List string to a DataGridView control

Question

I have a simple List lt string gt  and I d like it to be displayed in a DataGridView column  If the list would contain more complex objects  simply would establish the list as the value of its DataSource property   But when doing this   myDataGridView DataSource   myStringList    I get a column called Length and the strings  lengths are displayed   How to display the actual string values from the list in a column

User · Answer

Try this   IList lt String gt  list string  new List lt String gt     DataGridView DataSource   list string Select x   gt  new   Value   x    ToList    dgvSelectedNode Show      I hope this helps

User · Answer

you can also use linq and anonymous types to achieve the same result with much less code as described here   UPDATE  blog is down  here s the content        The values shown in the table represent the length of strings instead of string values      It may seem strange  but that   s how binding mechanism works by default     given an object it will try to bind to the first property of that object  the first property it can find    When passed an instance the String class the property it binds to is String Length since there   s no other property that would provide the actual string itself    That means that to get our binding right we need a wrapper object that will expose the actual value of a string as a property   public class StringWrapper            string stringValue       public string StringValue   get   return stringValue    set   stringValue   value            public StringWrapper string s              StringValue   s                    List lt StringWrapper gt  testData   new List lt StringWrapper gt            add data to the list   convert list of strings to list of string wrappers    Table1 SetDataBinding testdata     While this solution works as expected it requires quite a few lines of code  mostly to convert list of strings to the list of string wrappers     We can improve this solution by using LINQ and anonymous types- we   ll use LINQ query to create a new list of string wrappers  string wrapper will be an anonymous type in our case     var values   from data in testData select new   Value   data      Table1 SetDataBinding values ToList       The last change we   re going to make is to move the LINQ code to an extension method   public static class StringExtensions          public static IEnumerable CreateStringWrapperForBinding this IEnumerable lt string gt  strings              var values   from data in strings      select new   Value   data          return values ToList             This way we can reuse the code by calling single method on any collection of strings   Table1 SetDataBinding testData CreateStringWrapperForBinding

User · Answer

Try this      i have a  List lt string gt  g list   new List lt string gt        i put manually the values     for this example  g list Add  aaa    g list Add  bbb    g list Add  ccc       for each string add a row in dataGridView and put the l str value    foreach  string l str in g list        dataGridView1 Rows Add l str

User · Answer

Try this      i have a  List lt string gt  g list   new List lt string gt        i put manually the values     for this example  g list Add  aaa    g list Add  bbb    g list Add  ccc       for each string add a row in dataGridView and put the l str value    foreach  string l str in g list        dataGridView1 Rows Add l str

User · Answer

The following should work as long as you re bound to anything that implements IEnumerable lt string gt   It will bind the column directly to the string itself  rather than to a Property Path of that string object    lt sdk DataGridTextColumn Binding   Binding     gt

User · Answer

You might run into performance issues when assigning really large lists through LINQ  Following solution is suitable for large lists and without subclassing String   Set DataGridView  here  View   to virtual mode  create column you need and override   register for event CellValueNeeded   private void View CellValueNeeded object sender  DataGridViewCellValueEventArgs e           Optionally  check for column index if you got more columns     e Value   View Rows e RowIndex  DataBoundItem ToString        then you can simply assign your list to DataGridView   List lt String gt  MyList       View DataSource   MyList

User · Answer

Thats because DataGridView looks for properties of containing objects  For string there is just one property - length  So  you need a wrapper for a string like this  public class StringValue       public StringValue string s                 value   s            public string Value   get   return  value    set    value   value          string  value      Then bind List lt StringValue gt  object to your grid  It works

User · Answer

This is common issue  another way is to use DataTable object  DataTable dt   new DataTable    dt Columns Add  column name     dt Rows Add new object      Item 1      dt Rows Add new object      Item 2      dt Rows Add new object      Item 3        This problem is described in detail here  http   www psworld pl Programming BindingListOfString

User · Answer

Thats because DataGridView looks for properties of containing objects  For string there is just one property - length  So  you need a wrapper for a string like this  public class StringValue       public StringValue string s                 value   s            public string Value   get   return  value    set    value   value          string  value      Then bind List lt StringValue gt  object to your grid  It works

User · Answer

Try this   IList lt String gt  list string  new List lt String gt     DataGridView DataSource   list string Select x   gt  new   Value   x    ToList    dgvSelectedNode Show      I hope this helps

User · Answer

An alternate is to use a new helper function which will take values from List and update in the DataGridView as following       private void DisplayStringListInDataGrid List lt string gt  passedList  ref DataGridView gridToUpdate  string newColumnHeader                DataTable gridData   new DataTable            gridData Columns Add newColumnHeader            foreach  string listItem in passedList                        gridData Rows Add listItem                      BindingSource gridDataBinder   new BindingSource            gridDataBinder DataSource   gridData          dgDataBeingProcessed DataSource   gridDataBinder          Then we can call this function the following way       DisplayStringListInDataGrid  lt nameOfListWithStrings gt   ref  lt nameOfDataGridViewToDisplay gt    lt nameToBeGivenForTheNewColumn gt

User · Answer

An alternate is to use a new helper function which will take values from List and update in the DataGridView as following       private void DisplayStringListInDataGrid List lt string gt  passedList  ref DataGridView gridToUpdate  string newColumnHeader                DataTable gridData   new DataTable            gridData Columns Add newColumnHeader            foreach  string listItem in passedList                        gridData Rows Add listItem                      BindingSource gridDataBinder   new BindingSource            gridDataBinder DataSource   gridData          dgDataBeingProcessed DataSource   gridDataBinder          Then we can call this function the following way       DisplayStringListInDataGrid  lt nameOfListWithStrings gt   ref  lt nameOfDataGridViewToDisplay gt    lt nameToBeGivenForTheNewColumn gt

User · Answer

Thats because DataGridView looks for properties of containing objects  For string there is just one property - length  So  you need a wrapper for a string like this  public class StringValue       public StringValue string s                 value   s            public string Value   get   return  value    set    value   value          string  value      Then bind List lt StringValue gt  object to your grid  It works

User · Answer

You might run into performance issues when assigning really large lists through LINQ  Following solution is suitable for large lists and without subclassing String   Set DataGridView  here  View   to virtual mode  create column you need and override   register for event CellValueNeeded   private void View CellValueNeeded object sender  DataGridViewCellValueEventArgs e           Optionally  check for column index if you got more columns     e Value   View Rows e RowIndex  DataBoundItem ToString        then you can simply assign your list to DataGridView   List lt String gt  MyList       View DataSource   MyList

User · Answer

This is common issue  another way is to use DataTable object  DataTable dt   new DataTable    dt Columns Add  column name     dt Rows Add new object      Item 1      dt Rows Add new object      Item 2      dt Rows Add new object      Item 3        This problem is described in detail here  http   www psworld pl Programming BindingListOfString

User · Answer

Thats because DataGridView looks for properties of containing objects  For string there is just one property - length  So  you need a wrapper for a string like this  public class StringValue       public StringValue string s                 value   s            public string Value   get   return  value    set    value   value          string  value      Then bind List lt StringValue gt  object to your grid  It works

User · Answer

you can also use linq and anonymous types to achieve the same result with much less code as described here   UPDATE  blog is down  here s the content        The values shown in the table represent the length of strings instead of string values      It may seem strange  but that   s how binding mechanism works by default     given an object it will try to bind to the first property of that object  the first property it can find    When passed an instance the String class the property it binds to is String Length since there   s no other property that would provide the actual string itself    That means that to get our binding right we need a wrapper object that will expose the actual value of a string as a property   public class StringWrapper            string stringValue       public string StringValue   get   return stringValue    set   stringValue   value            public StringWrapper string s              StringValue   s                    List lt StringWrapper gt  testData   new List lt StringWrapper gt            add data to the list   convert list of strings to list of string wrappers    Table1 SetDataBinding testdata     While this solution works as expected it requires quite a few lines of code  mostly to convert list of strings to the list of string wrappers     We can improve this solution by using LINQ and anonymous types- we   ll use LINQ query to create a new list of string wrappers  string wrapper will be an anonymous type in our case     var values   from data in testData select new   Value   data      Table1 SetDataBinding values ToList       The last change we   re going to make is to move the LINQ code to an extension method   public static class StringExtensions          public static IEnumerable CreateStringWrapperForBinding this IEnumerable lt string gt  strings              var values   from data in strings      select new   Value   data          return values ToList             This way we can reuse the code by calling single method on any collection of strings   Table1 SetDataBinding testData CreateStringWrapperForBinding

User · Answer

The following should work as long as you re bound to anything that implements IEnumerable lt string gt   It will bind the column directly to the string itself  rather than to a Property Path of that string object    lt sdk DataGridTextColumn Binding   Binding     gt

[c#] How to bind a List<string> to a DataGridView control?

Examples related to c#

Examples related to binding

Examples related to datagridview