exontrol.EXGRIDLib.Columns var_Columns = exgrid1.Columns;
	(var_Columns.Add("A") as exontrol.EXGRIDLib.Column).Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.SpinType;
	(var_Columns.Add("B") as exontrol.EXGRIDLib.Column).FormatColumn = "currency(%0)";
	(var_Columns.Add("C") as exontrol.EXGRIDLib.Column).FormatColumn = "%1 format ''";
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.AddItem(1);
	var_Items.AddItem(2);
	var_Items.AddItem(3);

// Click event - Occurs when the user presses and then releases the left mouse button over the grid control.
private void exgrid1_Click(object sender)
{
	exgrid1.Ungroup();
}
//this.exgrid1.Click += new exontrol.EXGRIDLib.exg2antt.ClickEventHandler(this.exgrid1_Click);

exgrid1.BeginUpdate();
exgrid1.ColumnAutoResize = false;
// Add 'Microsoft ActiveX Data Objects 6.0 Library' reference to your project.
ADODB.Recordset rs = new ADODB.Recordset();
	rs.Open("Orders","Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Program Files\\Exontrol\\ExGrid\\Sample\\SAMPL" +
"E.MDB",exontrol.ADODB.CursorTypeEnum.adOpenStatic,exontrol.ADODB.LockTypeEnum.adLockOptimistic,0);
exgrid1.DataSource = (rs as ADODB.Recordset);
exgrid1.SortBarHeight = 24;
exgrid1.HeaderHeight = 24;
exgrid1.SortBarVisible = true;
exgrid1.SortBarCaption = "Drag a <b>column</b> header here to group by that column.";
exgrid1.AllowGroupBy = true;
exgrid1.ReadOnly = exontrol.EXGRIDLib.ReadOnlyEnum.exReadOnly;
exontrol.EXGRIDLib.Column var_Column = exgrid1.Columns[1];
	var_Column.Alignment = exontrol.EXGRIDLib.AlignmentEnum.CenterAlignment;
	var_Column.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellBackColor,15790320);
	var_Column.SortOrder = true;
exgrid1.EndUpdate();

exgrid1.BeginUpdate();
exgrid1.ColumnAutoResize = false;
// Add 'Microsoft ActiveX Data Objects 6.0 Library' reference to your project.
ADODB.Recordset rs = new ADODB.Recordset();
	rs.Open("Orders","Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Program Files\\Exontrol\\ExGrid\\Sample\\SAMPL" +
"E.MDB",exontrol.ADODB.CursorTypeEnum.adOpenStatic,exontrol.ADODB.LockTypeEnum.adLockOptimistic,0);
exgrid1.DataSource = (rs as ADODB.Recordset);
exgrid1.SortBarHeight = 24;
exgrid1.HeaderHeight = 24;
exgrid1.BackColorSortBar = Color.FromArgb(240,240,240);
exgrid1.BackColorSortBarCaption = exgrid1.BackColor;
exgrid1.VisualAppearance.Add(1,"gBFLBCJwBAEHhEJAEGg4BdsIQAAYAQGKIYBkAKBQAGaAoDDgNw0QwAAxjMK0EwsACEIrjKCRShyCYZRhGcTSBCIZBqEqSZL" +
"iEZRQiiCYsS5GQBSFDcOwHGyQYDkCQpAAWL4tCyMc7QHKAWhrEAbJjgQYJUh+TQAAZCIJRXRQAL/K6rKwnSCQIgkUBpGKdBy" +
"nEYoYxAfyESCJWyIahWAwoQjUMB1HLQAAxC5kKbkIxyBABFBdVjVeBYG78Bz+ABjEovbAMEwPBqAMwmIAZDheA4FR4AGhTXK" +
"cbxrFaXZSzKckPRoADSZq1Sg5LjDJI2ABqU6ABqNLZtJKsZS4apABrWeZ3Q7QMLdFTwA4PH6EZhxXAYbTVeaPZjQIBAgI");
exgrid1.SortBarVisible = true;
exgrid1.SortBarCaption = "Drag a <b>column</b> header here to group by that column.";
exgrid1.AllowGroupBy = true;
exontrol.EXGRIDLib.Column var_Column = exgrid1.Columns[1];
	var_Column.Alignment = exontrol.EXGRIDLib.AlignmentEnum.CenterAlignment;
	var_Column.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellBackColor,15790320);
	var_Column.SortOrder = true;
exontrol.EXGRIDLib.Column var_Column1 = exgrid1.Columns[5];
	var_Column1.Alignment = exontrol.EXGRIDLib.AlignmentEnum.CenterAlignment;
	var_Column1.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellBackColor,16119285);
	var_Column1.SortOrder = true;
exgrid1.set_Background32(exontrol.EXGRIDLib.BackgroundPartEnum.exSortBarLinkColor,0x1000000);
exgrid1.EndUpdate();

exgrid1.BeginUpdate();
exgrid1.ColumnAutoResize = false;
// Add 'Microsoft ActiveX Data Objects 6.0 Library' reference to your project.
ADODB.Recordset rs = new ADODB.Recordset();
	rs.Open("Orders","Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Program Files\\Exontrol\\ExGrid\\Sample\\SAMPL" +
"E.MDB",exontrol.ADODB.CursorTypeEnum.adOpenStatic,exontrol.ADODB.LockTypeEnum.adLockOptimistic,0);
exgrid1.DataSource = (rs as ADODB.Recordset);
exgrid1.SortBarVisible = true;
exgrid1.SortBarCaption = "Drag a <b>column</b> header here to group by that column.";
exgrid1.AllowGroupBy = true;
exontrol.EXGRIDLib.Column var_Column = exgrid1.Columns[1];
	var_Column.Alignment = exontrol.EXGRIDLib.AlignmentEnum.CenterAlignment;
	var_Column.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellBackColor,15790320);
exgrid1.EndUpdate();

exgrid1.BeginUpdate();
exgrid1.LinesAtRoot = exontrol.EXGRIDLib.LinesAtRootEnum.exGroupLinesOutside;
exgrid1.ColumnAutoResize = false;
// Add 'Microsoft ActiveX Data Objects 6.0 Library' reference to your project.
ADODB.Recordset rs = new ADODB.Recordset();
	rs.Open("Orders","Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Program Files\\Exontrol\\ExGrid\\Sample\\SAMPL" +
"E.MDB",exontrol.ADODB.CursorTypeEnum.adOpenStatic,exontrol.ADODB.LockTypeEnum.adLockOptimistic,0);
exgrid1.DataSource = (rs as ADODB.Recordset);
exgrid1.SortBarVisible = true;
exgrid1.SortBarCaption = "Drag a <b>column</b> header here to group by that column.";
exgrid1.AllowGroupBy = true;
exgrid1.Columns[6].AllowGroupBy = false;
exontrol.EXGRIDLib.Column var_Column = exgrid1.Columns[1];
	var_Column.GroupByTotalField = "";
	var_Column.GroupByFormatCell = "";
exgrid1.EndUpdate();

// AddItem event - Occurs after a new Item has been inserted to Items collection.
private void exgrid1_AddItem(object sender,int Item)
{
	exgrid1.Items.set_ItemDividerLineAlignment(Item,exontrol.EXGRIDLib.DividerAlignmentEnum.DividerBoth);
}
//this.exgrid1.AddItem += new exontrol.EXGRIDLib.exg2antt.AddItemEventHandler(this.exgrid1_AddItem);

// Change event - Occurs when the user changes the cell's content.
private void exgrid1_Change(object sender,int Item,int ColIndex,ref object NewValue)
{
	exgrid1.Refresh();
}
//this.exgrid1.Change += new exontrol.EXGRIDLib.exg2antt.ChangeEventHandler(this.exgrid1_Change);

exgrid1.BeginUpdate();
exgrid1.ScrollBySingleLine = true;
exgrid1.LinesAtRoot = exontrol.EXGRIDLib.LinesAtRootEnum.exGroupLinesOutside;
exgrid1.ColumnAutoResize = false;
// Add 'Microsoft ActiveX Data Objects 6.0 Library' reference to your project.
ADODB.Recordset rs = new ADODB.Recordset();
	rs.Open("Orders","Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Program Files\\Exontrol\\ExGrid\\Sample\\SAMPL" +
"E.MDB",exontrol.ADODB.CursorTypeEnum.adOpenStatic,exontrol.ADODB.LockTypeEnum.adLockOptimistic,0);
exgrid1.DataSource = (rs as ADODB.Recordset);
exgrid1.SortBarVisible = true;
exgrid1.SortBarCaption = "Drag a <b>column</b> header here to group by that column.";
exgrid1.AllowGroupBy = true;
exgrid1.Columns[6].AllowGroupBy = false;
exontrol.EXGRIDLib.Column var_Column = exgrid1.Columns[1];
	var_Column.GroupByTotalField = "sum(current,rec,%6)";
	var_Column.GroupByFormatCell = "'<font ;11>' + <caption> + '</font> <fgcolor=808080>( Freight: ' + currency(value) + ')'";
exgrid1.DefaultItemHeight = 28;
exgrid1.EndUpdate();

// AddItem event - Occurs after a new Item has been inserted to Items collection.
private void exgrid1_AddItem(object sender,int Item)
{
	exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
		var_Items.set_ItemDividerLine(Item,exontrol.EXGRIDLib.DividerLineEnum.EmptyLine);
		int l = var_Items.get_GroupItem(Item);
		var_Items.set_CellSingleLine(Item,l,false);
		var_Items.set_CellBold(Item,l,true);
		var_Items.set_CellBackColor32(Item,l,0x1000000);
}
//this.exgrid1.AddItem += new exontrol.EXGRIDLib.exg2antt.AddItemEventHandler(this.exgrid1_AddItem);

exgrid1.BeginUpdate();
exgrid1.ScrollBySingleLine = true;
exgrid1.LinesAtRoot = exontrol.EXGRIDLib.LinesAtRootEnum.exNoLinesAtRoot;
exgrid1.TreeColumnIndex = -1;
exgrid1.ColumnAutoResize = false;
// Add 'Microsoft ActiveX Data Objects 6.0 Library' reference to your project.
ADODB.Recordset rs = new ADODB.Recordset();
	rs.Open("Orders","Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Program Files\\Exontrol\\ExGrid\\Sample\\SAMPL" +
"E.MDB",exontrol.ADODB.CursorTypeEnum.adOpenStatic,exontrol.ADODB.LockTypeEnum.adLockOptimistic,0);
exgrid1.VisualAppearance.Add(1,"gBFLBCJwBAEHhEJAEGg4BKoCg6AADACAxRDAMgBQKAAzQFAYcBuGiGAAGMZhWgmFgAQhFcZQSKUOQTDKMIziaQIRDEMw5SS" +
"NIxyAK0QBkAqNQCkKKwIgmNYDSBMYABBIMBwiGQaRJnegYRDUMJCQjRVITVLMNoXDKZIyqEAHfpWVJWSLHcIhDBJUjcOYyTi" +
"OQrzCK8dB0G6bIrGEZpYRAPwEYDIIjbQhqFYDChCNLwHScEAxC4kLhnKK6Vb9d6HYhiOJYXhmDrfR7IMhyLI8QafFqXZhmOZ" +
"ZXizPY9T7QNB0LQ8eZbJqnahqOpaOx2W5dV7YNh2LTWGzXNq3bhuOzLbrme59X7gOB3RZeE4XRrHchxKq8XxnG6dZ7oOTUXo" +
"fFOK5WmudQTh2LpfHOO5em+doSh4LwfhOS5mnGIw9D6LxfjOW5unSIQ+D8L4flOa5yD2fg/D+L5fnOe54ByigGAKAJgEgBBr" +
"gGYIICYCoCmCSAcGOA5hAgRgSgSYQBGoFoFmGCBmBqBphGESgegeYgIgYIoHkSKIWCaCZigiJgqgqYhog4LoLmGSJGDKBZhE" +
"iVg2gMY4ImYCIBGOSJ1n6D5kAeZZ2hCZBHj4RoRl6J4eEqEpeAkNhOHaXYJEYUh0GUSRVkwchlgkZZChaZZGnWOoXmYBpOGK" +
"GJamaLhmhmWhJiYahnlmSY2G4ZZZEmRhyGMZxJlWCBhFCFgWHaHpYkmSh+GSJp6AWG4amgRoOGeIZahmEoKGyJgKDWOIXGkB" +
"wGFmJJcHkWoWHQJQqGWVoTmmRx+EuJ5eFkIoiHuJBKhWdIQGqB52D2KpgDiaougMIxqyODJrEgbgvi2YgYjKOoumKSpij4FI" +
"rFsBg0iyLBKj6RoOmqSwmimMpkCqGpOiibQJCaII0mmWxWFCJotgoXpahWaRLHaEY3mWag6mKIpuEmFoIjmaBbiYbIgi6Rha" +
"H+O5Onmcpyh2VYAAEASAg");
exgrid1.DrawGridLines = exontrol.EXGRIDLib.GridLinesEnum.exHLines;
exgrid1.DataSource = (rs as ADODB.Recordset);
exgrid1.SortBarVisible = true;
exgrid1.SortBarCaption = "Drag a <b>column</b> header here to group by that column.";
exgrid1.AllowGroupBy = true;
exontrol.EXGRIDLib.Column var_Column = exgrid1.Columns[1];
	var_Column.GroupByFormatCell = "'EmployeeID: ' + <caption> + '<br><font ;7><fgcolor=808080>Count: ' + value";
exgrid1.EndUpdate();

// AddItem event - Occurs after a new Item has been inserted to Items collection.
private void exgrid1_AddItem(object sender,int Item)
{
	exgrid1.Items.set_ItemDividerLine(Item,exontrol.EXGRIDLib.DividerLineEnum.EmptyLine);
}
//this.exgrid1.AddItem += new exontrol.EXGRIDLib.exg2antt.AddItemEventHandler(this.exgrid1_AddItem);

exgrid1.BeginUpdate();
exgrid1.ColumnAutoResize = false;
// Add 'Microsoft ActiveX Data Objects 6.0 Library' reference to your project.
ADODB.Recordset rs = new ADODB.Recordset();
	rs.Open("Orders","Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Program Files\\Exontrol\\ExGrid\\Sample\\SAMPL" +
"E.MDB",exontrol.ADODB.CursorTypeEnum.adOpenStatic,exontrol.ADODB.LockTypeEnum.adLockOptimistic,0);
exgrid1.DataSource = (rs as ADODB.Recordset);
exgrid1.SortBarVisible = true;
exgrid1.SortBarCaption = "Drag a <b>column</b> header here to group by that column.";
exgrid1.AllowGroupBy = true;
exgrid1.EndUpdate();

// MouseMove event - Occurs when the user moves the mouse.
private void exgrid1_MouseMoveEvent(object sender,short Button,short Shift,int X,int Y)
{
	int h = exgrid1.get_ItemFromPoint(-1,-1,c,hit);
	System.Diagnostics.Debug.Print( exgrid1.Items.get_GroupItem(h).ToString() );
}
//this.exgrid1.MouseMoveEvent += new exontrol.EXGRIDLib.exg2antt.MouseMoveEventHandler(this.exgrid1_MouseMoveEvent);

exgrid1.BeginUpdate();
exgrid1.ColumnAutoResize = false;
// Add 'Microsoft ActiveX Data Objects 6.0 Library' reference to your project.
ADODB.Recordset rs = new ADODB.Recordset();
	rs.Open("Orders","Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Program Files\\Exontrol\\ExGrid\\Sample\\SAMPL" +
"E.MDB",exontrol.ADODB.CursorTypeEnum.adOpenStatic,exontrol.ADODB.LockTypeEnum.adLockOptimistic,0);
exgrid1.DataSource = (rs as ADODB.Recordset);
exgrid1.SortBarVisible = true;
exgrid1.SortBarCaption = "Drag a <b>column</b> header here to group by that column.";
exgrid1.AllowGroupBy = true;
exgrid1.EndUpdate();

// AddItem event - Occurs after a new Item has been inserted to Items collection.
private void exgrid1_AddItem(object sender,int Item)
{
	exgrid1.Items.set_ExpandItem(Item,false);
}
//this.exgrid1.AddItem += new exontrol.EXGRIDLib.exg2antt.AddItemEventHandler(this.exgrid1_AddItem);

exgrid1.BeginUpdate();
exgrid1.ColumnAutoResize = false;
// Add 'Microsoft ActiveX Data Objects 6.0 Library' reference to your project.
ADODB.Recordset rs = new ADODB.Recordset();
	rs.Open("Orders","Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Program Files\\Exontrol\\ExGrid\\Sample\\SAMPL" +
"E.MDB",exontrol.ADODB.CursorTypeEnum.adOpenStatic,exontrol.ADODB.LockTypeEnum.adLockOptimistic,0);
exgrid1.DataSource = (rs as ADODB.Recordset);
exgrid1.SortBarVisible = true;
exgrid1.SortBarCaption = "Drag a <b>column</b> header here to group by that column.";
exgrid1.AllowGroupBy = true;
exgrid1.EndUpdate();

exgrid1.BeginUpdate();
exgrid1.ColumnAutoResize = false;
// Add 'Microsoft ActiveX Data Objects 6.0 Library' reference to your project.
ADODB.Recordset rs = new ADODB.Recordset();
	rs.Open("Orders","Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Program Files\\Exontrol\\ExGrid\\Sample\\SAMPL" +
"E.MDB",exontrol.ADODB.CursorTypeEnum.adOpenStatic,exontrol.ADODB.LockTypeEnum.adLockOptimistic,0);
exgrid1.DataSource = (rs as ADODB.Recordset);
exgrid1.SortBarVisible = true;
exgrid1.SortBarCaption = "<fgcolor=FF0000>Try to drag the EmployeeID column here.";
exgrid1.AllowGroupBy = true;
exgrid1.Columns[1].AllowGroupBy = false;
exgrid1.EndUpdate();

exgrid1.BeginUpdate();
exgrid1.ColumnAutoResize = false;
// Add 'Microsoft ActiveX Data Objects 6.0 Library' reference to your project.
ADODB.Recordset rs = new ADODB.Recordset();
	rs.Open("Orders","Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Program Files\\Exontrol\\ExGrid\\Sample\\SAMPL" +
"E.MDB",exontrol.ADODB.CursorTypeEnum.adOpenStatic,exontrol.ADODB.LockTypeEnum.adLockOptimistic,0);
exgrid1.DataSource = (rs as ADODB.Recordset);
exgrid1.SingleSort = false;
exgrid1.AllowGroupBy = true;
exgrid1.Columns[1].SortOrder = true;
exgrid1.EndUpdate();

exgrid1.BeginUpdate();
exgrid1.ColumnAutoResize = false;
// Add 'Microsoft ActiveX Data Objects 6.0 Library' reference to your project.
ADODB.Recordset rs = new ADODB.Recordset();
	rs.Open("Orders","Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Program Files\\Exontrol\\ExGrid\\Sample\\SAMPL" +
"E.MDB",exontrol.ADODB.CursorTypeEnum.adOpenStatic,exontrol.ADODB.LockTypeEnum.adLockOptimistic,0);
exgrid1.DataSource = (rs as ADODB.Recordset);
exgrid1.SortBarVisible = true;
exgrid1.SortBarCaption = "Drag a <b>column</b> header here to group by that column.";
exgrid1.AllowGroupBy = true;
exgrid1.EndUpdate();

exontrol.EXGRIDLib.Editor var_Editor = (exgrid1.Columns.Add("Numbers") as exontrol.EXGRIDLib.Column).Editor;
	var_Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.EditType;
	var_Editor.Numeric = exontrol.EXGRIDLib.NumericEnum.exFloat;
exgrid1.Items.AddItem(12);

exontrol.EXGRIDLib.Editor var_Editor = (exgrid1.Columns.Add("Numbers") as exontrol.EXGRIDLib.Column).Editor;
	var_Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.EditType;
	var_Editor.Numeric = exontrol.EXGRIDLib.NumericEnum.exInteger;
exgrid1.Items.AddItem(12);

exontrol.EXGRIDLib.Editor var_Editor = (exgrid1.Columns.Add("Numbers") as exontrol.EXGRIDLib.Column).Editor;
	var_Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.MaskType;
	var_Editor.Mask = "###.###";
exgrid1.Items.AddItem(12);

exgrid1.BeginUpdate();
exgrid1.LinesAtRoot = exontrol.EXGRIDLib.LinesAtRootEnum.exLinesAtRoot;
exontrol.EXGRIDLib.Column var_Column = (exgrid1.Columns.Add("Items") as exontrol.EXGRIDLib.Column);
	var_Column.DisplayFilterButton = true;
	var_Column.DisplayFilterPattern = false;
	var_Column.FilterList = exontrol.EXGRIDLib.FilterListEnum.exVisibleItems | exontrol.EXGRIDLib.FilterListEnum.exNoItems | exontrol.EXGRIDLib.FilterListEnum.exSortItemsAsc | exontrol.EXGRIDLib.FilterListEnum.exShowCheckBox | exontrol.EXGRIDLib.FilterListEnum.exShowFocusItem;
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	int h = var_Items.AddItem("Root 1");
	var_Items.InsertItem(h,0,"Child 1");
	var_Items.InsertItem(h,0,"Child 2");
	var_Items.set_ExpandItem(h,true);
	h = var_Items.AddItem("Root 2");
	var_Items.InsertItem(h,0,"Child 1");
	var_Items.InsertItem(h,0,"Child 2");
	var_Items.InsertItem(h,0,"Child 3");
	var_Items.set_ExpandItem(h,true);
exgrid1.EndUpdate();

exgrid1.BeginUpdate();
exgrid1.LinesAtRoot = exontrol.EXGRIDLib.LinesAtRootEnum.exLinesAtRoot;
exontrol.EXGRIDLib.Column var_Column = (exgrid1.Columns.Add("Item") as exontrol.EXGRIDLib.Column);
	var_Column.DisplayFilterButton = true;
	var_Column.DisplayFilterPattern = false;
	var_Column.Filter = "Child 1";
	var_Column.FilterType = exontrol.EXGRIDLib.FilterTypeEnum.exFilter;
exontrol.EXGRIDLib.Column var_Column1 = (exgrid1.Columns.Add("Date") as exontrol.EXGRIDLib.Column);
	var_Column1.DisplayFilterButton = true;
	var_Column1.DisplayFilterPattern = false;
	var_Column1.DisplayFilterDate = true;
	var_Column1.FilterList = exontrol.EXGRIDLib.FilterListEnum.exNoItems | exontrol.EXGRIDLib.FilterListEnum.exShowCheckBox | exontrol.EXGRIDLib.FilterListEnum.exShowFocusItem | exontrol.EXGRIDLib.FilterListEnum.exShowExclude;
	var_Column1.Filter = Convert.ToDateTime("12/28/2010").ToString();
	var_Column1.FilterType = exontrol.EXGRIDLib.FilterTypeEnum.exDate;
exgrid1.FilterCriteria = "%0 or %1";
exgrid1.set_Description(exontrol.EXGRIDLib.DescriptionTypeEnum.exFilterBarOr,"<font ;18><fgcolor=FF0000>or</fgcolor></font>");
exgrid1.set_Description(exontrol.EXGRIDLib.DescriptionTypeEnum.exFilterBarAnd,"<font ;18><fgcolor=FF0000>and</fgcolor></font>");
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	int h = var_Items.AddItem("Root 1");
	var_Items.set_CellValue(var_Items.InsertItem(h,0,"Child 1"),1,Convert.ToDateTime("12/27/2010"));
	var_Items.set_CellValue(var_Items.InsertItem(h,0,"Child 2"),1,Convert.ToDateTime("12/28/2010"));
	var_Items.set_ExpandItem(h,true);
	h = var_Items.AddItem("Root 2");
	var_Items.set_CellValue(var_Items.InsertItem(h,0,"Child 1"),1,Convert.ToDateTime("12/29/2010"));
	var_Items.set_CellValue(var_Items.InsertItem(h,0,"Child 2"),1,Convert.ToDateTime("12/30/2010"));
exgrid1.ApplyFilter();
exgrid1.EndUpdate();

exgrid1.BeginUpdate();
exontrol.EXGRIDLib.Column var_Column = (exgrid1.Columns.Add("Date") as exontrol.EXGRIDLib.Column);
	var_Column.SortType = exontrol.EXGRIDLib.SortTypeEnum.SortDate;
	var_Column.DisplayFilterButton = true;
	var_Column.DisplayFilterPattern = false;
	var_Column.DisplayFilterDate = true;
	var_Column.FilterList = exontrol.EXGRIDLib.FilterListEnum.exNoItems | exontrol.EXGRIDLib.FilterListEnum.exShowCheckBox | exontrol.EXGRIDLib.FilterListEnum.exShowFocusItem | exontrol.EXGRIDLib.FilterListEnum.exShowExclude;
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.AddItem(Convert.ToDateTime("12/27/2010"));
	var_Items.AddItem(Convert.ToDateTime("12/28/2010"));
	var_Items.AddItem(Convert.ToDateTime("12/29/2010"));
	var_Items.AddItem(Convert.ToDateTime("12/30/2010"));
	var_Items.AddItem(Convert.ToDateTime("12/31/2010"));
