Copy all values in a column. | Infragistics Forums

170

Copy all values in a column.

Kenneth posted over 16 years ago

I am trying to implement "Copy selected column" using context menu. Following code works fine in a plain grid but when a band is introduced it fails. Is there any other way I can implement this functionality?

        public static string GetDataFromEntireColumn(UltraGridCell currentCell, UltraGrid grid, bool includeHeader)
        {
            StringBuilder columnData = new StringBuilder();
            if (currentCell != null)
            {
                foreach (UltraGridRow row in grid.Rows)
                {
                    columnData.Append( row.Cells[currentCell.Column.Key].Text + Environment.NewLine);
                }
                if (includeHeader)
                {
                    columnData.Insert(0,currentCell.Column.Header.Caption + Environment.NewLine);
                }
            }
            return columnData.ToString();
        }

Thanks in advance

95

Offline Alejandro Castrejon posted 11 months ago in reply to John

I Simplify your code

public string LeeCol(UltraGridBand banda, UltraGridColumn columna, bool titulo)
{

StringBuilder columnData = new StringBuilder();
IEnumerable enumerator = ultraGrid1.Rows.GetRowEnumerator(GridRowType.DataRow, banda, null);
foreach (UltraGridRow row in enumerator)
{

columnData.Append(row.Cells[columna.Key].Text + Environment.NewLine);

}
if (titulo)
{

columnData.Insert(0, columna.Header.Caption + Environment.NewLine);

}
return columnData.ToString();

}
Cancel
Reply

Cancel
135

Offline John posted over 16 years ago in reply to Kenneth

In article , bnmerch says...

See my other posting for some example code of how to do that.

But after I sent it I realized that you don't need to send the
currentRow. Just reference the row from currentCell like this:
currentCell.Row
Cancel
Reply

Cancel
135

Offline John posted over 16 years ago

In article , bnmerch says...

Here some sample code that you can try. There may be a better way to
implement this, but this does seem to work.

public static string GetDataFromEntireColumn(UltraGridRow currentRow,
UltraGridCell currentCell, UltraGrid ultraGrid, bool includeHeader)
{
StringBuilder columnData = new StringBuilder();
if (currentCell != null)
{
RowsCollection rows;
if (currentRow.ParentRow == null)
{
rows = ultraGrid.Rows;
}
else
{
rows = currentRow.ParentRow.ChildBands[currentRow.Band].Rows;
}

foreach (UltraGridRow row in rows)
{
columnData.Append( row.Cells[currentCell.Column.Key].Text +
Environment.NewLine);
}
if (includeHeader)
{
columnData.Insert(0,currentCell.Column.Header.Caption +
Environment.NewLine);
}
}
return columnData.ToString();
}
Cancel
Reply

Cancel
170

Offline Kenneth posted over 16 years ago in reply to John

That's exactly what I want to know. How to find correct ChildBands collection in which the CurrentCell exists?

Thanks
Cancel
Reply

Cancel
135

Offline John posted over 16 years ago

In article , bnmerch says...

Is it failing when the currentCell is a cell in a child band?

If so, then you'll need to use the ChildBands collection of the parent
row and loop through the correct child band's row collection.

Your current foreach loop is looping through the parent rows in the
grid.

HTH

John
Cancel
Reply

Cancel