Click here to Skip to main content
11,578,739 members (60,171 online)
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C#4.0
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 !!!!
Posted 26-Oct-12 21:30pm
Starlene1.1K

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 Peter Leow 135
1 Frankie-C 115
2 OriginalGriff 113
3 Richard MacCutchan 85
4 Afzaal Ahmad Zeeshan 85
0 OriginalGriff 933
1 Sergey Alexandrovich Kryukov 740
2 Abhinav S 573
3 F-ES Sitecore 420
4 Dave Kreskowiak 419


Advertise | Privacy | Mobile
Web04 | 2.8.150603.1 | Last Updated 27 Oct 2012
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100