exgrid1.EndUpdate();

exgrid1.BeginUpdate();
exontrol.EXGRIDLib.Column var_Column = (exgrid1.Columns.Add("Date") as exontrol.EXGRIDLib.Column);
	var_Column.SortType = exontrol.EXGRIDLib.SortTypeEnum.SortDate;
	var_Column.DisplayFilterButton = true;
	var_Column.DisplayFilterPattern = false;
	var_Column.DisplayFilterDate = true;
	var_Column.FilterList = exontrol.EXGRIDLib.FilterListEnum.exNoItems | exontrol.EXGRIDLib.FilterListEnum.exShowCheckBox | exontrol.EXGRIDLib.FilterListEnum.exShowFocusItem;
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.AddItem(Convert.ToDateTime("12/27/2010"));
	var_Items.AddItem(Convert.ToDateTime("12/28/2010"));
	var_Items.AddItem(Convert.ToDateTime("12/29/2010"));
	var_Items.AddItem(Convert.ToDateTime("12/30/2010"));
	var_Items.AddItem(Convert.ToDateTime("12/31/2010"));
exgrid1.EndUpdate();

exgrid1.BeginUpdate();
exontrol.EXGRIDLib.Column var_Column = (exgrid1.Columns.Add("Dates") as exontrol.EXGRIDLib.Column);
	var_Column.SortType = exontrol.EXGRIDLib.SortTypeEnum.SortDate;
	var_Column.DisplayFilterButton = true;
	var_Column.DisplayFilterPattern = true;
	var_Column.DisplayFilterDate = true;
	var_Column.FilterList = exontrol.EXGRIDLib.FilterListEnum.exShowCheckBox | exontrol.EXGRIDLib.FilterListEnum.exShowFocusItem;
	var_Column.Filter = "to 12/27/2010";
	var_Column.FilterType = exontrol.EXGRIDLib.FilterTypeEnum.exDate;
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.AddItem(Convert.ToDateTime("12/27/2010"));
	var_Items.AddItem(Convert.ToDateTime("12/28/2010"));
	var_Items.AddItem(Convert.ToDateTime("12/29/2010"));
	var_Items.AddItem(Convert.ToDateTime("12/30/2010"));
	var_Items.AddItem(Convert.ToDateTime("12/31/2010"));
exgrid1.ApplyFilter();
exgrid1.EndUpdate();

exgrid1.BeginUpdate();
exontrol.EXGRIDLib.Column var_Column = (exgrid1.Columns.Add("Dates") as exontrol.EXGRIDLib.Column);
	var_Column.SortType = exontrol.EXGRIDLib.SortTypeEnum.SortDate;
	var_Column.DisplayFilterButton = true;
	var_Column.DisplayFilterPattern = true;
	var_Column.DisplayFilterDate = true;
	var_Column.FilterList = exontrol.EXGRIDLib.FilterListEnum.exNoItems | exontrol.EXGRIDLib.FilterListEnum.exShowFocusItem;
	var_Column.Filter = "to 12/27/2010";
	var_Column.FilterType = exontrol.EXGRIDLib.FilterTypeEnum.exDate;
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.AddItem(Convert.ToDateTime("12/27/2010"));
	var_Items.AddItem(Convert.ToDateTime("12/28/2010"));
	var_Items.AddItem(Convert.ToDateTime("12/29/2010"));
	var_Items.AddItem(Convert.ToDateTime("12/30/2010"));
	var_Items.AddItem(Convert.ToDateTime("12/31/2010"));
exgrid1.ApplyFilter();
exgrid1.EndUpdate();

exgrid1.BeginUpdate();
exontrol.EXGRIDLib.Column var_Column = (exgrid1.Columns.Add("Dates") as exontrol.EXGRIDLib.Column);
	var_Column.SortType = exontrol.EXGRIDLib.SortTypeEnum.SortDate;
	var_Column.DisplayFilterButton = true;
	var_Column.DisplayFilterPattern = true;
	var_Column.DisplayFilterDate = true;
	var_Column.FilterList = exontrol.EXGRIDLib.FilterListEnum.exNoItems | exontrol.EXGRIDLib.FilterListEnum.exShowFocusItem;
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.AddItem(Convert.ToDateTime("12/27/2010"));
	var_Items.AddItem(Convert.ToDateTime("12/28/2010"));
	var_Items.AddItem(Convert.ToDateTime("12/29/2010"));
	var_Items.AddItem(Convert.ToDateTime("12/30/2010"));
	var_Items.AddItem(Convert.ToDateTime("12/31/2010"));
exgrid1.EndUpdate();

exgrid1.BeginUpdate();
exgrid1.LinesAtRoot = exontrol.EXGRIDLib.LinesAtRootEnum.exLinesAtRoot;
exgrid1.set_Description(exontrol.EXGRIDLib.DescriptionTypeEnum.exFilterBarExclude,"Leaving out");
exontrol.EXGRIDLib.Column var_Column = (exgrid1.Columns.Add("Items") as exontrol.EXGRIDLib.Column);
	var_Column.DisplayFilterButton = true;
	var_Column.DisplayFilterPattern = false;
	var_Column.FilterList = exontrol.EXGRIDLib.FilterListEnum.exShowCheckBox | exontrol.EXGRIDLib.FilterListEnum.exShowFocusItem | exontrol.EXGRIDLib.FilterListEnum.exShowExclude;
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	int h = var_Items.AddItem("Root 1");
	var_Items.InsertItem(h,0,"Child 1");
	var_Items.InsertItem(h,0,"Child 2");
	var_Items.set_ExpandItem(h,true);
	h = var_Items.AddItem("Root 2");
	var_Items.InsertItem(h,0,"Child 1");
exgrid1.EndUpdate();

exgrid1.BeginUpdate();
exgrid1.LinesAtRoot = exontrol.EXGRIDLib.LinesAtRootEnum.exLinesAtRoot;
exontrol.EXGRIDLib.Column var_Column = (exgrid1.Columns.Add("Items") as exontrol.EXGRIDLib.Column);
	var_Column.DisplayFilterButton = true;
	var_Column.DisplayFilterPattern = false;
	var_Column.FilterList = exontrol.EXGRIDLib.FilterListEnum.exShowCheckBox | exontrol.EXGRIDLib.FilterListEnum.exShowFocusItem | exontrol.EXGRIDLib.FilterListEnum.exShowExclude;
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	int h = var_Items.AddItem("Root 1");
	var_Items.InsertItem(h,0,"Child 1");
	var_Items.InsertItem(h,0,"Child 2");
	var_Items.set_ExpandItem(h,true);
	h = var_Items.AddItem("Root 2");
	var_Items.InsertItem(h,0,"Child 1");
exgrid1.EndUpdate();

exgrid1.BeginUpdate();
exgrid1.LinesAtRoot = exontrol.EXGRIDLib.LinesAtRootEnum.exLinesAtRoot;
exontrol.EXGRIDLib.Column var_Column = (exgrid1.Columns.Add("Items") as exontrol.EXGRIDLib.Column);
	var_Column.DisplayFilterButton = true;
	var_Column.DisplayFilterPattern = false;
	var_Column.FilterList = exontrol.EXGRIDLib.FilterListEnum.exShowCheckBox | exontrol.EXGRIDLib.FilterListEnum.exShowFocusItem;
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	int h = var_Items.AddItem("Root 1");
	var_Items.InsertItem(h,0,"Child 1");
	var_Items.InsertItem(h,0,"Child 2");
	var_Items.set_ExpandItem(h,true);
	h = var_Items.AddItem("Root 2");
	var_Items.InsertItem(h,0,"Child 1");
	var_Items.set_SelectItem(var_Items.InsertItem(h,0,"Child 2"),true);
	var_Items.set_ExpandItem(h,true);
exgrid1.EndUpdate();

exgrid1.BeginUpdate();
exgrid1.LinesAtRoot = exontrol.EXGRIDLib.LinesAtRootEnum.exLinesAtRoot;
exontrol.EXGRIDLib.Column var_Column = (exgrid1.Columns.Add("Items") as exontrol.EXGRIDLib.Column);
	var_Column.DisplayFilterButton = true;
	var_Column.DisplayFilterPattern = false;
	var_Column.FilterList = exontrol.EXGRIDLib.FilterListEnum.exNoItems | exontrol.EXGRIDLib.FilterListEnum.exShowBlanks;
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	int h = var_Items.AddItem("Root 1");
	var_Items.InsertItem(h,0,"Child 1");
	var_Items.InsertItem(h,0,"Child 2");
	var_Items.set_ExpandItem(h,true);
	h = var_Items.AddItem("Root 2");
	var_Items.InsertItem(h,0,"Child 1");
	var_Items.InsertItem(h,0,"Child 2");
exgrid1.EndUpdate();

exgrid1.BeginUpdate();
exgrid1.LinesAtRoot = exontrol.EXGRIDLib.LinesAtRootEnum.exLinesAtRoot;
exontrol.EXGRIDLib.Column var_Column = (exgrid1.Columns.Add("Items") as exontrol.EXGRIDLib.Column);
	var_Column.DisplayFilterButton = true;
	var_Column.DisplayFilterPattern = false;
	var_Column.FilterList = exontrol.EXGRIDLib.FilterListEnum.exShowCheckBox | exontrol.EXGRIDLib.FilterListEnum.exShowBlanks;
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	int h = var_Items.AddItem("Root 1");
	var_Items.InsertItem(h,0,"Child 1");
	var_Items.InsertItem(h,0,"Child 2");
	var_Items.set_ExpandItem(h,true);
	h = var_Items.AddItem("Root 2");
	var_Items.InsertItem(h,0,"Child 1");
	var_Items.InsertItem(h,0,"Child 2");
exgrid1.EndUpdate();

exgrid1.BeginUpdate();
exgrid1.LinesAtRoot = exontrol.EXGRIDLib.LinesAtRootEnum.exLinesAtRoot;
exontrol.EXGRIDLib.Column var_Column = (exgrid1.Columns.Add("Items") as exontrol.EXGRIDLib.Column);
	var_Column.DisplayFilterButton = true;
	var_Column.DisplayFilterPattern = false;
	var_Column.FilterList = exontrol.EXGRIDLib.FilterListEnum.exShowCheckBox;
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	int h = var_Items.AddItem("Root 1");
	var_Items.InsertItem(h,0,"Child 1");
	var_Items.InsertItem(h,0,"Child 2");
	var_Items.set_ExpandItem(h,true);
	h = var_Items.AddItem("Root 2");
	var_Items.InsertItem(h,0,"Child 1");
	var_Items.InsertItem(h,0,"Child 2");
exgrid1.EndUpdate();

exgrid1.BeginUpdate();
exgrid1.LinesAtRoot = exontrol.EXGRIDLib.LinesAtRootEnum.exLinesAtRoot;
exontrol.EXGRIDLib.Column var_Column = (exgrid1.Columns.Add("Items") as exontrol.EXGRIDLib.Column);
	var_Column.DisplayFilterButton = true;
	var_Column.DisplayFilterPattern = false;
	var_Column.FilterList = exontrol.EXGRIDLib.FilterListEnum.exSingleSel;
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	int h = var_Items.AddItem("Root 1");
	var_Items.InsertItem(h,0,"Child 1");
	var_Items.InsertItem(h,0,"Child 2");
	var_Items.set_ExpandItem(h,true);
	h = var_Items.AddItem("Root 2");
	var_Items.InsertItem(h,0,"Child 1");
	var_Items.InsertItem(h,0,"Child 2");
exgrid1.EndUpdate();

exgrid1.BeginUpdate();
exgrid1.LinesAtRoot = exontrol.EXGRIDLib.LinesAtRootEnum.exLinesAtRoot;
exgrid1.set_Description(exontrol.EXGRIDLib.DescriptionTypeEnum.exFilterBarAll,"");
exontrol.EXGRIDLib.Column var_Column = (exgrid1.Columns.Add("Items") as exontrol.EXGRIDLib.Column);
	var_Column.DisplayFilterButton = true;
	var_Column.DisplayFilterPattern = true;
	var_Column.FilterList = exontrol.EXGRIDLib.FilterListEnum.exNoItems;
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	int h = var_Items.AddItem("Root 1");
	var_Items.InsertItem(h,0,"Child 1");
	var_Items.InsertItem(h,0,"Child 2");
	var_Items.set_ExpandItem(h,true);
	h = var_Items.AddItem("Root 2");
	var_Items.InsertItem(h,0,"Child 1");
	var_Items.InsertItem(h,0,"Child 2");
exgrid1.EndUpdate();

exgrid1.BeginUpdate();
exgrid1.LinesAtRoot = exontrol.EXGRIDLib.LinesAtRootEnum.exLinesAtRoot;
exontrol.EXGRIDLib.Column var_Column = (exgrid1.Columns.Add("Items") as exontrol.EXGRIDLib.Column);
	var_Column.DisplayFilterButton = true;
	var_Column.DisplayFilterPattern = true;
	var_Column.FilterList = exontrol.EXGRIDLib.FilterListEnum.exNoItems;
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	int h = var_Items.AddItem("Root 1");
	var_Items.InsertItem(h,0,"Child 1");
	var_Items.InsertItem(h,0,"Child 2");
	var_Items.set_ExpandItem(h,true);
	h = var_Items.AddItem("Root 2");
	var_Items.InsertItem(h,0,"Child 1");
	var_Items.InsertItem(h,0,"Child 2");
exgrid1.EndUpdate();

exgrid1.LinesAtRoot = exontrol.EXGRIDLib.LinesAtRootEnum.exGroupLinesOutside;
exgrid1.Indent = 12;
exgrid1.HasLines = exontrol.EXGRIDLib.HierarchyLineEnum.exThinLine;
exgrid1.Columns.Add("Default");
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	int h = var_Items.AddItem("Root 1");
	var_Items.InsertItem(h,0,"Child 1");
	var_Items.InsertItem(h,0,"Child 2");
	var_Items.InsertItem(h,0,"Child 3");
	var_Items.set_ExpandItem(h,true);
	h = var_Items.AddItem("Root 2");
	var_Items.InsertItem(h,0,"Child 1");
	var_Items.InsertItem(h,0,"Child 2");
	var_Items.InsertItem(h,0,"Child 3");

exgrid1.LinesAtRoot = exontrol.EXGRIDLib.LinesAtRootEnum.exGroupLinesAtRoot;
exgrid1.Indent = 12;
exgrid1.Columns.Add("Default");
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	int h = var_Items.AddItem("Root");
	var_Items.InsertItem(h,0,"Child 1");
	var_Items.InsertItem(h,0,"Child 2");
	var_Items.InsertItem(h,0,"Child 3");
	var_Items.set_ExpandItem(h,true);

exgrid1.LinesAtRoot = exontrol.EXGRIDLib.LinesAtRootEnum.exGroupLinesOutside;
exgrid1.Indent = 12;
exgrid1.Columns.Add("Default");
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	int h = var_Items.AddItem("Root 1");
	var_Items.InsertItem(h,0,"Child 1");
	var_Items.InsertItem(h,0,"Child 2");
	var_Items.InsertItem(h,0,"Child 3");
	var_Items.set_ExpandItem(h,true);
	h = var_Items.AddItem("Root 2");
	var_Items.InsertItem(h,0,"Child 1");
	var_Items.InsertItem(h,0,"Child 2");
	var_Items.InsertItem(h,0,"Child 3");

exgrid1.LinesAtRoot = exontrol.EXGRIDLib.LinesAtRootEnum.exGroupLinesInsideLeaf;
exgrid1.Indent = 12;
exgrid1.Columns.Add("Default");
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	int h = var_Items.AddItem("Root");
	var_Items.InsertItem(h,0,"Child 1");
	var_Items.InsertItem(h,0,"Child 2");
	var_Items.InsertItem(h,0,"Child 3");
	var_Items.set_ExpandItem(h,true);

exgrid1.LinesAtRoot = exontrol.EXGRIDLib.LinesAtRootEnum.exGroupLinesInside;
exgrid1.Indent = 12;
exgrid1.Columns.Add("Default");
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	int h = var_Items.AddItem("Root");
	var_Items.InsertItem(h,0,"Child 1");
	var_Items.InsertItem(h,0,"Child 2");
	var_Items.InsertItem(h,0,"Child 3");
	var_Items.set_ExpandItem(h,true);

exgrid1.LinesAtRoot = exontrol.EXGRIDLib.LinesAtRootEnum.exGroupLines;
exgrid1.Indent = 12;
exgrid1.Columns.Add("Default");
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	int h = var_Items.AddItem("Root");
	var_Items.InsertItem(h,0,"Child 1");
	var_Items.InsertItem(var_Items.InsertItem(h,0,"Child 2"),0,"SubChild 2");
	var_Items.InsertItem(h,0,"Child 3");
	var_Items.set_ExpandItem(h,true);

exgrid1.BeginUpdate();
exgrid1.DrawGridLines = exontrol.EXGRIDLib.GridLinesEnum.exRowLines;
exgrid1.DefaultItemHeight = 36;
exgrid1.FullRowSelect = exontrol.EXGRIDLib.CellSelectEnum.exColumnSel;
exontrol.EXGRIDLib.Columns var_Columns = exgrid1.Columns;
	exontrol.EXGRIDLib.Column var_Column = (var_Columns.Add("Column1") as exontrol.EXGRIDLib.Column);
		var_Column.Visible = false;
		var_Column.Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.EditType;
	exontrol.EXGRIDLib.Column var_Column1 = (var_Columns.Add("Column2") as exontrol.EXGRIDLib.Column);
		var_Column1.Visible = false;
		var_Column1.Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.EditType;
	exontrol.EXGRIDLib.Column var_Column2 = (var_Columns.Add("Column3") as exontrol.EXGRIDLib.Column);
		var_Column2.Alignment = exontrol.EXGRIDLib.AlignmentEnum.CenterAlignment;
		var_Column2.HeaderAlignment = exontrol.EXGRIDLib.AlignmentEnum.CenterAlignment;
		var_Column2.Visible = false;
		var_Column2.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellHasButton,true);
		var_Column2.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellButtonAutoWidth,true);
	exontrol.EXGRIDLib.Column var_Column3 = (var_Columns.Add("FormatLevel") as exontrol.EXGRIDLib.Column);
		var_Column3.FormatLevel = "(0/1),2:64";
		var_Column3.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellFormatLevel,var_Column3.FormatLevel);
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	int h = var_Items.AddItem("Cell 1.1");
	var_Items.set_CellValue(h,1,"Cell 1.2");
	var_Items.set_CellValue(h,2,"Cell 1.3");
	h = var_Items.AddItem("Cell 2.1");
	var_Items.set_CellValue(h,1,"Cell 2.2");
	var_Items.set_CellValue(h,2,"Cell 2.3");
exgrid1.EndUpdate();

exgrid1.LinesAtRoot = exontrol.EXGRIDLib.LinesAtRootEnum.exLinesAtRoot;
exontrol.EXGRIDLib.Column var_Column = (exgrid1.Columns.Add("Default") as exontrol.EXGRIDLib.Column);
	var_Column.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true);
	var_Column.PartialCheck = true;
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	int h = var_Items.AddItem("Root");
	var_Items.InsertItem(h,0,"Child 1");
	var_Items.InsertItem(h,0,"Child 2");
	var_Items.set_ExpandItem(h,true);
exontrol.EXGRIDLib.Appearance var_Appearance = exgrid1.VisualAppearance;
	var_Appearance.Add(1,"XP:Button 3 12");
	var_Appearance.Add(2,"XP:Button 3 11");
	var_Appearance.Add(3,"XP:Button 3 10");
exgrid1.set_CheckImage(exontrol.EXGRIDLib.CheckStateEnum.Unchecked,16777216);
exgrid1.set_CheckImage(exontrol.EXGRIDLib.CheckStateEnum.Checked,33554432);
exgrid1.set_CheckImage(exontrol.EXGRIDLib.CheckStateEnum.PartialChecked,50331648);

exontrol.EXGRIDLib.Editor var_Editor = (exgrid1.Columns.Add("Edit") as exontrol.EXGRIDLib.Column).Editor;
	var_Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.EditType;
	var_Editor.set_Option(exontrol.EXGRIDLib.EditorOptionEnum.exEditAllowContextMenu,false);
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.AddItem(10);
	var_Items.AddItem(20);

exontrol.EXGRIDLib.Editor var_Editor = (exgrid1.Columns.Add("DropDownList") as exontrol.EXGRIDLib.Column).Editor;
	var_Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.DropDownListType;
	var_Editor.AddItem(1,"DDList 1",null);
	var_Editor.AddItem(2,"DDList 2",null);
	var_Editor.AddItem(3,"DDList 3",null);
exontrol.EXGRIDLib.Editor var_Editor1 = (exgrid1.Columns.Add("DropDown") as exontrol.EXGRIDLib.Column).Editor;
	var_Editor1.EditType = exontrol.EXGRIDLib.EditTypeEnum.DropDownType;
	var_Editor1.AddItem(1,"DDType 1",null);
	var_Editor1.AddItem(2,"DDType 2",null);
	var_Editor1.AddItem(3,"DDType 3",null);
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.set_CellValue(.AddItem(1),1,exgrid1.Columns[1].Editor.get_FindItem(1));
	var_Items.set_CellValue(.AddItem(2),1,exgrid1.Columns[1].Editor.get_FindItem(2));

exontrol.EXGRIDLib.Editor var_Editor = (exgrid1.Columns.Add("DropDownList") as exontrol.EXGRIDLib.Column).Editor;
	var_Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.DropDownListType;
	var_Editor.AddItem(1,"First item",null);
	var_Editor.AddItem(2,"Second item",null);
	var_Editor.AddItem(3,"Third item",null);
exontrol.EXGRIDLib.Editor var_Editor1 = (exgrid1.Columns.Add("DropDown") as exontrol.EXGRIDLib.Column).Editor;
	var_Editor1.EditType = exontrol.EXGRIDLib.EditTypeEnum.DropDownType;
	var_Editor1.AddItem(1,"First item",null);
	var_Editor1.AddItem(2,"Second item",null);
	var_Editor1.AddItem(3,"Third item",null);
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.set_CellValue(var_Items.AddItem(1),1,"Any");
	var_Items.set_CellValue(var_Items.AddItem(2),1,"Any");

exgrid1.BeginUpdate();
(exgrid1.Columns.Add("Padding-Left") as exontrol.EXGRIDLib.Column).set_Def(exontrol.EXGRIDLib.DefColumnEnum.exHeaderPaddingLeft,18);
exontrol.EXGRIDLib.Column var_Column = (exgrid1.Columns.Add("Padding-Right") as exontrol.EXGRIDLib.Column);
	var_Column.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exHeaderPaddingRight,18);
	var_Column.HeaderAlignment = exontrol.EXGRIDLib.AlignmentEnum.RightAlignment;
exgrid1.EndUpdate();

exgrid1.BeginUpdate();
exgrid1.DrawGridLines = exontrol.EXGRIDLib.GridLinesEnum.exRowLines;
exontrol.EXGRIDLib.Column var_Column = (exgrid1.Columns.Add("Padding-Left") as exontrol.EXGRIDLib.Column);
	var_Column.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true);
	var_Column.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellPaddingLeft,18);
(exgrid1.Columns.Add("No-Padding") as exontrol.EXGRIDLib.Column).set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true);
(exgrid1.Columns.Add("Empty") as exontrol.EXGRIDLib.Column).Position = 0;
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.set_CellValue(var_Items.AddItem("Item A.1"),1,"Item A.2");
	var_Items.set_CellValue(var_Items.AddItem("Item B.1"),1,"Item B.2");
	var_Items.set_CellValue(var_Items.AddItem("Item C.1"),1,"Item C.2");
exgrid1.EndUpdate();

exgrid1.BeginUpdate();
exgrid1.LinesAtRoot = exontrol.EXGRIDLib.LinesAtRootEnum.exLinesAtRoot;
exgrid1.Columns.Add("Items");
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	int h = var_Items.AddItem("Root 1");
	var_Items.InsertItem(h,0,"Child 1");
	var_Items.InsertItem(h,0,"Child 2");
	h = var_Items.AddItem("Root 2");
	var_Items.InsertItem(h,0,"Child 1");
	var_Items.InsertItem(h,0,"Child 2");
	var_Items.set_ExpandItem(0,true);
exgrid1.EndUpdate();
exgrid1.DefaultItemHeight = 12;
exgrid1.Items.set_ItemHeight(0,12);

// Change event - Occurs when the user changes the cell's content.
private void exgrid1_Change(object sender,int Item,int ColIndex,ref object NewValue)
{
	System.Diagnostics.Debug.Print( "Locked:" );
	System.Diagnostics.Debug.Print( exgrid1.Items.get_IsItemLocked(Item).ToString() );
	exontrol.EXGRIDLib.Column var_Column = exgrid1.Columns[ColIndex];
		var_Column.Filter = NewValue.ToString();
		var_Column.FilterType = exontrol.EXGRIDLib.FilterTypeEnum.exPattern;
	exgrid1.ApplyFilter();
}
//this.exgrid1.Change += new exontrol.EXGRIDLib.exg2antt.ChangeEventHandler(this.exgrid1_Change);

