how to get the same value if the row is merge in c# .net

i have a excel sheet from where the data will read. then i stored the data in datatable .Again from data table iterating the datatable to get the data from a particular row and store in datatable.It is working fine if the row is not merge.If it is merge the for second record it is getting null value for that particular merger column.

how will i display the same value for the merged row.I neen ur suggestion


i am retriving like below

for (int i = 0; i < _dt.Rows.Count; i++)
            {
                base.WriteLog(LogLevels.Debug, String.Format
                    ("i - {0}", i));

                if (!hasRows)
                {
                    row = _FMEAGridDetails.NewRow();
                }

                else

                    row = _FMEAGridDetails.Rows[i] as GridRow;

 if (_dt.Rows[i][0] == DBNull.Value )
                {
                    _FMEAGridDetails.Rows[i][_opncode] = "";
                }
                else
                {
                    _FMEAGridDetails.Rows[i][_opncode] = _dt.Rows[i][0];
                }
}

thanks in advance !!!!

Tags: C# (C# 4.0)