如何将锯齿状的数组绑定到DataGridView？

问题描述

我有2D数组，具有不同类型的数据（整数，字符串，浮点数）。

如何将其绑定到数据网格视图？

还是将其转换为数据视图或BindingList或DataTable，然后将其绑定到datagridview？

编辑：
Object [ ，]是完全动态的数据（不同的行，列，数据类型。，例如转储数据）：（ Excel工作表）

[0，x] kjslwe 3 w 45 erer 643 reew 54 56 34

[1，y] 23 e 1 sf 123213 ds 343433

解决方案

您没有使用

在上面的示例中，我还设置了以下属性：

  grid.AllowUserToAddRows =错误； 
 grid.AllowUserToDeleteRows = false; 
 grid.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCellsExceptHeader; 
  

I have 2D array with different types of data(int, string, float).

How do i bind it to data grid view?

Or converting it to data View or BindingList or DataTable and then bind it to datagridview?

Edits:Object[,] is completely dynamic data(Different no of rows, columns, datatypes., Like dump data): (Excel sheets)

[0,x] "kjslwe" 3 "w" 45 "erer" 643 "reew" "54" 56 34

[1,y] 23 "e" 1 "sf" 123213 "ds" 343433

解决方案

You are not using a 2D Array, you are using a Jagged Array. A jagged array is an array whose elements are arrays. The elements of a jagged array can be of different dimensions and sizes. A jagged array is sometimes called an "array of arrays."

To show a jagged array in DataGridView, you can first calculate the number of columns which you need and set ColumnCount property of grid. Then add rows using an overload of Add method of Rows collection of grid which accepts param object[]. For example:

object[][] data = new object[][]{
        new object[] {"kjslwe", 3, "w", 45, "erer", 643, "reew", "54", 56, 34},
        new object [] {23, "e", 1, "so", 123213, "ds", 343433}
};

var columns = data.Max(x => x.Count());         /* Calculate number of columns */
grid.ColumnCount = columns;                     /* Set column count of grid   */
data.ToList().ForEach(x => grid.Rows.Add(x));   /* Add rows                    */

In the above example, I also set these properties:

grid.AllowUserToAddRows = false;
grid.AllowUserToDeleteRows = false;
grid.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCellsExceptHeader;

这篇关于如何将锯齿状的数组绑定到DataGridView？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！