// MouseUp event - Occurs when the user releases a mouse button.
private void exgrid1_MouseUpEvent(object sender,short Button,short Shift,int X,int Y)
{
	exgrid1.Edit(exgrid1.Items.get_LockedItem(exontrol.EXGRIDLib.VAlignmentEnum.exTop,0));
}
//this.exgrid1.MouseUpEvent += new exontrol.EXGRIDLib.exg2antt.MouseUpEventHandler(this.exgrid1_MouseUpEvent);

exgrid1.ColumnAutoResize = false;
exgrid1.ScrollBySingleLine = true;
exgrid1.ContinueColumnScroll = false;
// Add 'Microsoft ActiveX Data Objects 6.0 Library' reference to your project.
ADODB.Recordset rs = new ADODB.Recordset();
	rs.Open("Orders","Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Program Files\\Exontrol\\ExGrid\\Sample\\SAMPL" +
"E.MDB",exontrol.ADODB.CursorTypeEnum.adOpenStatic,exontrol.ADODB.LockTypeEnum.adLockOptimistic,0);
exgrid1.DataSource = (rs as ADODB.Recordset);
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.set_LockedItemCount(exontrol.EXGRIDLib.VAlignmentEnum.exTop,2);
	int h = var_Items.get_LockedItem(exontrol.EXGRIDLib.VAlignmentEnum.exTop,0);
	var_Items.get_CellEditor(h,0).EditType = exontrol.EXGRIDLib.EditTypeEnum.EditType;
	h = var_Items.get_LockedItem(exontrol.EXGRIDLib.VAlignmentEnum.exTop,1);
	var_Items.set_ItemHeight(h,4);
	var_Items.set_ItemDivider(h,0);
	var_Items.set_SelectableItem(h,false);

// Event event - Notifies the application once the control fires an event.
private void exgrid1_Event(object sender,int EventID)
{
	System.Diagnostics.Debug.Print( exgrid1.get_EventParam(-2).ToString() );
}
//this.exgrid1.Event += new exontrol.EXGRIDLib.exg2antt.EventEventHandler(this.exgrid1_Event);

exgrid1.BeginUpdate();
exgrid1.DrawGridLines = exontrol.EXGRIDLib.GridLinesEnum.exRowLines;
exgrid1.DefaultItemHeight = 36;
exontrol.EXGRIDLib.Columns var_Columns = exgrid1.Columns;
	exontrol.EXGRIDLib.Column var_Column = (var_Columns.Add("Column1") as exontrol.EXGRIDLib.Column);
		var_Column.Visible = false;
		var_Column.Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.EditType;
	exontrol.EXGRIDLib.Column var_Column1 = (var_Columns.Add("Column2") as exontrol.EXGRIDLib.Column);
		var_Column1.Visible = false;
		var_Column1.Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.EditType;
	(var_Columns.Add("Column3") as exontrol.EXGRIDLib.Column).Visible = false;
	exontrol.EXGRIDLib.Column var_Column2 = (var_Columns.Add("FormatLevel") as exontrol.EXGRIDLib.Column);
		var_Column2.FormatLevel = "(0/1),2";
		var_Column2.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellFormatLevel,var_Column2.FormatLevel);
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	int h = var_Items.AddItem("Cell 1.1");
	var_Items.set_CellValue(h,1,"Cell 1.2");
	var_Items.set_CellValue(h,2,"Cell 1.3");
	h = var_Items.AddItem("Cell 2.1");
	var_Items.set_CellValue(h,1,"Cell 2.2");
	var_Items.set_CellValue(h,2,"Cell 2.3");
exgrid1.EndUpdate();

exgrid1.BeginUpdate();
exgrid1.ColumnAutoResize = false;
exgrid1.ContinueColumnScroll = false;
// Add 'Microsoft ActiveX Data Objects 6.0 Library' reference to your project.
ADODB.Recordset rs = new ADODB.Recordset();
	rs.Open("Orders","Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Program Files\\Exontrol\\ExGrid\\Sample\\SAMPL" +
"E.MDB",exontrol.ADODB.CursorTypeEnum.adOpenStatic,exontrol.ADODB.LockTypeEnum.adLockOptimistic,0);
exgrid1.DataSource = (rs as ADODB.Recordset);
exgrid1.AutoDrag = exontrol.EXGRIDLib.AutoDragEnum.exAutoDragScroll;
exgrid1.EndUpdate();

exgrid1.BeginUpdate();
exgrid1.VisualAppearance.Add(1,"c:\\exontrol\\images\\normal.ebn");
exgrid1.set_HTMLPicture("p1","c:\\exontrol\\images\\card.png");
exgrid1.set_HTMLPicture("p2","c:\\exontrol\\images\\sun.png");
exgrid1.AutoDrag = exontrol.EXGRIDLib.AutoDragEnum.exAutoDragCopySnapShot;
exgrid1.LinesAtRoot = exontrol.EXGRIDLib.LinesAtRootEnum.exNoLinesAtRoot;
exgrid1.HasLines = exontrol.EXGRIDLib.HierarchyLineEnum.exThinLine;
exgrid1.ShowFocusRect = false;
exgrid1.DefaultItemHeight = 26;
exgrid1.Columns.Add("Task");
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	int h = var_Items.AddItem("<img>p1:32</img>Group 1");
	var_Items.set_CellValueFormat(h,0,exontrol.EXGRIDLib.ValueFormatEnum.exHTML);
	var_Items.set_ItemDivider(h,0);
	var_Items.set_ItemBold(h,true);
	int h1 = var_Items.InsertItem(h,0,"Task 1");
	int h2 = var_Items.InsertItem(h,0,"Task 2");
	int h3 = var_Items.InsertItem(h,0,"Task 3");
	h = var_Items.AddItem("<img>p2:32</img>Group 2");
	var_Items.set_CellValueFormat(h,0,exontrol.EXGRIDLib.ValueFormatEnum.exHTML);
	var_Items.set_ItemBold(h,true);
	var_Items.set_ItemDivider(h,0);
	h1 = var_Items.InsertItem(h,0,"Task");
	var_Items.set_ExpandItem(0,true);
exgrid1.EndUpdate();

