Insert String Array Values Into DataGridView C#

Question

I am developing a windows form application in C#. My Program will read the values from excel cells and insert the data into DataGridView to display the users.

After I have read the excel files, I get the results in string arrays. How can I insert into DataGridView?

private void btnImport_Click(object sender, EventArgs e)
    {
        Microsoft.Office.Interop.Excel.Application ExcelObj = null;
        ExcelObj = new Microsoft.Office.Interop.Excel.Application();

        if (ExcelObj != null)
        {
            if (tbxFileDirectory.Text != "")
            {
                Workbook workbook = ExcelObj.Workbooks.Open(
                openFD.FileName, 0, true, 5, "", "", true, XlPlatform.xlWindows, "\t", false, false, 0, true);

                Sheets sheets = workbook.Worksheets;

                //Get excel sheet number
                Worksheet worksheet = (Worksheet)sheets.get_Item(1);

                for (int i = 6; i <= worksheet.UsedRange.Rows.Count; i++)
                {
                    Range range = worksheet.get_Range("A" + i.ToString(), "K" + i.ToString());

                    Array myvalues = (Array)range.Cells.Value;

                    string[] strArray = ConvertToStringArray(myvalues);

                    //INSERT INTO DATAGRIDVIEW
                }
                MessageBox.Show("File was imported successfully");
            }
            else
            {
                MessageBox.Show("Please select the file to import.");
            }
        }
        else 
        {
            MessageBox.Show("ERROR: EXCEL couldn't be started!");
        }
    }

My DataGrid has 4 columns, ProductID, ProductName, Price, & Qty. I want to insert these values, strArray[0], strArray[1], strArray[9] & strArray[10] in each of the column. How can I do this? Any help will be much appreciated!

Community · Accepted Answer · 2017-05-23 12:29:58Z

2

DataGridView has performance issues when inserting strings directly, and it is awkward to manipulate the data if all you have is the data in the grid itself (though obviously you have to data you parsed from excel). You are usually better off putting the data into a DataTable and then bind that to the grid.

See Add new column and data to datatable that already contains data - c# if you need an example of stuffing data into a DataTable via code.

Binding is easy, assign the DataTable to the DataSource property of the grid.

If you get more than a few hundred rows, you may still see performance issues though -- however, by changing the logic to a virtualize the data see DataGridView live display of datatable using virtual mode for a simple example of that.

edited May 23, 2017 at 12:29

CommunityBot

11 silver badge

answered Aug 22, 2013 at 13:36

Gary Walker

9,2043 gold badges22 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ehsan · Accepted Answer · 2013-08-22 08:37:51Z

2

you can do this

dataGridView1.Rows.Add(strArray[0],strArray[1]......);

answered Aug 22, 2013 at 8:37

Ehsan

32.8k6 gold badges61 silver badges66 bronze badges

1 Comment

Aung Kaung Hein Over a year ago

I can insert the strings directly into DataGridView but I would use DataTable to insert them into it. Thanks for your help. +1

Collectives™ on Stack Overflow

Insert String Array Values Into DataGridView C#

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related