iterating through rows in a girdview.

Peter Dzuya

Thank you so much for this forum.

I have a gridview which I have used to import data from Microsoft excel.Now I want to pick selected colums and save them into my database. I have used the following code.

foreach (DataGridViewRow dgvr in dataGridView1.Rows){

DataRow dr = ((DataRowView)dgvr.DataBoundItem).Row;

if (dr["BOXNO"].ToString() != null) {

var boxNumber = dr["BOXNO"].ToString();

var dateOfSale = dr["DATEOFSALE"].ToString();

var broker = dr["BROKER"].ToString();

var lotNumber = dr["LOTNO"].ToString();

var gden = dr["GARDENMARK"].ToString();

var invoiceNumber = dr["INVOICENO"].ToString();

}

It iterates all records well, but then I get the following exception "Object referencenot set to an instanceod an object".

Please assist.

Thanks

Peter Dzuya.

4 Replies

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

Raja T9y ago
Hi Peter,

Your most welcome... Happy Coding :)
Peter Dzuya9y ago
Thank you so much. I tried the first option from Amit Gupta, and the exception was still there. The second one from Raja T. worked. I thank you all.
Raja T9y ago
Hi Peter,

try like this way..

foreach (DataGridViewRow dgvr in dataGridView1.Rows)
{
   if ((DataRowView)dgvr.DataBoundItem != null)
   {
      DataRow dr = ((DataRowView)dgvr.DataBoundItem).Row;
      if (dr["Id"].ToString() != null)
      {
         var boxNumber = dr["Name"].ToString();
         var dateOfSale = dr["City"].ToString();
         var broker = dr["Salary"].ToString();
         var lotNumber = dr["color"].ToString();
         var gden = dr["imgpath"].ToString();
      }
   }
}
Amit Gupta9y ago
Before converting ToString(), do check tgat those fields are not DBNull like
if(dr["BOXNO"] != DBNull.Value)
var boxNumber = dr["BOXNO"].ToString();
Do check all to resolve your problem