exgrid1.BeginUpdate();
exgrid1.set_HTMLPicture("p1","gCJKBOI4NBQaBQAhQNJJIIhShQAIERFQIA0RAYGLriiIEM5BJpBiIARYlMBNhQPLhJIhBKhoQLlTTLV4la5VYx/fZVOoee7" +
"de62drYdI4YIWcIteIQEbEEAzCghEwIRIZKSmJD8EIZMzARgZKYmEAmDISYgEAISIJKdg4JzSOK7bp9b73HiqezeNYxLD7Th" +
"7N67dpmQSQIZJUpzVRqT46PY9Xy1yL2Qz/c6HXbzHoAKYgWrzC7tZDtLgBOpzOajQApWDXZwOdABb6eHa+fCHMTCB7AMo7S6" +
"AIxMcADcAIfHEe6AQ7/G7zfhfHqeAb/AJ8B6TfITMAVGLrd4Db78aY/fydH77axfPjjS5fP7tcLMY6EOYed4dbyHcwHCoHfA" +
"ICCApOHEDgcA+OAnACAJgBya5jAoLh5hCc4OGcQ47GeQIBneNoGHaTI5kAKxOHuHAzjGXp5mwAZgnyNB/nCPh9g+ABinGYA1" +
"kmGYAAqThjgGQRwHiThPC8Vhfnma5/ngXZvn8ew7keQBfmOUAYCIBj7ngbY/nqS4/nkDYzieXwLn+dp+j+EpiE8CAAEKNwZF" +
"OTZ3FCOpgHyRQHkCcAJmUDRzgEHwhAYHoRAGHxADuCAxAeDxOAcHA3jmRw4guaoamcbZMAwM4EDWTkNgGqQqHYPJEDmKhrDw" +
"B4QmcKAsgkcQGGQHBLiYfBGjcCESFATIID0KgDjgBJ3hGVQVk4JZqHcbpklef58g+fwFScd09j+AwnECWY0FeEIBFmdIyAsZ" +
"4fHyEIRB6Ch4F8UZLDWdQ5CAAheEOTAxGmWgDhqYIaEGO4AgiAYNm8RhwACKo4HaCgviCHptB4Uo9ACAQlFsG5rEINAFh4Wp" +
"xAQRAqE4QAlGARJGjmLw2EYfAdk8DIomYGJKjISY5AiChKGYIg/EMUg7iEGZ7B8GABn4Do0jYWRVASMgiGoLwTHMdJKEkaI9" +
"CaZwej6H85mcCAGlwBQfFoH4bFyJgEAOdRBBCEoSC4ZpUAOOpwBURBbieeYzEeKwIAOJQAFSVABp6U5Kg+PhvkGex8HAOJnE" +
"2ZgPF4WY1kQHALiic54lcYYQiAQ55g6VQbHMdZfjyF4PCYTTLkaAQGCadRIE0VImlQLQgm0EhalsNYMkgHRMDKHpiGoEYmlA" +
"RpZDQYQMiECYzHwQhEHCKZOmOVZ+mMJYgFqIRgBYVoLCmXgHlAaoeCUYJKgcU4IneHoQiIQR5kIDBEBiGhMDoHgL4CQ/BiBe" +
"EIOILgRBaBwL8fweAZiZGaNEWoYBwjuBSAAOoiASBECMJwG44Qih6EEDMcIRBmCyBcPQRgwwBCRECJgPQ+h0gRBCDQZYNwXj" +
"wB8FAVYvQsC8BSKYWy+BvABC8DwSobAghSAEOoFgjGKAVEeJCA4oBxDZB2PwWQCWqgQAkCEAgfA4D2HSB0PwEwsBdCICkBoK" +
"gIjVAEFcD4gw8D0CsAEXwnQtgFBoAUPIahmiICANQRwWgjCDGKAsbwEBaCjEozkWQDhECcCiMsIAjBIiQBMAYA4DRUCMBsCk" +
"YA+xaCFESG8P4LwBCqGqIQOgiRtASESIYOA+xmAnCoIUYo1QJhiE4BIAT+REghVkG0SwcgnCbAEJoI44QoCnFQFQCgjx0BdC" +
"SG8XIzQegFc0KgbIJgWgkDUBkOIrgEicCOKAM4HBwDnA+JkIQXg9jYBmJ1SI3w4hxDsIYNQzxnDeEUPkZwIQfAaFcE0LQmws" +
"AtEsEYAo8BXCjCsEAAYLggDQEIOQYIsBWgeFSBkEo4A+iPBQIQGAIQ8AIBCBEPowBDjQCkKQAAHhoiMBGFEWoggFDqEkBkIA" +
"7RcjKDwNcAYthjh9AeBAIoKhCDUDaD0YIewUAlFiFoRqrBlhVGOHoAoXw9ADH0H4cA2RZieFmAsZAQwnitHgPoS4RhfDyEqH" +
"MaQcAhiaHoAQa4gwDCzCEB4GISgIgACeM0DIHwQi0AZAkOIGgoCfFQncQ4ZhcgqHYB8HwagsCPGaOoZwAhQATHGAwKgcAAiV" +
"GMjsSIihRBcFeK4CILQ7hjGAMsCoUBSgiEANMYg1RiiCAoKAd45wuCeDMK4VwYAbA3AQDgIwchDCUD2EIdAqA8gkCuAsSgXQ" +
"ZCcFeFcM4jAxhPHYOYZgdxHChAwCwJQhQ4hMB4H8SwKAKgeA4MMfwQQRV9qGPcGwUQDjOBOGoDwUA9BWBuJ8CEIxlh7G+MgK" +
"gxRciEEkHERo9hUBWWIJURgqhRA4CoEsJYjxXhQAAKKoY8R6DjGYLMaYjgMAgBKKgAQwQ7jcBYGAP4Fx9TnE8MMOgAhDiHFg" +
"FgYAcAFA7F2DATYdxGCjCCGcWIgBzinAWI4R4MxZh5FEMgEIVwrgzCUPESgIhCCYCwP4CgPg/DiASDEQIwhnBuBIMYIQ6g9X" +
"2D2GYOYmxTD3AcB8CQ3hbh4FaGoHI3gkj7HIE4awEAiAtAaCkXwxQSBAH6CsEAgBhi5BSMscoihug5HxmgLgZQFhYAqKYGIM" +
"RPgvCwCwFgqh9gwFOOQAoKg4D8pm2UOIeQOAAHwOgEYWBXA7BcC4I4tBHDgBlkoQ95x7hJFaN4OgwRbgAHWPEYIcw6gFFqEY" +
"UwUxnhsB8DITYGQciaHeL0bIKBZADAoG0CgFxWioDuGYNolQLAEAWkEagowVCs2SFAeIWBzD7A5NwC4kAuB4DgAQWYqRuj7G" +
"SAoQwDCtgZH0OQCYGBjgOAiDgbAzxmBmDgHzjQQBvh3k+CwS4PR1jRHEMcNgAhLgXGMCsPgGAsguGeBkQ4cxTDzCGKYWYfQp" +
"DwCoAoRQZwzguA4B4BrVhsA7HhycDIpQjhrDCHkeoiR4gLDQIQYIXAtMfD6EAdQaBrMBEiLEJIFAoAdCiBEKgow8jNHOCqwg" +
"rhMi+A2PEMIThWiZFcIMaoCBIhEGSJkTgOwhCAFGAcBIRxvCmBqIcLIvwrC4FyIEdYBRqDaEiEcRAYRBi/GcFIc4OBJDLCmN" +
"YVYGwzdGBMNMDIqgYC2DyO8dwQQLgHCWLsJwEB4hIHGNkVwWRvreAiI0LQKwRDZGwKAVgUQGD7AcEEUgIAnBQFEI0f4XAEO6" +
"GsHADoaBSDkEKE0DQwwoCuBMMwQYBx4DwAIEoDwjQOBYhUgNhGAGBwgWB9gCADhXBZhkBfgtAAgFApBNhKABAcuohnAPhphu" +
"g6B2B3BehghyAghRArAWBgAjBghDhPApAZF1DsB4hjAlBUBFBEhThiheArAFhVBtB1BIhuBiAHgUALBMgXhXg/hGAqAggbAu" +
"B+hZgKgQHdBSgTAxA2A1AfBDhigRBAgyBzApgFhAAjh9goAlhvBSBsArACsBgshABBhNgVgphqBvBAg8higxA0hPhoghhkgN" +
"gcBaBtBRhhBdBHB2B2AeBQgFgRhxh4ADAYgsgtBWBahchdBgB6h8gjgTBMABgIgghqh0AXAcAJhtBEAQAVBigZBMh5hUAKBN" +
"guAKAph+BVgQBYBglUBUgKgbAOhZgEgOAOhghygagOAOAgAlARhRA5hOByAWh6g6p/gugChjAAhrABhWBDBHA6hDByBtgaBe" +
"g8hpATBVvSg2vRgDhSAHJxvQA+AhB4A5hJB3h0gzgjhUAEBagFAnhPg/g2BUhIqJhchGA3hUgJBmh8BIAmAAgnB4BnBxhegj" +
"gMgtAyhsgphVheAdADA+O2hAhzB4AQBxA+AzAsABhpBYgBATBuhOheB1BshTBNBZg5gsBWAWAnBWALBYBUAOwAh0gTARhoB4" +
"segWBrg4A/Awhgh5h6Bch4hFhRghgFhSAjgjhwAshYBcAfAhh1AgAkAeg3geh5A8G2BSh6gHAAAVBnAghGBQBdA3A+gEAggM" +
"gfhqgth4BQlMBXgGBBA3BJgxhZg0g7BVhEBhB/A3AxBahlBWP0g7BMh0h9BiBoh/AkBvhMh4AqnwABhjAWh0hEBUgCgjh2gU" +
"A1gcAdBAhOgOhMAmBggZh5BjA1gOgtBQh3h2hWBCg2gLgpAVsNBWhnAUBZhAhfBvgRhCAwASh6hbAUgyBihJBEBwA6gmh4Bg" +
"gBBSBBAygABghEgIgWAaBQB3BKgFAYBRAQAFBggig0BGgFAIg5hYhKBwB5BlAYBegPAwAuA6h2B3hhhnA+ASBiBGA5g4BYAD" +
"gYhGBUBBhVhNhcgispBFA4A/hnhyAFhnAEBKH9hjh6gNBnAnAwgfB1gMhjhAh0hmBsAwBWhQAsBygshDAChYhNhZguB6AuES" +
"BeB+gXB+ByABg3gugVgeAvg9g7hwBBgPh3z/AmATBYA/gsBshthngrBlBZhiBCgugaBeAFABBnA2h4hWAtB3BcBnBWghAxA1" +
"g/BCACBFgahKAFA+hrgIimgXAIhhBkBghAhihCwVArhshvA4h+AwASAChAAHAqhVgVoTB5B1gIoOAxBBBphzgegbgFgcAeB2" +
"BggMgWA1BDBWB4BxgHgLAmMrBrB1gHAUgdgeA9BdgJEbhDgfhNAQhah5B7AXhWhIhdByAjh3gCgpB2Acg+hvB5hzBLhLhSBn" +
"B0BdhfBSBfqRgNhVAFAQhMB1hrhNAEhQhY1SB0ANAxgxA7gDg7A7gwBWAMg+BRB1hmBxApAjhlhtg6ADBAhdA8g8hZBpArBG" +
"ANBFhTA2g3hQhLBIhshWBxhggQgmA9g8B/BeBxzzh/AXh8JCgDAqAdglAMg8B+AJhMBnBwB0BgggAPAjhrBFgThqA4gigPAD" +
"giAVASudB6gJBUhAgtAwB3h4BFFxhwBhh7hQhyAhBnAlh6ASgOh/B9gFBIBrA8g6hbh2hWgrBmgpA1BjB9gkAmAWgAALBMA7" +
"g4A6AABnA6hLACglBjBChCAVBth9Atg1BTB3gGhZhhg0BrhvBNhJBSBvAzBTBjgnhwBTgPhhBig8hjsJBIgRBKhPBJAjgXAX" +
"oYgPAHAHgABrhRhoB8U0B5BzBGBqhxBFAVAYBGAVg5BUhqAtAMhrgFhzAdgbhSAqA8B7AKAlAvB4gJANB4AxALAoAiVhpxBk" +
"hqBZARBiAUgZBXBbAvKRARAzhFgGg9hdhMhshmAMARAMAIh5BnBeAgA6AyAdAMhUi4BeBPhsBMqrgzhJh3BdAchRARhXBYhh" +
"AYg7guAuhGAEBzAchLgrhYBeAMosB0AUB8hNBygmhnquAbgbgOgHAVhaA/B6AvBvgwBthRhdBwB9h/g3A4BEhohdBgh3h/gw" +
"A3BHge0eg4B6BwBLBtg+BHABAOBagzApBNApBOh6gBghB5gBAI4QgLhTAEBMhBgugRgkhnAihOBlgtglhLBNBEg0hFBzBIvE" +
"hbhvBYBkB3gugzg+BehNBTg8A3hrhRBjAGhvA/BqBwhuBkBigygjgkAOgugbg5A+gGhpgkhnhkghh1gvAdAzhWhdBLBWAoAM" +
"h4BYhbg3AqAZBHhBBjhiB/ACBqgPBjhADNAfh+hoBdAtgpAfgmhCh3gghgANBIg2BegABQAaAXg0AHBBBLAxAYM0AiBXg6gy" +
"hSgWANhLgzglhRAoBMB6ARgpAWhWg3BtBrR9hAAqg8gLAPtxAZhlgZAjhDgRgHgn1PgEBhgxBiB9hHAHgfgAAI09A1BYhZqN" +
"AwAYAHBWklgGBsgIBYhizSB4BMA4g8BjBcLHXkhCjqAIg1AsgwPRhWhsBshcBJBqgEhMhhhBgUg8gsA2gCgHAQhBYYAzBaBA" +
"gnBkgAARgRZShpgLANA3BxgChmgVhyBnAmBBADgaBJmrh0iUB+hwB+gzB+h2gyA9hRhigdAIA+BHhkAkgtnMgAhehShtAHZz" +
"BRgUidgqNYrtR1hThggtAEAfAohiBCBOA6AjA4gyhZgHA4ATg3BsB6g2hytDhPQwhjD5gLAVp+BDBsATgppBBkgMhzgdoOP+" +
"YahHB0BBW7gHBHAdBDB6hkB4gEhqAdB4ByBRhPBbuqBLBrACAPB/g2BwBmhbhPBQgWg2h/B2BhgJhvA+B6AGBzhwB+AGOkAJ" +
"hSB6B0All2BUgaB0BtAtBEgkBjAbgbAUBJBbh7rOgyh9h2A7B2A+gzhtACAmBaZ1Bqh6BWgWgmgrAMvbBdgLALgjAOA0gdsE" +
"BfhlgLAhhrA1hcBcBYAzhaggAUgoAjBxgQhpBVBoBJBsgXBzBqI4gLgTgGB1gJgHBHgNApg+gkgLA8BQgjhqAaBqBpBQA1gu" +
"h5gWg6BNB/hEhvArhkBlhdBWgbBDA9gxgbAChuAjAcA2hSh6ATBWgkglhPhNgKAEhOgug1hxB0AEA3BXBmhRQRAZBrgBApBP" +
"g2g8hCgaByhUE8BUhKhwBHvMhKhwhrAPA9h4g8A0gYhaBMhqAzhvA/h4hwhlgDA/hrBQh7g1gDBcAug4AogAhSAhgbh6hiAj" +
"AQg1BXB+h9B1gjBKBdACBageBxh0hpgJgOATgUATBwBJhPhPhwAeh6ApzQgnA8B2glgegVBhgrAgg9AlgChbgZhHAXhvBsAu" +
"BeA2ArhiA7BoBFgHgvgZBsBIgvBVAMA1gxgAhtA2hfg3geBkAlB1BYrbhbgKhzBbBUhEpeMhgOhnA+hGg7hvBQhWgwBGhSB3" +
"A1heB5h3AahUhvhahtBvgGhQAOgRBhhbAtg6gDgBA2gEhjBtTmA2gMgshvOYB8h4B8BVgLAig+g1AGhChtheBdgIh0B3AZgY" +
"B5B5gUgCg8BBhghFglBdAHhLg8ccBaghgShvB0hwAhBWgxglhlgNgkBSArA612tcg6gZhrBLUohIgZBQZVAWFNh1h/BVhyBN" +
"hNgGAKA2BTgkAAhtgQhZBsgdB5BPhvh8hNhfh9h9A3g+h5gNhfhdAdB9B+h0Ahg2BmgiBYhGgGhYB2hUh8gIAthHhXA2hEB4" +
"BbB0E5haBwAOBvAjgxgvBtgTBFhjg8hHhqA5A/gmA2glhxg2gJhDAWhKhsg5BLgChrhth9n6giAVgwhhhnhOg0hlBuh8h3O1" +
"g6h5gdg5gPhzgOhZAvBKg/h9EuB+AXhwAEg4TXBIhUgHAtgTA/AOg8AJh8ARhwBrhsAaABA/hYhHBFAEh/gXhgA9pRk8BjA8" +
"g7hAgxg2A3hoAIhbAsg1BFAUhxBFhfAohVAAhFAAhZh+AphwAYhbAzg0BsXwBcBugUhbBhh2g7Acgt5fhxAPhBAwg/AEguW/" +
"hgAkBBhgBzA0Bdg3faBwBFg3h+hmhYh4hBfSgxg5h1A/gBheADASgcAKg/gJAjCRgkgignAiBXAhAwBBCAg==");
exgrid1.set_HTMLPicture("p2","gCJKBOI4NBQaBQAhQNJJIIhShQAFUREQIA0RFKQJY2iIJOBILJzhQOYkjYgBSorBwbhQKJ5pIZDKBQNBvOhvOc1OAgJMxEB" +
"wORvMxpNhlhR4bSdKZnKhTdIWHr3bz0IRLRCAShLN5SCoIEBSISLQAUSImFQhBIQJSIEKhbIVKLBCJFIoEDbIUCIAaORyARl" +
"wFgMRQKbAHcghUSOQajRCKZT7cJ7UZray8e7mZr+WrXHznVjzTqzZ4HYAIBiWJAzKI1QAMVJCDwRcCDY7EYzhcguICBBQkOA" +
"ACAIWZkEJzfojAIAfB+Hg8FYiYAHXwAAJ4aYLBAAYBNTbAGAcQ7/B7qISZLgBQCEALAOiRHBLBFjABAPSOISm+ZG9CdTAmKY" +
"AFAAgADAZYxjEcYACgFsBhOP5zGmABAE6fBMj25ItkoEIKgCUBIgAEAJjKRAiAANAdgAVhnisRQigALAYAACgzCWYgcgAbEF" +
"hgJIrjMJAAFgW7tGcCAFlkADTAAGAokQQoUgAAg9wGZARhGPAAEITMYiMeQrh4eIVlcCBzomAA8EyWQeFyEgciKQItgQFo4g" +
"OK4rhcDwUGcJILhWCgbDCAQwk0IAXGEPJMgyGRAhoB5wHmZiFQ6CrZEGeZ+jwZwHFcZxnBsRxbAcL4WnUX4DH+EQxQOfxyme" +
"VY4CAhRwjoPxon8FgXlmDRAB2AxADafxRBKdwCDQLwFlAOp7kWMxZAeIBawAdJtCueY4OW5oilCSBcmybJynIchsCUYghC2M" +
"JlCuPp/DOYQvmAK5+jYfLmH4e56nAXxxBIQIZC6QIjgIfBwGEZh6CYUoOGeSQEkIMRuHMR4jn4W4Fn+fgOmmERiCSMRciwFQ" +
"KHGKIJDiRwiE0Rh5hkUoRESIRJBSYoSmkf4yHEb4WH2AYfG+GsfjUHwAj2SIWlQLoxgGewlhOCAsDoYBxHuhR5F2N5gmoFAE" +
"AGQA0EGcJnjuf53h+fojlAEsIjMJJJDihQvCIEgXCoZRZh+Y7sgAIhQECFRYCCDZ6GCDAWGAAwOGCApuGCBZ+DAGxCCEEhiG" +
"EIQICEBQyEADg5DAFJWEEIQUEMZpYA6FQwBeaggA6GhgCiNBDEmOAHUIKpcAcHo4AefQwgQTxghQXhAgSAggmQBAJjCEJtEQ" +
"AIxEULARkcBALkyQp8BCYIkAICRFhIEBkkQCgohEJZIhqJAYikRQqBAKokA6eQejkAQckOLgjF0SIdmQAAZEEPwQwvAjgxEo" +
"IEWQUQejUAYLUIYuRUA3A0IQIwogFjQDIHQGImhHgWFAJsaAchaAaB6IwGwoRzjQFWGgB42hHg+CGMcGAwB0AYAODMYgbAYA" +
"uGMMMIQsQcAsASJMMYyxYgiFYAwVYxgNCwCsKwAYuxEj1DGM8WId3tiBCKMABINgCB3CECAMIHgghICwEwLAThsBIFQCADgJ" +
"AaARG0AkG4CQBiECiMIE4IhJioCWLQEwugIj5GIBgMQMgYiHCwEgFgIxrASEeBMF4EA9iICGMQG4JAJCJCGDIE4uRIACCSLE" +
"UgVBpASGkEYaQbgpAjHSCwVImwaBIA0CMSYyRtBkDWLIA4ORKAsBACsZAhRyCdHIMMcgMxyAbMOPILYChOhiCAHEUg+ApjiB" +
"QFIZQaglAZHKBAcoNBygGDKJgGQQQqijE0FIboqBQhUAiDUR4WghCtFCLYKQrwoiHFQBMGgdRNA5GaIMCwSQlilFaKISo0wN" +
"BoAuGge4aRXjoDpIAbolQPBOEuNAK40hljpCOOgS46ABj0DuAwBohgKm0EQGcFAGRNw0AwGcDIdwMCvEwEwUwGRpiLAyMcKg" +
"MAbgxHWJgc4mQHiZDeFVjwtgVB8AqJEZQChKhKEqCYSoGwVAvCoKkVQphVDeFUAsKo8wqjLCoI8VIXgph9FcEYKoMwpjjFSA" +
"kaglhVhVFUJ0KA6wpgbKWKkHYqBDiqDOKgN4VAfikD8FkfoiQDBZGGEwYYTwhikCiKAWIXxxi8GMCABYYwMizDwCwEIawGir" +
"EMHUQINRiAmFiM0bIfA7AqF2JgfoHRdiLB6KoVIoQchDBmEoGYVxZhSHmJQMwPwDjjEwHEfAnA6BOASOcFApxLjzD8IobwFB" +
"3gpHECkDYpgaBMFyDEMoXA1iqEsJcSwWBVhIFWFEVYRx1i9BsK4dopxOimF6EUXYWR9iBAcEEY4SgThcBOEcM4jxnAFE6OcK" +
"Y2QpjdFOAoU4Fgmg9B0PUVwLhVBrFKBsUIuwiB3F+G4U47hMCeF8F4QAngmBvFON4PIvRzj6A4H0F4/QqD9DaPoU49QjgMCw" +
"AYWYDASAGG2AwZwGAeDFBqHEN4PAOgvGONseIUQhhdGGEAIYpQwiVDCJccIhBIi5GiDwUY1QjCNCMA8RgaRjBcHGCQcYbRjZ" +
"4FGCYAwJgQgmCWE0dQTR3TpCaLkUwKRTA7CZowY4zRmDNFEM0awmQaibB6DEa4Mhzib06NcTY3xbhgC0HgLQLBbCoFsLgMoS" +
"RZDkC0KYLI7hbC8DcIULQOQsilCwFULQXRZhGFaJ0VoJRrC7FaLsU4ERTi5CcJMJwqxPDWDOMMWA8RbDJFsKkW4GRYDlGxko" +
"Vwtg2i2D6GEM4YgLhnFuMUVwwx3CTF6JMPoug+iNH6D0A4DRDjZAcKsDoWgOh+DmLQOQFAdBWB0N4TQzhODuB+H0Yo9BLDpB" +
"eGcLAzwIDPGwDMcYtgJjLBSMQNJShNjTwVusXIc1KCIEWIkJYghlguEuD4FwmwNjGG6MgXo5AlB0HqHELo4Q9DSHqJ0TYsxN" +
"jCHaKgbYrx3A2HcGkdwhxuCfGYDQT4KRPBZBmHMaAwxkBDHAFEco0QfgLE+JUGAaxvisD9ZQJ4gQzi1HOCMF4YwXiRCuK0a6" +
"QBSh3FUPcMI7wLg+HsD4OQnxxg+HGDwG43gZDeCyF8ZgNxgC3GQLcZYTxhhvE8F8Qo3whh/BGzQf4eh/jRAAKcQAJQAhnAGI" +
"kQIQU3ACH2PgPQfAQi/EcD8HQ2wyj2FkNkdoQRGCgFyEECoQRHiCFaIIcowRWghDQMgdgkPqj3HOJgZwkRnBpAcIUKAfh0DW" +
"GgAcMI5gwiLGGH4BgJxCiHEKFcQwPxHBwEQFgDQ0QYhLgag7hohuAhg5hvgiB9AiBLAiBvBNgzgYgngchXgWglAagVAfBVAX" +
"A1AeBtAbhdAaBdAfhjAXAzAshmBqgsBOgsAkg2AlgOAcgXAVBXAbA3A2BfBvh+B2h5hDhxBOhxAFhxg9gLhMAXhkAug4A8hQ" +
"hnBhB6BCsLhUgXAJAWAdBLAgAmBEAnAcBKB4AggIAVBUALBGASh5AJg7gShHAFA8hhAOhhAzgRAXhogbBohEBsAhguAVKLh5" +
"AkAVAmg9BJB2BIheAag8gSBigZhSgWByhchCAThUhIBeAmAGgmBuhNgdBPALBNA7AQA2gZMNBegYhBhJBIhIA4ghBVAQgmhJ" +
"hbAzh1AzhzAzA7BlhWAyhChZB/Big3BFhbgXgPBKgDhkg1hZhIBWACgsgWgFBbD7h0AqAtAUBrgVADhZAzgykeBfhmhEhlAc" +
"q7BPAVhmh2hmBZhlBthIAbhOB3hPh/h2gJBhAJBwhJBbBShDAlgrgWgOgsBzBehWA1Ack0A4g8htgFBxgKgCgVhDArADBWAe" +
"BcBFKmA2hqgnhVh2grhLhXA/BegTA9Amg1hAgvBghlBBBghagAg1h1qxAFByhCg+h1huBrh2gugngsAXgshvhagwh9BDBOgN" +
"gfAKhEhFBXAKBtgLhLgKg/hsAUBuA8BygNhDg3hlBfhMhuBKBaBUhVhiBcgyBngzBpAzB0hzBvAWhPAtgHBLBVBLhzBLgHA3" +
"AGhshtBaAGhvgrBaB2h6h7AihtgXhLhmgUBthdhBhbIGhRhfyFBeAyhThkhnBmgdgfgqJRh6AqB9AqOpBpBuyahrh8A3Boh3" +
"ANg9heB7AaB2BqhtgtjLB+gfBkhfBtgqgAgqgmhqgzBqgyh9gkh9hZh7gfhXBEhVB0h8BLB9g2guhWgnA2g4h2hjgBhpABh+" +
"gDgRgHBbBrhchqBqgOhpAegqApBHhrAVh1gjgHBjgPhfB/BOh3g7gWgGgbAGgqhGhOBjBxARg4AiA8hyB0h7gEhvh7gPAGgd" +
"BtA7BGA9hWBwgDhpgPg7AOgzsqg1AhBNB5BNAjBNgphNB9gtgxAthdAnhmAfBohrB1BvA9B+AjhtgPgHhOAaAeAsg8glB5gq" +
"Bkg0htB0hBBphJgzh5BnhGBOhKhOg+g/AXB8huAwBthRBbA9hzgxhnBvg1AHg3h3hdAIA6BwhpAih/hFhzgdheAdhnAuB5Bc" +
"A6B5BZBthygJgrhcArhNBXgdAvg2h1A6B1AeB/BJhpgnhjhdhOBdhNBXBcr0Bch3A9Behag9gzB7h0gNhPAbhnBuh6Beg8h4" +
"gLB/hrBqhPAcgehuheh5g9A3h7hil6hvgLBug/A5ATh+hnBlhdhsg7gTh3BWheAnheAvh6AgPjhsghhuhDhqgfgth/BuBsB3" +
"huA/g1BgA7hQB5wBgjh7gDBChBhnh/BIh6hHgHghgChHhMhHhlhDKTh1hPAcAfAcgchxAfg5B+h0h+BTghhnysATBPALlfh/" +
"BlhXALgLAXg/B8Bqh1hrhnBohMBohQhLh5BLhJhfg2g+BSh+h1BgB1gMhXhthjBhBjAPBfBkg8AZgYgvB6ArB9h2hgg7huA7" +
"gOh3hRhvgHgnhyA+AQA/gUB/g0B8hYh6gphoBTh9hJgMhJhJh/gCABhMB5h+AxgZgWhtiIgCAzgggmggiFBYhHA+B9gohJiI" +
"gQAxgkApAmiFA9GzkIhBiFB8h/iFBAB0iFA6kYAAB1AwCFAdBMCFALg3hJAvhigjCFAFh9AkgiAggqCkBWBMAshHguhjg4hj" +
"h/15Bsh3AZB7hnAGBDghg1AiBMgtCQBZASgtycBigkBIALh9gSg3gghfAgAfAkhfAkAIByASggBADqBBAWAgB5AIACBEAxAl" +
"hbAygWhqM8hDBRAcAZhOB6g3Azh0hWh5AYKaBpAItWg4gBhCg9hABBhth+h1h/quMOgxAzB+BygvjjhfBlAwAIBWA6AUA6gF" +
"hUAfBFBzALAKg6AEBGAvAIgzB5AVhnAyAngChRhuBag1hnhUh029AQh6hKxyhoh9g8BzgOh4A1grgZguB/hnANh8Bbg/g/AN" +
"gigjAIAihHBTBKhlhMgEh1BwAmhUBqAAASAPBWh7hxhfh8BtgjhngFBvgwAYBEBKBGAAATi5ABA2gWhshEhSAlBMg6gfBChO" +
"h7g3puANoXhJgYB2ArgMAHHyBggGAxATA+BZh4haggFDhBBEACAIh6hzA9gtA0BQhZJWhxh9gbhMhMhBhkBIBjhSBthzBgg7" +
"BogvgLhbAch2g1BIgFAtBvhYBaA+gMBhAwBVAxhwAQAkBNASBEBnh7AGBABMggAiB/g3goAlAIAIBBEKBxAqAzBNBSA6Apg9" +
"h2AKBXgFBIhlguBzgUhqBJBlgogmBXAUhCgahPB9A9AgAehlA+rahPh2APh5hkg4gvg+gYBcgbA2hxgjgigRB1gqgpALBWg3" +
"BaAQAxASArAZGMgEAiglh5BXgEg9BbAigJAaBWAPhIBmgShKgqgUhqg6AfhFhnB1gZAWA6A2AyBPA9BigQBFgjhehUBegRgb" +
"gXhahmhWgaBYgHgihcgJAugJheAFhIB5h6AuA9BLhqhXAZwQgLB7h8hMgpgqhrh9BlA4ANAJg6g4hSgYB8WMhYBDBfBbBRBz" +
"h/gIBGACBOglg6h4h0BrhSh1gvgFhCBbBpA/BPBsglAKhfBMgygRBpAVA8BfAMhBgkA2grhNgbBrANhJAtgVhzBVMVhPAdAx" +
"gahxgwA5AdAYBqgoA9gpBnB9gCh3hvBPBWg2BGh6BfBbtKBlBAAMh5kBBiB0hYhSg/gdgUAAgcAHgegogUALAvAGgyBb3VhV" +
"BehNhxg7A2gehyAcgugmBYgPAYBmg9hujAgxgtAuAig9o/BzhZgwhDAwSBhEg0hLBhAeA3BihvB4AQAChahWgVgwhqhlAUAm" +
"TbB9yUBmhGgFgUh9BEg5hehXBqhrg+APBvArACAoBqAehnh+BqgKBSg5gxgTAogMBTg9xxAIABhzBygYAqg6AZAUAzBdhShn" +
"h6AoBCh7BSkZAR0+h9hqhFg9B9U+Agg3heg/g6gmhMBeABAgBEBvAwgfBPh+ByA4A/h7iagIgfgmArBvAegcA4B/g0h9heh1" +
"hdBhBkhhhRg3A3A9gVhpF0hXhxhJg9S8Bxg1hDg9hvA8OKhbhBBpBxhYAjAihkgWBSBFhogGBiA6AkBfBhhqAKA3ByAHBfAN" +
"sEq8BThvhchaBcB+hpgVgthx6ZBigf2shHhghhG8AzgZhSBEAoh6BcBuBnBjhFgDh7g/heB5h0hOgPhuBWB2gFBXg+h3hWhh" +
"hOh2hPhMh/BzA8BKgfA/AjB8hLALhiglg7gRIpBfhbhQBTB4gWBCB8AlBFBBAghiASBUAaB5hOBBhbgmgKAMBEh9AsglBJhv" +
"AkhGBdAcBfB/hJg3hkhugfg/B4hDhXhyBzBhAyniB4BVADBEgHASTegmgIhEgRAUAHh0Augshjhlh1gyhbA7A1h9gnhvhfB4" +
"gvhVhFhFhrhTA1g7B3htgTAzADgJh4hmBngJgJA2APA6gyg9BaBohLhvADhxBThA8aBIASgmhSgnAugbA3glAXASgqAwhhgY" +
"BaA2hTBthsg5g9A4h4BjAqg5h/gnhXB/h4AahFhVBHgQBzggBTAQhGABBIgeApgKAAAcAgg5AABDhABsA7AAABL7g3hwAjhy" +
"A/h3h+hBh2gwg4AXh/glgWh5A2g2huBAAKg8hiBDB3APArhagIgFhGB8gQgMBxAlgghEgABIgQA0gMA7h5huBcAFgkhKhehw" +
"BBAGhYh2hCg9BfA/A+g4hxhTsdg0BlhRAHhSA2AAhZALBSAMhIA0g8h+BOg9goABAcBBAqAABUgAB7APAwhogxB2h9AIArhd" +
"hnhXhfhZg7h4BIhuAUBbeWgRC9gegmANB6hEhcBpgDBVeQgnhTBqA5goBYgaARASAQhagogJh6hJBFg+BoBWBkB+hmhYgeA+" +
"hqhjh9A5BWA3h/BwBChzgugvhWgzAEAsgBgohshZgMgUABARAACNAoAfABgigBCIBCADhKADgkhHgaB70tBqgwPDBPh/Boh2" +
"hJhxBWhZdohACytSkQAwp26ISCyh0y3IEzO/jeKhUzzASQUjhs510AkmqTSVF24EeTEwf32+XCvWu+0uamI3ECcgEJE+QUkf" +
"gY8hiRUilnezxA2R0JEcUGS4Xk2mc+Fmhy230eeViTSsZAULFCc2+NRiSgiCRkPFCqDw7CuAigRGSREgbkkoWQEGkzQWnheC" +
"j+eGgH3qTwo5RmwCYQBsAmoAW4Ai4AzSaW4LFaBSkc3sDhawA6iA4yCIJB8wnUyDCSEOLyOqWuwCwAyK2x0n1iNgyOAQRCaX" +
"0snkIEBItTAqwgchSyAMhsIGlIw0afmqgRKA34KUgrgGMAAIkA/CYVVCAUky1enwA9jOwmEAXQADMEA+gmqHlQD3o82S5jS1" +
"1YhyM3hqujLFwYgjPIURkHEGhTAQLwnH8AiUM8jAAN8CQ0BMLSELcKhrKsTD4DEcy6FgaQ3NImgBCEwA8AM3ANJAfgFFAlwB" +
"MoABSAAyRHB4ChaK4IxyIASwgM0wDxFMIDeAUKxAGYQCuOo0goLUYT7IMCxkHoiwhGUjgFDkKQ2FgtTdBcBgTAMSAMCQJQSA" +
"o2RZCsXCRFEWzpNQFA+LYSjCAsEgAAsBiEAEYDAHEHxEAoJA3AAMQAMgAAQEsLxlAAHhgA8TgTHAuAPMQOSYCscCsCERSEJQ" +
"ST6KYizNMkdAqHUPBhFkTgANkUhwCkBx9CEaACJACCcBwZT+MQXA4DUcCuMcpwxKQTgzMsfibHQywBKAqDAHIDDIAIxASIgh" +
"zgDQAxiAUkjlDIsAIEABCnBoCAzIAawQCIWCWCAaQBCMAQ+IUDyqJM2iQM0qihLQ1RKEgtgGKkGClAkczEEcHznDcfSUBkFA" +
"lPslDFBomT0CoExBFskgSEoCyfHo8zaCsWA1AAcQJIIORTJAzAZBwSQwLsMwVJcCQfEgyxPK95AgO4wBwCAqiQEIixZJ0Hyd" +
"Mo5g9G8ZgfMooA+KsUROLQrTaNE0DGBQXB6OoERKGABCoXIMQ1F0CDkDoLx5MYgQfHYVB9HQcjcHsYzcOYlCMAUtBdqgXSaF" +
"4TgnB4lTbGcPjqAAPjPA4BA4IIcCMFkmzhNA9x3KoqjwKUzh7KwTDhJkagFHY7j0NARzfD0NSPJ43yHLgiwyCY0zvBAQytGU" +
"2yWDo6CYPUpifB8rDtG4TTmJssiyOAmCBFQDhQP4GCwFoZg5AACAAIcsxoD83xAAI4AIFQtzYL8IzZNsyyfDAxQHE48A9MgN" +
"glgghFFKJkKgTAiAyHiJca4owiBgAkCkdYDg6ipE0EIGQiQnCtA6LACI6hUD5GsI0bonQvhtB8LsBQeByBACiIAJgAQ9AEFW" +
"JcWAOBBgkf2AYJACgkCEHIrQGLzRnixGuD0X4ew4jrBkDEMYsxBjeFeJkD4shYh1EoD4BobAXglC+OINIUQ/juC2BwQoSgmi" +
"+G0DgJQhxShYDoCUT4iAwhxH4JwUgtQDg3A+F4Xw1xdh9FwDUPQYQBjeEqIAZQAQogCGQEEWAjwmgZGANwAIXBBhBDAMcCAD" +
"QRhNHsHEfYbhrA8EgBcf4ehaisB8O8M4JRkjpBoFMbo8QUC2A6FMGYnxoBoAQPEUgoAnimFOHMF48AYBeAkJECojRJDJDiEY" +
"GYzRYDTEwK8bonA6DXDOO8Pw/BFg/H2J4bQ3gMC8HwBoQQrxgBcEAHQAIlgLDEA0CAQA2QBhJECOMLIfBUiYAgE8HxywvgeD" +
"sLcfoqw/g3G4NgHgcATjzEeE4I49o+jxCECUC4Exnh1HgAgUA+hrCHEAJAL4CkaCYGAPAJIAg4BdEMBkPY9AniiA0NYNADxl" +
"i8HQHcPYiw1h/HmNYPYnx+D5FWO4ToKx1hXC+AcRoxwkBqAAE4fI8haDiFmOgcwGhpATDQHERQyR7O8D6PMUAuxKheH+PsWg" +
"sh9BPCaL0XAXxWhvCMMkawuA0h7CWNoJQpQVDEBIBASAmx/gtAuL8FAPQejmAECEGIpQXApByBMC4DhSivAuDIFgzAlCWC6G" +
"odQ5gBhbAcC8WoxQPj+GGH8P48hgw0HcLwfI/QzivHaAwQ4lxXDBFYDwA4sgxiAAKNgJoEB1j7EwO4PwjBujbDuOMewUQ7B7" +
"FsPofY/xfPWDkNAYIthYD6FQFkUggx/BmB+PYBQWwmAOG4MQQ46AkALGgKAf41AFD/A4JIDwVw7DOEGJoXADhrB3D8KAGGAw" +
"xDHCgCwAw6xChNDcPIbwIhvj6GyIQKwDw3jcEyLyLAeBZgYHsN4LgsxbDIEQIQeg3g6srCeE4XovQtibAuN8FYxxhijB4B8H" +
"wCB8jgFCAkOAdQWC6CoEoGwVAahcH2NkagzQiivCuP4T4gh8xgH+DgGAExAjnGiLYIwGhNDFHCKESgXidBODuF0bgkRTD3BA" +
"JceYbBaBqA+B4Y4zQ7inBoKkR46xiggAmGpZ4MY3h6G2FccQngKg2DUCUe4ZAvAJC6LsaAcQ3iXBmG4KoJBoj6GEB0Gwnhuj" +
"BEoLMAIRQJAEFgPgLQ9x9BlFWAUBIQhogxCsOsYQBhYjhFuKsYwmRDiVCaMMZIIhOhsY4HcQYjh3gzHKLcfQQwYj0F8GoRYf" +
"hbClHkJgaITB3AEEyI4KoRBxCsHkK4YokRWDKAEKcaYtgPBfB0M0JoAx8DIDaJcQ4vAUDBDSPIRoWwdB8G8HAMQEhqBGf0GI" +
"MYNhXC3GaKwW46hHBmA4LYZgTg2AxH8HUMQ8woBnHyIYSg7gkAoGmAkdorBkDsCcCYFINB2jsCIAUHoZBNidBoLIHQyh8jIG" +
"MC4GoCwNB1DaKwMfLhyA2B6K0d48BKh7CeHwLwBgCAmB0OEIIKhrieCSJMaATwrj8GeHsRI3BBg2AaGYaIhwnBajQJECY6Qk" +
"BCFwJwVI2A7ghYSOsOYrQmhDEyFUNogx9DUC8J4ZY6QIhtGeC8XQcRPAgEQH8W43QeACCwFIYQfgehIA8JoZIpBTDrFaH8Cy" +
"0ApC5EuB4Tg1BQBsB6DcY42hgCWGKGgcIkhJh1GmIQSozRqhuD0DwSYvQIjiBOHsYYlBVgOAoOMeQ/gjC/C2NAeYEQQ0pCQI" +
"kPoPhUC8HGAgY4QQMCjB0O8cwbAFB5GECnoYoh4gOCIL4NY0xOjbD3B4B1BUAmClAyAYDFDLDKDqDrB1BKD/BnAADtCOCxD1" +
"DLZnCEAAgZAABJBFBOBECuBCBgCCEBA==");
object var_HTMLPicture = exgrid1.get_HTMLPicture("aka1");
exgrid1.HeaderHeight = 24;
exgrid1.DefaultItemHeight = 48;
exgrid1.DrawGridLines = exontrol.EXGRIDLib.GridLinesEnum.exRowLines;
exgrid1.GridLineColor = Color.FromArgb(240,240,240);
exgrid1.SelBackMode = exontrol.EXGRIDLib.BackModeEnum.exTransparent;
exgrid1.ColumnAutoResize = false;
exgrid1.ContinueColumnScroll = false;
// Add 'Microsoft ActiveX Data Objects 6.0 Library' reference to your project.
ADODB.Recordset rs = new ADODB.Recordset();
	rs.Open("Orders","Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Program Files\\Exontrol\\ExGrid\\Sample\\SAMPL" +
"E.MDB",exontrol.ADODB.CursorTypeEnum.adOpenStatic,exontrol.ADODB.LockTypeEnum.adLockOptimistic,0);
exgrid1.DataSource = (rs as ADODB.Recordset);
exgrid1.Columns[0].set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellValueFormat,1);
exgrid1.Columns[0].FormatColumn = "value + ` <img>p` + (1 + (value mod 3 ) ) + `</img>`";
exgrid1.Columns[0].Width = 112;
exgrid1.Columns[1].set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellHasCheckBox,1);
exgrid1.Columns[2].LevelKey = "1";
exgrid1.Columns[3].LevelKey = "1";
exgrid1.Columns[4].LevelKey = "1";
exgrid1.AutoDrag = exontrol.EXGRIDLib.AutoDragEnum.exAutoDragCopyImage;
exgrid1.SingleSel = false;
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	int h = var_Items[1];
	var_Items.set_SelectItem(h,true);
	h = var_Items[2];
	var_Items.set_SelectItem(h,true);
	h = var_Items[3];
	var_Items.set_SelectItem(h,true);
	var_Items.set_LockedItemCount(exontrol.EXGRIDLib.VAlignmentEnum.exBottom,1);
	h = var_Items.get_LockedItem(exontrol.EXGRIDLib.VAlignmentEnum.exBottom,0);
	var_Items.set_CellValue(h,1,"<font ;16>Click the selection and <b>wait to start dragging</b>, and then drop to Microsoft Wor" +
"d, ...");
	var_Items.set_CellSingleLine(h,1,false);
	var_Items.set_CellValueFormat(h,1,exontrol.EXGRIDLib.ValueFormatEnum.exHTML);
	var_Items.set_CellHAlignment(h,1,exontrol.EXGRIDLib.AlignmentEnum.CenterAlignment);
	var_Items.set_ItemDivider(h,1);
	var_Items.set_ItemDividerLineAlignment(h,exontrol.EXGRIDLib.DividerAlignmentEnum.DividerTop);
