DataGridView Exception

Farrukh Javeid

I have been trying to get the values from DataGridView. My stupid logic works a bit when accessing the individual cells of the Data Grid Row.
This is the the code that I am using.

private void btn_fetch_Click(object sender, EventArgs e)
        {
            string result = "";
            string part1 = "";
            string part2 = "";

            for (int i = 1; i <= DGV_CsvFile.Rows.Count; i++)
            {
                part1 = DGV_CsvFile.Rows[i].Cells[0].Value.ToString();
                part2 = DGV_CsvFile.Rows[i].Cells[1].Value.ToString();
                result =result + part1+" : "+part2+"\n";
            }
                        
        }

But the problem comes when it completes its iteration, the following exception comes on my face. Frown

"Object reference not set to an instance of an object."
and it selects the first line of the loop.

Need urgent help fellows.
Thanx in advance.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sam Hobbs16y ago
You know how at the bottom of most DataGridViews there is a row for adding data? Usually that row is empty and that is probably the one that does not have an object. So Kirtan's suggestion is likely to work, at least most of the time; it will probably not work proeprly if you set the property that disables adding rows. So something else that might work is to use the DataGridView.NewRowIndex Property. You could check to see if both are true; that the index is equal to the DataGridView.NewRowIndex Property and thde object is null.
0
Kirtan Patel16y ago
I highlighted the mistake ..by red color you need loop till count-1

private void btn_fetch_Click(object sender, EventArgs e)
   {
   string result = "";
   string part1 = "";
   string part2 = "";

   for (int i = 1; i <= DGV_CsvFile.Rows.Count-1; i++)
   {
   part1 = DGV_CsvFile.Rows[i].Cells[0].Value.ToString();
   part2 = DGV_CsvFile.Rows[i].Cells[1].Value.ToString();
   result =result + part1+" : "+part2+"\n";
   }

   }
0
Mamta M16y ago
Typically this exception occurs when the object is null. Probably your DataGridView is empty or the rows are inaccessible, hence when the loop is encountered, the exception is being thrown. Why don't you try a MessageBox.Show with DGV_CsvFile.Rows.Count? And then also try displaying DGV_CsvFile.Rows[i].Cells[0].Value. If any of these throw a similar exception, you will know where you are going wrong.
0