Column Class

Class that represents a grid column.

Object Model

Syntax

Visual Basic
C#

'Declaration
 
Public Class Column 
   Inherits RowCol

public class Column : RowCol

Remarks

Here is the list of what all can be achieved using the Column class:

Enable/Disable editing, merging, dragging, sorting and resizing of individual columns using AllowEditing, AllowMerging, AllowDragging and AllowResizing properties.
Customize the column header with the help of the Caption property.
Use its DataType property for getting or setting the type of object which can be stored in the column.
Define custom editor for the column using its Editor property.
The DataMap and ImageMap properties can be used to map the actual cell values to different display values or images respectively.
Display Sparkline in column cells setting the ShowSparkline property to True. Customize the sparkline and its styles using the Sparkline property which is of type Sparkline class.
Apply filters on a column using its Filter property.
The Sort property specifies how a column should be sorted when the C1FlexGridBase.Sort method is called with a SortFlags.UseColSort flag.
Perform column calculation on FlexGrid columns through expressions with the help of its Expression property.
Control the text and image alignment in the fixed and scrollable cells of the column using the TextAlign, TextAlignFixed, ImageAlign and ImageAlignFixed properties.
Get or set whether a column is selected or not using its Selected property.
Control how the content of the column is formatted with the help of its Format property.
Get or set custom CellStyle associated with the column using its Style property.
Move a column to a new position in the collection with the help of the Move method.
Clear the contents of a column or repaint a column using the Clear and Invalidate methods.

Example

private void Form1_Load(object sender, EventArgs e)
{
     _flex = new C1FlexGrid();
     _flex.Dock = DockStyle.Fill;
     this.Controls.Add(_flex);

     OleDbConnection con = new OleDbConnection("provider=microsoft.jet.oledb.4.0;Data Source="" + Environment.GetFolderPath(Environment.SpecialFolder.Personal) + ""\\ComponentOne Samples\\Common\\C1NWind.mdb");
     DataTable productsTable = new DataTable();
     DataTable categoryTable = new DataTable();
     new OleDbDataAdapter("Select * from Products", con).Fill(productsTable);
     new OleDbDataAdapter("Select CategoryId,CategoryName,Picture from Categories", con).Fill(categoryTable);

     _flex.DataSource = productsTable;
            
     //Formatting
     _flex.Cols[""UnitPrice""].Format = "c";

     //Applying Custom Editor
     NumericUpDown numericUpDownEditor = new NumericUpDown();
     numericUpDownEditor.Maximum = 200;
     _flex.Cols["UnitsInStock"].Editor = numericUpDownEditor;

     //Using ImageMap
     ListDictionary categoryList = new ListDictionary();
     foreach (DataRow row in categoryTable.Rows)
     categoryList.Add(row["CategoryId"] ,row["CategoryName"]);

     ImageList imgList = new ImageList();
     foreach (DataRow row in categoryTable.Rows)
       imgList.Images.Add(row[""CategoryId""].ToString(), LoadImage((byte[])(row["Picture"])));

     ListDictionary images = new ListDictionary();
     for (int i = 1; i <=imgList.Images.Count; i++)
        images[i] = imgList.Images[i.ToString()];

     _flex.Cols["CategoryId"].DataMap = categoryList;
     _flex.Cols["CategoryId"].ImageMap = images;
     _flex.Cols["CategoryId"].ImageAndText = true;
     _flex.Cols["CategoryId"].ImageAlign = ImageAlignEnum.RightBottom;

     //Applying filter
     _flex.AllowFiltering = true;
     ConditionFilter priceFilter = new ConditionFilter();
     priceFilter.Condition1.Parameter = "50";
     priceFilter.Condition1.Operator = ConditionOperator.GreaterThan;
     _flex.Cols["UnitPrice"].Filter = priceFilter;

     //Column calculation on FlexGrid columns through expressions.
     Column unboundcol = _flex.Cols.Add();
     unboundcol.DataType = typeof(object);
     unboundcol.AllowEditing = false;
     unboundcol.Name = "CustomColumn";
     unboundcol.Caption = "Custom Column";
     unboundcol.AllowExpressionEditing = true;
     unboundcol.Expression = "[UnitsInStock] -[UnitsOnOrder]";

     //Sorting a specific column
     _flex.Cols["ReorderLevel"].Sort = SortFlags.Descending;
     _flex.Sort(SortFlags.UseColSort, _flex.Cols["ReorderLevel"].Index );
}

static Image LoadImage(byte[] picData)
{
    // make sure this is an embedded object
    const int bmData = 78;
    if (picData == null || picData.Length < bmData + 2) return null;
    if (picData[0] != 0x15 || picData[1] != 0x1c) return null;

    // we only handle bitmaps for now
    if (picData[bmData] != 'B' || picData[bmData + 1] != 'M') return null;

    // load the picture
    Image img = null;
    try
    {
        MemoryStream ms = new MemoryStream(picData, bmData, picData.Length - bmData);
        img = Image.FromStream(ms);
    }
    catch { }

    // return what we got
    return img;
}

Inheritance Hierarchy

System.Object
C1.Win.C1FlexGrid.RowCol
C1.Win.C1FlexGrid.Column

Reference

Column Members
C1.Win.C1FlexGrid Namespace