exgrid1.EndUpdate();

exgrid1.BeginUpdate();
exgrid1.ColumnAutoResize = false;
exgrid1.ContinueColumnScroll = false;
// Add 'Microsoft ActiveX Data Objects 6.0 Library' reference to your project.
ADODB.Recordset rs = new ADODB.Recordset();
	rs.Open("Orders","Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Program Files\\Exontrol\\ExGrid\\Sample\\SAMPL" +
"E.MDB",exontrol.ADODB.CursorTypeEnum.adOpenStatic,exontrol.ADODB.LockTypeEnum.adLockOptimistic,0);
exgrid1.DataSource = (rs as ADODB.Recordset);
exgrid1.Columns[2].LevelKey = "1";
exgrid1.Columns[3].LevelKey = "1";
exgrid1.Columns[4].LevelKey = "1";
exgrid1.AutoDrag = exontrol.EXGRIDLib.AutoDragEnum.exAutoDragCopyText;
exgrid1.SingleSel = false;
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	int h = var_Items[1];
	var_Items.set_SelectItem(h,true);
	h = var_Items[3];
	var_Items.set_SelectItem(h,true);
	h = var_Items[4];
	var_Items.set_SelectItem(h,true);
	h = var_Items[5];
	var_Items.set_SelectItem(h,true);
	var_Items.set_LockedItemCount(exontrol.EXGRIDLib.VAlignmentEnum.exBottom,1);
	h = var_Items.get_LockedItem(exontrol.EXGRIDLib.VAlignmentEnum.exBottom,0);
	var_Items.set_CellValue(h,0,"<font ;16>Click the selection and <b>wait to start dragging</b>, and then drop to Microsoft Wor" +
"d, Excel, ...");
	var_Items.set_CellSingleLine(h,0,false);
	var_Items.set_CellValueFormat(h,0,exontrol.EXGRIDLib.ValueFormatEnum.exHTML);
	var_Items.set_CellHAlignment(h,0,exontrol.EXGRIDLib.AlignmentEnum.CenterAlignment);
	var_Items.set_ItemDivider(h,0);
	var_Items.set_ItemDividerLineAlignment(h,exontrol.EXGRIDLib.DividerAlignmentEnum.DividerTop);
exgrid1.EndUpdate();

exgrid1.BeginUpdate();
exgrid1.VisualAppearance.Add(1,"c:\\exontrol\\images\\normal.ebn");
exgrid1.AutoDrag = exontrol.EXGRIDLib.AutoDragEnum.exAutoDragPositionAny;
exgrid1.LinesAtRoot = exontrol.EXGRIDLib.LinesAtRootEnum.exNoLinesAtRoot;
exgrid1.HasLines = exontrol.EXGRIDLib.HierarchyLineEnum.exSolidLine;
exgrid1.HasButtons = exontrol.EXGRIDLib.ExpandButtonEnum.exWPlus;
exgrid1.ShowFocusRect = false;
exgrid1.SelBackMode = exontrol.EXGRIDLib.BackModeEnum.exTransparent;
exgrid1.Columns.Add("Task");
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	int h = var_Items.AddItem("Group 1");
	var_Items.set_ItemBold(h,true);
	var_Items.set_ItemDivider(h,0);
	int h1 = var_Items.InsertItem(h,0,"Task 1");
	int h2 = var_Items.InsertItem(h1,0,"Task 2");
	h2 = var_Items.InsertItem(h1,0,"Task 3");
	int h3 = var_Items.InsertItem(h,0,"Task 3");
	var_Items.set_ExpandItem(h,true);
	var_Items.set_ExpandItem(h1,true);
	h = var_Items.AddItem("Group 2");
	var_Items.set_ItemBold(h,true);
	var_Items.set_ItemDivider(h,0);
	var_Items.set_LockedItemCount(exontrol.EXGRIDLib.VAlignmentEnum.exBottom,1);
	h = var_Items.get_LockedItem(exontrol.EXGRIDLib.VAlignmentEnum.exBottom,0);
	var_Items.set_CellValue(h,0,"Click a row, and move by dragging <b>up, down</b> to change the row's parent or <b>left,right</" +
"b> to increase or decrease the indentation.");
	var_Items.set_CellSingleLine(h,0,false);
	var_Items.set_CellValueFormat(h,0,exontrol.EXGRIDLib.ValueFormatEnum.exHTML);
exgrid1.EndUpdate();

exgrid1.BeginUpdate();
exgrid1.VisualAppearance.Add(1,"c:\\exontrol\\images\\normal.ebn");
exgrid1.AutoDrag = exontrol.EXGRIDLib.AutoDragEnum.exAutoDragPositionKeepIndent;
exgrid1.LinesAtRoot = exontrol.EXGRIDLib.LinesAtRootEnum.exNoLinesAtRoot;
exgrid1.HasLines = exontrol.EXGRIDLib.HierarchyLineEnum.exThinLine;
exgrid1.ShowFocusRect = false;
exgrid1.Columns.Add("Task");
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	int h = var_Items.AddItem("Group 1");
	var_Items.set_ItemDivider(h,0);
	var_Items.set_ItemBold(h,true);
	int h1 = var_Items.InsertItem(h,0,"Task 1");
	int h2 = var_Items.InsertItem(h,0,"Task 2");
	int h3 = var_Items.InsertItem(h,0,"Task 3");
	var_Items.set_ExpandItem(h,true);
	h = var_Items.AddItem("Group 2");
	var_Items.set_ItemBold(h,true);
	var_Items.set_ItemDivider(h,0);
exgrid1.EndUpdate();

exgrid1.BeginUpdate();
exgrid1.VisualAppearance.Add(1,"c:\\exontrol\\images\\normal.ebn");
exgrid1.AutoDrag = exontrol.EXGRIDLib.AutoDragEnum.exAutoDragPosition;
exgrid1.Columns.Add("Task");
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	int h1 = var_Items.AddItem("Task 1");
	int h2 = var_Items.AddItem("Task 2");
	int h3 = var_Items.AddItem("Task 3");
exgrid1.EndUpdate();

exgrid1.BeginUpdate();
exgrid1.Columns.Add("Def");
exgrid1.HotBackColor = Color.FromArgb(0,0,128);
exgrid1.HotForeColor = Color.FromArgb(255,255,255);
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.AddItem("Item A");
	var_Items.AddItem("Item B");
	var_Items.AddItem("Item C");
exgrid1.EndUpdate();

exgrid1.BeginUpdate();
exgrid1.Columns.Add("Task");
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.AddItem("Task 1");
	var_Items.AddItem("Task 2");
exgrid1.EndUpdate();
exgrid1.Template = "Dim p;p = CreateObject(`Exontrol.Print`);p.PrintExt = Me;p.AutoRelease = False;p.Preview();";

exgrid1.BeginUpdate();
exgrid1.Columns.Add("Default");
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.AddItem("Item 1");
	var_Items.AddItem("Task 2");
exgrid1.EndUpdate();
// Add 'exontrol.exprint.dll' reference to your project.
// Add 'ExPrint 1.0 Control Library' reference to your project.
exontrol.EXPRINTLib.exprint var_Print = new exontrol.EXPRINTLib.exprint();
	var_Print.PrintExt = (exgrid1.ExecuteTemplate("me") as exontrol.EXGRIDLib.exgrid);
	var_Print.Preview();

exgrid1.BeginUpdate();
exontrol.EXGRIDLib.ConditionalFormat var_ConditionalFormat = exgrid1.ConditionalFormats.Add("1","K1");
	var_ConditionalFormat.BackColor = Color.FromArgb(255,0,0);
	var_ConditionalFormat.ApplyTo = (exontrol.EXGRIDLib.FormatApplyToEnum)0x1;
exontrol.EXGRIDLib.ConditionalFormat var_ConditionalFormat1 = exgrid1.ConditionalFormats.Add("1","K2");
	var_ConditionalFormat1.BackColor = Color.FromArgb(255,0,0);
	var_ConditionalFormat1.ApplyTo = (exontrol.EXGRIDLib.FormatApplyToEnum)0x2;
exgrid1.MarkSearchColumn = false;
exgrid1.DrawGridLines = exontrol.EXGRIDLib.GridLinesEnum.exRowLines;
exontrol.EXGRIDLib.Columns var_Columns = exgrid1.Columns;
	var_Columns.Add("Column 1");
	var_Columns.Add("Column 2");
	var_Columns.Add("Column 3");
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.AddItem(null);
	var_Items.AddItem(null);
	var_Items.AddItem(null);
exgrid1.EndUpdate();

// ButtonClick event - Occurs when user clicks on the cell's button.
private void exgrid1_ButtonClick(object sender,int Item,int ColIndex,object Key)
{
	// Add 'Microsoft ActiveX Data Objects 6.0 Library' reference to your project.
	(exgrid1.DataSource as ADODB.Recordset).AddNew(null,null);
}
//this.exgrid1.ButtonClick += new exontrol.EXGRIDLib.exg2antt.ButtonClickEventHandler(this.exgrid1_ButtonClick);

ADODB.Recordset rs = new ADODB.Recordset();
	rs.Append("Task",exontrol.ADODB.DataTypeEnum.adBSTR,null,null,null);
	rs.Append("Start",exontrol.ADODB.DataTypeEnum.adDate,null,null,null);
	rs.Append("End",exontrol.ADODB.DataTypeEnum.adDate,null,null,null);
rs.Open(null,null,null,null,0);
exgrid1.DrawGridLines = exontrol.EXGRIDLib.GridLinesEnum.exRowLines;
exgrid1.DetectAddNew = true;
exgrid1.DetectDelete = true;
exgrid1.DataSource = (rs as ADODB.Recordset);
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.set_LockedItemCount(exontrol.EXGRIDLib.VAlignmentEnum.exTop,1);
	int h = var_Items.get_LockedItem(exontrol.EXGRIDLib.VAlignmentEnum.exTop,0);
	var_Items.set_ItemDivider(h,0);
	var_Items.set_ItemHeight(h,22);
	var_Items.set_CellValue(h,0,"AddNew");
	var_Items.set_CellHasButton(h,0,true);
	var_Items.set_CellHAlignment(h,0,exontrol.EXGRIDLib.AlignmentEnum.CenterAlignment);

// OLEStartDrag event is not supported. Use the DragEnter,DragLeave,DragOver, DragDrop ... events.
exgrid1.BeginUpdate();
exgrid1.Columns.Add("Default");
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.AddItem("Item 1");
	var_Items.AddItem("Item 2");
	var_Items.AddItem("Item 3");
	var_Items.AddItem("Item 4");
	var_Items.AddItem("Item 5");
exgrid1.OLEDropMode = exontrol.EXGRIDLib.exOLEDropModeEnum.exOLEDropManual;
exgrid1.EndUpdate();

// AfterExpandItem event - Fired after an item is expanded (collapsed).
private void exgrid1_AfterExpandItem(object sender,int Item)
{
	System.Diagnostics.Debug.Print( "AfterExpandItem" );
	System.Diagnostics.Debug.Print( Item.ToString() );
}
//this.exgrid1.AfterExpandItem += new exontrol.EXGRIDLib.exg2antt.AfterExpandItemEventHandler(this.exgrid1_AfterExpandItem);

// AnchorClick event - Occurs when an anchor element is clicked.
private void exgrid1_AnchorClick(object sender,string AnchorID,string Options)
{
	System.Diagnostics.Debug.Print( "AnchorClick" );
	System.Diagnostics.Debug.Print( AnchorID.ToString() );
	System.Diagnostics.Debug.Print( Options.ToString() );
}
//this.exgrid1.AnchorClick += new exontrol.EXGRIDLib.exg2antt.AnchorClickEventHandler(this.exgrid1_AnchorClick);

// BeforeExpandItem event - Fired before an item is about to be expanded (collapsed).
private void exgrid1_BeforeExpandItem(object sender,int Item,ref object Cancel)
{
	System.Diagnostics.Debug.Print( "BeforeExpandItem" );
	System.Diagnostics.Debug.Print( Item.ToString() );
}
//this.exgrid1.BeforeExpandItem += new exontrol.EXGRIDLib.exg2antt.BeforeExpandItemEventHandler(this.exgrid1_BeforeExpandItem);

// ButtonClick event - Occurs when user clicks on the cell's button.
private void exgrid1_ButtonClick(object sender,int Item,int ColIndex,object Key)
{
	System.Diagnostics.Debug.Print( "ButtonClick" );
	System.Diagnostics.Debug.Print( Item.ToString() );
	System.Diagnostics.Debug.Print( ColIndex.ToString() );
	System.Diagnostics.Debug.Print( Key.ToString() );
}
//this.exgrid1.ButtonClick += new exontrol.EXGRIDLib.exg2antt.ButtonClickEventHandler(this.exgrid1_ButtonClick);

// CellImageClick event - Fired after the user clicks on the image's cell area.
private void exgrid1_CellImageClick(object sender,int Item,int ColIndex)
{
	System.Diagnostics.Debug.Print( "CellImageClick" );
	System.Diagnostics.Debug.Print( Item.ToString() );
	System.Diagnostics.Debug.Print( ColIndex.ToString() );
}
//this.exgrid1.CellImageClick += new exontrol.EXGRIDLib.exg2antt.CellImageClickEventHandler(this.exgrid1_CellImageClick);

// CellStateChanged event - Fired after cell's state has been changed.
private void exgrid1_CellStateChanged(object sender,int Item,int ColIndex)
{
	System.Diagnostics.Debug.Print( "CellStateChanged" );
	System.Diagnostics.Debug.Print( Item.ToString() );
	System.Diagnostics.Debug.Print( ColIndex.ToString() );
}
//this.exgrid1.CellStateChanged += new exontrol.EXGRIDLib.exg2antt.CellStateChangedEventHandler(this.exgrid1_CellStateChanged);

// Change event - Occurs when the user changes the cell's content.
private void exgrid1_Change(object sender,int Item,int ColIndex,ref object NewValue)
{
	System.Diagnostics.Debug.Print( "Change" );
	System.Diagnostics.Debug.Print( Item.ToString() );
	System.Diagnostics.Debug.Print( ColIndex.ToString() );
	System.Diagnostics.Debug.Print( NewValue.ToString() );
}
//this.exgrid1.Change += new exontrol.EXGRIDLib.exg2antt.ChangeEventHandler(this.exgrid1_Change);

// Click event - Occurs when the user presses and then releases the left mouse button over the grid control.
private void exgrid1_Click(object sender)
{
	System.Diagnostics.Debug.Print( "Click" );
}
//this.exgrid1.Click += new exontrol.EXGRIDLib.exg2antt.ClickEventHandler(this.exgrid1_Click);

// ColumnClick event - Fired after the user clicks on column's header.
private void exgrid1_ColumnClick(object sender,exontrol.EXGRIDLib.Column Column)
{
	System.Diagnostics.Debug.Print( "ColumnClick" );
}
//this.exgrid1.ColumnClick += new exontrol.EXGRIDLib.exg2antt.ColumnClickEventHandler(this.exgrid1_ColumnClick);

// DblClick event - Occurs when the user dblclk the left mouse button over an object.
private void exgrid1_DblClick(object sender,short Shift,int X,int Y)
{
	System.Diagnostics.Debug.Print( "DblClick" );
	System.Diagnostics.Debug.Print( Shift.ToString() );
	System.Diagnostics.Debug.Print( X.ToString() );
	System.Diagnostics.Debug.Print( Y.ToString() );
	exgrid1.Edit(null);
}
//this.exgrid1.DblClick += new exontrol.EXGRIDLib.exg2antt.DblClickEventHandler(this.exgrid1_DblClick);

// Edit event - Occurs just before editing the focused cell.
private void exgrid1_EditEvent(object sender,int Item,int ColIndex,ref bool Cancel)
{
	System.Diagnostics.Debug.Print( "Edit" );
	System.Diagnostics.Debug.Print( Item.ToString() );
	System.Diagnostics.Debug.Print( ColIndex.ToString() );
}
//this.exgrid1.EditEvent += new exontrol.EXGRIDLib.exg2antt.EditEventHandler(this.exgrid1_EditEvent);

// EditClose event - Occurs when the edit operation ends.
private void exgrid1_EditCloseEvent(object sender)
{
	System.Diagnostics.Debug.Print( "EditClose" );
}
//this.exgrid1.EditCloseEvent += new exontrol.EXGRIDLib.exg2antt.EditCloseEventHandler(this.exgrid1_EditCloseEvent);

// EditOpen event - Occurs when the edit operation starts.
private void exgrid1_EditOpen(object sender)
{
	System.Diagnostics.Debug.Print( "EditOpen" );
}
//this.exgrid1.EditOpen += new exontrol.EXGRIDLib.exg2antt.EditOpenEventHandler(this.exgrid1_EditOpen);

// FilterChange event - Occurs when filter was changed.
private void exgrid1_FilterChange(object sender)
{
	System.Diagnostics.Debug.Print( "FilterChange" );
}
//this.exgrid1.FilterChange += new exontrol.EXGRIDLib.exg2antt.FilterChangeEventHandler(this.exgrid1_FilterChange);

// FilterChanging event - Notifies your application that the filter is about to change.
private void exgrid1_FilterChanging(object sender)
{
	System.Diagnostics.Debug.Print( "FilterChanging" );
}
//this.exgrid1.FilterChanging += new exontrol.EXGRIDLib.exg2antt.FilterChangingEventHandler(this.exgrid1_FilterChanging);

// FocusChanged event - Occurs when a new cell is focused.
private void exgrid1_FocusChanged(object sender)
{
	System.Diagnostics.Debug.Print( "FocusChanged" );
}
//this.exgrid1.FocusChanged += new exontrol.EXGRIDLib.exg2antt.FocusChangedEventHandler(this.exgrid1_FocusChanged);

// KeyDown event - Occurs when the user presses a key while an object has the focus.
private void exgrid1_KeyDown(object sender,ref short KeyCode,short Shift)
{
	System.Diagnostics.Debug.Print( "KeyDown" );
	System.Diagnostics.Debug.Print( KeyCode.ToString() );
	System.Diagnostics.Debug.Print( Shift.ToString() );
}
//this.exgrid1.KeyDown += new exontrol.EXGRIDLib.exg2antt.KeyDownEventHandler(this.exgrid1_KeyDown);

// KeyPress event - Occurs when the user presses and releases an ANSI key.
private void exgrid1_KeyPress(object sender,ref short KeyAscii)
{
	System.Diagnostics.Debug.Print( "KeyPress" );
	System.Diagnostics.Debug.Print( KeyAscii.ToString() );
}
//this.exgrid1.KeyPress += new exontrol.EXGRIDLib.exg2antt.KeyPressEventHandler(this.exgrid1_KeyPress);

// KeyUp event - Occurs when the user releases a key while an object has the focus.
private void exgrid1_KeyUp(object sender,ref short KeyCode,short Shift)
{
	System.Diagnostics.Debug.Print( "KeyUp" );
	System.Diagnostics.Debug.Print( KeyCode.ToString() );
	System.Diagnostics.Debug.Print( Shift.ToString() );
}
//this.exgrid1.KeyUp += new exontrol.EXGRIDLib.exg2antt.KeyUpEventHandler(this.exgrid1_KeyUp);

// LayoutChanged event - Occurs when column's position or column's size is changed.
private void exgrid1_LayoutChanged(object sender)
{
	System.Diagnostics.Debug.Print( "LayoutChanged" );
}
//this.exgrid1.LayoutChanged += new exontrol.EXGRIDLib.exg2antt.LayoutChangedEventHandler(this.exgrid1_LayoutChanged);

// MouseDown event - Occurs when the user presses a mouse button.
private void exgrid1_MouseDownEvent(object sender,short Button,short Shift,int X,int Y)
{
	System.Diagnostics.Debug.Print( "MouseDown" );
	System.Diagnostics.Debug.Print( Button.ToString() );
	System.Diagnostics.Debug.Print( Shift.ToString() );
	System.Diagnostics.Debug.Print( X.ToString() );
	System.Diagnostics.Debug.Print( Y.ToString() );
}
//this.exgrid1.MouseDownEvent += new exontrol.EXGRIDLib.exg2antt.MouseDownEventHandler(this.exgrid1_MouseDownEvent);

// MouseMove event - Occurs when the user moves the mouse.
private void exgrid1_MouseMoveEvent(object sender,short Button,short Shift,int X,int Y)
{
}
//this.exgrid1.MouseMoveEvent += new exontrol.EXGRIDLib.exg2antt.MouseMoveEventHandler(this.exgrid1_MouseMoveEvent);

// MouseUp event - Occurs when the user releases a mouse button.
private void exgrid1_MouseUpEvent(object sender,short Button,short Shift,int X,int Y)
{
	System.Diagnostics.Debug.Print( "MouseUp" );
	System.Diagnostics.Debug.Print( Button.ToString() );
	System.Diagnostics.Debug.Print( Shift.ToString() );
	System.Diagnostics.Debug.Print( X.ToString() );
	System.Diagnostics.Debug.Print( Y.ToString() );
}
//this.exgrid1.MouseUpEvent += new exontrol.EXGRIDLib.exg2antt.MouseUpEventHandler(this.exgrid1_MouseUpEvent);

// OffsetChanged event - Occurs when the scroll position has been changed.
private void exgrid1_OffsetChanged(object sender,bool Horizontal,int NewVal)
{
	System.Diagnostics.Debug.Print( "OffsetChanged" );
	System.Diagnostics.Debug.Print( Horizontal.ToString() );
	System.Diagnostics.Debug.Print( NewVal.ToString() );
}
//this.exgrid1.OffsetChanged += new exontrol.EXGRIDLib.exg2antt.OffsetChangedEventHandler(this.exgrid1_OffsetChanged);

// OversizeChanged event - Occurs when the right range of the scroll has been changed.
private void exgrid1_OversizeChanged(object sender,bool Horizontal,int NewVal)
{
	System.Diagnostics.Debug.Print( "OversizeChanged" );
	System.Diagnostics.Debug.Print( Horizontal.ToString() );
	System.Diagnostics.Debug.Print( NewVal.ToString() );
}
//this.exgrid1.OversizeChanged += new exontrol.EXGRIDLib.exg2antt.OversizeChangedEventHandler(this.exgrid1_OversizeChanged);

// RClick event - Fired when right mouse button is clicked
private void exgrid1_RClick(object sender)
{
	System.Diagnostics.Debug.Print( "RClick" );
}
//this.exgrid1.RClick += new exontrol.EXGRIDLib.exg2antt.RClickEventHandler(this.exgrid1_RClick);

// ScrollButtonClick event - Occurs when the user clicks a button in the scrollbar.
private void exgrid1_ScrollButtonClick(object sender,exontrol.EXGRIDLib.ScrollBarEnum ScrollBar,exontrol.EXGRIDLib.ScrollPartEnum ScrollPart)
{
	System.Diagnostics.Debug.Print( "ScrollButtonClick" );
	System.Diagnostics.Debug.Print( ScrollBar.ToString() );
	System.Diagnostics.Debug.Print( ScrollPart.ToString() );
}
//this.exgrid1.ScrollButtonClick += new exontrol.EXGRIDLib.exg2antt.ScrollButtonClickEventHandler(this.exgrid1_ScrollButtonClick);

// SelectionChanged event - Fired after a new item has been selected.
private void exgrid1_SelectionChanged(object sender)
{
	System.Diagnostics.Debug.Print( "SelectionChanged" );
}
//this.exgrid1.SelectionChanged += new exontrol.EXGRIDLib.exg2antt.SelectionChangedEventHandler(this.exgrid1_SelectionChanged);

