C# converting datagrid view cells in to a single string

Question

The following method is used by me to convert the cells in a datagrid view into a single string and print the string in the console when button is licked!

private void button3_Click(object sender, EventArgs e)
        {
            String file = "";
            for (int i = 0; i < dataGridView1.Rows.Count; i++)
            {
                for (int j = 0; j < dataGridView1.Columns.Count; j++)
                {
                    file = file + dataGridView1.Rows[i].Cells[j].Value.ToString();
                }
            }
            Console.WriteLine(file);
        }

But i get the following error "An unhandled exception of type 'System.NullReferenceException' occured' with the code line dataGridView1.Rows[i].Cells[j].Value.ToString(); highlighted! How can I correct this issue?

score 0 · Answer 1 · answered Aug 25 '17 at 05:20

0

You must check if value exists in cell like this ->

if (dataGridView1.Rows[i].Cells[j].Value!=null)
{    
file = file + dataGridView1.Rows[i].Cells[j].Value.ToString();
}

answered Aug 25 '17 at 05:20

N1gthm4r3

755
1
11
23

Thanx for the answer when both first and second answers combine it works properly! :D – Kushan Peiris Aug 25 '17 at 05:43

Bùi Quang Thành · Accepted Answer · 2017-08-25T05:47:26.503

0

  private void button3_Click(object sender, EventArgs e)
            {
                string file = "";
                for (int i = 0; i < dataGridView1.Rows.Count; i++)
                {
                    for (int j = 0; j < dataGridView1.Rows[i].Cells.Count; j++)
                    {
                       if(dataGridView1.Rows[i].Cells[j].Value!=null)
                         {
                      file+=dataGridView1.Rows[i].Cells[j].Value.ToString();
                         }
                       else
                         {
                           file+="";
                         }
                    }
                }
                Console.WriteLine(file);
            }

I think your loop for j is wrong. Let try this.

edited Aug 25 '17 at 05:47

answered Aug 25 '17 at 05:28

Bùi Quang Thành

128
13

Thanx for the answer when both first and second answers combine it works properly! :D – Kushan Peiris Aug 25 '17 at 05:41
i had just updated, it seems that some columns in your grid dont have value, try the updated code. – Bùi Quang Thành Aug 25 '17 at 05:48
Thanx this works well – Kushan Peiris Aug 25 '17 at 06:54

C# converting datagrid view cells in to a single string

2 Answers2