// Sort event - Fired when the control sorts a column.
private void exgrid1_Sort(object sender)
{
	System.Diagnostics.Debug.Print( "Sort" );
}
//this.exgrid1.Sort += new exontrol.EXGRIDLib.exg2antt.SortEventHandler(this.exgrid1_Sort);

exgrid1.BeginUpdate();
exgrid1.Images("gBJJgBAIEAAGAEGCAAhb/hz/EIAh8Tf5CJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0" +
"/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1" +
"BAmBhOCwMGwuDw2ExWJxmIx2HyGLv+TlykUCgABmGYzzObzuczWcKujzOa0ug02hz+r1Wtz2qoCA2QAYG1yk02YA3NMy2Yh8" +
"Sh202zx4gA4jxADM5XG4vHACy6ESdjM6XUZiZTMS5bwZSm1c83+yQHCYHk81Q8O7qW18u/9NG3vAf/y83u4PQWQA0ZVADq/z" +
"6um6rkuw7TqH+5bYJu+z5vE8z2N02cGweoDfwfCrbQfBqkNzBb6QfDLxp6+LlOs5cSOTEzlm7FYACFFwADvGIAGvGjzOu7Mb" +
"wHHECQSmUOvS8cGwk20gQc2ycQs4MLvLD8MNtDSfyS+cmyZJzywa96axzDsTw6/x1AAL8xRbF8Vm65jkH/AL8QFNTqR6lsfu" +
"DIb2uDKTzTo88FTtIk+PK3SNRDKiew5JVDSnK08NnOUGRClkt0PFEDUjMwAENS4AM2zj4udNznujT1PTgjdGQg8c71RPtESv" +
"CL1JrO8lozQUj1nP6d1TKtc0U8dS1jCaNRzGhrxnGthWJYdjUrYwc2ZMMx2NB8czZNk4VLPMstzXD6Q6mltVjPNAT0m1CvnD" +
"tBxBXlI3PRKNzZDtjQ6cd5TQ/TSU0/r/udC0A1Ez1SUja8/QhWVavrSLfpxWNzXZR2CygmVtXXVl03Lg+BV+lV3UjeDgzEL4" +
"AXkcb6Pje5LZNDzhuLfrOX/RtT0TQbc5lENSvBi2K5xlFdUHhN1ZhJ9F59WybOU7NjWTFkvxhGT9zIIQAWYHIABFqmnABSsT" +
"0HUaNYlI1dZmjNuUDRybzvIVWyDoOc54n8Oyxm9Ta9cSUaLbbg44+b4xiO9nY/pt73u38Tuc52tpdruYxDVyUbBV+gYpu2c7" +
"PyGMKTt21cjnW6OvzO8PppUvP/Ljlt/wt/Vvn+v8V1eCdbgaa7fnMi8vyD0TnzGEJXyp/wJ3js98iXe+F3/hwGM3jeQZjTeU" +
"znmOT5bTKJyqYcbm2c5bzXpqvsWw4FUkCO473wgB8cD9/znzO14n1+D4/efcTP4fl5+WKvxbbptmqV+B/ni/68R4514AvxeT" +
"AR50B3oPNei/iBhFgfErgeR4kBIiSAAJKSiC7PT5wMKIQ4fwfyHDzg2PwD4/B/jgg2PgA48AfjgB+RkeAARwAPGAA8jI4AAD" +
"gAOMAAZGTyw6YbDkA7ZDaAHgxDyCxGgBw8EBBmJcS4LjAATDweBGoqjgAGP4jQ/AcjwAHBsiQex8gPH+MF7pDxxkB");
exgrid1.DrawGridLines = exontrol.EXGRIDLib.GridLinesEnum.exAllLines;
exgrid1.LinesAtRoot = exontrol.EXGRIDLib.LinesAtRootEnum.exLinesAtRoot;
exgrid1.GridLineStyle = exontrol.EXGRIDLib.GridLinesStyleEnum.exGridLinesHDash;
exgrid1.AutoEdit = false;
exgrid1.ExpandOnDblClick = false;
exontrol.EXGRIDLib.Columns var_Columns = exgrid1.Columns;
	exontrol.EXGRIDLib.Column var_Column = (var_Columns.Add("Column") as exontrol.EXGRIDLib.Column);
		var_Column.DisplayFilterButton = true;
		var_Column.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true);
		var_Column.Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.EditType;
	exontrol.EXGRIDLib.Column var_Column1 = (var_Columns.Add("Button") as exontrol.EXGRIDLib.Column);
		var_Column1.AllowSizing = false;
		var_Column1.Width = 18;
		var_Column1.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellHasButton,true);
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	int h = var_Items.AddItem("parent");
	var_Items.set_CellImage(h,0,1);
	var_Items.InsertItem(h,"","child");
	var_Items.set_ExpandItem(h,true);
exgrid1.EndUpdate();

// ColumnClick event - Fired after the user clicks on column's header.
private void exgrid1_ColumnClick(object sender,exontrol.EXGRIDLib.Column Column)
{
	exgrid1.BeginUpdate();
	exgrid1.Columns[0].Selected = false;
	exgrid1.Columns[1].Selected = false;
	exgrid1.Items.SelectAll();
	exgrid1.EndUpdate();
}
//this.exgrid1.ColumnClick += new exontrol.EXGRIDLib.exg2antt.ColumnClickEventHandler(this.exgrid1_ColumnClick);

exgrid1.BeginUpdate();
exgrid1.MarkSearchColumn = false;
exgrid1.ShowFocusRect = false;
exgrid1.SingleSel = false;
exgrid1.FullRowSelect = exontrol.EXGRIDLib.CellSelectEnum.exRectSel;
exgrid1.SortOnClick = exontrol.EXGRIDLib.SortOnClickEnum.exNoSort;
exontrol.EXGRIDLib.Columns var_Columns = exgrid1.Columns;
	var_Columns.Add("Column1");
	var_Columns.Add("Column2");
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.set_CellValue(var_Items.AddItem("One"),1,"Three");
	var_Items.set_CellValue(var_Items.AddItem("Two"),1,"Four");
	var_Items.SelectAll();
exgrid1.EndUpdate();

exontrol.EXGRIDLib.Column var_Column = (exgrid1.Columns.Add("Currency") as exontrol.EXGRIDLib.Column);
	var_Column.FormatColumn = "dbl(value) ? currency(dbl(value)) : ``";
	exontrol.EXGRIDLib.Editor var_Editor = var_Column.Editor;
		var_Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.EditType;
		var_Editor.Numeric = exontrol.EXGRIDLib.NumericEnum.exFloat;
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.AddItem(1.23);
	var_Items.AddItem(2.34);
	var_Items.AddItem(0);
	var_Items.AddItem(10000.99);

exgrid1.Columns.Add("Number");
(exgrid1.Columns.Add("Currency") as exontrol.EXGRIDLib.Column).ComputedField = "%0 ? currency(%0) : ``";
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.AddItem(1.23);
	var_Items.AddItem(2.34);
	var_Items.AddItem(0);
	var_Items.AddItem(10000.99);

exgrid1.BeginUpdate();
exgrid1.BackColorAlternate = Color.FromArgb(240,240,240);
exgrid1.Columns.Add("Names");
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.AddItem("Mantel");
	var_Items.AddItem("Mechanik");
	var_Items.AddItem("Motor");
	var_Items.AddItem("Murks");
	var_Items.AddItem("Märchen");
	var_Items.AddItem("Möhren");
	var_Items.AddItem("Mühle");
exgrid1.Columns[0].SortOrder = exontrol.EXGRIDLib.SortOrderEnum.SortAscending;
exgrid1.EndUpdate();
System.Diagnostics.Debug.Print( exgrid1.GetItems(1).ToString() );

// EditClose event - Occurs when the edit operation ends.
private void exgrid1_EditCloseEvent(object sender)
{
	exgrid1.Items.AddItem("");
}
//this.exgrid1.EditCloseEvent += new exontrol.EXGRIDLib.exg2antt.EditCloseEventHandler(this.exgrid1_EditCloseEvent);

exgrid1.BeginUpdate();
exgrid1.AutoEdit = true;
(exgrid1.Columns.Add("Default") as exontrol.EXGRIDLib.Column).Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.EditType;
exgrid1.FullRowSelect = exontrol.EXGRIDLib.CellSelectEnum.exColumnSel;
exgrid1.Items.AddItem("");
exgrid1.DrawGridLines = exontrol.EXGRIDLib.GridLinesEnum.exAllLines;
exgrid1.ScrollBars = exontrol.EXGRIDLib.ScrollBarsEnum.exDisableBoth;
exgrid1.EndUpdate();

exgrid1.BeginUpdate();
exgrid1.set_HTMLPicture("pic1","c:\\exontrol\\images\\zipdisk.gif");
exgrid1.HeaderHeight = 48;
(exgrid1.Columns.Add("DefaultSize") as exontrol.EXGRIDLib.Column).HTMLCaption = "Default-Size <img>pic1</img> Picture";
(exgrid1.Columns.Add("CustomSize") as exontrol.EXGRIDLib.Column).HTMLCaption = "Custom-Size <img>pic1:16</img> Picture";
exgrid1.EndUpdate();

exgrid1.BeginUpdate();
exontrol.EXGRIDLib.ConditionalFormat var_ConditionalFormat = exgrid1.ConditionalFormats.Add("1",null);
	var_ConditionalFormat.Bold = true;
	var_ConditionalFormat.ForeColor = Color.FromArgb(255,0,0);
	var_ConditionalFormat.ApplyTo = (exontrol.EXGRIDLib.FormatApplyToEnum)0x1;
exgrid1.Columns.Add("C1");
exontrol.EXGRIDLib.Column var_Column = (exgrid1.Columns.Add("C2") as exontrol.EXGRIDLib.Column);
	var_Column.HeaderBold = true;
	var_Column.HTMLCaption = "<fgcolor=FF0000>C2";
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.set_CellValue(var_Items.AddItem(10),1,11);
	var_Items.set_CellValue(var_Items.AddItem(12),1,13);
exgrid1.EndUpdate();

exontrol.EXGRIDLib.Column var_Column = (exgrid1.Columns.Add("Check") as exontrol.EXGRIDLib.Column);
	exontrol.EXGRIDLib.Editor var_Editor = var_Column.Editor;
		var_Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.CheckValueType;
		var_Editor.set_Option(exontrol.EXGRIDLib.EditorOptionEnum.exCheckValue2,1);
	var_Column.DisplayFilterButton = true;
	var_Column.DisplayFilterPattern = false;
	var_Column.CustomFilter = "checked||-1|||unchecked||0";
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.AddItem(true);
	var_Items.AddItem(true);
	var_Items.AddItem(false);
	var_Items.AddItem(true);
	var_Items.AddItem(false);
	var_Items.AddItem(true);
	var_Items.AddItem(false);

exontrol.EXGRIDLib.Column var_Column = (exgrid1.Columns.Add("Check") as exontrol.EXGRIDLib.Column);
	exontrol.EXGRIDLib.Editor var_Editor = var_Column.Editor;
		var_Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.CheckValueType;
		var_Editor.set_Option(exontrol.EXGRIDLib.EditorOptionEnum.exCheckValue2,1);
	var_Column.DisplayFilterButton = true;
	var_Column.DisplayFilterPattern = false;
	var_Column.FilterType = exontrol.EXGRIDLib.FilterTypeEnum.exCheck;
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.AddItem(true);
	var_Items.AddItem(true);
	var_Items.AddItem(false);
	var_Items.AddItem(true);
	var_Items.AddItem(false);
	var_Items.AddItem(true);
	var_Items.AddItem(false);

// ButtonClick event - Occurs when user clicks on the cell's button.
private void exgrid1_ButtonClick(object sender,int Item,int ColIndex,object Key)
{
	System.Diagnostics.Debug.Print( "ButtonClick" );
	System.Diagnostics.Debug.Print( exgrid1.Items.get_CellCaption(Item,ColIndex) );
	System.Diagnostics.Debug.Print( Key.ToString() );
}
//this.exgrid1.ButtonClick += new exontrol.EXGRIDLib.exg2antt.ButtonClickEventHandler(this.exgrid1_ButtonClick);

exgrid1.BeginUpdate();
exgrid1.DefaultItemHeight = 22;
exgrid1.HeaderHeight = 22;
exgrid1.Appearance = exontrol.EXGRIDLib.AppearanceEnum.None2;
exgrid1.DrawGridLines = exontrol.EXGRIDLib.GridLinesEnum.exRowLines;
exgrid1.ScrollBySingleLine = false;
exgrid1.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0" +
"/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1" +
"/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qO" +
"x3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" +
"NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=");
exgrid1.set_HTMLPicture("pic1","c:\\exontrol\\images\\auction.gif");
exontrol.EXGRIDLib.Columns var_Columns = exgrid1.Columns;
	exontrol.EXGRIDLib.Column var_Column = (var_Columns.Add("Type") as exontrol.EXGRIDLib.Column);
		var_Column.Width = 48;
		var_Column.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellValueFormat,1);
	exontrol.EXGRIDLib.Column var_Column1 = (var_Columns.Add("Appearance") as exontrol.EXGRIDLib.Column);
		var_Column1.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellValueFormat,1);
		var_Column1.Alignment = exontrol.EXGRIDLib.AlignmentEnum.CenterAlignment;
		var_Column1.HeaderAlignment = exontrol.EXGRIDLib.AlignmentEnum.CenterAlignment;
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	int h = var_Items.AddItem("Items.<b>CellHasButton</b> property");
	var_Items.set_CellValue(h,1,"Button <b>1</b>");
	var_Items.set_CellHasButton(h,1,true);
	h = var_Items.AddItem("Items.<b>CellButtonAutoWidth</b> property");
	var_Items.set_CellValue(h,1," Button <b>2</b> ");
	var_Items.set_CellHasButton(h,1,true);
	var_Items.set_CellButtonAutoWidth(h,1,true);
	h = var_Items.AddItem("Items.<b>CellHasButton</b> property");
	var_Items.set_CellValue(h,1," <img>2</img>Button <b>3</b> ");
	var_Items.set_CellHasButton(h,1,true);
	var_Items.set_CellButtonAutoWidth(h,1,true);
	h = var_Items.AddItem("Items.<b>CellHasButton</b> property");
	var_Items.set_ItemHeight(h,32);
	var_Items.set_CellValue(h,1," <img>2</img>Button <b>4</b> <img>pic1</img> ");
	var_Items.set_CellHasButton(h,1,true);
	var_Items.set_CellButtonAutoWidth(h,1,true);
	h = var_Items.AddItem("Items.<b>CellHasButton</b> in splitted cells");
	var_Items.set_CellValue(h,1," Button <b>5.1</b> ");
	var_Items.set_CellHasButton(h,1,true);
	var_Items.set_CellButtonAutoWidth(h,1,true);
	object s = var_Items.get_SplitCell(h,1);
	var_Items.set_CellValue(0,s," Button <b>5.2</b> ");
	var_Items.set_CellHasButton(0,s,true);
	var_Items.set_CellButtonAutoWidth(0,s,true);
	h = var_Items.AddItem("Column.<b>Editor</b>, Items.<b>CellEditor</b>");
	var_Items.set_CellValue(h,1,"Visible when clicking the cell");
	exontrol.EXGRIDLib.Editor var_Editor = var_Items.get_CellEditor(h,1);
		var_Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.EditType;
		var_Editor.AddButton("B1",1,0,"This is a bit of text that's shown when the cursor hovers the button B1",null,null);
		var_Editor.AddButton("B3",2,1,"This is a bit of text that's shown when the cursor hovers the button B3",null,null);
		var_Editor.AddButton("B4",1,1,"This is a bit of text that's shown when the cursor hovers the button B4",null,null);
		var_Editor.ButtonWidth = 24;
	h = var_Items.AddItem("Column.<b>Editor</b>, Items.<b>CellEditor</b>");
	var_Items.set_CellValue(h,1,3);
	exontrol.EXGRIDLib.Editor var_Editor1 = var_Items.get_CellEditor(h,1);
		var_Editor1.EditType = exontrol.EXGRIDLib.EditTypeEnum.CheckListType;
		var_Editor1.AddItem(1,"Flag 1",null);
		var_Editor1.AddItem(2,"Flag 2",null);
		var_Editor1.AddItem(4,"Flag 4",null);
		var_Editor1.AddItem(8,"Flag 8",null);
		var_Editor1.AddButton("C1",1,0,"This is a bit of text that's shown when the cursor hovers the button C1",null,null);
		var_Editor1.AddButton("C3",2,0,"This is a bit of text that's shown when the cursor hovers the button C2",null,null);
		var_Editor1.AddButton("C4",1,0,"This is a bit of text that's shown when the cursor hovers the button C3",null,null);
		var_Editor1.ButtonWidth = 24;
exgrid1.EndUpdate();

// CellStateChanged event - Fired after cell's state has been changed.
private void exgrid1_CellStateChanged(object sender,int Item,int ColIndex)
{
	exgrid1.Items.set_SelectItem(Item,true);
}
//this.exgrid1.CellStateChanged += new exontrol.EXGRIDLib.exg2antt.CellStateChangedEventHandler(this.exgrid1_CellStateChanged);

(exgrid1.Columns.Add("Check") as exontrol.EXGRIDLib.Column).set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true);
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.AddItem(0);
	var_Items.AddItem(1);
	var_Items.AddItem(2);
	var_Items.AddItem(3);

// AddItem event - Occurs after a new Item has been inserted to Items collection.
private void exgrid1_AddItem(object sender,int Item)
{
	exgrid1.Items.set_ItemMinHeight(Item,18);
	exgrid1.Items.set_ItemMaxHeight(Item,72);
}
//this.exgrid1.AddItem += new exontrol.EXGRIDLib.exg2antt.AddItemEventHandler(this.exgrid1_AddItem);

exgrid1.BeginUpdate();
exgrid1.ItemsAllowSizing = exontrol.EXGRIDLib.ItemsAllowSizingEnum.exResizeItem;
exgrid1.ScrollBySingleLine = false;
exgrid1.BackColorAlternate = Color.FromArgb(240,240,240);
exgrid1.Columns.Add("Names");
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.AddItem("Mantel");
	var_Items.AddItem("Mechanik");
	var_Items.AddItem("Motor");
	var_Items.AddItem("Murks");
	var_Items.AddItem("Märchen");
	var_Items.AddItem("Möhren");
	var_Items.AddItem("Mühle");
exgrid1.Columns[0].SortOrder = exontrol.EXGRIDLib.SortOrderEnum.SortAscending;
exgrid1.EndUpdate();

exgrid1.LinesAtRoot = exontrol.EXGRIDLib.LinesAtRootEnum.exLinesAtRoot;
exgrid1.Columns.Add("Def");
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	int h = var_Items.AddItem("Root");
	var_Items.InsertItem(h,0,"Child 1");
	var_Items.InsertItem(h,0,"Child 2");
exgrid1.PutItems(exgrid1.GetItems(-1),null);

exgrid1.BeginUpdate();
exgrid1.LinesAtRoot = exontrol.EXGRIDLib.LinesAtRootEnum.exLinesAtRoot;
exontrol.EXGRIDLib.Column var_Column = (exgrid1.Columns.Add("Items") as exontrol.EXGRIDLib.Column);
	var_Column.DisplayFilterButton = true;
	var_Column.FilterType = exontrol.EXGRIDLib.FilterTypeEnum.exFilter;
	var_Column.Filter = "Child 2";
exontrol.EXGRIDLib.Column var_Column1 = (exgrid1.Columns.Add("Pos.1") as exontrol.EXGRIDLib.Column);
	var_Column1.FormatColumn = "1 ropos ''";
	var_Column1.Position = 0;
	var_Column1.Width = 32;
	var_Column1.AllowSizing = false;
exontrol.EXGRIDLib.Column var_Column2 = (exgrid1.Columns.Add("Pos.2") as exontrol.EXGRIDLib.Column);
	var_Column2.FormatColumn = "1 ropos ':'";
	var_Column2.Position = 1;
	var_Column2.Width = 32;
	var_Column2.AllowSizing = false;
exontrol.EXGRIDLib.Column var_Column3 = (exgrid1.Columns.Add("Pos.3") as exontrol.EXGRIDLib.Column);
	var_Column3.FormatColumn = "1 ropos ':|A-Z'";
	var_Column3.Position = 2;
	var_Column3.Width = 32;
	var_Column3.AllowSizing = false;
exontrol.EXGRIDLib.Column var_Column4 = (exgrid1.Columns.Add("Pos.4") as exontrol.EXGRIDLib.Column);
	var_Column4.FormatColumn = "1 ropos '|A-Z|'";
	var_Column4.Position = 3;
	var_Column4.Width = 32;
	var_Column4.AllowSizing = false;
exontrol.EXGRIDLib.Column var_Column5 = (exgrid1.Columns.Add("Pos.5") as exontrol.EXGRIDLib.Column);
	var_Column5.FormatColumn = "'<font Tahoma;7>' + 1 ropos '-<b>||A-Z'";
	var_Column5.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellValueFormat,1);
	var_Column5.Position = 4;
	var_Column5.Width = 32;
	var_Column5.AllowSizing = false;
exontrol.EXGRIDLib.Column var_Column6 = (exgrid1.Columns.Add("Pos.6") as exontrol.EXGRIDLib.Column);
	var_Column6.FormatColumn = "'<b>'+ 1 ropos '</b>:<fgcolor=FF0000>|A-Z|'";
	var_Column6.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellValueFormat,1);
	var_Column6.Position = 5;
	var_Column6.Width = 48;
	var_Column6.AllowSizing = false;
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	int h = var_Items.AddItem("Root 1");
	var_Items.InsertItem(h,0,"Child 1");
	var_Items.InsertItem(h,0,"Child 2");
	var_Items.set_ExpandItem(h,true);
	h = var_Items.AddItem("Root 2");
	var_Items.InsertItem(h,0,"Child 1");
	var_Items.InsertItem(h,0,"Child 2");
exgrid1.ApplyFilter();
exgrid1.EndUpdate();

exgrid1.BeginUpdate();
exgrid1.LinesAtRoot = exontrol.EXGRIDLib.LinesAtRootEnum.exLinesAtRoot;
exgrid1.Columns.Add("Items");
exontrol.EXGRIDLib.Column var_Column = (exgrid1.Columns.Add("Pos.1") as exontrol.EXGRIDLib.Column);
	var_Column.FormatColumn = "1 rpos ''";
	var_Column.Position = 0;
	var_Column.Width = 32;
	var_Column.AllowSizing = false;
exontrol.EXGRIDLib.Column var_Column1 = (exgrid1.Columns.Add("Pos.2") as exontrol.EXGRIDLib.Column);
	var_Column1.FormatColumn = "1 rpos ':'";
	var_Column1.Position = 1;
	var_Column1.Width = 32;
	var_Column1.AllowSizing = false;
exontrol.EXGRIDLib.Column var_Column2 = (exgrid1.Columns.Add("Pos.3") as exontrol.EXGRIDLib.Column);
	var_Column2.FormatColumn = "1 rpos ':|A-Z'";
	var_Column2.Position = 2;
	var_Column2.Width = 32;
	var_Column2.AllowSizing = false;
exontrol.EXGRIDLib.Column var_Column3 = (exgrid1.Columns.Add("Pos.4") as exontrol.EXGRIDLib.Column);
	var_Column3.FormatColumn = "1 rpos '|A-Z|'";
	var_Column3.Position = 3;
	var_Column3.Width = 32;
	var_Column3.AllowSizing = false;
exontrol.EXGRIDLib.Column var_Column4 = (exgrid1.Columns.Add("Pos.5") as exontrol.EXGRIDLib.Column);
	var_Column4.FormatColumn = "'<font Tahoma;7>' + 1 rpos '-<b>||A-Z'";
	var_Column4.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellValueFormat,1);
	var_Column4.Position = 4;
	var_Column4.Width = 32;
	var_Column4.AllowSizing = false;
exontrol.EXGRIDLib.Column var_Column5 = (exgrid1.Columns.Add("Pos.6") as exontrol.EXGRIDLib.Column);
	var_Column5.FormatColumn = "'<b>'+ 1 rpos '</b>:<fgcolor=FF0000>|A-Z|'";
	var_Column5.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellValueFormat,1);
	var_Column5.Position = 5;
	var_Column5.Width = 48;
	var_Column5.AllowSizing = false;
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	int h = var_Items.AddItem("Root 1");
	var_Items.InsertItem(h,0,"Child 1");
	var_Items.InsertItem(h,0,"Child 2");
	var_Items.set_ExpandItem(h,true);
	h = var_Items.AddItem("Root 2");
	var_Items.InsertItem(h,0,"Child 1");
	var_Items.InsertItem(h,0,"Child 2");
exgrid1.EndUpdate();

// ValidateValue event - Occurs before user changes the cell's value.
private void exgrid1_ValidateValue(object sender,int Item,int ColIndex,object NewValue,ref bool Cancel)
{
	System.Diagnostics.Debug.Print( "ValidateValue" );
	System.Diagnostics.Debug.Print( NewValue.ToString() );
	System.Diagnostics.Debug.Print( "Change the Cancel parameter for ValidateValue event to accept/decline the newly value. " );
	System.Diagnostics.Debug.Print( "The DiscardValidateValue restores back the previously values." );
	exgrid1.DiscardValidateValue();
}
//this.exgrid1.ValidateValue += new exontrol.EXGRIDLib.exg2antt.ValidateValueEventHandler(this.exgrid1_ValidateValue);

exgrid1.BeginUpdate();
exgrid1.CauseValidateValue = exontrol.EXGRIDLib.ValidateValueType.exValidateCell;
(exgrid1.Columns.Add("Date") as exontrol.EXGRIDLib.Column).Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.DateType;
(exgrid1.Columns.Add("Text") as exontrol.EXGRIDLib.Column).Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.EditType;
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.set_CellValue(var_Items.AddItem(Convert.ToDateTime("1/1/2001")),1,"text");
	var_Items.set_CellValue(var_Items.AddItem(Convert.ToDateTime("1/1/2001")),1,"text");
	var_Items.set_CellValue(var_Items.AddItem(Convert.ToDateTime("1/1/2001")),1,"text");
	var_Items.set_CellValue(var_Items.AddItem(Convert.ToDateTime("1/1/2001")),1,"text");
	var_Items.set_CellValue(var_Items.AddItem(Convert.ToDateTime("1/1/2001")),1,"text");
exgrid1.EndUpdate();

// ValidateValue event - Occurs before user changes the cell's value.
private void exgrid1_ValidateValue(object sender,int Item,int ColIndex,object NewValue,ref bool Cancel)
{
	System.Diagnostics.Debug.Print( "ValidateValue" );
	System.Diagnostics.Debug.Print( NewValue.ToString() );
	System.Diagnostics.Debug.Print( "Change the Cancel parameter for ValidateValue event to accept/decline the newly value. " );
	Cancel = true;
	System.Diagnostics.Debug.Print( "You can not leave the item/record until the Cancel is False." );
}
//this.exgrid1.ValidateValue += new exontrol.EXGRIDLib.exg2antt.ValidateValueEventHandler(this.exgrid1_ValidateValue);

exgrid1.BeginUpdate();
exgrid1.CauseValidateValue = exontrol.EXGRIDLib.ValidateValueType.exValidateItem;
(exgrid1.Columns.Add("Date") as exontrol.EXGRIDLib.Column).Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.DateType;
(exgrid1.Columns.Add("Text") as exontrol.EXGRIDLib.Column).Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.EditType;
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.set_CellValue(var_Items.AddItem(Convert.ToDateTime("1/1/2001")),1,"text");
	var_Items.set_CellValue(var_Items.AddItem(Convert.ToDateTime("1/1/2001")),1,"text");
	var_Items.set_CellValue(var_Items.AddItem(Convert.ToDateTime("1/1/2001")),1,"text");
	var_Items.set_CellValue(var_Items.AddItem(Convert.ToDateTime("1/1/2001")),1,"text");
	var_Items.set_CellValue(var_Items.AddItem(Convert.ToDateTime("1/1/2001")),1,"text");
exgrid1.EndUpdate();

// ValidateValue event - Occurs before user changes the cell's value.
private void exgrid1_ValidateValue(object sender,int Item,int ColIndex,object NewValue,ref bool Cancel)
{
	System.Diagnostics.Debug.Print( "ValidateValue" );
	System.Diagnostics.Debug.Print( NewValue.ToString() );
	System.Diagnostics.Debug.Print( "Change the Cancel parameter for ValidateValue event to accept/decline the newly value." );
	Cancel = true;
	System.Diagnostics.Debug.Print( "You can not leave the cell until the Cancel is False." );
}
//this.exgrid1.ValidateValue += new exontrol.EXGRIDLib.exg2antt.ValidateValueEventHandler(this.exgrid1_ValidateValue);

exgrid1.BeginUpdate();
exgrid1.CauseValidateValue = exontrol.EXGRIDLib.ValidateValueType.exValidateCell;
(exgrid1.Columns.Add("Date") as exontrol.EXGRIDLib.Column).Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.DateType;
(exgrid1.Columns.Add("Text") as exontrol.EXGRIDLib.Column).Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.EditType;
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.set_CellValue(var_Items.AddItem(Convert.ToDateTime("1/1/2001")),1,"text");
	var_Items.set_CellValue(var_Items.AddItem(Convert.ToDateTime("1/1/2001")),1,"text");
	var_Items.set_CellValue(var_Items.AddItem(Convert.ToDateTime("1/1/2001")),1,"text");
	var_Items.set_CellValue(var_Items.AddItem(Convert.ToDateTime("1/1/2001")),1,"text");
	var_Items.set_CellValue(var_Items.AddItem(Convert.ToDateTime("1/1/2001")),1,"text");
exgrid1.EndUpdate();

exontrol.EXGRIDLib.Columns var_Columns = exgrid1.Columns;
	var_Columns.Add("Items");
	exontrol.EXGRIDLib.Column var_Column = (var_Columns.Add("Pos") as exontrol.EXGRIDLib.Column);
		var_Column.FormatColumn = "1 pos ''";
		var_Column.Position = 0;
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.AddItem("Item 1");
	var_Items.AddItem("Item 2");
	var_Items.AddItem("Item 3");

exgrid1.set_HTMLPicture("pic1","c:\\exontrol\\images\\zipdisk.gif");
exgrid1.ToolTipDelay = 1;
(exgrid1.Columns.Add("tootip") as exontrol.EXGRIDLib.Column).ToolTip = "<br><font Tahoma;10>This</font> is a <b>multi-lines</b> tooltip assigned to a column. The toolt" +
"ip supports built-in HTML tags, icons and pictures.<br><br><br><img>pic1</img> picture ... <br><" +
"br>";

exgrid1.VisualAppearance.Add(1,"gBFLBCJwBAEHhEJAEGg4BI0IQAAYAQGKIYBkAKBQAGaAoDDUOQzQwAAxDKKUEwsACEIrjKCYVgOHYYRrIMYgBCMJhLEoaZL" +
"hEZRQiqDYtRDFQBSDDcPw/EaRZohGaYJgEgI=");
exgrid1.set_Background32(exontrol.EXGRIDLib.BackgroundPartEnum.exCursorHoverColumn,0x1000000);
(exgrid1.Columns.Add("S") as exontrol.EXGRIDLib.Column).Width = 32;
(exgrid1.Columns.Add("Level 1") as exontrol.EXGRIDLib.Column).LevelKey = 1;
(exgrid1.Columns.Add("Level 2") as exontrol.EXGRIDLib.Column).LevelKey = 1;
(exgrid1.Columns.Add("Level 3") as exontrol.EXGRIDLib.Column).LevelKey = 1;
(exgrid1.Columns.Add("E1") as exontrol.EXGRIDLib.Column).Width = 32;
(exgrid1.Columns.Add("E2") as exontrol.EXGRIDLib.Column).Width = 32;
(exgrid1.Columns.Add("E3") as exontrol.EXGRIDLib.Column).Width = 32;
(exgrid1.Columns.Add("E4") as exontrol.EXGRIDLib.Column).Width = 32;

exgrid1.BeginUpdate();
(exgrid1.Columns.Add("Def") as exontrol.EXGRIDLib.Column).set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellValueFormat,1);
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	int h = var_Items.AddItem(100000.27);
	var_Items.set_FormatCell(h,0,"(value format '') +  ' <fgcolor=808080>(default positive)'");
	h = var_Items.AddItem(100000.27);
	var_Items.set_FormatCell(h,0,"(value format '2|.|3|,|1|1')");
	h = var_Items.AddItem(-100000.27);
	var_Items.set_FormatCell(h,0,"(value format '') +  ' <fgcolor=808080>(default negative)'");
	h = var_Items.AddItem(-100000.27);
	var_Items.set_FormatCell(h,0,"(value format '2|.|3|,|1|1')");
exgrid1.EndUpdate();

exgrid1.BeginUpdate();
(exgrid1.Columns.Add("Def") as exontrol.EXGRIDLib.Column).set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellValueFormat,1);
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	int h = var_Items.AddItem(0.27);
	var_Items.set_FormatCell(h,0,"(value format '') +  ' <fgcolor=808080>(default)'");
	h = var_Items.AddItem(0.27);
	var_Items.set_FormatCell(h,0,"(value format '|||||0') +  ' <fgcolor=808080>(Display no leading zeros)'");
exgrid1.EndUpdate();

exgrid1.BeginUpdate();
(exgrid1.Columns.Add("Def") as exontrol.EXGRIDLib.Column).set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellValueFormat,1);
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	int h = var_Items.AddItem(-100000.27);
	var_Items.set_FormatCell(h,0,"(value format '') +  ' <fgcolor=808080>(default)'");
	h = var_Items.AddItem(-100000.27);
	var_Items.set_FormatCell(h,0,"(value format '||||1') +  ' <fgcolor=808080>(Negative sign, number; for example, -1.1)'");
exgrid1.EndUpdate();

exgrid1.BeginUpdate();
(exgrid1.Columns.Add("Def") as exontrol.EXGRIDLib.Column).set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellValueFormat,1);
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	int h = var_Items.AddItem(100000.27);
	var_Items.set_FormatCell(h,0,"(value format '') +  ' <fgcolor=808080>(default)'");
	h = var_Items.AddItem(100000.27);
	var_Items.set_FormatCell(h,0,"(value format '|||-') +  ' <fgcolor=808080>(grouping character is -)'");
exgrid1.EndUpdate();

exgrid1.BeginUpdate();
(exgrid1.Columns.Add("Def") as exontrol.EXGRIDLib.Column).set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellValueFormat,1);
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	int h = var_Items.AddItem(100000.27);
	var_Items.set_FormatCell(h,0,"(value format '') +  ' <fgcolor=808080>(default)'");
	h = var_Items.AddItem(100000.27);
	var_Items.set_FormatCell(h,0,"(value format '||2') +  ' <fgcolor=808080>(grouping by 2 digits)'");
exgrid1.EndUpdate();

exgrid1.BeginUpdate();
(exgrid1.Columns.Add("Def") as exontrol.EXGRIDLib.Column).set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellValueFormat,1);
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	int h = var_Items.AddItem(100.27);
	var_Items.set_FormatCell(h,0,"(value format '') +  ' <fgcolor=808080>(default)'");
	h = var_Items.AddItem(100.27);
	var_Items.set_FormatCell(h,0,"(value format '|;') +  ' <fgcolor=808080>(decimal separator is <b>;</b>)'");
exgrid1.EndUpdate();

exgrid1.BeginUpdate();
(exgrid1.Columns.Add("Def") as exontrol.EXGRIDLib.Column).set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellValueFormat,1);
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	int h = var_Items.AddItem(100.27);
	var_Items.set_FormatCell(h,0,"(value format '') +  ' <fgcolor=808080>(default)'");
	h = var_Items.AddItem(100.27);
	var_Items.set_FormatCell(h,0,"(value format '3') +  ' <fgcolor=808080>(3 digits)'");
	h = var_Items.AddItem(100.27);
	var_Items.set_FormatCell(h,0,"(value format 2) +  '  <fgcolor=808080>(2 digits)'");
	h = var_Items.AddItem(100.27);
	var_Items.set_FormatCell(h,0,"(value format 1) +  ' <fgcolor=808080>(1 digit)'");
exgrid1.EndUpdate();

// MouseMove event - Occurs when the user moves the mouse.
private void exgrid1_MouseMoveEvent(object sender,short Button,short Shift,int X,int Y)
{
	exgrid1.ShowToolTip(exgrid1.get_ItemFromPoint(-1,-1,c,hit).ToString(),"","8","8",null);
}
//this.exgrid1.MouseMoveEvent += new exontrol.EXGRIDLib.exg2antt.MouseMoveEventHandler(this.exgrid1_MouseMoveEvent);

exgrid1.BeginUpdate();
exgrid1.Columns.Add("Def");
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.AddItem("Item 1");
	var_Items.AddItem("Item 2");
	var_Items.AddItem("Item 3");
exgrid1.EndUpdate();

exontrol.EXGRIDLib.Columns var_Columns = exgrid1.Columns;
	var_Columns.Add("A");
	var_Columns.Add("B");
	var_Columns.Add("C");
exgrid1.DrawGridLines = exontrol.EXGRIDLib.GridLinesEnum.exAllLines;
exgrid1.ColumnAutoResize = true;

exgrid1.ColumnAutoResize = false;
exontrol.EXGRIDLib.Columns var_Columns = exgrid1.Columns;
	(var_Columns.Add("A") as exontrol.EXGRIDLib.Column).Width = 128;
	(var_Columns.Add("B") as exontrol.EXGRIDLib.Column).Width = 128;
exgrid1.DrawGridLines = exontrol.EXGRIDLib.GridLinesEnum.exAllLines;

exgrid1.BeginUpdate();
exgrid1.MarkSearchColumn = false;
exontrol.EXGRIDLib.Columns var_Columns = exgrid1.Columns;
	var_Columns.Add("Name");
	exontrol.EXGRIDLib.Column var_Column = (var_Columns.Add("A") as exontrol.EXGRIDLib.Column);
		var_Column.SortType = exontrol.EXGRIDLib.SortTypeEnum.SortNumeric;
		var_Column.AllowSizing = false;
		var_Column.Width = 36;
		var_Column.FormatColumn = "len(value) ? value + ' +'";
		var_Column.Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.SpinType;
	exontrol.EXGRIDLib.Column var_Column1 = (var_Columns.Add("B") as exontrol.EXGRIDLib.Column);
		var_Column1.SortType = exontrol.EXGRIDLib.SortTypeEnum.SortNumeric;
		var_Column1.AllowSizing = false;
		var_Column1.Width = 36;
		var_Column1.FormatColumn = "len(value) ? value + ' +'";
		var_Column1.Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.SpinType;
	exontrol.EXGRIDLib.Column var_Column2 = (var_Columns.Add("C") as exontrol.EXGRIDLib.Column);
		var_Column2.SortType = exontrol.EXGRIDLib.SortTypeEnum.SortNumeric;
		var_Column2.AllowSizing = false;
		var_Column2.Width = 36;
		var_Column2.FormatColumn = "len(value) ? value + ' ='";
		var_Column2.Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.SpinType;
	exontrol.EXGRIDLib.Column var_Column3 = (var_Columns.Add("A+B+C") as exontrol.EXGRIDLib.Column);
		var_Column3.SortType = exontrol.EXGRIDLib.SortTypeEnum.SortNumeric;
		var_Column3.Width = 64;
		var_Column3.ComputedField = "dbl(%1)+dbl(%2)+dbl(%3)";
		var_Column3.FormatColumn = "type(value) in (0,1) ? 'null' : ( dbl(value)<0 ? '<fgcolor=FF0000>'+ (value format '2|.|3|,|1' " +
") : (dbl(value)>0 ? '<fgcolor=0000FF>+'+(value format '2|.|3|,' ): '0.00') )";
		var_Column3.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellValueFormat,1);
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	int h = var_Items.AddItem("Root");
	var_Items.set_CellValueFormat(h,4,exontrol.EXGRIDLib.ValueFormatEnum.exComputedField);
	int h1 = var_Items.InsertItem(h,0,"Child 1");
	var_Items.set_CellValue(h1,1,7);
	var_Items.set_CellValue(h1,2,3);
	var_Items.set_CellValue(h1,3,1);
	h1 = var_Items.InsertItem(h,0,"Child 2");
	var_Items.set_CellValue(h1,1,-2);
	var_Items.set_CellValue(h1,2,-2);
	var_Items.set_CellValue(h1,3,-4);
	h1 = var_Items.InsertItem(h,0,"Child 3");
	var_Items.set_CellValue(h1,1,2);
	var_Items.set_CellValue(h1,2,2);
	var_Items.set_CellValue(h1,3,-4);
	var_Items.set_ExpandItem(h,true);
exgrid1.EndUpdate();

exgrid1.BeginUpdate();
exgrid1.LinesAtRoot = exontrol.EXGRIDLib.LinesAtRootEnum.exLinesAtRoot;
exgrid1.Columns.Add("Items");
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	int h = var_Items.AddItem("Root 1");
	var_Items.InsertItem(h,0,"Child 1");
	var_Items.InsertItem(h,0,"Child 2");
	h = var_Items.AddItem("Root 2");
	var_Items.InsertItem(h,0,"Child 1");
	var_Items.InsertItem(h,0,"Child 2");
	var_Items.set_ExpandItem(0,false);
exgrid1.EndUpdate();

exgrid1.BeginUpdate();
exgrid1.LinesAtRoot = exontrol.EXGRIDLib.LinesAtRootEnum.exLinesAtRoot;
exgrid1.Columns.Add("Items");
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	int h = var_Items.AddItem("Root 1");
	var_Items.InsertItem(h,0,"Child 1");
	var_Items.InsertItem(h,0,"Child 2");
	h = var_Items.AddItem("Root 2");
	var_Items.InsertItem(h,0,"Child 1");
	var_Items.InsertItem(h,0,"Child 2");
	var_Items.set_ExpandItem(0,true);
exgrid1.EndUpdate();

exgrid1.BeginUpdate();
exontrol.EXGRIDLib.Column var_Column = (exgrid1.Columns.Add("Numbers") as exontrol.EXGRIDLib.Column);
	var_Column.SortType = exontrol.EXGRIDLib.SortTypeEnum.SortNumeric;
	exontrol.EXGRIDLib.Editor var_Editor = var_Column.Editor;
		var_Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.SpinType;
		var_Editor.Numeric = exontrol.EXGRIDLib.NumericEnum.exFloat;
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.AddItem(1);
	var_Items.AddItem(2);
	var_Items.AddItem(3);
	var_Items.AddItem(4);
	var_Items.set_LockedItemCount(exontrol.EXGRIDLib.VAlignmentEnum.exBottom,1);
	int h = var_Items.get_LockedItem(exontrol.EXGRIDLib.VAlignmentEnum.exBottom,0);
	var_Items.set_CellValue(h,0,"sum(all,dir,dbl(%0))");
	var_Items.set_SortableItem(h,false);
	var_Items.set_CellValueFormat(h,0,exontrol.EXGRIDLib.ValueFormatEnum.exTotalField);
	var_Items.set_CellHAlignment(h,0,exontrol.EXGRIDLib.AlignmentEnum.RightAlignment);
	var_Items.set_FormatCell(h,0,"'SUM: '+value");
exgrid1.EndUpdate();

exgrid1.BeginUpdate();
exgrid1.LinesAtRoot = exontrol.EXGRIDLib.LinesAtRootEnum.exGroupLinesAtRoot;
exgrid1.Columns.Add("");
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	int h = var_Items.AddItem("Root 1");
	object hx = var_Items.get_SplitCell(h,0);
	var_Items.set_CellValue(0,hx,"count(current,dir,1)");
	var_Items.set_CellValueFormat(0,hx,exontrol.EXGRIDLib.ValueFormatEnum.exTotalField);
	var_Items.set_FormatCell(0,hx,"'Childs: ' + value");
	var_Items.InsertItem(h,0,"Child 1");
	var_Items.InsertItem(h,0,"Child 2");
	var_Items.set_ExpandItem(h,true);
	h = var_Items.AddItem("Root 2");
	hx = var_Items.get_SplitCell(h,0);
	var_Items.set_CellValue(0,hx,"count(current,dir,1)");
	var_Items.set_CellValueFormat(0,hx,exontrol.EXGRIDLib.ValueFormatEnum.exTotalField);
	var_Items.set_FormatCell(0,hx,"'Childs: ' + value");
	var_Items.InsertItem(h,0,"Child 1");
	var_Items.InsertItem(h,0,"Child 2");
	var_Items.InsertItem(h,0,"Child 3");
	var_Items.InsertItem(h,0,"Child 4");
exgrid1.EndUpdate();

exgrid1.BeginUpdate();
exgrid1.Columns.Add("T");
exontrol.EXGRIDLib.Editor var_Editor = (exgrid1.Columns.Add("A") as exontrol.EXGRIDLib.Column).Editor;
	var_Editor.Numeric = exontrol.EXGRIDLib.NumericEnum.exInteger;
	var_Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.SpinType;
exontrol.EXGRIDLib.Editor var_Editor1 = (exgrid1.Columns.Add("B") as exontrol.EXGRIDLib.Column).Editor;
	var_Editor1.Numeric = exontrol.EXGRIDLib.NumericEnum.exInteger;
	var_Editor1.EditType = exontrol.EXGRIDLib.EditTypeEnum.SpinType;
exgrid1.Columns.Add("A+B");
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	int h = var_Items.AddItem("Incorrect");
	var_Items.set_CellToolTip(h,0,"Just type a number in the column A or B. The result will be concaternated");
	var_Items.set_CellValue(h,1,"10");
	var_Items.set_CellValue(h,2,"20");
	var_Items.set_CellValue(h,3,"currency(%1+%2)");
	var_Items.set_CellValueFormat(h,3,exontrol.EXGRIDLib.ValueFormatEnum.exComputedField);
	h = var_Items.AddItem("Correct");
	var_Items.set_CellValue(h,1,10);
	var_Items.set_CellValue(h,2,20);
	var_Items.set_CellValue(h,3,"currency(dbl(%1)+dbl(%2))");
	var_Items.set_CellValueFormat(h,3,exontrol.EXGRIDLib.ValueFormatEnum.exComputedField);
exgrid1.EndUpdate();

exgrid1.BeginUpdate();
(exgrid1.Columns.Add("A") as exontrol.EXGRIDLib.Column).Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.SpinType;
(exgrid1.Columns.Add("B") as exontrol.EXGRIDLib.Column).Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.SpinType;
exgrid1.Columns.Add("A+B");
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	int h = var_Items.AddItem(10);
	var_Items.set_CellValue(h,1,20);
	var_Items.set_CellValueFormat(h,2,exontrol.EXGRIDLib.ValueFormatEnum.exComputedField);
	var_Items.set_CellValue(h,2,"currency(dbl(%0)+dbl(%1))");
	System.Diagnostics.Debug.Print( "CellCaption returns " );
	System.Diagnostics.Debug.Print( var_Items.get_CellCaption(h,2) );
	System.Diagnostics.Debug.Print( "CellValue returns " );
	System.Diagnostics.Debug.Print( var_Items.get_CellValue(h,2).ToString() );
	System.Diagnostics.Debug.Print( "ComputeValue returns " );
	System.Diagnostics.Debug.Print( var_Items.get_ComputeValue("dbl(%0)+dbl(%1)",h,0,var_Items.get_CellValueFormat(h,2)).ToString() );
exgrid1.EndUpdate();

exgrid1.BeginUpdate();
exgrid1.Columns.Add("A");
exgrid1.Columns.Add("B");
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	int h = var_Items.AddItem(10);
	var_Items.set_CellValue(h,1,20);
	System.Diagnostics.Debug.Print( "A+B is " );
	System.Diagnostics.Debug.Print( var_Items.get_ComputeValue("dbl(%0)+dbl(%1)",h,0,2).ToString() );
exgrid1.EndUpdate();

exgrid1.BeginUpdate();
exgrid1.Columns.Add("");
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	int h = var_Items.AddItem("<b>bold</b>");
	System.Diagnostics.Debug.Print( var_Items.get_ComputeValue(var_Items.get_CellValue(h,0),h,0,1).ToString() );
exgrid1.EndUpdate();

exgrid1.BeginUpdate();
exgrid1.TreeColumnIndex = -1;
exgrid1.SortOnClick = exontrol.EXGRIDLib.SortOnClickEnum.exNoSort;
exgrid1.Columns.Add("Numbers");
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.AddItem(1);
	var_Items.AddItem(2);
	int h = var_Items.AddItem("separator");
	var_Items.set_SelectableItem(h,false);
	var_Items.set_ItemDivider(h,0);
	var_Items.set_ItemDividerLineAlignment(h,exontrol.EXGRIDLib.DividerAlignmentEnum.DividerCenter);
	var_Items.set_ItemDividerLine(h,exontrol.EXGRIDLib.DividerLineEnum.ThinLine);
	var_Items.set_CellHAlignment(h,0,exontrol.EXGRIDLib.AlignmentEnum.CenterAlignment);
	var_Items.AddItem(3);
	var_Items.AddItem(4);
exgrid1.EndUpdate();

exgrid1.BeginUpdate();
(exgrid1.Columns.Add("Numbers") as exontrol.EXGRIDLib.Column).SortType = exontrol.EXGRIDLib.SortTypeEnum.SortNumeric;
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.AddItem(1);
	var_Items.AddItem(2);
	var_Items.AddItem(0);
	var_Items.AddItem(0);
	var_Items.AddItem(0);
	var_Items.AddItem(0);
	var_Items.AddItem(3);
	var_Items.AddItem(4);
	int h = var_Items.AddItem("sum(all,dir,dbl(%0)?1:0)");
	var_Items.set_SortableItem(h,false);
	var_Items.set_CellValueFormat(h,0,exontrol.EXGRIDLib.ValueFormatEnum.exTotalField);
	var_Items.set_CellHAlignment(h,0,exontrol.EXGRIDLib.AlignmentEnum.RightAlignment);
	var_Items.set_FormatCell(h,0,"'COUNT non-zero: '+value");
exgrid1.EndUpdate();

exgrid1.BeginUpdate();
(exgrid1.Columns.Add("Numbers") as exontrol.EXGRIDLib.Column).SortType = exontrol.EXGRIDLib.SortTypeEnum.SortNumeric;
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.AddItem(1);
	var_Items.AddItem(2);
	var_Items.AddItem(3);
	var_Items.AddItem(4);
	int h = var_Items.AddItem("avg(all,dir,dbl(%0))");
	var_Items.set_SortableItem(h,false);
	var_Items.set_CellValueFormat(h,0,exontrol.EXGRIDLib.ValueFormatEnum.exTotalField);
	var_Items.set_CellHAlignment(h,0,exontrol.EXGRIDLib.AlignmentEnum.RightAlignment);
	var_Items.set_FormatCell(h,0,"'AVG: '+value");
exgrid1.EndUpdate();

exgrid1.BeginUpdate();
(exgrid1.Columns.Add("Numbers") as exontrol.EXGRIDLib.Column).SortType = exontrol.EXGRIDLib.SortTypeEnum.SortNumeric;
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.AddItem(1);
	var_Items.AddItem(2);
	var_Items.AddItem(3);
	var_Items.AddItem(4);
	int h = var_Items.AddItem("count(all,dir,0)");
	var_Items.set_SortableItem(h,false);
	var_Items.set_CellValueFormat(h,0,exontrol.EXGRIDLib.ValueFormatEnum.exTotalField);
	var_Items.set_CellHAlignment(h,0,exontrol.EXGRIDLib.AlignmentEnum.RightAlignment);
	var_Items.set_FormatCell(h,0,"'COUNT: '+value");
exgrid1.EndUpdate();

exgrid1.BeginUpdate();
(exgrid1.Columns.Add("Numbers") as exontrol.EXGRIDLib.Column).SortType = exontrol.EXGRIDLib.SortTypeEnum.SortNumeric;
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.AddItem(1);
	var_Items.AddItem(2);
	var_Items.AddItem(3);
	var_Items.AddItem(4);
	int h = var_Items.AddItem("max(all,dir,dbl(%0))");
	var_Items.set_SortableItem(h,false);
	var_Items.set_CellValueFormat(h,0,exontrol.EXGRIDLib.ValueFormatEnum.exTotalField);
	var_Items.set_CellHAlignment(h,0,exontrol.EXGRIDLib.AlignmentEnum.RightAlignment);
	var_Items.set_FormatCell(h,0,"'MAX: '+value");
exgrid1.EndUpdate();

exgrid1.BeginUpdate();
(exgrid1.Columns.Add("Numbers") as exontrol.EXGRIDLib.Column).SortType = exontrol.EXGRIDLib.SortTypeEnum.SortNumeric;
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.AddItem(1);
	var_Items.AddItem(2);
	var_Items.AddItem(3);
	var_Items.AddItem(4);
	int h = var_Items.AddItem("min(all,dir,dbl(%0))");
	var_Items.set_SortableItem(h,false);
	var_Items.set_CellValueFormat(h,0,exontrol.EXGRIDLib.ValueFormatEnum.exTotalField);
	var_Items.set_CellHAlignment(h,0,exontrol.EXGRIDLib.AlignmentEnum.RightAlignment);
	var_Items.set_FormatCell(h,0,"'MIN: '+value");
exgrid1.EndUpdate();

exgrid1.BeginUpdate();
(exgrid1.Columns.Add("Numbers") as exontrol.EXGRIDLib.Column).SortType = exontrol.EXGRIDLib.SortTypeEnum.SortNumeric;
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.AddItem(1);
	var_Items.AddItem(2);
	var_Items.AddItem(3);
	var_Items.AddItem(4);
	int h = var_Items.AddItem("sum(all,dir,dbl(%0))");
	var_Items.set_SortableItem(h,false);
	var_Items.set_CellValueFormat(h,0,exontrol.EXGRIDLib.ValueFormatEnum.exTotalField);
	var_Items.set_CellHAlignment(h,0,exontrol.EXGRIDLib.AlignmentEnum.RightAlignment);
	var_Items.set_FormatCell(h,0,"'SUM: '+value");
exgrid1.EndUpdate();

// Change event - Occurs when the user changes the cell's content.
private void exgrid1_Change(object sender,int Item,int ColIndex,ref object NewValue)
{
	exgrid1.Refresh();
}
//this.exgrid1.Change += new exontrol.EXGRIDLib.exg2antt.ChangeEventHandler(this.exgrid1_Change);

exgrid1.BeginUpdate();
exgrid1.LinesAtRoot = exontrol.EXGRIDLib.LinesAtRootEnum.exGroupLinesAtRoot;
exgrid1.Columns.Add("Members");
exontrol.EXGRIDLib.Column var_Column = (exgrid1.Columns.Add("Values") as exontrol.EXGRIDLib.Column);
	var_Column.FormatColumn = "currency(value)";
	exontrol.EXGRIDLib.Editor var_Editor = var_Column.Editor;
		var_Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.SpinType;
		var_Editor.Numeric = exontrol.EXGRIDLib.NumericEnum.exInteger;
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	int h = var_Items.AddItem("Group 1");
	var_Items.set_ItemBold(h,true);
	var_Items.set_CellEditorVisible(h,1,false);
	var_Items.set_CellValue(h,1,"sum(current,dir,dbl(%1))");
	var_Items.set_CellValueFormat(h,1,exontrol.EXGRIDLib.ValueFormatEnum.exHTML | exontrol.EXGRIDLib.ValueFormatEnum.exTotalField);
	var_Items.set_CellHAlignment(h,1,exontrol.EXGRIDLib.AlignmentEnum.RightAlignment);
	var_Items.set_CellValue(var_Items.InsertItem(h,0,"Child 1"),1,10);
	var_Items.set_CellValue(var_Items.InsertItem(h,0,"Child 2"),1,20);
	var_Items.set_CellValue(var_Items.InsertItem(h,0,"Child 3"),1,30);
	var_Items.set_ExpandItem(h,true);
	h = var_Items.AddItem("Group 2");
	var_Items.set_ItemBold(h,true);
	var_Items.set_CellEditorVisible(h,1,false);
	var_Items.set_CellValue(h,1,"sum(current,dir,dbl(%1))");
	var_Items.set_CellValueFormat(h,1,exontrol.EXGRIDLib.ValueFormatEnum.exHTML | exontrol.EXGRIDLib.ValueFormatEnum.exTotalField);
	var_Items.set_CellHAlignment(h,1,exontrol.EXGRIDLib.AlignmentEnum.RightAlignment);
	var_Items.set_CellValue(var_Items.InsertItem(h,0,"Child 1"),1,5);
	var_Items.set_CellValue(var_Items.InsertItem(h,0,"Child 2"),1,15);
	var_Items.set_CellValue(var_Items.InsertItem(h,0,"Child 3"),1,35);
	h = var_Items.AddItem("total");
	var_Items.set_CellValue(h,1,"sum(all,rec,dbl(%1))");
	var_Items.set_CellValueFormat(h,1,exontrol.EXGRIDLib.ValueFormatEnum.exHTML | exontrol.EXGRIDLib.ValueFormatEnum.exTotalField);
	var_Items.set_CellEditorVisible(h,1,false);
	var_Items.set_FormatCell(h,1,"'Total: <b>' + currency(value)");
	var_Items.set_CellHAlignment(h,1,exontrol.EXGRIDLib.AlignmentEnum.RightAlignment);
	var_Items.set_ItemDivider(h,1);
	var_Items.set_ItemDividerLineAlignment(h,exontrol.EXGRIDLib.DividerAlignmentEnum.DividerCenter);
	var_Items.set_ItemDividerLine(h,exontrol.EXGRIDLib.DividerLineEnum.DoubleLine);
	var_Items.set_SortableItem(h,false);
exgrid1.EndUpdate();

// Change event - Occurs when the user changes the cell's content.
private void exgrid1_Change(object sender,int Item,int ColIndex,ref object NewValue)
{
	exgrid1.Refresh();
}
//this.exgrid1.Change += new exontrol.EXGRIDLib.exg2antt.ChangeEventHandler(this.exgrid1_Change);

exgrid1.BeginUpdate();
exgrid1.BackColor = Color.FromArgb(255,255,255);
exgrid1.LinesAtRoot = exontrol.EXGRIDLib.LinesAtRootEnum.exGroupLinesAtRoot;
exgrid1.ShowFocusRect = false;
exgrid1.Columns.Add("Members");
exontrol.EXGRIDLib.Column var_Column = (exgrid1.Columns.Add("Values") as exontrol.EXGRIDLib.Column);
	var_Column.FormatColumn = "currency(value)";
	exontrol.EXGRIDLib.Editor var_Editor = var_Column.Editor;
		var_Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.SpinType;
		var_Editor.Numeric = exontrol.EXGRIDLib.NumericEnum.exInteger;
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	int h = var_Items.AddItem("Group 1");
	var_Items.set_ItemBold(h,true);
	var_Items.set_SortableItem(h,false);
	var_Items.set_CellEditorVisible(h,1,false);
	var_Items.set_FormatCell(h,1," ");
	var_Items.set_CellValue(var_Items.InsertItem(h,0,"Child 1"),1,10);
	var_Items.set_CellValue(var_Items.InsertItem(h,0,"Child 2"),1,20);
	var_Items.set_CellValue(var_Items.InsertItem(h,0,"Child 3"),1,30);
	int hT = var_Items.InsertItem(h,0,"subtotal");
	var_Items.set_CellHAlignment(hT,1,exontrol.EXGRIDLib.AlignmentEnum.RightAlignment);
	var_Items.set_CellEditorVisible(hT,1,false);
	var_Items.set_CellValue(hT,1,"sum(parent,dir,dbl(%1))");
	var_Items.set_CellValueFormat(hT,1,exontrol.EXGRIDLib.ValueFormatEnum.exHTML | exontrol.EXGRIDLib.ValueFormatEnum.exTotalField);
	var_Items.set_FormatCell(hT,1,"'subtotal: <b>' + currency(value)");
	var_Items.set_ItemDivider(hT,1);
	var_Items.set_ItemDividerLineAlignment(hT,exontrol.EXGRIDLib.DividerAlignmentEnum.DividerCenter);
	var_Items.set_SortableItem(hT,false);
	var_Items.set_SelectableItem(hT,false);
	var_Items.set_ItemDividerLine(hT,exontrol.EXGRIDLib.DividerLineEnum.DotLine);
	var_Items.set_ExpandItem(h,true);
	h = var_Items.AddItem("Group 2");
	var_Items.set_ItemBold(h,true);
	var_Items.set_SortableItem(h,false);
	var_Items.set_FormatCell(h,1," ");
	var_Items.set_CellEditorVisible(h,1,false);
	var_Items.set_CellValue(var_Items.InsertItem(h,0,"Child 1"),1,15);
	var_Items.set_CellValue(var_Items.InsertItem(h,0,"Child 2"),1,25);
	var_Items.set_CellValue(var_Items.InsertItem(h,0,"Child 3"),1,18);
	hT = var_Items.InsertItem(h,0,"subtotal");
	var_Items.set_CellHAlignment(hT,1,exontrol.EXGRIDLib.AlignmentEnum.RightAlignment);
	var_Items.set_CellEditorVisible(hT,1,false);
	var_Items.set_CellValue(hT,1,"sum(parent,dir,dbl(%1))");
	var_Items.set_CellValueFormat(hT,1,exontrol.EXGRIDLib.ValueFormatEnum.exHTML | exontrol.EXGRIDLib.ValueFormatEnum.exTotalField);
	var_Items.set_FormatCell(hT,1,"'subtotal: <b>' + currency(value)");
	var_Items.set_ItemDivider(hT,1);
	var_Items.set_ItemDividerLineAlignment(hT,exontrol.EXGRIDLib.DividerAlignmentEnum.DividerCenter);
	var_Items.set_ItemDividerLine(hT,exontrol.EXGRIDLib.DividerLineEnum.DotLine);
	var_Items.set_SortableItem(hT,false);
	var_Items.set_SelectableItem(hT,false);
	var_Items.set_ExpandItem(h,true);
	h = var_Items.AddItem("total");
	var_Items.set_CellValue(h,1,"sum(all,rec,dbl(%1))");
	var_Items.set_CellValueFormat(h,1,exontrol.EXGRIDLib.ValueFormatEnum.exHTML | exontrol.EXGRIDLib.ValueFormatEnum.exTotalField);
	var_Items.set_CellEditorVisible(h,1,false);
	var_Items.set_FormatCell(h,1,"'Total: <b><font ;11>' + currency(value)");
	var_Items.set_CellHAlignment(h,1,exontrol.EXGRIDLib.AlignmentEnum.CenterAlignment);
	var_Items.set_ItemDivider(h,1);
	var_Items.set_ItemDividerLineAlignment(h,exontrol.EXGRIDLib.DividerAlignmentEnum.DividerCenter);
	var_Items.set_ItemDividerLine(h,exontrol.EXGRIDLib.DividerLineEnum.DoubleLine);
	var_Items.set_SortableItem(h,false);
	var_Items.set_SelectableItem(h,false);
exgrid1.EndUpdate();

// Change event - Occurs when the user changes the cell's content.
private void exgrid1_Change(object sender,int Item,int ColIndex,ref object NewValue)
{
	exgrid1.Refresh();
}
//this.exgrid1.Change += new exontrol.EXGRIDLib.exg2antt.ChangeEventHandler(this.exgrid1_Change);

exgrid1.BeginUpdate();
exontrol.EXGRIDLib.Column var_Column = (exgrid1.Columns.Add("C1") as exontrol.EXGRIDLib.Column);
	exontrol.EXGRIDLib.Editor var_Editor = var_Column.Editor;
		var_Editor.Numeric = exontrol.EXGRIDLib.NumericEnum.exInteger;
		var_Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.SpinType;
	var_Column.SortType = exontrol.EXGRIDLib.SortTypeEnum.SortNumeric;
exontrol.EXGRIDLib.Column var_Column1 = (exgrid1.Columns.Add("C2") as exontrol.EXGRIDLib.Column);
	exontrol.EXGRIDLib.Editor var_Editor1 = var_Column1.Editor;
		var_Editor1.Numeric = exontrol.EXGRIDLib.NumericEnum.exInteger;
		var_Editor1.EditType = exontrol.EXGRIDLib.EditTypeEnum.SpinType;
	var_Column1.SortType = exontrol.EXGRIDLib.SortTypeEnum.SortNumeric;
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.set_LockedItemCount(exontrol.EXGRIDLib.VAlignmentEnum.exBottom,1);
	int h = var_Items.get_LockedItem(exontrol.EXGRIDLib.VAlignmentEnum.exBottom,0);
	var_Items.set_ItemBackColor(h,Color.FromArgb(0,0,0));
	var_Items.set_ItemBold(h,true);
	var_Items.set_CellValue(h,0,"sum(all,dir,dbl(%0))");
	var_Items.set_CellValueFormat(h,0,exontrol.EXGRIDLib.ValueFormatEnum.exTotalField);
	var_Items.set_CellValue(h,1,"sum(all,dir,dbl(%1))");
	var_Items.set_CellValueFormat(h,1,exontrol.EXGRIDLib.ValueFormatEnum.exTotalField);
exontrol.EXGRIDLib.Items var_Items1 = exgrid1.Items;
	var_Items1.set_CellValue(var_Items1.AddItem(10),1,12);
	var_Items1.set_CellValue(var_Items1.AddItem(25),1,5);
	var_Items1.set_CellValue(var_Items1.AddItem(31),1,17);
	var_Items1.set_CellValue(var_Items1.AddItem(48),1,22);
exgrid1.EndUpdate();

// Change event - Occurs when the user changes the cell's content.
private void exgrid1_Change(object sender,int Item,int ColIndex,ref object NewValue)
{
	exgrid1.Refresh();
}
//this.exgrid1.Change += new exontrol.EXGRIDLib.exg2antt.ChangeEventHandler(this.exgrid1_Change);

exgrid1.ColumnAutoResize = false;
exgrid1.ContinueColumnScroll = false;
// Add 'Microsoft ActiveX Data Objects 6.0 Library' reference to your project.
ADODB.Recordset rs = new ADODB.Recordset();
	rs.Open("Orders","Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Program Files\\Exontrol\\ExGrid\\Sample\\SAMPL" +
"E.MDB",exontrol.ADODB.CursorTypeEnum.adOpenStatic,exontrol.ADODB.LockTypeEnum.adLockOptimistic,0);
exgrid1.DataSource = (rs as ADODB.Recordset);
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.set_LockedItemCount(exontrol.EXGRIDLib.VAlignmentEnum.exTop,1);
	int h = var_Items.get_LockedItem(exontrol.EXGRIDLib.VAlignmentEnum.exTop,0);
	var_Items.set_ItemDivider(h,0);
	var_Items.set_CellValueFormat(h,0,exontrol.EXGRIDLib.ValueFormatEnum.exHTML | exontrol.EXGRIDLib.ValueFormatEnum.exTotalField);
	var_Items.set_CellValue(h,0,"sum(all,dir,%1)");

// Change event - Occurs when the user changes the cell's content.
private void exgrid1_Change(object sender,int Item,int ColIndex,ref object NewValue)
{
	exgrid1.Refresh();
}
//this.exgrid1.Change += new exontrol.EXGRIDLib.exg2antt.ChangeEventHandler(this.exgrid1_Change);

exgrid1.BeginUpdate();
exontrol.EXGRIDLib.Column var_Column = (exgrid1.Columns.Add("Numbers") as exontrol.EXGRIDLib.Column);
	exontrol.EXGRIDLib.Editor var_Editor = var_Column.Editor;
		var_Editor.Numeric = exontrol.EXGRIDLib.NumericEnum.exInteger;
		var_Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.SpinType;
	var_Column.SortType = exontrol.EXGRIDLib.SortTypeEnum.SortNumeric;
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.set_LockedItemCount(exontrol.EXGRIDLib.VAlignmentEnum.exTop,1);
	int h = var_Items.get_LockedItem(exontrol.EXGRIDLib.VAlignmentEnum.exTop,0);
	var_Items.set_ItemBackColor(h,Color.FromArgb(0,0,0));
	var_Items.set_CellValue(h,0,"sum(all,dir,dbl(%0))");
	var_Items.set_CellValueFormat(h,0,exontrol.EXGRIDLib.ValueFormatEnum.exTotalField);
	var_Items.set_CellHAlignment(h,0,exontrol.EXGRIDLib.AlignmentEnum.RightAlignment);
	var_Items.set_FormatCell(h,0,"'Total: '+value");
exontrol.EXGRIDLib.Items var_Items1 = exgrid1.Items;
	var_Items1.AddItem(10);
	var_Items1.AddItem(25);
	var_Items1.AddItem(31);
	var_Items1.AddItem(48);
exgrid1.EndUpdate();

// Change event - Occurs when the user changes the cell's content.
private void exgrid1_Change(object sender,int Item,int ColIndex,ref object NewValue)
{
	exgrid1.Refresh();
}
//this.exgrid1.Change += new exontrol.EXGRIDLib.exg2antt.ChangeEventHandler(this.exgrid1_Change);

exgrid1.BeginUpdate();
exontrol.EXGRIDLib.Editor var_Editor = (exgrid1.Columns.Add("Items") as exontrol.EXGRIDLib.Column).Editor;
	var_Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.SpinType;
	var_Editor.Numeric = exontrol.EXGRIDLib.NumericEnum.exInteger;
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	int h = var_Items.AddItem("Group 1");
	var_Items.set_CellEditorVisible(h,0,false);
	var_Items.InsertItem(h,0,10);
	var_Items.InsertItem(h,0,20);
	var_Items.InsertItem(h,0,30);
	int hT = var_Items.InsertItem(h,0,"sum(parent,dir,dbl(%0))");
	var_Items.set_CellEditorVisible(hT,0,false);
	var_Items.set_CellValueFormat(hT,0,exontrol.EXGRIDLib.ValueFormatEnum.exHTML | exontrol.EXGRIDLib.ValueFormatEnum.exTotalField);
	var_Items.set_ItemDivider(hT,0);
	var_Items.set_ItemDividerLineAlignment(hT,exontrol.EXGRIDLib.DividerAlignmentEnum.DividerTop);
	var_Items.set_SelectableItem(hT,false);
	var_Items.set_SortableItem(hT,false);
	var_Items.set_ExpandItem(h,true);
exgrid1.EndUpdate();

exgrid1.BeginUpdate();
exgrid1.Columns.Add("Value");
exgrid1.Columns.Add("FormatCell");
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	int h = var_Items.AddItem(1);
	var_Items.set_CellValue(h,1,12);
	var_Items.set_FormatCell(h,1,"currency(value)");
	h = var_Items.AddItem(Convert.ToDateTime("1/1/2001"));
	var_Items.set_CellValue(h,1,Convert.ToDateTime("1/1/2001"));
	var_Items.set_CellValueFormat(h,1,exontrol.EXGRIDLib.ValueFormatEnum.exHTML);
	var_Items.set_FormatCell(h,1,"longdate(value) replace '2001' with '<b>2001</b>'");
exgrid1.EndUpdate();

exgrid1.HasLines = exontrol.EXGRIDLib.HierarchyLineEnum.exNoLine;
exgrid1.ScrollBySingleLine = true;
exontrol.EXGRIDLib.Columns var_Columns = exgrid1.Columns;
	var_Columns.Add("Name");
	var_Columns.Add("A");
	var_Columns.Add("B");
	var_Columns.Add("C");
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	int h = var_Items.AddItem("Group 1");
	var_Items.set_CellHAlignment(h,0,exontrol.EXGRIDLib.AlignmentEnum.CenterAlignment);
	var_Items.set_ItemDivider(h,0);
	var_Items.set_ItemDividerLineAlignment(h,exontrol.EXGRIDLib.DividerAlignmentEnum.DividerBoth);
	var_Items.set_ItemHeight(h,24);
	var_Items.set_SortableItem(h,false);
	int h1 = var_Items.InsertItem(h,0,"Child 1");
	var_Items.set_CellValue(h1,1,1);
	var_Items.set_CellValue(h1,2,2);
	var_Items.set_CellValue(h1,3,3);
	h1 = var_Items.InsertItem(h,0,"Child 2");
	var_Items.set_CellValue(h1,1,4);
	var_Items.set_CellValue(h1,2,5);
	var_Items.set_CellValue(h1,3,6);
	var_Items.set_ExpandItem(h,true);
	h = var_Items.AddItem("Group 2");
	var_Items.set_CellHAlignment(h,0,exontrol.EXGRIDLib.AlignmentEnum.CenterAlignment);
	var_Items.set_ItemDivider(h,0);
	var_Items.set_ItemDividerLineAlignment(h,exontrol.EXGRIDLib.DividerAlignmentEnum.DividerBoth);
	var_Items.set_ItemHeight(h,24);
	var_Items.set_SortableItem(h,false);
	h1 = var_Items.InsertItem(h,0,"Child 1");
	var_Items.set_CellValue(h1,1,1);
	var_Items.set_CellValue(h1,2,2);
	var_Items.set_CellValue(h1,3,3);
	h1 = var_Items.InsertItem(h,0,"Child 2");
	var_Items.set_CellValue(h1,1,4);
	var_Items.set_CellValue(h1,2,5);
	var_Items.set_CellValue(h1,3,6);
	var_Items.set_ExpandItem(h,true);

exgrid1.BeginUpdate();
exgrid1.MarkSearchColumn = false;
exontrol.EXGRIDLib.Columns var_Columns = exgrid1.Columns;
	var_Columns.Add("Name");
	exontrol.EXGRIDLib.Column var_Column = (var_Columns.Add("Values") as exontrol.EXGRIDLib.Column);
		var_Column.SortType = exontrol.EXGRIDLib.SortTypeEnum.SortNumeric;
		var_Column.AllowSizing = false;
		var_Column.Width = 64;
		var_Column.FormatColumn = "((0:=dbl(value)) < 10? '<fgcolor=808080><font ;7>' :'<b>') + currency(=:0)";
		var_Column.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellValueFormat,1);
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	int h = var_Items.AddItem("Root");
	var_Items.set_FormatCell(h,1,"'<none>'");
	var_Items.set_CellValue(var_Items.InsertItem(h,0,"Child 1"),1,10);
	var_Items.set_CellValue(var_Items.InsertItem(h,0,"Child 2"),1,15);
	var_Items.set_CellValue(var_Items.InsertItem(h,0,"Child 3"),1,25);
	var_Items.set_ExpandItem(h,true);
exgrid1.EndUpdate();