|
79
|
ImageSize property on 32 (specifies the size of control' icons/images/check-boxes/radio-buttons)
// CreateView event - A view has been created.
private void excascadetree1_CreateView(object sender,exontrol.EXCASCADETREELib.View View)
{
// Items.ItemHeight(0) = View.DefaultItemHeight
// FilterBarFont.Size = Me.Font.Size
// ToolTipFont.Size = Me.Font.Size
exontrol.EXCASCADETREELib.View var_View = excascadetree1.View;
var_View.DefaultItemHeight = 36;
var_View.HeaderHeight = var_View.DefaultItemHeight;
var_View.SortBarHeight = var_View.DefaultItemHeight;
var_View.Indent = 26;
var_View.set_CheckImage(exontrol.EXCASCADETREELib.CheckStateEnum.Unchecked,16777216);
var_View.set_CheckImage(exontrol.EXCASCADETREELib.CheckStateEnum.Checked,33554432);
var_View.set_CheckImage(exontrol.EXCASCADETREELib.CheckStateEnum.PartialChecked,50331648);
var_View.EnsureVisibleColumn("Function");
Object var_Object = var_View.Columns["Function"];
var_View.Columns[0].set_Def(exontrol.EXCASCADETREELib.DefColumnEnum.exCellHasCheckBox,true);
}
//this.excascadetree1.CreateView += new exontrol.EXCASCADETREELib.exg2antt.CreateViewEventHandler(this.excascadetree1_CreateView);
// Error event - An internal error occurs.
private void excascadetree1_Error(object sender,int Err,string Description)
{
System.Diagnostics.Debug.Print( "Error" );
System.Diagnostics.Debug.Print( Description.ToString() );
}
//this.excascadetree1.Error += new exontrol.EXCASCADETREELib.exg2antt.ErrorEventHandler(this.excascadetree1_Error);
excascadetree1.BeginUpdate();
excascadetree1.ImageSize = 32;
excascadetree1.Font.Size = 16;
excascadetree1.Images("gBJJgBAIDAAEg4AEEKAD/hz/EMNh8TIRNGwAjEZAEXjAojKAjMLjABhkaABAk0plUrlktl0vmExmUzmk1m03nE5nU7nk9miAoE+oVDolFo1HpFJpU5h8Sf9OqFNqUOq" +
"NUqdPq9VrFWrlbr1QpdhAFAkFis1ntFptVrtkrpszrNvmVxqk3uVtm1kmF3sdBvF/wGBmV+j9BYGHwWJulfxdax2NyFdx2JlV6l9Nw7AAGZymdz2Cy2GxErvWcz9ivlw" +
"yV21cuxugwktzGIzmvwtl0+53U5y0a0Wazmmyu/3dCyOMyXHx/J5nIr9q3uyqnBxFN3G46ma4vb7mD2Ng4nZze00fDkHC7t7us2rOX5tguetpHRlmz4HVqnXk1PjHO+C" +
"MPo9MBMC+j2vC8j7wS8cFNI4kBo05UIvfCT/NsnsApU+0Fqg/T+oy/kPxC0sEQfErKQK96+w28UWRI8UGvO8sTLS9r2PWmsMJTDTask3CsIbIEQRA3shOXEEAO/GclJ9" +
"FEKrrA8FRbKMXRIlb0JxCkjS1LMswhCcvuel0cv26cSMa8Ufx+2sQwhEUoSXOCjSbLcnxjKc7sdKUVyq28NtVI71P9P7JxtQEapjQ6fzfM8zPfNE2PhIsLL63E40slk5" +
"y7N89LcyU9SvMb3SdUc6VJLj5VLVLfO/PS9KzNFHUa/0XyBD0dxlS9cxhMlTRSoNXypPErWDPyfNS+MwprRNO0FD8wVVZ1AI08URwVRjtJ1WCn21QkkUrXVLVPQS/XIk" +
"FgTxT9iONZ9xVTdq+L1eKg3kkF6Upe68XtfV51/MtrVjBlwYFL1ev8y1/P6/lyzzYl02wntj0RVFmS1Qa+M5as93QxEUW9e993rfmQ2+vy65M/mL1lhl/2bj2ByVduMt" +
"NhCJT9hdz41nN14Ld12Z9UjfI/oUAaGseiw6+uFLLhcVabJOS5RqOE0BHlZ5VnEr5fOMs3st+aa/bbRzrJGV51Y0b0DbqaWXZD90hIsPbjWu52+6Wyadpe66hhO+P/Xi" +
"oW5rD8ZbrUZuVg6n1dsE/cXmewu1m9PVwnd35/nueXho/NaJzmjc61W76esuT77eG8pTquy9TwWH8LEzG8RDfFalx3Gcfvna9rvG/cptGLd9tuI6TZOP5Fiqi99vea+X" +
"4VRcBq/JZZtVQ9cwSs5lsXE372+a9z7PbfB3VVqHyvMctLto8uob6eV0m/cD6MN2v+T33t6sBut42vdv2bJ8a997x2maFJfK+qArbGJPEKE+1qTflMsIdW/GCJX17KcT" +
"6/czr/X+u1g29B7j/4BQfWkkx4zIHisjhPCmE0K4SwtXM+d4BvHRwNZOoBph9IJvPek9d40FoMJxf691jj2ywQQcHEWET4XJwkTszlVqm2GokewxtBT1DpQjRxDN0rUV" +
"DNKdC3lb6tzNOwh6upMSSYfv4YBCl/bsn9PxiFCEo7SI6Obc9HeOrnY8x4jtHtdpN4GRbaorhsbu18Pph5CiHymI0RpSXGJ/z2oUOxYxG858AyiI+bfJtuTcG5yelBJy" +
"T8okhqFd4a5yxL0rvulYtKCsZiWxWkc1s1cRoxxwhA31DLE0mR9l9HqX8fJgTDmFMVH0MIsRzVYnwnMi1dyzmhLt2kS2pxIiU62Wj5ptQGlSYFakLonTUJNLKaM5Wzlf" +
"fEkuFkk5wTrhVO2eE7G6lJhxFFYUZ55zmn0WuBCD4pzhirFCKkbomsOoIYmZx5p90LoYWGPdD5g0QmJRKYxbZ6zYoVQ2jVGylSak7KSkFH6RSjpHKFuU+YMyNo5SulkC" +
"6I0vonTCitMXPoEpVS2H5FQfEqp2R1opIgAEkJISYARTCukOhmPNI5Ex/wzGHUsicMwA1LHgQ90Y/KpoQHAD+pB/R4NzIaMAB9Xaw1gqaAOsh/A/ptIkWUfhGK1kZH8R" +
"gH5GqvgArqRmt4AAPrTroRofBGADkqr6Rmu4D7CEaHARiwpJrEEZsXXwlVjyMWRsaRqwdkLGNBABZmytmyMnaINZqyVpLR2ftKAAAdd6h2osbaskdiq4EZtgSmyNcbVW" +
"RJNXe3AA7REar3b0stlAAXBtoRmvJGLjEYAHUWsFcwCD/rnaop9aEICMAPdK5hT6xpeuzdOtAgKuJeGfdq6ggEbkTvAP+p9UCHXrvKkcgIA==");
exontrol.EXCASCADETREELib.Appearance var_Appearance = excascadetree1.VisualAppearance;
var_Appearance.Add(1,"gBFLBCJwBAEHhEJAAEhABfICg6AADACAxRDgMQBQKAAzQFAYbhkGCGAAGMZxRgmFgAQhFcZQSKUOQTDKMIziaQAGgkNQwCSLIwjNIsBxPFKVQChEYxSjKA40SJNUgyj" +
"6CCY+QLIE5PfQgAL9I6eJABCCSQKkYx0HScRiwPBIbAZAYhCZqaKhWgkKI/WBQIABRDVLx5ESiLRtKy7Mq2bpvXBcNxXHalaztO68LxvKyqHb5fJ/PpgL4YHgmC4NQ7E" +
"MRwF6rfbyfZ7Xg/ORPTijZ4sdzMHTzJyscx3HqfaBoOaZU5eMLceTUMofHIndxCcasPbsOatVqjG5sYjcGC3La9cz3Pq/bpuDCbMxuaK1TrYXr1TTrcofBDldAxXRKDx" +
"RDWVhLnYOw9i6XxzjuXprCaOoKB6EwbiCZZCGOdZYlcT4xHmbhMnwNxtn+G5bmqdZ7n4Pw/i+X5zm+dQ9g4CAFjsfAJheOI8HsDoWDWTB/lwSAQkmA5PEgRYoDyDwYFY" +
"FoFmGCBmBqBphDgRJ0gOTIYBGRB/lyRh0iSCZbjYWJzgWDwIjYLoLmMCJGDKDJjBgWgqG6YhyhGHRzA2aJ1mCABOAiOJvhCZBJBYRoRmSCQmEqEQimkAZgg8TZnDCV4U" +
"kmCUmBKZYJGYWoWCUUhiFMNZckNUh2GENoaGaGZmgmJhqhqZpGGIEx2GYIxSGGGJdggWJth2Z4JmYeoemeSZ2H6H4hGmQhihyTRHGYLg7CiCgmgqIpokoNoOiOaJ4jqA" +
"ochqaZGgaCxpAoZoaiaaJqEmWIcGgShcnCJwqEqFoR3YOoFlgchflqNouiuawHmWSYqGkWZQhcatzmaOoumuSp2j6L5bBaKo0GQKRnGGCxqiyCwmkqMpsksNpOGUGI7A" +
"0ew1G0Rxlg0PptgsZuDG2Sx2l6N5tnYNZZjUDRXDCVo5l2FoymqOpukuNpujubwLjmWY5k0ZwxkaFxYlWdp6j6b5Lnafo/nABQdg2FxcUsY5BkmXAkmeQpckwNRrkKTh" +
"8CSHZBk4NwyC4KxxgMDwakOMZDn8GgwnGAo2C4cwthMcwmCcMoHBMHRehwTIghySYNksZwcH4HBMEsHx5hyPItiweYxnwSZEH4Mozn0fR+DMAo7EYJ50gkdZelKdNql2" +
"UgJn0GIukwH4HicQRai2GI4mSVpNl0dZGledgNgcYpYDWUx3FsOQi5YV5anaTY3G6W53A2RxylydxFjiaxEFCCgBBAQ==");
var_Appearance.Add(2,"gBFLBCJwBAEHhEJAAEhABcoFg6AADACAxRDgMQBQKAAzQFAYbhkGCGAAGMZxRgmFgAQhFcZQSKUOQTDKMIziaQAGgkNQwCSLIwjNIsBxPFKVQChEYxSjKA40SJNUgyj" +
"6CCY+QLIE5PfQgAL9I6eJABCCSQKkYx0HScRiwPBIbAZAYhCZqaKhWgkKI/WBQIABRDVLx5ESiLRtKy7Mq2bpvXBcNxXHalaztO68LxvKyqHb5fJ/PpgL4YHgmC4NQ7E" +
"MRwF6rfbyfZ7Xg/ORPTijZ4sdzMHTzJyscx3HqfaBoOaZU5eMLceTUMofHIndxCcasPbsLpOS5LNKsaxmWLYdhFdTxQi6LpvfA8BwXC6JY7heRYRbFbYxRjGNi1TS7G4" +
"nGKd5WGuL4UHwI4VkaYxii8V4pgQMgVBQdQ5iCTYGi8T4vlWbJ3nuPg+l+H5AlSCg6ByPBoE8Ap3jqYxhBido5g0OgOGOGI4CsSpCCAcgcAuEokiEN5NCKfJ9DyTRjnS" +
"cg1CEYxOBmBpPCgagdgcIZoHoGIFA4AxQkCAxKAgKBwgGSpIBCZhjF2E5UnQPQMiMCJBCIBwxkSQgsgo+JtDKT4ziiQw+k6EwAnsOgLnkHI+yCQ4iEuE4klkPhShEJBp" +
"AoPgymOMoaDgHBjFMBgyD0HYTiCZSZhIIIGC4ChiHSew5kwM5omILZPiOBI0hwZw5kodIdA+M4Uj4PxOmMSJ9DuTQzmyZgviceZagaHVfj4awwmaAh2GUIYmCOEZZDaD" +
"RDFGdwcg4EwyHMN4LBOaJbCoaZqgKH8qkMfIyD8DozDyfA7A0Coui0OpMmOZJdCsahKg6NooioChwmEMxLEoXJbDUTRXGSUgykyMgQG0GpPHMdI3D4TRCgSeQ0kmaw+l" +
"GNAtCOZJVCiT5DhyRQwAqMg0EoDBBGEGAsASC5yiSCw+k4Mp6lWNQuksTpRjMTxDGzJwGmGMpDDKXYTECSAxl6Q5olkK4PgMMIVkASRMBMBgzEkaZEjsNALhIZA6AeQB" +
"gk0ZJEgAAJ0CIAgODMNIsD6DRih9uYwFyAwfCUb5ijmbI+gwdxkk8MZMGeMpPCkDxzBiC5MHMPJLDSSROFMLIoBEQogEMFJPnENYQGgE4DCOaJfC7tYkhGTQ0kyWwyku" +
"XpMiyRpKjKR4wngM4JmOWJACCdYtHMWw+Eych4nINYLAEYA8AgdAEEsQZajaQoog4GxPiMVIolcdxNG8XZVkmNoRwWRVBlFeFEeAZQJgnFiHgHwcAhjhHgGMSI5xki2C" +
"yA4EQsA3i0HkBsLwKRFgAHcPkHopBJBcBeDUYI7xyDOHqKkWo2hLCsDIBIY4qQ5A8DoMMYwOAqCSBGKgU4yB2iDBwIgB4hxQgAAWNgBoAgsBdEcBUQ4sQ9A/HqD0JI8R" +
"pBzH2OYVgahLBHFiJQJweQiDhDUE4SAARQAzFsG0EQwA6AOWSBkFgVAIBCHeGERQFQiCQHeFkC4vkiB8DyB4F4QxVDvGMNEOQexMjlBeOAKQiQLgfDA7QEAaRiBdEkH8" +
"TI7AZiFBAGYBIABWjYBiGACioQ4C1A+AMMgWhfgxHgPsT4URIB0COKgPgjRwiAB8AYUArxBgCF6J4GY5hrAOCAPAAoGRRCsCIMEXATXfgAF8BMJwURuEQDgD4Q4OBoAe" +
"HGFgLIwQrC2D0JoSQ+QvhrHoSgQI8AbDFGID8C4Ah6BQAQAASACwgCYCMAUMARAvCKAiAMCAokeCKBEOAKgCBoDaHuMsEAqwJDiACDURg8R6gPCyDofYWAhgoDIJ4ZAu" +
"hoiGAYGgRoQw/A0GMMga4GwxiEDeIYYInATCDBQAoBAwAoDlA0KMBoVRGiDGwDQUYIRsgaGGDgM4LAwDWB8EcIA1APhjEgGQVwgRIgjFIIQHokgZA+CSEkLIKQSjHAwM" +
"sCwDAsAEB2ABTIwRwD6A8CMToSxkAxE4HYIw+BsgbBEDAHYBwojCBoIYFgXSjABE4MsHIbQWhlGILQS4UhvBdAUKEEwHgxDAAABQQQUAhgKHiDwE4JS4A7BGLQZwCR4g" +
"aBEMUYAqgKApHgGwVAIRNgvBMMQXImwZDtE4I8UIyAZCDCAE8AwrhgAdEEBACQLRCg4FEB4AYtA7CdEiPQMoJAMDNCkOMCAXAFDhH0D0Q4EgfAaGSK4NYzRUj9BuCgAg" +
"swOBjB4Fqpw8B2ADAwE4A4Qx2DAE6JIaQPQGhAGKBcIQ5B5gHByKIFARwADbAyKUfgdBKBBGyEcVIAB/ijHoIoSA0gdBNl+OATYERZgBGSDYWIWAUCEGKA4FAhR7CIBt" +
"YQGYZg4CMAiKEcAOwkBjHWE8Z4lQgA+DkBoTohwwCeAaMEEgBQCCABgHMRwQRhhMEWFQd4HwZgwDqFESItAbAGEANCpINAzANCCJkK4ah+heFYBURwsQrS2CsMYMoWGB" +
"hYDWI0EInQgiApXaOVI1QFDsC8MUNoMBMA1HMJga4eh+BeAWOgNNowGjYzCGAAwax+iJBeBVT4gxoBIAGFsJFBxgBiGKFkKQ7g5DFFQEcAo4AzDDACKEQQLgCiJDYB0M" +
"gRBCCQAgQEA==");
var_Appearance.Add(3,"gBFLBCJwBAEHhEJAAEhABQ4Fg6AADACAxRDgMQBQKAAzQFAYbhkGCGAAGMZxRgmFgAQhFcZQSKUOQTDKMIziaQAGgkNQwCSLIwjNIsBxPFKVQChEYxSjKA40SJNUgyj" +
"6CCY+QLIE5PfQgAL9I6eJABCCSQKkYx0HScRiwPBIbAZAYhCZqaKhWgkKI/WBQIABRDVLx5ESiLRtKy7Mq2bpvXBcNxXHalaztO68LxvKyqHb5fJ/PpgL4YHgmC4NQ7E" +
"MRwF6rfbyfZ7Xg/ORPTijZ4sdzMHTzJyscx3HqfaBoOaZU5eMLceTUMofHIndxCcasPbsLpOS5LNKsaxmWLYdhFdTxQi6LpvfA8BwXC6JY7heRYRbFbYxRjGNi1TS7G4" +
"nGKd5WGuL4UHwI4VkaYxii8V4pgQMgVBQdQ5iCTYGi8T4vlWbJ3nuPg+l+H5AlSCg6ByPBoE8Ap3jqYxhBido5g0OgOGOGI4CsSpCCAcgcAuEosiYN5NHMOJ+D4TpTnS" +
"eQ7CEY4uBmBpPhgagdgcIZoHibIEyUBJZDQIJShoCgcCAcoyAQOYYlcZJ1D0DxDCiQgwEiAZMHEMJLFKPJ9D2DoDnidQ4k+Y5QmKEROBkIhKD0JIZDIS4TGUCQuEeEJj" +
"nOIg8CuY4RkYNgwGMM5RllGpThDRYIGKZIpCkJFUH0PINyWcQ3CaaZCG+HBnEOTJhD8Tx4GoeQ/GcaZSHOH5nCmQhshoZhihYYwhiYA4RlkNoNEMUZ3ByDjwEsPxOnMa" +
"J9DuDR6F6GYmCmKh0nANtMioP4Gg8aoSiIO5NhodociqaY6GaFYkEyOg8lsNRNTaUgykyMgQG0GpPiONJbD8DpDEyfA6k0KwOkWMQsGsAJU0SagwkoJQJDIPISCQCJTG" +
"SUwyGaM4KkmMgtksHpFjAZ4TGCBAbgaSpcksdhNAMIJHHsD5TjSWWMAMOpwjyLwbk6cAz0KRJiDkDYzESCwiggcgcgYIQwCIEINCMCITj6TVxkMXp2j0cQLlCTo7E2F4" +
"ymkMZdhMPJHDGHpLAyVg+k4UwrCCSIyByDJ8DuDY8CiWY0kiXAXC6QJwFKGIjCeJpjgyezjlyDw6klHx5myRoMGwZwbkcToTEiew4kwbQfEmUgPkOKJUD4DpTHSHQmgk" +
"XI/ASTA1g0XIEDMTBimyfI7jSLYHEiUoPk0Fw/kadAsHGao8A0A5smEMJ2mNyg5gzJZwDgCpChyIZVyIZwFCMJEPASRkBqE+IcHInRcDxA2H4bIsx0AtDsIBpwZwYicD" +
"6BscwDwUBgHCIYaIfgtiVH2O4WgUwJjEFeAEQA7y4hMCiBMS4aRdB9A4CYE4LxljyBMHcDItBxinDCLcTYmgejBFQ9UTg9gFBOEmAQTI7A4iZGMGkQAWQ7jYA2HIL8BR" +
"AjDG4HcCwARbjZHiNoDw1nLDnGyNINQ+wjCpBMEgcovQUgICQJEcgWRuBvAyJ4d4ugpCUAINcHogxIgnDiM4N4axzD3F2JMTY/hRqYF6FsWIxhYAGGoAALQYgYirBwBE" +
"BwpAjBEAAIEIYsA2gOHCMAGgXAACIDmMITAUgFABH0D0I4WwvhNFGMAOIvxRD2GKNcMA8gjAPDCPwBogRPAxA8PgRwZRICYDED8RAXQEghEAN8DIgwIBdB4JYWwMgtiQ" +
"HoFQKAiRFguFKGwGQhglDsEOVwEQQRkCKBwOIHgSREDRBYHEXQcQdD7GIGARQHRxipBrMobgewDCUCADsEYWAzgMHKHQDQxxsDzA6EMfAeQHB4GQDkUYPA0iECiKoGgR" +
"hcDdA2GMQA8AOCjDSPgHI4QnApAKBICwHg1A+BcAwcYsgbjGGQNkCIgRsA6EcBEWANADjsB0B8YYzQQDIGSBcEYZBCCPEkFIHQSgkgZAwG4IwBAbAYGGAgL4Ch4g8BOC" +
"QAA2KKC0GcAke4AAXAFCoHkDw4xbBFEcJkE4JRSiEFeJYKQVRMgJHODwX4xAgC/AsIIZAeAHDRG0HYI40RKCLEGDUI4jAghwBWIceA+whCpHMFYZYOQxglDMHMBQGxYj" +
"VHiAoBIPgfgHGwPsHYJRSB6A0IERQLhCjJHMA4OQoAoCOACLYGYSx8DpBQIMWQdRnDRH+DsE4fB3CeAmM67kAAXBFEIDYDI7wLBtEoEIfYNwjiUGGJQYQMAjCHEAO0C4" +
"zxW29CoCgfIxR9AKA6J8BgUAIhDGMIoJ40hqgwCgKETgnBhhqCGI0AIqgZhGDANQDIlBDCRGkCoJISR0g1BSKQOgfAzBRG0DYHARh4DeDAOwANuw8ApCKKkYg/RPhjBs" +
"H0J4yg5hPGWN0GwFBHQBFaDoQIURljFAoB4GgzRVzbBECQFQRQoguHGHANwDRdCKy8CgSIGwhhoDYJYYI1giBICSAEgI=");
var_Appearance.Add(4,"gBFLBCJwBAEHhEJAAEhABUYCg6AADACAxRDgMQBQKAAzQFAYbhkGCGAAGMZxRgmFgAQhFcZQSKUOQTDKMIziYBYfgkMIgSbJUgDGAkRRdDSOYDmGQYDiCIoRShOMIjH" +
"LUXxtDaIZwhEAoJb+RgAUY/cTzaAEUwHHiTKInaCQShsFYJUJAdRURQ9EwvCIZBpEWwLChENQwWLCNj2TScBwjCyqbale45ViqdoDU5EUiXJJ8ZxnECfYyrGjaMpCeKB" +
"UrGYTVRBIMxLLSia5oeJqMrnBpNVrIUgXCAGFwHK6BcauXIIDp6XoWWRbAAWDpVVzNNC3YzkCIceADHKiXxmVz4JLdGZ1QTGID2XaYaxWK4oZjsVSc4KDHbETbHFi9Fo" +
"3NaaxGisew+GYc4HlCR5NAAAIIEkQJSGMOgdE4RhYDwJJsAaAYQgmPpolCWgSCiBJzjcEIAkQXIBm8d5UhOQgCDUIBDDJDhgggJgKgKYJIDSVoDk8KBFF4OohEMZgWDs" +
"YYDj4GoGmGSB2B6B5iAiBgYDsYRjGSbIJo4RgqDuIpIAoLoLmMCJGDKDJjJiLA7xqUAAgGTwYnYPoPmQCQGEKEJkEkFg9gGY44BoRoSmSSQ2EKEggHgRhShSZRJFYVoV" +
"mWCRmFKFAgGOTheheZgJgYYoYmYSYWGaF4lkMMJ0hqZpJjYbobmcCZGHKHJmjmJh0h2Z4JmYcIaE8WZ2H6H5oAoBoCiCaBKBYfdjGoJoKiKaJKDaDojmkChGgmIgpCoV" +
"oWiWaJZiSd4mmmSh2h6J5qAqBoiiiaY5iSeIpmqComiqKpqkqNouiuah6hqMIsmsSpWiuGhP1kOoumuSp2j6L5sAsBo54gKwWkaMZsgsJpKjKbJLDaRYxYWRpSjSbIZi" +
"Se41m2CxmlqNptksdpejebR5iSfI4m4S4W16boLiaao6m5fJ9jubwLkaco8m8S5WnaPZunuOp4j6b5Lnac4SA0PAGlgP4wEwFwGkGcIMCcCpCnCCxiA8NYAAmMJfkSbh" +
"FCcFpFnGDBnBqRpUhuEwTDeZ5lHCfw6HIQxLCaAxygyJwqgGcATE4FA6hWY4tjEAAQBAgIA==");
excascadetree1.BackColorHeader32 = 0x4c6c6c6;
excascadetree1.SelBackColor32 = 0x4000000;
excascadetree1.SelForeColor = Color.FromArgb(0,0,1);
excascadetree1.set_Background((exontrol.EXCASCADETREELib.BackgroundPartEnum)0x14,excascadetree1.SelBackColor);
excascadetree1.set_Background((exontrol.EXCASCADETREELib.BackgroundPartEnum)0x15,excascadetree1.SelForeColor);
excascadetree1.set_Background((exontrol.EXCASCADETREELib.BackgroundPartEnum)0x8 | exontrol.EXCASCADETREELib.BackgroundPartEnum.exSplitBar,excascadetree1.BackColor);
excascadetree1.set_Background((exontrol.EXCASCADETREELib.BackgroundPartEnum)0x9 | exontrol.EXCASCADETREELib.BackgroundPartEnum.exSplitBar,excascadetree1.ForeColor);
excascadetree1.set_Background32((exontrol.EXCASCADETREELib.BackgroundPartEnum)0x20,-1);
excascadetree1.set_Background32((exontrol.EXCASCADETREELib.BackgroundPartEnum)0x0,0x4000000);
excascadetree1.set_Background32(exontrol.EXCASCADETREELib.BackgroundPartEnum.exHeaderFilterBarActive,0x4010101);
excascadetree1.set_Background32((exontrol.EXCASCADETREELib.BackgroundPartEnum)0x1,0x40000ff);
excascadetree1.HeaderAppearance = exontrol.EXCASCADETREELib.AppearanceEnum.Etched;
excascadetree1.BackColorSortBar = excascadetree1.BackColor;
excascadetree1.BackColorLevelHeader = excascadetree1.BackColor;
excascadetree1.Mode = exontrol.EXCASCADETREELib.CascadeModeEnum.exSplitFixCascadeMode;
excascadetree1.DataSource = "Source=C:\\Program Files\\Exontrol\\ExCascadeTree\\Sample\\Access\\cities.accdb;Member=Select * FROM Countries;Key=CountryCode;" +
"Tag=Country;Name=CountryName >>> Member=Select * FROM States WHERE CountryCode IN (<%Parent.CountryCode%>);Key=StateCode;Name=St" +
"ateName;Tag=State ||| Member=Select * FROM Cities WHERE CountryCode IN (<%Parent.CountryCode%>);Tag=City;Name=Name >>> Member=Se" +
"lect * FROM Cities WHERE CountryCode IN (<%Parent.Parent.CountryCode%>) AND StateCode IN (<%Parent.StateCode%>);Tag=City;Name=Na" +
"me";
excascadetree1.Select = "US\\MN";
excascadetree1.EndUpdate();
|
|
78
|
ImageSize property on 16 (default) (specifies the size of control' icons/images/check-boxes/radio-buttons)
// CreateView event - A view has been created.
private void excascadetree1_CreateView(object sender,exontrol.EXCASCADETREELib.View View)
{
exontrol.EXCASCADETREELib.View var_View = excascadetree1.View;
var_View.EnsureVisibleColumn("Function");
Object var_Object = var_View.Columns["Function"];
var_View.Columns[0].set_Def(exontrol.EXCASCADETREELib.DefColumnEnum.exCellHasCheckBox,true);
}
//this.excascadetree1.CreateView += new exontrol.EXCASCADETREELib.exg2antt.CreateViewEventHandler(this.excascadetree1_CreateView);
// Error event - An internal error occurs.
private void excascadetree1_Error(object sender,int Err,string Description)
{
System.Diagnostics.Debug.Print( "Error" );
System.Diagnostics.Debug.Print( Description.ToString() );
}
//this.excascadetree1.Error += new exontrol.EXCASCADETREELib.exg2antt.ErrorEventHandler(this.excascadetree1_Error);
excascadetree1.BeginUpdate();
excascadetree1.ImageSize = 16;
excascadetree1.Images("gBJJgBAIDAAEg4ACEKAD/hz/EMNh8TIRNGwAjEZAEXjAojJAjMLjABAAgjUYkUnlUrlktl0vmExmUzmk1m03nE5nU7nkrQCAntBoVDolFo1HoM/ADAplLptImdMYFOq" +
"dSqlXq1QrVbrlGpVWsFNrNdnNjsk7pQAtNroFnt0sh8Yr9iulTuNxs1Eu8OiT/vsnsNVutXlk/oGGtVKxGLxWNtsZtN8iUYuNvy0Zvd+xNYwdwvl4p870GCqc8vOeuVt" +
"tmp1knyOayWVy+WzN/ze1wOElenm+12WUz/Bv2/3UyyWrzeutux2GSyGP2dQ33C1ur3GD3M4zUNzHdlWjq/E3nGzVpjWv4HA7fRy/Tv2IrN8rPW6nZ3ve7mUlfu20Z8a" +
"cvQyb+vY9jasYoDwMm+LytVBDqKG3z8O3Cb8P+mkAuY9cCQ2uL4KaxDKvkp8RNLEjqugnrwQo/UWPzFyeQw5sNLZFENrI4kOqU66pw8uzmOKvTqNqjULJvGL1JO48GtT" +
"GsbLdEL3scxLlyiw8dQeoUVxdLTtyKmUjwGlslRPJsnK1HbAKbKCrsQo8uQk/CeP44iaR/ATnTNPLvyxPU+z9P9AUDQVBowiofJXQ6Oo+kKMpIkjztE4TKn4P6JowfgP" +
"nwD5/nAjB8AOeAPo0eAA1IAFH07UhAIMpYAVIYFHqBUhwVjV1S1EtQAHxW65V0AZwAeuQAnwB5gAPYViEDVhwAHTQBkCjB4gOhwDmCyhH0sACAg==");
exontrol.EXCASCADETREELib.Appearance var_Appearance = excascadetree1.VisualAppearance;
var_Appearance.Add(4,"gBFLBCJwBAEHhEJAAEhABUYCg6AADACAxRDgMQBQKAAzQFAYbhkGCGAAGMZxRgmFgAQhFcZQSKUOQTDKMIziYBYfgkMIgSbJUgDGAkRRdDSOYDmGQYDiCIoRShOMIjH" +
"LUXxtDaIZwhEAoJb+RgAUY/cTzaAEUwHHiTKInaCQShsFYJUJAdRURQ9EwvCIZBpEWwLChENQwWLCNj2TScBwjCyqbale45ViqdoDU5EUiXJJ8ZxnECfYyrGjaMpCeKB" +
"UrGYTVRBIMxLLSia5oeJqMrnBpNVrIUgXCAGFwHK6BcauXIIDp6XoWWRbAAWDpVVzNNC3YzkCIceADHKiXxmVz4JLdGZ1QTGID2XaYaxWK4oZjsVSc4KDHbETbHFi9Fo" +
"3NaaxGisew+GYc4HlCR5NAAAIIEkQJSGMOgdE4RhYDwJJsAaAYQgmPpolCWgSCiBJzjcEIAkQXIBm8d5UhOQgCDUIBDDJDhgggJgKgKYJIDSVoDk8KBFF4OohEMZgWDs" +
"YYDj4GoGmGSB2B6B5iAiBgYDsYRjGSbIJo4RgqDuIpIAoLoLmMCJGDKDJjJiLA7xqUAAgGTwYnYPoPmQCQGEKEJkEkFg9gGY44BoRoSmSSQ2EKEggHgRhShSZRJFYVoV" +
"mWCRmFKFAgGOTheheZgJgYYoYmYSYWGaF4lkMMJ0hqZpJjYbobmcCZGHKHJmjmJh0h2Z4JmYcIaE8WZ2H6H5oAoBoCiCaBKBYfdjGoJoKiKaJKDaDojmkChGgmIgpCoV" +
"oWiWaJZiSd4mmmSh2h6J5qAqBoiiiaY5iSeIpmqComiqKpqkqNouiuah6hqMIsmsSpWiuGhP1kOoumuSp2j6L5sAsBo54gKwWkaMZsgsJpKjKbJLDaRYxYWRpSjSbIZi" +
"Se41m2CxmlqNptksdpejebR5iSfI4m4S4W16boLiaao6m5fJ9jubwLkaco8m8S5WnaPZunuOp4j6b5Lnac4SA0PAGlgP4wEwFwGkGcIMCcCpCnCCxiA8NYAAmMJfkSbh" +
"FCcFpFnGDBnBqRpUhuEwTDeZ5lHCfw6HIQxLCaAxygyJwqgGcATE4FA6hWY4tjEAAQBAgIA==");
excascadetree1.BackColorHeader32 = 0x4c6c6c6;
excascadetree1.SelBackColor32 = 0x4000000;
excascadetree1.SelForeColor = Color.FromArgb(0,0,1);
excascadetree1.set_Background((exontrol.EXCASCADETREELib.BackgroundPartEnum)0x14,excascadetree1.SelBackColor);
excascadetree1.set_Background((exontrol.EXCASCADETREELib.BackgroundPartEnum)0x15,excascadetree1.SelForeColor);
excascadetree1.set_Background((exontrol.EXCASCADETREELib.BackgroundPartEnum)0x8 | exontrol.EXCASCADETREELib.BackgroundPartEnum.exSplitBar,excascadetree1.BackColor);
excascadetree1.set_Background((exontrol.EXCASCADETREELib.BackgroundPartEnum)0x9 | exontrol.EXCASCADETREELib.BackgroundPartEnum.exSplitBar,excascadetree1.ForeColor);
excascadetree1.set_Background32((exontrol.EXCASCADETREELib.BackgroundPartEnum)0x20,-1);
excascadetree1.set_Background32((exontrol.EXCASCADETREELib.BackgroundPartEnum)0x0,0x4000000);
excascadetree1.set_Background32(exontrol.EXCASCADETREELib.BackgroundPartEnum.exHeaderFilterBarActive,0x4010101);
excascadetree1.set_Background32((exontrol.EXCASCADETREELib.BackgroundPartEnum)0x1,0x40000ff);
excascadetree1.HeaderAppearance = exontrol.EXCASCADETREELib.AppearanceEnum.Etched;
excascadetree1.BackColorSortBar = excascadetree1.BackColor;
excascadetree1.BackColorLevelHeader = excascadetree1.BackColor;
excascadetree1.Mode = exontrol.EXCASCADETREELib.CascadeModeEnum.exSplitFixCascadeMode;
excascadetree1.DataSource = "Source=C:\\Program Files\\Exontrol\\ExCascadeTree\\Sample\\Access\\cities.accdb;Member=Select * FROM Countries;Key=CountryCode;" +
"Tag=Country;Name=CountryName >>> Member=Select * FROM States WHERE CountryCode IN (<%Parent.CountryCode%>);Key=StateCode;Name=St" +
"ateName;Tag=State ||| Member=Select * FROM Cities WHERE CountryCode IN (<%Parent.CountryCode%>);Tag=City;Name=Name >>> Member=Se" +
"lect * FROM Cities WHERE CountryCode IN (<%Parent.Parent.CountryCode%>) AND StateCode IN (<%Parent.StateCode%>);Tag=City;Name=Na" +
"me";
excascadetree1.Select = "US\\MN";
excascadetree1.EndUpdate();
|
|
77
|
Is it possible to highlight the column's header once a filter is applied
excascadetree1.BeginUpdate();
exontrol.EXCASCADETREELib.Appearance var_Appearance = excascadetree1.VisualAppearance;
var_Appearance.Add(2,"gBFLBCJwBAEHhEJAAEhABX8GACAADACAxSDEMQBQKAAzQFAYbhgHCGAAGQaBUgmFgAQhFcZQSKUOQTDKNYykCIRSDUJYkSZEIyjBI8ExXFqNACkGKwYgmNYiTLAcgAN" +
"J0WBaGIZJ4gOT5fDKMoEDRRYADFCscwxJybQAqGQKKb+VgAVY/cTyBIAEQSKA0TDOQ5TSKWB4JPZQRBEbZMNBtBIUJquKaqShdQJCU5FdY3Xblez9P7AMBwLFEC4NQ8Y" +
"NYuPhjR4dRTIMhvVAsUArFh8Zg9GZZFjmDIDT4ydBLTQwcyVIKnP5qOa6XbmPoCQDYKxZHYxPzVDa3axuL76dqCAT7XrXNy1TbNRrzQKfcJqfCbdw2YaDZLOOT3fjuI4" +
"hhKaRzFAHJ+jYQ4xHuY4gHuGIXGeExqC8Tp6C+PoEm+G5ImycRgh0XwvDGa5rgOeoejyXwnFeQp2mkf5ClgBB9gCWIYAwfYAEKV58mkdwOggNArgOXY2EWLoDkKOA0mg" +
"bhOGgZApgaSBIHWSYHSmbApgYThmESZYJkIeIkgeCpfliLIHgpMIcmUYYYmODAlg2SI4mWfRfGOEguDcCRjFYAJihCQhJBSDoRmONgKEcI4kFCEJhhOVYTmYnAlEAQhW" +
"BMJYJGYWoWmWSR2F6F5lnkWAQhUAgpEieRWEuSYkjWGpmkmNhuhuZwJkYcocmaaYkjyEhngnUA6lEFAlAEgI=");
var_Appearance.Add(1,"CP:2 -8 -4 2 4");
excascadetree1.set_Background32((exontrol.EXCASCADETREELib.BackgroundPartEnum)0x0,0x1fefefe);
excascadetree1.set_Background32(exontrol.EXCASCADETREELib.BackgroundPartEnum.exHeaderFilterBarActive,0x1010101);
excascadetree1.set_Background32((exontrol.EXCASCADETREELib.BackgroundPartEnum)0x20,-1);
excascadetree1.BackColorHeader = Color.FromArgb(255,255,255);
excascadetree1.Mode = exontrol.EXCASCADETREELib.CascadeModeEnum.exSingleCascadeMode;
exontrol.EXCASCADETREELib.View var_View = excascadetree1.get_DefaultView(null);
var_View.HeaderHeight = 28;
var_View.DrawGridLines = exontrol.EXCASCADETREELib.GridLinesEnum.exRowLines;
var_View.HeaderVisible = true;
exontrol.EXCASCADETREELib.Columns var_Columns = var_View.Columns;
(var_Columns.Add("C1") as exontrol.EXCASCADETREELib.Column).DisplayFilterButton = true;
exontrol.EXCASCADETREELib.Column var_Column = (var_Columns.Add("C2") as exontrol.EXCASCADETREELib.Column);
var_Column.DisplayFilterButton = true;
var_Column.Filter = "Item 2";
var_Column.FilterType = exontrol.EXCASCADETREELib.FilterTypeEnum.exFilter;
(var_Columns.Add("C3") as exontrol.EXCASCADETREELib.Column).DisplayFilterButton = true;
exontrol.EXCASCADETREELib.Items var_Items = var_View.Items;
int h = var_Items.AddItem("Item 1");
var_Items.set_CellValue(h,1,"Item 2");
var_Items.set_CellValue(h,2,"Item 3");
h = var_Items.AddItem("Item 4");
var_Items.set_CellValue(h,1,"Item 5");
var_Items.set_CellValue(h,2,"Item 6");
var_View.ApplyFilter();
excascadetree1.EndUpdate();
|
|
76
|
Is it possible to show the filterbar on top of the rows
excascadetree1.BeginUpdate();
excascadetree1.Mode = exontrol.EXCASCADETREELib.CascadeModeEnum.exSingleCascadeMode;
exontrol.EXCASCADETREELib.View var_View = excascadetree1.get_DefaultView(null);
var_View.ColumnAutoResize = true;
var_View.FilterBarPromptVisible = exontrol.EXCASCADETREELib.FilterBarVisibleEnum.exFilterBarTop;
var_View.HeaderHeight = 24;
var_View.FilterBarHeight = var_View.HeaderHeight;
var_View.HeaderAppearance = exontrol.EXCASCADETREELib.AppearanceEnum.Flat;
var_View.DrawGridLines = exontrol.EXCASCADETREELib.GridLinesEnum.exAllLines;
var_View.GridLineStyle = exontrol.EXCASCADETREELib.GridLinesStyleEnum.exGridLinesGeometric;
exontrol.EXCASCADETREELib.Column var_Column = (var_View.Columns.Add("Column") as exontrol.EXCASCADETREELib.Column);
var_Column.DisplayFilterButton = true;
var_Column.FilterType = exontrol.EXCASCADETREELib.FilterTypeEnum.exPattern;
var_Column.Filter = "B*";
exontrol.EXCASCADETREELib.Column var_Column1 = (var_View.Columns.Add("Index") as exontrol.EXCASCADETREELib.Column);
var_Column1.FormatColumn = "1 index ``";
var_Column1.Position = 0;
var_Column1.Width = 48;
var_Column1.AllowSizing = false;
var_Column1.SortType = exontrol.EXCASCADETREELib.SortTypeEnum.SortNumeric;
var_Column1.set_Def(exontrol.EXCASCADETREELib.DefColumnEnum.exCellHasCheckBox,true);
exontrol.EXCASCADETREELib.Items var_Items = var_View.Items;
var_Items.AddItem("A.1");
var_Items.AddItem("A.2");
var_Items.AddItem("B.1");
var_Items.AddItem("B.2");
var_Items.AddItem("B.3");
var_Items.AddItem("C");
var_View.ApplyFilter();
excascadetree1.EndUpdate();
|
|
75
|
Is there anyway to stop the header changing colour when the mouse hovers/moves across the column header (non-clickable)
// CreateView event - A view has been created.
private void excascadetree1_CreateView(object sender,exontrol.EXCASCADETREELib.View View)
{
exontrol.EXCASCADETREELib.View var_View = excascadetree1.View;
object k = var_View.ParentView.get_Value(null);
var_View.BeginUpdate();
var_View.ColumnAutoResize = true;
var_View.Columns.Add(k.ToString());
exontrol.EXCASCADETREELib.Items var_Items = var_View.Items;
var_Items.AddItem(excascadetree1.FormatABC("A + `-> Sub-Item 1`",k,null,null));
var_Items.AddItem(excascadetree1.FormatABC("A + `-> Sub-Item 2`",k,null,null));
var_Items.AddItem(excascadetree1.FormatABC("A + `-> Sub-Item 3`",k,null,null));
var_View.EndUpdate();
}
//this.excascadetree1.CreateView += new exontrol.EXCASCADETREELib.exg2antt.CreateViewEventHandler(this.excascadetree1_CreateView);
excascadetree1.BeginUpdate();
exontrol.EXCASCADETREELib.View var_View = excascadetree1.View;
var_View.BeginUpdate();
var_View.ColumnAutoResize = true;
exontrol.EXCASCADETREELib.Column var_Column = (var_View.Columns.Add("Default") as exontrol.EXCASCADETREELib.Column);
var_Column.AllowSort = false;
var_Column.AllowDragging = false;
var_View.Key = 0;
exontrol.EXCASCADETREELib.Items var_Items = var_View.Items;
var_Items.AddItem("Item A");
var_Items.set_SelectItem(var_Items.AddItem("Item B"),true);
var_Items.AddItem("Item C");
var_View.EndUpdate();
excascadetree1.EndUpdate();
|
|
74
|
Is there anyway to stop the header changing colour when the mouse hovers/moves across the column header
// CreateView event - A view has been created.
private void excascadetree1_CreateView(object sender,exontrol.EXCASCADETREELib.View View)
{
exontrol.EXCASCADETREELib.View var_View = excascadetree1.View;
object k = var_View.ParentView.get_Value(null);
var_View.BeginUpdate();
var_View.ColumnAutoResize = true;
var_View.Columns.Add(k.ToString());
exontrol.EXCASCADETREELib.Items var_Items = var_View.Items;
var_Items.AddItem(excascadetree1.FormatABC("A + `-> Sub-Item 1`",k,null,null));
var_Items.AddItem(excascadetree1.FormatABC("A + `-> Sub-Item 2`",k,null,null));
var_Items.AddItem(excascadetree1.FormatABC("A + `-> Sub-Item 3`",k,null,null));
var_View.EndUpdate();
}
//this.excascadetree1.CreateView += new exontrol.EXCASCADETREELib.exg2antt.CreateViewEventHandler(this.excascadetree1_CreateView);
excascadetree1.BeginUpdate();
excascadetree1.set_Background32((exontrol.EXCASCADETREELib.BackgroundPartEnum)0x20,-1);
exontrol.EXCASCADETREELib.View var_View = excascadetree1.View;
var_View.BeginUpdate();
var_View.ColumnAutoResize = true;
var_View.Columns.Add("Default");
var_View.Key = 0;
exontrol.EXCASCADETREELib.Items var_Items = var_View.Items;
var_Items.AddItem("Item A");
var_Items.set_SelectItem(var_Items.AddItem("Item B"),true);
var_Items.AddItem("Item C");
var_View.EndUpdate();
excascadetree1.EndUpdate();
|
|
73
|
Type of wraps the cell's caption support (Sample 2)
excascadetree1.Mode = exontrol.EXCASCADETREELib.CascadeModeEnum.exSingleCascadeMode;
exontrol.EXCASCADETREELib.View var_View = excascadetree1.get_DefaultView(null);
var_View.BeginUpdate();
var_View.HeaderSingleLine = false;
var_View.HeaderHeight = 36;
var_View.DrawGridLines = exontrol.EXCASCADETREELib.GridLinesEnum.exRowLines;
var_View.ColumnAutoResize = false;
var_View.ScrollBySingleLine = true;
exontrol.EXCASCADETREELib.Columns var_Columns = var_View.Columns;
exontrol.EXCASCADETREELib.Column var_Column = (var_Columns.Add("Single-Line (exCaptionSingleLine)") as exontrol.EXCASCADETREELib.Column);
var_Column.Width = 96;
var_Column.set_Def(exontrol.EXCASCADETREELib.DefColumnEnum.exCellValueFormat,1);
var_Column.set_Def(exontrol.EXCASCADETREELib.DefColumnEnum.exCellSingleLine,-1);
exontrol.EXCASCADETREELib.Column var_Column1 = (var_Columns.Add("Word-Wrap (exCaptionWordWrap)") as exontrol.EXCASCADETREELib.Column);
var_Column1.Width = 96;
var_Column1.set_Def(exontrol.EXCASCADETREELib.DefColumnEnum.exCellValueFormat,1);
var_Column1.set_Def(exontrol.EXCASCADETREELib.DefColumnEnum.exCellSingleLine,0);
var_Column1.FormatColumn = "%0";
exontrol.EXCASCADETREELib.Column var_Column2 = (var_Columns.Add("Break-Wrap (exCaptionBreakWrap)") as exontrol.EXCASCADETREELib.Column);
var_Column2.Width = 96;
var_Column2.set_Def(exontrol.EXCASCADETREELib.DefColumnEnum.exCellValueFormat,1);
var_Column2.set_Def(exontrol.EXCASCADETREELib.DefColumnEnum.exCellSingleLine,1);
var_Column2.FormatColumn = "%0";
exontrol.EXCASCADETREELib.Items var_Items = var_View.Items;
var_Items.AddItem("This is the <b>first</b> line.<br>This is the <b>second</b> line.<br>This is the <b>third</b> line.");
var_Items.AddItem("This is the <b>first</b> line.\\r\\nThis is the <b>second</b> line.\\r\\nThis is the <b>third</b> line.");
var_View.EndUpdate();
|
|
72
|
Type of wraps the cell's caption support (Sample 1)
excascadetree1.Mode = exontrol.EXCASCADETREELib.CascadeModeEnum.exSingleCascadeMode;
exontrol.EXCASCADETREELib.View var_View = excascadetree1.get_DefaultView(null);
var_View.BeginUpdate();
var_View.HeaderSingleLine = false;
var_View.HeaderHeight = 36;
var_View.DrawGridLines = exontrol.EXCASCADETREELib.GridLinesEnum.exRowLines;
var_View.ColumnAutoResize = false;
var_View.ScrollBySingleLine = true;
(var_View.Columns.Add("Default") as exontrol.EXCASCADETREELib.Column).Width = 128;
exontrol.EXCASCADETREELib.Items var_Items = var_View.Items;
int h = var_Items.AddItem("This is the first line.\\r\\nThis is the second line.\\r\\nThis is the third line.");
h = var_Items.AddItem("This is the <b>first</b> line.<br>This is the <b>second</b> line.<br>This is the <b>third</b> line.");
var_Items.set_CellValueFormat(h,0,exontrol.EXCASCADETREELib.ValueFormatEnum.exHTML);
h = var_Items.AddItem("This is the first line.\\r\\nThis is the second line.\\r\\nThis is the third line.");
var_Items.set_CellSingleLine(h,0,exontrol.EXCASCADETREELib.CellSingleLineEnum.exCaptionWordWrap);
h = var_Items.AddItem("This is the <b>first</b> line.<br>This is the <b>second</b> line.<br>This is the <b>third</b> line.");
var_Items.set_CellValueFormat(h,0,exontrol.EXCASCADETREELib.ValueFormatEnum.exHTML);
var_Items.set_CellSingleLine(h,0,exontrol.EXCASCADETREELib.CellSingleLineEnum.exCaptionWordWrap);
h = var_Items.AddItem("This is the first line.\\r\\nThis is the second line.\\r\\nThis is the third line.");
var_Items.set_CellSingleLine(h,0,exontrol.EXCASCADETREELib.CellSingleLineEnum.exCaptionBreakWrap);
h = var_Items.AddItem("This is the <b>first</b> line.<br>This is the <b>second</b> line.<br>This is the <b>third</b> line.");
var_Items.set_CellValueFormat(h,0,exontrol.EXCASCADETREELib.ValueFormatEnum.exHTML);
var_Items.set_CellSingleLine(h,0,exontrol.EXCASCADETREELib.CellSingleLineEnum.exCaptionBreakWrap);
var_View.EndUpdate();
|
|
71
|
Can I break the cell's caption using the line break <br> or \r\n (Sample 2)
excascadetree1.Mode = exontrol.EXCASCADETREELib.CascadeModeEnum.exSingleCascadeMode;
exontrol.EXCASCADETREELib.View var_View = excascadetree1.get_DefaultView(null);
var_View.BeginUpdate();
var_View.DrawGridLines = exontrol.EXCASCADETREELib.GridLinesEnum.exRowLines;
var_View.ColumnAutoResize = false;
var_View.ScrollBySingleLine = true;
(var_View.Columns.Add("Default") as exontrol.EXCASCADETREELib.Column).Width = 128;
exontrol.EXCASCADETREELib.Items var_Items = var_View.Items;
var_Items.set_CellSingleLine(var_Items.AddItem("This is the first line.\\r\\nThis is the second line.\\r\\nThis is the third line."),0,exontrol.EXCASCADETREELib.CellSingleLineEnum.exCaptionBreakWrap);
var_Items.AddItem("This is the first line.\\r\\nThis is the second line.\\r\\nThis is the third line.");
var_View.EndUpdate();
|
|
70
|
Can I break the cell's caption using the line break <br> or \r\n (Sample 1)
excascadetree1.Mode = exontrol.EXCASCADETREELib.CascadeModeEnum.exSingleCascadeMode;
exontrol.EXCASCADETREELib.View var_View = excascadetree1.get_DefaultView(null);
var_View.BeginUpdate();
var_View.DrawGridLines = exontrol.EXCASCADETREELib.GridLinesEnum.exRowLines;
var_View.ColumnAutoResize = false;
var_View.ScrollBySingleLine = true;
exontrol.EXCASCADETREELib.Column var_Column = (var_View.Columns.Add("Default") as exontrol.EXCASCADETREELib.Column);
var_Column.Width = 128;
var_Column.set_Def(exontrol.EXCASCADETREELib.DefColumnEnum.exCellSingleLine,1);
exontrol.EXCASCADETREELib.Items var_Items = var_View.Items;
var_Items.AddItem("This is the first line.\\r\\nThis is the second line.\\r\\nThis is the third line.");
var_Items.AddItem("This is the first line.\\r\\nThis is the second line.\\r\\nThis is the third line.");
var_View.EndUpdate();
|
|
69
|
Is it possible to change the visual appearance of the position signs when user changes the column's position by drag and drop
excascadetree1.BeginUpdate();
exontrol.EXCASCADETREELib.Appearance var_Appearance = excascadetree1.VisualAppearance;
var_Appearance.Add(1,"gBFLBCJwBAEHhEJAAEhABZEGACAADACAxRDgMQBQKAAzAJBIYhiG4cYCgMYxXDOCYXABCEYRXBIZQ7BKNIxjSJwFgmEgADKMA4SOKIZhrE4bBhGaQRUgyI43RhHUBzV" +
"IUcQvE6TZRHCQYHgkNIhDJIM7TPLkeSVJaTIRoKhJUogApQThTMgVRDEThkGoSa6soSoYTDBKybLrSLKagOT5YUDKUqSdKEZRpEq1YztWbaQoCUoqVRRVIWfbNd4JJa4" +
"aDhWpYdpeeY5R7bWLgBYVVABL7LLRsSxpHxPF6RXxaeI3GKsaS8G6ic6nPQMHj7I4NS5pUa6Rh2VYNSa8AAtETRYznOw4bTMXAjNIea5bAYIIR5HIoDzVbQcCQAHL9DB" +
"eEMIQEEISgGhMGZQmocgymoYRRCIEQ0G2HYBnEIBig4V4zCQGINnmagCECY43medZ6H2Pw/g+X5fnueh/h+R5+AKABfkMWgGgGYA4AICoCGCE5WA4CphACMgSD2IRIDI" +
"BICmEd5YGCBpRjGBgegWIYIgWdgoGIRQsiKCZiAiJZ0gGQI4jUS4LECOAiBmDJflGfg2BSY4Al4OhGkOCJ2DgFJjGGfgqgiH5Ch4RhGkqOQmEOEpkFkHQYhJRYyESAok" +
"GKHhIhKIxJEmf4VGUeRGFmF5iBkchPhYJQ5GoYIZg6Ug6GoFYmkmNhuhulRGHKGoImefh0BUZ4JmYeoemeSZ2H6HQmgoBgXDqXwUAQgI=");
var_Appearance.Add(2,"CP:1 0 -36 0 0");
excascadetree1.set_Background32(exontrol.EXCASCADETREELib.BackgroundPartEnum.exColumnsPositionSign,0x2000000);
excascadetree1.Mode = exontrol.EXCASCADETREELib.CascadeModeEnum.exSingleCascadeMode;
exontrol.EXCASCADETREELib.View var_View = excascadetree1.get_DefaultView(null);
var_View.BeginUpdate();
var_View.HeaderAppearance = exontrol.EXCASCADETREELib.AppearanceEnum.Etched;
exontrol.EXCASCADETREELib.Columns var_Columns = var_View.Columns;
var_Columns.Add("Column 1");
var_Columns.Add("Column 2");
var_Columns.Add("Column 3");
var_View.EndUpdate();
excascadetree1.EndUpdate();
|
|
68
|
DataSource (control, ADODB, ACCDB, x64)
// CreateView event - A view has been created.
private void excascadetree1_CreateView(object sender,exontrol.EXCASCADETREELib.View View)
{
object bSingle = excascadetree1.FormatABC("value > 0 ? 0 : -1",excascadetree1.View.Index,null,null);
object bColumnAutoResize = excascadetree1.FormatABC("value = `City` ? 0 : -1",excascadetree1.View.Tag,null,null);
exontrol.EXCASCADETREELib.View var_View = excascadetree1.View;
var_View.ColumnAutoResize = false;
var_View.SingleSel = false;
}
//this.excascadetree1.CreateView += new exontrol.EXCASCADETREELib.exg2antt.CreateViewEventHandler(this.excascadetree1_CreateView);
// Error event - An internal error occurs.
private void excascadetree1_Error(object sender,int Err,string Description)
{
System.Diagnostics.Debug.Print( "Error" );
System.Diagnostics.Debug.Print( Description.ToString() );
}
//this.excascadetree1.Error += new exontrol.EXCASCADETREELib.exg2antt.ErrorEventHandler(this.excascadetree1_Error);
excascadetree1.BeginUpdate();
excascadetree1.Mode = exontrol.EXCASCADETREELib.CascadeModeEnum.exAutoFitOnResizeClient | exontrol.EXCASCADETREELib.CascadeModeEnum.exSplitFixCascadeMode;
excascadetree1.DataSource = "locktype=1;Source=C:\\Program Files\\Exontrol\\ExCascadeTree\\Sample\\Access\\cities.accdb;Member=Select * FROM Countries;Key=C" +
"ountryCode;Tag=Country;Name=CountryName >>> Member=Select * FROM States WHERE CountryCode IN (<%Parent.CountryCode%>);Key=StateC" +
"ode;Name=StateName;Tag=State ||| Member=Select * FROM Cities WHERE CountryCode IN (<%Parent.CountryCode%>);Tag=City;Name=Name >>" +
"> Member=Select * FROM Cities WHERE CountryCode IN (<%Parent.Parent.CountryCode%>) AND StateCode IN (<%Parent.StateCode%>);Tag=C" +
"ity;Name=Name";
excascadetree1.Select = "US\\AK";
excascadetree1.EndUpdate();
|
|
67
|
DataSource (view, ADODB, ACCDB, x64)
// Error event - An internal error occurs.
private void excascadetree1_Error(object sender,int Err,string Description)
{
System.Diagnostics.Debug.Print( "Error" );
System.Diagnostics.Debug.Print( Description.ToString() );
}
//this.excascadetree1.Error += new exontrol.EXCASCADETREELib.exg2antt.ErrorEventHandler(this.excascadetree1_Error);
excascadetree1.BeginUpdate();
excascadetree1.StatusBarVisible = exontrol.EXCASCADETREELib.StatusBarAnchorEnum.exStatusBarAnchorTop;
excascadetree1.StatusBarLabel = "<b>DataSource</b> could be string (Source/Member), ADO or DAO objects";
excascadetree1.DefColumnWidth = 336;
// Add 'Microsoft ActiveX Data Objects 6.1 Library(msado15.dll)' reference to your project.
ADODB.Recordset ado = new ADODB.Recordset();
ado.Open("Countries","Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Program Files\\Exontrol\\ExCascadeTree\\Sample\\Access\\cities.accdb",exontrol.ADODB.CursorTypeEnum.adOpenStatic,exontrol.ADODB.LockTypeEnum.adLockReadOnly,-1);
exontrol.EXCASCADETREELib.View var_View = excascadetree1.get_DefaultView(null);
var_View.DataSource = (ado as ADODB.Recordset);
var_View.ColumnAutoResize = true;
excascadetree1.EndUpdate();
|
|
66
|
Simple sample
// CreateView event - A view has been created.
private void excascadetree1_CreateView(object sender,exontrol.EXCASCADETREELib.View View)
{
object bSingle = excascadetree1.FormatABC("value > 0 ? 0 : -1",excascadetree1.View.Index,null,null);
object bColumnAutoResize = excascadetree1.FormatABC("value = `City` ? 0 : -1",excascadetree1.View.Tag,null,null);
exontrol.EXCASCADETREELib.View var_View = excascadetree1.View;
var_View.ColumnAutoResize = false;
var_View.SingleSel = false;
}
//this.excascadetree1.CreateView += new exontrol.EXCASCADETREELib.exg2antt.CreateViewEventHandler(this.excascadetree1_CreateView);
// Error event - An internal error occurs.
private void excascadetree1_Error(object sender,int Err,string Description)
{
System.Diagnostics.Debug.Print( "Error" );
System.Diagnostics.Debug.Print( Description.ToString() );
}
//this.excascadetree1.Error += new exontrol.EXCASCADETREELib.exg2antt.ErrorEventHandler(this.excascadetree1_Error);
excascadetree1.BeginUpdate();
excascadetree1.Mode = exontrol.EXCASCADETREELib.CascadeModeEnum.exAutoFitOnResizeClient | exontrol.EXCASCADETREELib.CascadeModeEnum.exSplitFixCascadeMode;
excascadetree1.DataSource = "Source=C:\\Program Files\\Exontrol\\ExCascadeTree\\Sample\\Access\\cities.accdb;Member=Select * FROM Countries;Key=CountryCode;" +
"Tag=Country;Name=CountryName >>> Member=Select * FROM States WHERE CountryCode IN (<%Parent.CountryCode%>);Key=StateCode;Name=St" +
"ateName;Tag=State ||| Member=Select * FROM Cities WHERE CountryCode IN (<%Parent.CountryCode%>);Tag=City;Name=Name >>> Member=Se" +
"lect * FROM Cities WHERE CountryCode IN (<%Parent.Parent.CountryCode%>) AND StateCode IN (<%Parent.StateCode%>);Tag=City;Name=Na" +
"me";
excascadetree1.EndUpdate();
|
|
65
|
FilterBar sample
// CreateView event - A view has been created.
private void excascadetree1_CreateView(object sender,exontrol.EXCASCADETREELib.View View)
{
exontrol.EXCASCADETREELib.View var_View = excascadetree1.View;
var_View.HeaderHeight = 20;
var_View.HeaderAppearance = exontrol.EXCASCADETREELib.AppearanceEnum.Etched;
var_View.DrawGridLines = exontrol.EXCASCADETREELib.GridLinesEnum.exAllLines;
var_View.GridLineStyle = exontrol.EXCASCADETREELib.GridLinesStyleEnum.exGridLinesDash;
exontrol.EXCASCADETREELib.View var_View1 = excascadetree1.get_DefaultView(null);
exontrol.EXCASCADETREELib.View var_View2 = var_View1.get_View("Country");
var_View2.BeginUpdate();
var_View2.ColumnAutoResize = true;
var_View2.Columns[0].Visible = false;
exontrol.EXCASCADETREELib.Column var_Column = var_View2.Columns[1];
var_Column.HTMLCaption = "Country";
var_Column.DisplayFilterButton = true;
var_Column.FilterList = exontrol.EXCASCADETREELib.FilterListEnum.exShowExclude | exontrol.EXCASCADETREELib.FilterListEnum.exShowFocusItem | exontrol.EXCASCADETREELib.FilterListEnum.exShowCheckBox | exontrol.EXCASCADETREELib.FilterListEnum.exSortItemsAsc;
var_Column.FilterBarDropDownWidth = 2;
var_View2.EndUpdate();
exontrol.EXCASCADETREELib.View var_View3 = var_View1.get_View("State");
var_View3.BeginUpdate();
var_View3.ColumnAutoResize = true;
var_View3.Columns[0].Visible = false;
var_View3.Columns[1].Visible = false;
exontrol.EXCASCADETREELib.Column var_Column1 = var_View3.Columns[2];
var_Column1.HTMLCaption = "State";
var_Column1.DisplayFilterButton = true;
var_Column1.FilterList = exontrol.EXCASCADETREELib.FilterListEnum.exShowExclude | exontrol.EXCASCADETREELib.FilterListEnum.exShowFocusItem | exontrol.EXCASCADETREELib.FilterListEnum.exShowCheckBox | exontrol.EXCASCADETREELib.FilterListEnum.exSortItemsAsc;
var_Column1.FilterBarDropDownWidth = 2;
var_View3.EndUpdate();
exontrol.EXCASCADETREELib.View var_View4 = var_View1.get_View("City");
var_View4.BeginUpdate();
var_View4.Columns["CountryCode"].Visible = false;
var_View4.Columns["StateCode"].Visible = false;
exontrol.EXCASCADETREELib.Column var_Column2 = var_View4.Columns["Name"];
var_Column2.HTMLCaption = "City";
var_Column2.Width = 128;
var_Column2.DisplayFilterButton = true;
var_Column2.FilterList = exontrol.EXCASCADETREELib.FilterListEnum.exShowExclude | exontrol.EXCASCADETREELib.FilterListEnum.exShowFocusItem | exontrol.EXCASCADETREELib.FilterListEnum.exShowCheckBox | exontrol.EXCASCADETREELib.FilterListEnum.exSortItemsAsc;
var_Column2.FilterBarDropDownWidth = 2;
var_View4.SearchColumnIndex = var_View4.Columns["Name"].Index;
exontrol.EXCASCADETREELib.Column var_Column3 = var_View4.Columns["Status"];
var_Column3.DisplayFilterButton = true;
var_Column3.FilterList = exontrol.EXCASCADETREELib.FilterListEnum.exShowExclude | exontrol.EXCASCADETREELib.FilterListEnum.exShowFocusItem | exontrol.EXCASCADETREELib.FilterListEnum.exShowCheckBox | exontrol.EXCASCADETREELib.FilterListEnum.exSortItemsAsc;
var_Column3.FilterBarDropDownWidth = 2;
exontrol.EXCASCADETREELib.Column var_Column4 = var_View4.Columns["Function"];
var_Column4.set_Def(exontrol.EXCASCADETREELib.DefColumnEnum.exCellValueFormat,1);
var_Column4.FormatColumn = "value replace 1 with `<img>1</img>` replace 2 with `<img>2</img>` replace 3 with `<img>3</img>` replace 4 with `<img>4</img>` r" +
"eplace 5 with `<img>5</img>` replace 6 with `<img>6</img>` replace 7 with `<img>7</img>` replace 8 with `<img>8</img>` replace 9" +
" with `<img>9</img>` replace `-` with `` ";
exontrol.EXCASCADETREELib.Column var_Column5 = (var_View4.Columns.Add("Pos") as exontrol.EXCASCADETREELib.Column);
var_Column5.AllowSizing = false;
var_Column5.Width = 32;
var_Column5.set_Def(exontrol.EXCASCADETREELib.DefColumnEnum.exCellBackColor,15790320);
var_Column5.Position = 0;
var_Column5.FormatColumn = "1 pos ``";
var_Column5.Alignment = exontrol.EXCASCADETREELib.AlignmentEnum.CenterAlignment;
var_Column5.HeaderAlignment = var_Column5.Alignment;
var_View4.CountLockedColumns = 1;
var_View4.Width = var_View4.WidthToFit;
var_View4.EndUpdate();
exontrol.EXCASCADETREELib.View var_View5 = excascadetree1.View;
var_View5.FilterBarHeight = 36;
var_View5.FilterBarCaption = "(( ( allui replace `[<b>` with `<bgcolor=000000><fgcolor=FFFFFF><b> ` replace `</b>]` with ` </b></bgcolor></fgcolor>` replace " +
"`[<s>` with `<bgcolor=C0C0C0><fgcolor=FFFFFF> ` replace `</s>]` with ` </fgcolor></bgcolor>` ) + `<r><fgcolor=808080>` + ( matc" +
"hitemcount < 0 ? ( ( len(value) ? `` : `` ) + `<r>` + abs(matchitemcount + 1) + ` result(s)` ) : (`<r><fgcolor=808080>`+ itemcou" +
"nt + ` item(s)`) )))";
var_View5.FilterBarPromptVisible = exontrol.EXCASCADETREELib.FilterBarVisibleEnum.exFilterBarShowCloseIfRequired | exontrol.EXCASCADETREELib.FilterBarVisibleEnum.exFilterBarVisible | exontrol.EXCASCADETREELib.FilterBarVisibleEnum.exFilterBarPromptVisible;
}
//this.excascadetree1.CreateView += new exontrol.EXCASCADETREELib.exg2antt.CreateViewEventHandler(this.excascadetree1_CreateView);
// Error event - An internal error occurs.
private void excascadetree1_Error(object sender,int Err,string Description)
{
System.Diagnostics.Debug.Print( "Error" );
System.Diagnostics.Debug.Print( Description.ToString() );
}
//this.excascadetree1.Error += new exontrol.EXCASCADETREELib.exg2antt.ErrorEventHandler(this.excascadetree1_Error);
excascadetree1.BeginUpdate();
excascadetree1.Images("C:\\Program Files\\Exontrol\\ExCascadeTree\\Sample\\Bullets\\Bullet-01.ico");
excascadetree1.Images("C:\\Program Files\\Exontrol\\ExCascadeTree\\Sample\\Bullets\\Bullet-02.ico");
excascadetree1.Images("C:\\Program Files\\Exontrol\\ExCascadeTree\\Sample\\Bullets\\Bullet-03.ico");
excascadetree1.Images("C:\\Program Files\\Exontrol\\ExCascadeTree\\Sample\\Bullets\\Bullet-04.ico");
excascadetree1.Images("C:\\Program Files\\Exontrol\\ExCascadeTree\\Sample\\Bullets\\Bullet-05.ico");
excascadetree1.Images("C:\\Program Files\\Exontrol\\ExCascadeTree\\Sample\\Bullets\\Bullet-06.ico");
excascadetree1.Images("C:\\Program Files\\Exontrol\\ExCascadeTree\\Sample\\Bullets\\Bullet-07.ico");
excascadetree1.Images("C:\\Program Files\\Exontrol\\ExCascadeTree\\Sample\\Bullets\\Bullet-08.ico");
excascadetree1.Images("C:\\Program Files\\Exontrol\\ExCascadeTree\\Sample\\Bullets\\Bullet-09.ico");
excascadetree1.DataSource = "Source=C:\\Program Files\\Exontrol\\ExCascadeTree\\Sample\\Access\\cities.mdb;Member=Select * FROM Countries;Key=CountryCode;Ta" +
"g=Country;Name=CountryName >>> Member=Select * FROM States WHERE CountryCode IN (<%Parent.CountryCode%>);Key=StateCode;Name=Stat" +
"eName;Tag=State ||| Member=Select * FROM Cities WHERE CountryCode IN (<%Parent.CountryCode%>);Tag=City;Name=Name >>> Member=Sele" +
"ct * FROM Cities WHERE CountryCode IN (<%Parent.Parent.CountryCode%>) AND StateCode IN (<%Parent.StateCode%>);Tag=City;Name=Name" +
"";
excascadetree1.Select = "RO\\CJ";
exontrol.EXCASCADETREELib.View var_View = excascadetree1.get_DefaultView(null).get_View("City");
var_View.FilterBarPromptPattern = "Tu";
exontrol.EXCASCADETREELib.Appearance var_Appearance = excascadetree1.VisualAppearance;
var_Appearance.Add(1,"gBFLBCJwBAEHhEJAAEhABZEGACAADACAxRDgMQBQKAAzAJBIYhiG4cYCgMYxXDOCYXABCEYRXBIZQ7BKNIxjSJwFgmEgADKMA4SOKIZhrE4bBhGaQRUgyI43RhHUBzV" +
"IUcQvE6TZRHCQYHgkNIhDJIM7TPLkeSVJaTIRoKhJUogApQThTMgVRDEThkGoSa6soSoYTDBKybLrSLKagOT5YUDKUqSdKEZRpEq1YztWbaQoCUoqVRRVIWfbNd4JJa4" +
"aDhWpYdpeeY5R7bWLgBYVVABL7LLRsSxpHxPF6RXxaeI3GKsaS8G6ic6nPQMHj7I4NS5pUa6Rh2VYNSa8AAtETRYznOw4bTMXAjNIea5bAYIIR5HIoDzVbQcCQAHL9DB" +
"eEMIQEEISgGhMGZQmocgymoYRRCIEQ0G2HYBnEIBig4V4zCQGINnmagCECY43medZ6H2Pw/g+X5fnueh/h+R5+AKABfkMWgGgGYA4AICoCGCE5WA4CphACMgSD2IRIDI" +
"BICmEd5YGCBpRjGBgegWIYIgWdgoGIRQsiKCZiAiJZ0gGQI4jUS4LECOAiBmDJflGfg2BSY4Al4OhGkOCJ2DgFJjGGfgqgiH5Ch4RhGkqOQmEOEpkFkHQYhJRYyESAok" +
"GKHhIhKIxJEmf4VGUeRGFmF5iBkchPhYJQ5GoYIZg6Ug6GoFYmkmNhuhulRGHKGoImefh0BUZ4JmYeoemeSZ2H6HQmgoBgXDqXwUAQgI=");
var_Appearance.Add(2,"gBFLBCJwBAEHhEJAAEhABHQDg6AADACAxRDgMQBQKAAzAJBIYhiG4cYCgMZhXDOCYXABCEYRXBIZQ7BKNIxjSJ5BhIAAyDSJMjSRJUEhqGCWYDleYYYAKHIMQLOg7IJ" +
"jyI4/SJAYCydKAWhxIaZKJHCZoEDaTAADCNVAQp6MEIJVbVEI0e79OgBLp/Z7kECIJJAaRjHQdJxGLA8EhtCQhCZteK6SgMKJYXhWQYRXI1JwvMBrWrdQjiOYELQtMKm" +
"SZNLYGG4dR5SVJbcYhSYsRRFMoyDIOXYDLKsdYqSpXIThObEGgaPqJYjsUjCMKnR7HVIURrBPC9TBPE69ZgmC6ucKPX51ShKFaBWDZcwFAS+UBuYCAILiEAQGZ1XT8OR" +
"OicbgJgSTJRlCaZeDsHY7QGR4xkSYp3CaExZAQMgalQYAwjCAAfBANxcA2TgKAUOpDCGFhKg0RpXCwCwDHQHQHEyAIkCkOhbFOGA8A8DohBgRg9AccZcn8EpEjMLI2C2" +
"DYxAgQgvAIUIVkoAAPBQDJlECTZ3CCYwDACQwUA8A5MCAWAWDiQi4l8aQOEgLJuBgBgDmYFAzEoIoIl0WALgKYJbBABADAAHgHg8VAMmqCQQDMXABAATYwTmNwBDATJX" +
"AiAgjHmNQ5lgQ5QEQEQMmcWg/GwD5ylyNw2gMcJcjsBgBgOQQDDhRpVAMMwnDBFw1B0Ax8D0DxOmmJJIGQTY5hGMAwkwM4CAYLZAmAOJnAqAojiIGg6iieYkmeAYOHaK" +
"JDCyCwjH6AoggsQpQliAJLhgaJ0CESBTnyDwjk+cg4g4P5IHIHJ+BWRRzlYWAxiOUxihsY4KjKLJRGqC44FCegkkkM58iAKAPnIWIWD8SRSFSfQnkmewUhYP4GiGKJ7G" +
"0TIbCSUoggqUo0lAQ4LnEcBcD8Coiiif4nE+eAAn2HpOkcFJqi4T5SkyMw/kqQown8IBIBOdA+A+DJrBqVxXEqYo4lCApLhGHBnD8S4ymyfxmg+cwQkQP5egOUZIWoEA" +
"kjIeIPBMBJBD+TBjBifwvkuc58hQJQPmFrYykkchclSApKjGOBuD+TRDFCfw3mmIxNi8FxFlOXhVC4aYDFyPgvg2YBcBcLZGCGCJ0DSLRzGSWQ/lmY5+mEP5gmMDBZRS" +
"MRsFsOxMhMJJ/DsTpTnwaQaE+N5ojuNhdEYNI5C4TZJO1GRDmCaxnA2Yx4n8IpIjOTBQBQC5TgyYw7gUYRYikC0BYRwsDQBoB8eA6Q2hsE0BUXgywZtYCyHMKwnxSAhA" +
"QHkIQhRrBaDsCwA4ERiB2EWAIYIXhhiVEgAEUYwwYjyASLge4FhHgRDkM8OQih0jWPkGgBBAQ");
excascadetree1.BackColorSortBar = excascadetree1.BackColor;
excascadetree1.set_ScrollPartVisible(exontrol.EXCASCADETREELib.ScrollBarEnum.exVScroll,exontrol.EXCASCADETREELib.ScrollPartEnum.exExtentThumbPart,true);
excascadetree1.set_ScrollPartVisible(exontrol.EXCASCADETREELib.ScrollBarEnum.exHScroll,exontrol.EXCASCADETREELib.ScrollPartEnum.exExtentThumbPart,true);
excascadetree1.set_ScrollPartVisible(exontrol.EXCASCADETREELib.ScrollBarEnum.exScroll,exontrol.EXCASCADETREELib.ScrollPartEnum.exExtentThumbPart,true);
excascadetree1.ScrollWidth = 4;
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exVSBack,Color.FromArgb(240,240,240));
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exVSThumb,Color.FromArgb(128,128,128));
excascadetree1.ScrollHeight = 4;
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exHSBack,excascadetree1.get_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exVSBack));
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exHSThumb,excascadetree1.get_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exVSThumb));
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exScrollSizeGrip,excascadetree1.get_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exVSBack));
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exSplitBar,Color.FromArgb(196,196,196));
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exCSplitBar,excascadetree1.get_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exSplitBar));
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exHSplitBar,excascadetree1.get_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exSplitBar));
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exSplitBarSize,Color.FromArgb(4,0,0));
excascadetree1.set_Background32((exontrol.EXCASCADETREELib.BackgroundPartEnum)0x0,0x1000000);
excascadetree1.set_Background32((exontrol.EXCASCADETREELib.BackgroundPartEnum)0x1,0x2000000);
excascadetree1.set_Background32((exontrol.EXCASCADETREELib.BackgroundPartEnum)0x20,-1);
excascadetree1.EndUpdate();
|
|
64
|
GroupBy sample
// CreateView event - A view has been created.
private void excascadetree1_CreateView(object sender,exontrol.EXCASCADETREELib.View View)
{
excascadetree1.View.HeaderHeight = 24;
exontrol.EXCASCADETREELib.View var_View = excascadetree1.get_DefaultView(null);
exontrol.EXCASCADETREELib.View var_View1 = var_View.get_View("State");
var_View1.BeginUpdate();
var_View1.SingleSel = false;
var_View1.ColumnAutoResize = true;
var_View1.Columns[0].Visible = false;
var_View1.Columns[1].Visible = false;
exontrol.EXCASCADETREELib.Column var_Column = var_View1.Columns[2];
var_Column.HTMLCaption = "State <off 4><fgcolor=808080>Name";
var_Column.SortOrder = exontrol.EXCASCADETREELib.SortOrderEnum.SortAscending;
var_View1.EndUpdate();
exontrol.EXCASCADETREELib.View var_View2 = var_View.get_View("City");
int nSelected = var_View2.ParentView.Items.SelectCount;
object bGroupBy = excascadetree1.FormatABC("value > 1 ? -1 : 0",nSelected,null,null);
var_View2.BeginUpdate();
var_View2.SingleSel = false;
var_View2.SortBarCaption = "Drag a <b>column</b> header here to group by that column.";
var_View2.HasLines = exontrol.EXCASCADETREELib.HierarchyLineEnum.exSolidLine;
var_View2.ColumnAutoResize = false;
var_View2.DrawGridLines = exontrol.EXCASCADETREELib.GridLinesEnum.exVLines;
var_View2.GridLineStyle = exontrol.EXCASCADETREELib.GridLinesStyleEnum.exGridLinesVSolid;
var_View2.Columns["CountryCode"].Visible = false;
exontrol.EXCASCADETREELib.Column var_Column1 = var_View2.Columns["Name"];
var_Column1.HTMLCaption = "City <off 4><fgcolor=808080>Name";
var_Column1.Width = 128;
var_Column1.SortOrder = exontrol.EXCASCADETREELib.SortOrderEnum.SortAscending;
var_View2.SearchColumnIndex = 2;
var_View2.TreeColumnIndex = var_View2.SearchColumnIndex;
var_View2.SingleSort = false;
var_View2.AllowGroupBy = false;
var_View2.SortBarVisible = false;
exontrol.EXCASCADETREELib.Column var_Column2 = var_View2.Columns["StateCode"];
var_Column2.Visible = false;
var_Column2.SortOrder = exontrol.EXCASCADETREELib.SortOrderEnum.SortAscending;
var_View2.Width = var_View2.WidthToFit;
var_View2.EndUpdate();
}
//this.excascadetree1.CreateView += new exontrol.EXCASCADETREELib.exg2antt.CreateViewEventHandler(this.excascadetree1_CreateView);
// Error event - An internal error occurs.
private void excascadetree1_Error(object sender,int Err,string Description)
{
System.Diagnostics.Debug.Print( "Error" );
System.Diagnostics.Debug.Print( Description.ToString() );
}
//this.excascadetree1.Error += new exontrol.EXCASCADETREELib.exg2antt.ErrorEventHandler(this.excascadetree1_Error);
excascadetree1.BeginUpdate();
exontrol.EXCASCADETREELib.Appearance var_Appearance = excascadetree1.VisualAppearance;
var_Appearance.Add(1,"C:\\Program Files\\Exontrol\\ExCascadeTree\\Sample\\EBN\\Assorted\\vistaselDark.ebn");
var_Appearance.Add(2,"C:\\Program Files\\Exontrol\\ExCascadeTree\\Sample\\EBN\\Assorted\\bhframe.ebn");
excascadetree1.DataSource = "Source=C:\\Program Files\\Exontrol\\ExCascadeTree\\Sample\\Access\\cities.mdb;Member=Select * FROM Countries;Key=CountryCode;Ta" +
"g=Country;Name=CountryName >>> Member=Select * FROM States WHERE CountryCode IN (<%Parent.CountryCode%>);Key=StateCode;Name=Stat" +
"eName;Tag=State ||| Member=Select * FROM Cities WHERE CountryCode IN (<%Parent.CountryCode%>);Tag=City;Name=Name >>> Member=Sele" +
"ct * FROM Cities WHERE CountryCode IN (<%Parent.Parent.CountryCode%>) AND StateCode IN (<%Parent.StateCode%>);Tag=City;Name=Name" +
"";
excascadetree1.Select = "RO\\CJ|BV|GL|IL";
exontrol.EXCASCADETREELib.View var_View = excascadetree1.get_DefaultView(null).get_View("Country");
var_View.BeginUpdate();
var_View.ColumnAutoResize = true;
var_View.Columns[0].Visible = false;
exontrol.EXCASCADETREELib.Column var_Column = var_View.Columns[1];
var_Column.HTMLCaption = "Country <off 4><fgcolor=808080>Name";
var_Column.SortOrder = exontrol.EXCASCADETREELib.SortOrderEnum.SortAscending;
var_View.EndUpdate();
excascadetree1.SelBackColor32 = 0x1000000;
excascadetree1.SelForeColor = Color.FromArgb(255,255,255);
excascadetree1.BackColorHeader32 = 0x2000000;
excascadetree1.BackColorSortBar = excascadetree1.BackColor;
excascadetree1.BackColorSortBarCaption = excascadetree1.BackColor;
excascadetree1.set_ScrollPartVisible(exontrol.EXCASCADETREELib.ScrollBarEnum.exVScroll,exontrol.EXCASCADETREELib.ScrollPartEnum.exExtentThumbPart,true);
excascadetree1.set_ScrollPartVisible(exontrol.EXCASCADETREELib.ScrollBarEnum.exHScroll,exontrol.EXCASCADETREELib.ScrollPartEnum.exExtentThumbPart,true);
excascadetree1.set_ScrollPartVisible(exontrol.EXCASCADETREELib.ScrollBarEnum.exScroll,exontrol.EXCASCADETREELib.ScrollPartEnum.exExtentThumbPart,true);
excascadetree1.ScrollWidth = 4;
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exVSBack,Color.FromArgb(240,240,240));
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exVSThumb,Color.FromArgb(128,128,128));
excascadetree1.ScrollHeight = 4;
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exHSBack,excascadetree1.get_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exVSBack));
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exHSThumb,excascadetree1.get_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exVSThumb));
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exScrollSizeGrip,excascadetree1.get_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exVSBack));
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exSplitBar,Color.FromArgb(196,196,196));
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exCSplitBar,excascadetree1.get_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exSplitBar));
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exHSplitBar,excascadetree1.get_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exSplitBar));
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exSplitBarSize,Color.FromArgb(4,0,0));
excascadetree1.BackColorSortBar = excascadetree1.BackColor;
excascadetree1.EndUpdate();
|
|
63
|
Manual sample
// CreateView event - A view has been created.
private void excascadetree1_CreateView(object sender,exontrol.EXCASCADETREELib.View V)
{
exontrol.EXCASCADETREELib.View var_View = excascadetree1.View;
var_View.BeginUpdate();
object k = var_View.ParentView.get_Value(null);
var_View.HeaderVisible = false;
var_View.ColumnAutoResize = true;
var_View.ScrollBySingleLine = true;
(var_View.Columns.Add("Default") as exontrol.EXCASCADETREELib.Column).set_Def(exontrol.EXCASCADETREELib.DefColumnEnum.exCellSingleLine,false);
var_View.Key = 0;
exontrol.EXCASCADETREELib.Items var_Items = var_View.Items;
var_Items.AddItem(excascadetree1.FormatABC("A + `.Child 1`",k,null,null));
var_Items.AddItem(excascadetree1.FormatABC("A + `.Child 2`",k,null,null));
var_Items.AddItem(excascadetree1.FormatABC("A + `.Child 3`",k,null,null));
var_View.EndUpdate();
}
//this.excascadetree1.CreateView += new exontrol.EXCASCADETREELib.exg2antt.CreateViewEventHandler(this.excascadetree1_CreateView);
excascadetree1.BeginUpdate();
excascadetree1.BackColorAlternate32 = 0x7ff0f0f0;
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exSplitBar,Color.FromArgb(240,240,240));
exontrol.EXCASCADETREELib.View var_View = excascadetree1.get_DefaultView(null);
var_View.BeginUpdate();
var_View.HeaderVisible = false;
var_View.ColumnAutoResize = true;
var_View.ScrollBySingleLine = true;
(var_View.Columns.Add("Default") as exontrol.EXCASCADETREELib.Column).set_Def(exontrol.EXCASCADETREELib.DefColumnEnum.exCellSingleLine,false);
var_View.Key = 0;
exontrol.EXCASCADETREELib.Items var_Items = var_View.Items;
var_Items.AddItem("Item A");
var_Items.AddItem("Item B");
var_Items.AddItem("Item C");
var_View.EndUpdate();
excascadetree1.Select = "Item A\\Item*A*2\\Item*A*2*3\\";
excascadetree1.EndUpdate();
|
|
62
|
Appearance sample
// CreateView event - A view has been created.
private void excascadetree1_CreateView(object sender,exontrol.EXCASCADETREELib.View View)
{
excascadetree1.View.HeaderHeight = 24;
exontrol.EXCASCADETREELib.View var_View = excascadetree1.get_DefaultView(null);
exontrol.EXCASCADETREELib.View var_View1 = var_View.get_View("State");
var_View1.BeginUpdate();
var_View1.ColumnAutoResize = true;
var_View1.Columns[0].Visible = false;
var_View1.Columns[1].Visible = false;
exontrol.EXCASCADETREELib.Column var_Column = var_View1.Columns[2];
var_Column.HTMLCaption = "State <off 4><fgcolor=808080>Name";
var_Column.SortOrder = exontrol.EXCASCADETREELib.SortOrderEnum.SortAscending;
exontrol.EXCASCADETREELib.Items var_Items = var_View1.Items;
var_Items.set_LockedItemCount(exontrol.EXCASCADETREELib.VAlignmentEnum.exTop,1);
int h = var_Items.get_LockedItem(exontrol.EXCASCADETREELib.VAlignmentEnum.exTop,0);
var_Items.set_ItemDivider(h,0);
var_Items.set_CellValueFormat(h,0,exontrol.EXCASCADETREELib.ValueFormatEnum.exTotalField | exontrol.EXCASCADETREELib.ValueFormatEnum.exHTML);
var_Items.set_CellValue(h,0,"count(all,all,1)");
var_Items.set_FormatCell(h,0,"`<r>States: <b>`+ (value format `0`)");
var_View1.EndUpdate();
exontrol.EXCASCADETREELib.View var_View2 = var_View.get_View("City");
var_View2.BeginUpdate();
var_View2.SingleSel = false;
var_View2.ColumnAutoResize = false;
var_View2.DrawGridLines = exontrol.EXCASCADETREELib.GridLinesEnum.exVLines;
var_View2.GridLineStyle = exontrol.EXCASCADETREELib.GridLinesStyleEnum.exGridLinesVSolid;
var_View2.Columns[0].Visible = false;
var_View2.Columns[1].Visible = false;
exontrol.EXCASCADETREELib.Column var_Column1 = var_View2.Columns[2];
var_Column1.HTMLCaption = "City <off 4><fgcolor=808080>Name";
var_Column1.Width = 128;
var_Column1.set_Def(exontrol.EXCASCADETREELib.DefColumnEnum.exCellHasCheckBox,true);
var_Column1.SortOrder = exontrol.EXCASCADETREELib.SortOrderEnum.SortAscending;
var_View2.SearchColumnIndex = 2;
var_View2.ConditionalFormats.Add("%CS2 = 1",null).Bold = true;
exontrol.EXCASCADETREELib.Items var_Items1 = var_View2.Items;
var_Items1.set_LockedItemCount(exontrol.EXCASCADETREELib.VAlignmentEnum.exTop,1);
h = var_Items1.get_LockedItem(exontrol.EXCASCADETREELib.VAlignmentEnum.exTop,0);
var_Items1.set_ItemDivider(h,0);
var_Items1.set_CellValueFormat(h,0,exontrol.EXCASCADETREELib.ValueFormatEnum.exTotalField | exontrol.EXCASCADETREELib.ValueFormatEnum.exHTML);
var_Items1.set_CellValue(h,0,"count(all,all,1)");
var_Items1.set_FormatCell(h,0,"`<r>Cities: <b>`+ (value format `0`)");
var_View2.Width = var_View2.WidthToFit;
var_View2.EndUpdate();
}
//this.excascadetree1.CreateView += new exontrol.EXCASCADETREELib.exg2antt.CreateViewEventHandler(this.excascadetree1_CreateView);
// Error event - An internal error occurs.
private void excascadetree1_Error(object sender,int Err,string Description)
{
System.Diagnostics.Debug.Print( "Error" );
System.Diagnostics.Debug.Print( Description.ToString() );
}
//this.excascadetree1.Error += new exontrol.EXCASCADETREELib.exg2antt.ErrorEventHandler(this.excascadetree1_Error);
excascadetree1.BeginUpdate();
exontrol.EXCASCADETREELib.Appearance var_Appearance = excascadetree1.VisualAppearance;
var_Appearance.Add(1,"C:\\Program Files\\Exontrol\\ExCascadeTree\\Sample\\EBN\\MSOffice-Ribbon\\msor_select.ebn");
var_Appearance.Add(2,"C:\\Program Files\\Exontrol\\ExCascadeTree\\Sample\\EBN\\MSOffice-Ribbon\\msor_background.ebn");
excascadetree1.DataSource = "Source=C:\\Program Files\\Exontrol\\ExCascadeTree\\Sample\\Access\\cities.mdb;Member=Select * FROM Countries;Key=CountryCode;Ta" +
"g=Country;Name=CountryName >>> Member=Select * FROM States WHERE CountryCode IN (<%Parent.CountryCode%>);Key=StateCode;Name=Stat" +
"eName;Tag=State ||| Member=Select * FROM Cities WHERE CountryCode IN (<%Parent.CountryCode%>);Tag=City;Name=Name >>> Member=Sele" +
"ct * FROM Cities WHERE CountryCode IN (<%Parent.Parent.CountryCode%>) AND StateCode IN (<%Parent.StateCode%>);Tag=City;Name=Name" +
"";
excascadetree1.Select = "US\\AK";
exontrol.EXCASCADETREELib.View var_View = excascadetree1.get_DefaultView(null).get_View("Country");
var_View.BeginUpdate();
var_View.ColumnAutoResize = true;
var_View.Columns[0].Visible = false;
exontrol.EXCASCADETREELib.Column var_Column = var_View.Columns[1];
var_Column.HTMLCaption = "Country <off 4><fgcolor=808080>Name";
var_Column.SortOrder = exontrol.EXCASCADETREELib.SortOrderEnum.SortAscending;
exontrol.EXCASCADETREELib.Items var_Items = var_View.Items;
var_Items.set_LockedItemCount(exontrol.EXCASCADETREELib.VAlignmentEnum.exTop,1);
int h = var_Items.get_LockedItem(exontrol.EXCASCADETREELib.VAlignmentEnum.exTop,0);
var_Items.set_ItemDivider(h,0);
var_Items.set_CellValueFormat(h,0,exontrol.EXCASCADETREELib.ValueFormatEnum.exTotalField | exontrol.EXCASCADETREELib.ValueFormatEnum.exHTML);
var_Items.set_CellValue(h,0,"count(all,all,1)");
var_Items.set_FormatCell(h,0,"`<r>Countries: <b>`+ (value format `0`)");
var_View.EndUpdate();
excascadetree1.SelBackColor32 = 0x1000000;
excascadetree1.SelForeColor = Color.FromArgb(0,0,0);
excascadetree1.BackColorHeader32 = 0x2000000;
excascadetree1.set_ScrollPartVisible(exontrol.EXCASCADETREELib.ScrollBarEnum.exVScroll,exontrol.EXCASCADETREELib.ScrollPartEnum.exExtentThumbPart,true);
excascadetree1.set_ScrollPartVisible(exontrol.EXCASCADETREELib.ScrollBarEnum.exHScroll,exontrol.EXCASCADETREELib.ScrollPartEnum.exExtentThumbPart,true);
excascadetree1.set_ScrollPartVisible(exontrol.EXCASCADETREELib.ScrollBarEnum.exScroll,exontrol.EXCASCADETREELib.ScrollPartEnum.exExtentThumbPart,true);
excascadetree1.ScrollWidth = 4;
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exVSBack,Color.FromArgb(240,240,240));
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exVSThumb,Color.FromArgb(128,128,128));
excascadetree1.ScrollHeight = 4;
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exHSBack,excascadetree1.get_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exVSBack));
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exHSThumb,excascadetree1.get_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exVSThumb));
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exScrollSizeGrip,excascadetree1.get_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exVSBack));
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exSplitBar,Color.FromArgb(196,196,196));
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exCSplitBar,excascadetree1.get_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exSplitBar));
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exHSplitBar,excascadetree1.get_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exSplitBar));
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exSplitBarSize,Color.FromArgb(4,0,0));
excascadetree1.BackColorSortBar = excascadetree1.BackColor;
excascadetree1.EndUpdate();
|
|
61
|
How can I get the selected items (sample 2)
// CreateView event - A view has been created.
private void excascadetree1_CreateView(object sender,exontrol.EXCASCADETREELib.View View)
{
exontrol.EXCASCADETREELib.View var_View = excascadetree1.View;
object k = var_View.ParentView.get_Value(null);
var_View.BeginUpdate();
var_View.ColumnAutoResize = true;
var_View.Key = -1;
var_View.Columns.Add(k.ToString());
exontrol.EXCASCADETREELib.Items var_Items = var_View.Items;
var_Items.AddItem(excascadetree1.FormatABC("A + `-> Sub-Item 1`",k,null,null));
var_Items.AddItem(excascadetree1.FormatABC("A + `-> Sub-Item 2`",k,null,null));
var_Items.AddItem(excascadetree1.FormatABC("A + `-> Sub-Item 3`",k,null,null));
var_View.EndUpdate();
}
//this.excascadetree1.CreateView += new exontrol.EXCASCADETREELib.exg2antt.CreateViewEventHandler(this.excascadetree1_CreateView);
// ViewItemStateEndChanging event - Indicates that the state of the item has been changed.
private void excascadetree1_ViewItemStateEndChanging(object sender,exontrol.EXCASCADETREELib.ViewItemStateEnum Operation,int Item,int ColIndex)
{
System.Diagnostics.Debug.Print( "End" );
System.Diagnostics.Debug.Print( Operation.ToString() );
exontrol.EXCASCADETREELib.Items var_Items = excascadetree1.View.Items;
System.Diagnostics.Debug.Print( "FocusItem" );
System.Diagnostics.Debug.Print( var_Items.get_CellCaption(var_Items.FocusItem,0) );
System.Diagnostics.Debug.Print( "SelectedItem" );
System.Diagnostics.Debug.Print( var_Items.get_CellCaption(var_Items.get_SelectedItem(0),0) );
}
//this.excascadetree1.ViewItemStateEndChanging += new exontrol.EXCASCADETREELib.exg2antt.ViewItemStateEndChangingEventHandler(this.excascadetree1_ViewItemStateEndChanging);
// ViewItemStateStartChanging event - Indicates that the state of the item is about to be changed.
private void excascadetree1_ViewItemStateStartChanging(object sender,exontrol.EXCASCADETREELib.ViewItemStateEnum Operation,int Item,int ColIndex,ref object Cancel)
{
System.Diagnostics.Debug.Print( "Start" );
System.Diagnostics.Debug.Print( Operation.ToString() );
}
//this.excascadetree1.ViewItemStateStartChanging += new exontrol.EXCASCADETREELib.exg2antt.ViewItemStateStartChangingEventHandler(this.excascadetree1_ViewItemStateStartChanging);
excascadetree1.BeginUpdate();
exontrol.EXCASCADETREELib.View var_View = excascadetree1.View;
var_View.BeginUpdate();
var_View.ColumnAutoResize = true;
var_View.Columns.Add("Default");
var_View.Key = 0;
var_View.LinesAtRoot = exontrol.EXCASCADETREELib.LinesAtRootEnum.exLinesAtRoot;
exontrol.EXCASCADETREELib.Items var_Items = var_View.Items;
var_Items.AddItem("Item A");
var_Items.set_SelectItem(var_Items.AddItem("Item B"),true);
var_Items.AddItem("Item C");
var_View.EndUpdate();
excascadetree1.EndUpdate();
|
|
60
|
How do I specify a foreground color for a particular view
// Error event - An internal error occurs.
private void excascadetree1_Error(object sender,int Err,string Description)
{
System.Diagnostics.Debug.Print( "Error" );
System.Diagnostics.Debug.Print( Description.ToString() );
}
//this.excascadetree1.Error += new exontrol.EXCASCADETREELib.exg2antt.ErrorEventHandler(this.excascadetree1_Error);
excascadetree1.BeginUpdate();
excascadetree1.Mode = exontrol.EXCASCADETREELib.CascadeModeEnum.exSplitFixCascadeMode;
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exSplitBar,Color.FromArgb(196,196,196));
excascadetree1.DataSource = "Source=C:\\Program Files\\Exontrol\\ExCascadeTree\\Sample\\Access\\cities.accdb;Member=Select * FROM Countries;Key=CountryCode;" +
"Tag=Country;Name=CountryName >>> Member=Select * FROM States WHERE CountryCode IN (<%Parent.CountryCode%>);Key=StateCode;Name=St" +
"ateName;Tag=State ||| Member=Select * FROM Cities WHERE CountryCode IN (<%Parent.CountryCode%>);Tag=City;Name=Name >>> Member=Se" +
"lect * FROM Cities WHERE CountryCode IN (<%Parent.Parent.CountryCode%>) AND StateCode IN (<%Parent.StateCode%>);Tag=City;Name=Na" +
"me";
excascadetree1.Select = "US\\AK";
excascadetree1.get_DefaultView(null).ConditionalFormats.Add("1",null).ForeColor = Color.FromArgb(128,128,128);
excascadetree1.EndUpdate();
|
|
59
|
How do display result/items in the view's filter bar
// CreateView event - A view has been created.
private void excascadetree1_CreateView(object sender,exontrol.EXCASCADETREELib.View View)
{
exontrol.EXCASCADETREELib.View var_View = excascadetree1.View;
var_View.HeaderAppearance = exontrol.EXCASCADETREELib.AppearanceEnum.Etched;
var_View.HeaderHeight = 24;
var_View.DrawGridLines = exontrol.EXCASCADETREELib.GridLinesEnum.exAllLines;
var_View.GridLineStyle = exontrol.EXCASCADETREELib.GridLinesStyleEnum.exGridLinesDash;
exontrol.EXCASCADETREELib.View var_View1 = excascadetree1.get_DefaultView(null);
exontrol.EXCASCADETREELib.View var_View2 = var_View1.get_View("Country");
var_View2.BeginUpdate();
var_View2.ColumnAutoResize = true;
var_View2.Columns[0].Visible = false;
exontrol.EXCASCADETREELib.Column var_Column = var_View2.Columns[1];
var_Column.HTMLCaption = "Country <off 4><fgcolor=808080>Name";
var_Column.DisplayFilterButton = true;
var_Column.FilterList = exontrol.EXCASCADETREELib.FilterListEnum.exShowExclude | exontrol.EXCASCADETREELib.FilterListEnum.exShowFocusItem | exontrol.EXCASCADETREELib.FilterListEnum.exShowCheckBox | exontrol.EXCASCADETREELib.FilterListEnum.exSortItemsAsc;
var_Column.FilterBarDropDownWidth = 2;
var_View2.EndUpdate();
exontrol.EXCASCADETREELib.View var_View3 = var_View1.get_View("State");
var_View3.BeginUpdate();
var_View3.ColumnAutoResize = true;
var_View3.Columns[0].Visible = false;
var_View3.Columns[1].Visible = false;
exontrol.EXCASCADETREELib.Column var_Column1 = var_View3.Columns[2];
var_Column1.HTMLCaption = "State <off 4><fgcolor=808080>Name";
var_Column1.DisplayFilterButton = true;
var_Column1.FilterList = exontrol.EXCASCADETREELib.FilterListEnum.exShowExclude | exontrol.EXCASCADETREELib.FilterListEnum.exShowFocusItem | exontrol.EXCASCADETREELib.FilterListEnum.exShowCheckBox | exontrol.EXCASCADETREELib.FilterListEnum.exSortItemsAsc;
var_Column1.FilterBarDropDownWidth = 2;
var_View3.EndUpdate();
exontrol.EXCASCADETREELib.View var_View4 = var_View1.get_View("City");
var_View4.BeginUpdate();
var_View4.Columns[0].Visible = false;
var_View4.Columns[1].Visible = false;
exontrol.EXCASCADETREELib.Column var_Column2 = var_View4.Columns[2];
var_Column2.HTMLCaption = "City <off 4><fgcolor=808080>Name";
var_Column2.Width = 128;
var_Column2.set_Def(exontrol.EXCASCADETREELib.DefColumnEnum.exCellHasCheckBox,true);
var_Column2.DisplayFilterButton = true;
var_Column2.FilterList = exontrol.EXCASCADETREELib.FilterListEnum.exShowExclude | exontrol.EXCASCADETREELib.FilterListEnum.exShowFocusItem | exontrol.EXCASCADETREELib.FilterListEnum.exShowCheckBox | exontrol.EXCASCADETREELib.FilterListEnum.exSortItemsAsc;
var_Column2.FilterBarDropDownWidth = 2;
exontrol.EXCASCADETREELib.Column var_Column3 = (var_View4.Columns.Add("Pos") as exontrol.EXCASCADETREELib.Column);
var_Column3.AllowSizing = false;
var_Column3.Width = 32;
var_Column3.set_Def(exontrol.EXCASCADETREELib.DefColumnEnum.exCellBackColor,15790320);
var_Column3.Position = 0;
var_Column3.FormatColumn = "1 pos ``";
var_View4.CountLockedColumns = 1;
var_View4.EndUpdate();
exontrol.EXCASCADETREELib.View var_View5 = excascadetree1.View;
var_View5.FilterBarHeight = 36;
var_View5.FilterBarCaption = "(( ( allui replace `[<b>` with `<bgcolor=000000><fgcolor=FFFFFF><b> ` replace `</b>]` with ` </b></bgcolor></fgcolor>` replace " +
"`[<s>` with `<bgcolor=C0C0C0><fgcolor=FFFFFF> ` replace `</s>]` with ` </fgcolor></bgcolor>` ) + `<r><fgcolor=808080>` + ( matc" +
"hitemcount < 0 ? ( ( len(value) ? `` : `` ) + `<r>` + abs(matchitemcount + 1) + ` result(s)` ) : (`<r><fgcolor=808080>`+ itemcou" +
"nt + ` item(s)`) )))";
var_View5.FilterBarPromptType = exontrol.EXCASCADETREELib.FilterPromptEnum.exFilterPromptStartWith;
var_View5.FilterBarPromptVisible = exontrol.EXCASCADETREELib.FilterBarVisibleEnum.exFilterBarShowCloseIfRequired | exontrol.EXCASCADETREELib.FilterBarVisibleEnum.exFilterBarVisible | exontrol.EXCASCADETREELib.FilterBarVisibleEnum.exFilterBarPromptVisible;
}
//this.excascadetree1.CreateView += new exontrol.EXCASCADETREELib.exg2antt.CreateViewEventHandler(this.excascadetree1_CreateView);
// Error event - An internal error occurs.
private void excascadetree1_Error(object sender,int Err,string Description)
{
System.Diagnostics.Debug.Print( "Error" );
System.Diagnostics.Debug.Print( Description.ToString() );
}
//this.excascadetree1.Error += new exontrol.EXCASCADETREELib.exg2antt.ErrorEventHandler(this.excascadetree1_Error);
excascadetree1.BeginUpdate();
excascadetree1.set_ScrollPartVisible(exontrol.EXCASCADETREELib.ScrollBarEnum.exVScroll,exontrol.EXCASCADETREELib.ScrollPartEnum.exExtentThumbPart,true);
excascadetree1.set_ScrollPartVisible(exontrol.EXCASCADETREELib.ScrollBarEnum.exHScroll,exontrol.EXCASCADETREELib.ScrollPartEnum.exExtentThumbPart,true);
excascadetree1.set_ScrollPartVisible(exontrol.EXCASCADETREELib.ScrollBarEnum.exScroll,exontrol.EXCASCADETREELib.ScrollPartEnum.exExtentThumbPart,true);
excascadetree1.ScrollWidth = 4;
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exVSBack,Color.FromArgb(240,240,240));
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exVSThumb,Color.FromArgb(128,128,128));
excascadetree1.ScrollHeight = 4;
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exHSBack,excascadetree1.get_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exVSBack));
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exHSThumb,excascadetree1.get_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exVSThumb));
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exScrollSizeGrip,excascadetree1.get_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exVSBack));
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exSplitBar,Color.FromArgb(196,196,196));
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exCSplitBar,excascadetree1.get_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exSplitBar));
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exHSplitBar,excascadetree1.get_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exSplitBar));
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exSplitBarSize,Color.FromArgb(2,0,0));
excascadetree1.EndUpdate();
excascadetree1.BeginUpdate();
excascadetree1.MinColumnWidth = 348;
excascadetree1.Mode = exontrol.EXCASCADETREELib.CascadeModeEnum.exSplitFixCascadeMode;
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exSplitBar,Color.FromArgb(196,196,196));
excascadetree1.DataSource = "Source=C:\\Program Files\\Exontrol\\ExCascadeTree\\Sample\\Access\\cities.accdb;Member=Select * FROM Countries;Key=CountryCode;" +
"Tag=Country;Name=CountryName >>> Member=Select * FROM States WHERE CountryCode IN (<%Parent.CountryCode%>);Key=StateCode;Name=St" +
"ateName;Tag=State ||| Member=Select * FROM Cities WHERE CountryCode IN (<%Parent.CountryCode%>);Tag=City;Name=Name >>> Member=Se" +
"lect * FROM Cities WHERE CountryCode IN (<%Parent.Parent.CountryCode%>) AND StateCode IN (<%Parent.StateCode%>);Tag=City;Name=Na" +
"me";
excascadetree1.Select = "US\\AK";
exontrol.EXCASCADETREELib.View var_View = excascadetree1.get_DefaultView(null).get_View("City");
var_View.FilterBarPromptPattern = "An";
excascadetree1.EndUpdate();
|
|
58
|
I am using the filter prompt feature, the question is how can I filter for items that starts with typed characters rather than contains
// CreateView event - A view has been created.
private void excascadetree1_CreateView(object sender,exontrol.EXCASCADETREELib.View View)
{
exontrol.EXCASCADETREELib.View var_View = excascadetree1.View;
var_View.FilterBarPromptType = exontrol.EXCASCADETREELib.FilterPromptEnum.exFilterPromptStartWith;
var_View.FilterBarPromptVisible = exontrol.EXCASCADETREELib.FilterBarVisibleEnum.exFilterBarPromptVisible;
}
//this.excascadetree1.CreateView += new exontrol.EXCASCADETREELib.exg2antt.CreateViewEventHandler(this.excascadetree1_CreateView);
// Error event - An internal error occurs.
private void excascadetree1_Error(object sender,int Err,string Description)
{
System.Diagnostics.Debug.Print( "Error" );
System.Diagnostics.Debug.Print( Description.ToString() );
}
//this.excascadetree1.Error += new exontrol.EXCASCADETREELib.exg2antt.ErrorEventHandler(this.excascadetree1_Error);
excascadetree1.BeginUpdate();
excascadetree1.Mode = exontrol.EXCASCADETREELib.CascadeModeEnum.exSplitFixCascadeMode;
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exSplitBar,Color.FromArgb(196,196,196));
excascadetree1.DataSource = "Source=C:\\Program Files\\Exontrol\\ExCascadeTree\\Sample\\Access\\cities.accdb;Member=Select * FROM Countries;Key=CountryCode;" +
"Tag=Country;Name=CountryName >>> Member=Select * FROM States WHERE CountryCode IN (<%Parent.CountryCode%>);Key=StateCode;Name=St" +
"ateName;Tag=State ||| Member=Select * FROM Cities WHERE CountryCode IN (<%Parent.CountryCode%>);Tag=City;Name=Name >>> Member=Se" +
"lect * FROM Cities WHERE CountryCode IN (<%Parent.Parent.CountryCode%>) AND StateCode IN (<%Parent.StateCode%>);Tag=City;Name=Na" +
"me";
excascadetree1.Select = "US\\AK";
exontrol.EXCASCADETREELib.View var_View = excascadetree1.get_DefaultView(null).get_View("City");
var_View.FilterBarPromptPattern = "An";
exontrol.EXCASCADETREELib.Column var_Column = var_View.Columns["Name"];
var_Column.Width = 128;
var_Column.set_Def(exontrol.EXCASCADETREELib.DefColumnEnum.exCellValueFormat,1);
var_Column.FormatColumn = "value replace `An` with `<bgcolor=000000><fgcolor=FFFFFF>An</fgcolor></bgcolor>` ";
excascadetree1.EndUpdate();
|
|
57
|
FilterBarCaption Predefined Keywords
// Error event - An internal error occurs.
private void excascadetree1_Error(object sender,int Err,string Description)
{
System.Diagnostics.Debug.Print( "Error" );
System.Diagnostics.Debug.Print( Description.ToString() );
}
//this.excascadetree1.Error += new exontrol.EXCASCADETREELib.exg2antt.ErrorEventHandler(this.excascadetree1_Error);
excascadetree1.BeginUpdate();
excascadetree1.BackColorAlternate = Color.FromArgb(240,240,240);
excascadetree1.Mode = exontrol.EXCASCADETREELib.CascadeModeEnum.exSingleCascadeMode;
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exSplitBar,Color.FromArgb(196,196,196));
excascadetree1.DataSource = "Source=C:\\Program Files\\Exontrol\\ExCascadeTree\\Sample\\Access\\cities.accdb;Member=Select * FROM Countries;Key=CountryCode;" +
"Tag=Country;Name=CountryName >>> Member=Select * FROM States WHERE CountryCode IN (<%Parent.CountryCode%>);Key=StateCode;Name=St" +
"ateName;Tag=State ||| Member=Select * FROM Cities WHERE CountryCode IN (<%Parent.CountryCode%>);Tag=City;Name=Name >>> Member=Se" +
"lect * FROM Cities WHERE CountryCode IN (<%Parent.Parent.CountryCode%>) AND StateCode IN (<%Parent.StateCode%>);Tag=City;Name=Na" +
"me";
excascadetree1.Select = "US";
exontrol.EXCASCADETREELib.View var_View = excascadetree1.get_DefaultView(null).get_View("Country");
exontrol.EXCASCADETREELib.Column var_Column = (var_View.Columns.Add("Pos") as exontrol.EXCASCADETREELib.Column);
var_Column.Position = 0;
var_Column.Width = 32;
var_Column.AllowSizing = false;
var_Column.FormatColumn = "1pos ``";
exontrol.EXCASCADETREELib.Column var_Column1 = var_View.Columns["CountryCode"];
var_Column1.Width = 32;
var_Column1.AllowSizing = false;
var_Column1.DisplayFilterButton = true;
exontrol.EXCASCADETREELib.Column var_Column2 = var_View.Columns["CountryName"];
var_Column2.DisplayFilterButton = true;
var_Column2.FilterList = exontrol.EXCASCADETREELib.FilterListEnum.exShowExclude | exontrol.EXCASCADETREELib.FilterListEnum.exShowFocusItem | exontrol.EXCASCADETREELib.FilterListEnum.exShowCheckBox | exontrol.EXCASCADETREELib.FilterListEnum.exSortItemsAsc;
var_Column2.FilterBarDropDownWidth = 2;
var_Column2.FilterType = exontrol.EXCASCADETREELib.FilterTypeEnum.exFilter;
var_Column2.Filter = "Italy|Romania|Germany";
var_View.FilterBarPromptPattern = "a";
var_View.ColumnAutoResize = true;
var_View.SearchColumnIndex = var_View.Columns["CountryName"].Index;
var_View.FilterInclude = exontrol.EXCASCADETREELib.FilterIncludeEnum.exItemsWithChilds;
var_View.FilterBarCaption = "`<fgcolor=0000FF><i>value/current</i></fgcolor>: <fgcolor=808080>` + value + `</fgcolor>` + `<br><fgcolor=0000FF><i>available</" +
"i></fgcolor>: ` + available + `<br><fgcolor=0000FF><i>allui</i></fgcolor>: ` + allui + `<br><fgcolor=0000FF><i>all</i></fgcolor>" +
": ` + all + `<br><fgcolor=0000FF><i>itemcount</i></fgcolor>: <fgcolor=808080>` + itemcount + `</fgcolor>`+ `<br><fgcolor=0000FF>" +
"<i>visibleitemcount</i></fgcolor>: <fgcolor=808080>` + visibleitemcount + `</fgcolor>`+ `<br><fgcolor=0000FF><i>matchitemcount</" +
"i></fgcolor>: <fgcolor=808080>` + matchitemcount + `</fgcolor>`+ `<br><fgcolor=0000FF><i>promptpattern</i></fgcolor>: <fgcolor=8" +
"08080>` + promptpattern + `</fgcolor>`+ `<br><fgcolor=0000FF><i>leafitemcount</i></fgcolor>: <fgcolor=808080>` + leafitemcount +" +
" `</fgcolor>`";
var_View.FilterBarPromptVisible = exontrol.EXCASCADETREELib.FilterBarVisibleEnum.exFilterBarCaptionVisible | exontrol.EXCASCADETREELib.FilterBarVisibleEnum.exFilterBarVisible | exontrol.EXCASCADETREELib.FilterBarVisibleEnum.exFilterBarPromptVisible;
var_View.ApplyFilter();
excascadetree1.EndUpdate();
|
|
56
|
How can I enable the column's filter bar (view)
// CreateView event - A view has been created.
private void excascadetree1_CreateView(object sender,exontrol.EXCASCADETREELib.View View)
{
excascadetree1.View.FilterBarPromptVisible = exontrol.EXCASCADETREELib.FilterBarVisibleEnum.exFilterBarPromptVisible;
}
//this.excascadetree1.CreateView += new exontrol.EXCASCADETREELib.exg2antt.CreateViewEventHandler(this.excascadetree1_CreateView);
// Error event - An internal error occurs.
private void excascadetree1_Error(object sender,int Err,string Description)
{
System.Diagnostics.Debug.Print( "Error" );
System.Diagnostics.Debug.Print( Description.ToString() );
}
//this.excascadetree1.Error += new exontrol.EXCASCADETREELib.exg2antt.ErrorEventHandler(this.excascadetree1_Error);
excascadetree1.BeginUpdate();
excascadetree1.Mode = exontrol.EXCASCADETREELib.CascadeModeEnum.exSplitFixCascadeMode;
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exSplitBar,Color.FromArgb(196,196,196));
excascadetree1.DataSource = "Source=C:\\Program Files\\Exontrol\\ExCascadeTree\\Sample\\Access\\cities.accdb;Member=Select * FROM Countries;Key=CountryCode;" +
"Tag=Country;Name=CountryName >>> Member=Select * FROM States WHERE CountryCode IN (<%Parent.CountryCode%>);Key=StateCode;Name=St" +
"ateName;Tag=State ||| Member=Select * FROM Cities WHERE CountryCode IN (<%Parent.CountryCode%>);Tag=City;Name=Name >>> Member=Se" +
"lect * FROM Cities WHERE CountryCode IN (<%Parent.Parent.CountryCode%>) AND StateCode IN (<%Parent.StateCode%>);Tag=City;Name=Na" +
"me";
excascadetree1.Select = "US\\AK";
exontrol.EXCASCADETREELib.View var_View = excascadetree1.get_DefaultView(null).get_View("Country");
var_View.ColumnAutoResize = true;
var_View.Columns["CountryCode"].Visible = false;
exontrol.EXCASCADETREELib.Column var_Column = var_View.Columns["CountryName"];
var_Column.DisplayFilterButton = true;
var_Column.FilterList = exontrol.EXCASCADETREELib.FilterListEnum.exShowExclude | exontrol.EXCASCADETREELib.FilterListEnum.exShowFocusItem | exontrol.EXCASCADETREELib.FilterListEnum.exShowCheckBox | exontrol.EXCASCADETREELib.FilterListEnum.exSortItemsAsc;
var_Column.FilterBarDropDownWidth = 2;
var_Column.FilterType = exontrol.EXCASCADETREELib.FilterTypeEnum.exFilter;
var_Column.Filter = "Romania|Germany";
var_View.ApplyFilter();
excascadetree1.EndUpdate();
|
|
55
|
How can I enable the column's filter bar
// CreateView event - A view has been created.
private void excascadetree1_CreateView(object sender,exontrol.EXCASCADETREELib.View View)
{
exontrol.EXCASCADETREELib.View var_View = excascadetree1.View;
var_View.FilterBarPromptVisible = exontrol.EXCASCADETREELib.FilterBarVisibleEnum.exFilterBarPromptVisible;
exontrol.EXCASCADETREELib.Column var_Column = var_View.Columns[0];
var_Column.DisplayFilterButton = true;
var_Column.FilterList = exontrol.EXCASCADETREELib.FilterListEnum.exShowExclude | exontrol.EXCASCADETREELib.FilterListEnum.exShowFocusItem | exontrol.EXCASCADETREELib.FilterListEnum.exShowCheckBox | exontrol.EXCASCADETREELib.FilterListEnum.exSortItemsAsc;
var_Column.FilterBarDropDownWidth = 2;
exontrol.EXCASCADETREELib.View var_View1 = excascadetree1.get_DefaultView(null).get_View("Country");
exontrol.EXCASCADETREELib.Column var_Column1 = var_View1.Columns[0];
var_Column1.FilterType = exontrol.EXCASCADETREELib.FilterTypeEnum.exFilter;
var_Column1.Filter = "US|RO|GE";
var_View1.ApplyFilter();
}
//this.excascadetree1.CreateView += new exontrol.EXCASCADETREELib.exg2antt.CreateViewEventHandler(this.excascadetree1_CreateView);
// Error event - An internal error occurs.
private void excascadetree1_Error(object sender,int Err,string Description)
{
System.Diagnostics.Debug.Print( "Error" );
System.Diagnostics.Debug.Print( Description.ToString() );
}
//this.excascadetree1.Error += new exontrol.EXCASCADETREELib.exg2antt.ErrorEventHandler(this.excascadetree1_Error);
excascadetree1.BeginUpdate();
excascadetree1.Mode = exontrol.EXCASCADETREELib.CascadeModeEnum.exSplitFixCascadeMode;
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exSplitBar,Color.FromArgb(196,196,196));
excascadetree1.DataSource = "Source=C:\\Program Files\\Exontrol\\ExCascadeTree\\Sample\\Access\\cities.accdb;Member=Select * FROM Countries;Key=CountryCode;" +
"Tag=Country;Name=CountryName >>> Member=Select * FROM States WHERE CountryCode IN (<%Parent.CountryCode%>);Key=StateCode;Name=St" +
"ateName;Tag=State ||| Member=Select * FROM Cities WHERE CountryCode IN (<%Parent.CountryCode%>);Tag=City;Name=Name >>> Member=Se" +
"lect * FROM Cities WHERE CountryCode IN (<%Parent.Parent.CountryCode%>) AND StateCode IN (<%Parent.StateCode%>);Tag=City;Name=Na" +
"me";
excascadetree1.Select = "US\\AK";
excascadetree1.EndUpdate();
|
|
54
|
How can I enable the control's filter bar (view)
// Error event - An internal error occurs.
private void excascadetree1_Error(object sender,int Err,string Description)
{
System.Diagnostics.Debug.Print( "Error" );
System.Diagnostics.Debug.Print( Description.ToString() );
}
//this.excascadetree1.Error += new exontrol.EXCASCADETREELib.exg2antt.ErrorEventHandler(this.excascadetree1_Error);
excascadetree1.BeginUpdate();
excascadetree1.Mode = exontrol.EXCASCADETREELib.CascadeModeEnum.exSplitFixCascadeMode;
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exSplitBar,Color.FromArgb(196,196,196));
excascadetree1.DataSource = "Source=C:\\Program Files\\Exontrol\\ExCascadeTree\\Sample\\Access\\cities.accdb;Member=Select * FROM Countries;Key=CountryCode;" +
"Tag=Country;Name=CountryName >>> Member=Select * FROM States WHERE CountryCode IN (<%Parent.CountryCode%>);Key=StateCode;Name=St" +
"ateName;Tag=State ||| Member=Select * FROM Cities WHERE CountryCode IN (<%Parent.CountryCode%>);Tag=City;Name=Name >>> Member=Se" +
"lect * FROM Cities WHERE CountryCode IN (<%Parent.Parent.CountryCode%>) AND StateCode IN (<%Parent.StateCode%>);Tag=City;Name=Na" +
"me";
excascadetree1.Select = "US\\AK";
excascadetree1.get_DefaultView(null).FilterBarPromptVisible = exontrol.EXCASCADETREELib.FilterBarVisibleEnum.exFilterBarPromptVisible;
excascadetree1.EndUpdate();
|
|
53
|
How can I enable the control's filter bar
// CreateView event - A view has been created.
private void excascadetree1_CreateView(object sender,exontrol.EXCASCADETREELib.View View)
{
excascadetree1.View.FilterBarPromptVisible = exontrol.EXCASCADETREELib.FilterBarVisibleEnum.exFilterBarPromptVisible;
}
//this.excascadetree1.CreateView += new exontrol.EXCASCADETREELib.exg2antt.CreateViewEventHandler(this.excascadetree1_CreateView);
// Error event - An internal error occurs.
private void excascadetree1_Error(object sender,int Err,string Description)
{
System.Diagnostics.Debug.Print( "Error" );
System.Diagnostics.Debug.Print( Description.ToString() );
}
//this.excascadetree1.Error += new exontrol.EXCASCADETREELib.exg2antt.ErrorEventHandler(this.excascadetree1_Error);
excascadetree1.BeginUpdate();
excascadetree1.Mode = exontrol.EXCASCADETREELib.CascadeModeEnum.exSplitFixCascadeMode;
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exSplitBar,Color.FromArgb(196,196,196));
excascadetree1.DataSource = "Source=C:\\Program Files\\Exontrol\\ExCascadeTree\\Sample\\Access\\cities.accdb;Member=Select * FROM Countries;Key=CountryCode;" +
"Tag=Country;Name=CountryName >>> Member=Select * FROM States WHERE CountryCode IN (<%Parent.CountryCode%>);Key=StateCode;Name=St" +
"ateName;Tag=State ||| Member=Select * FROM Cities WHERE CountryCode IN (<%Parent.CountryCode%>);Tag=City;Name=Name >>> Member=Se" +
"lect * FROM Cities WHERE CountryCode IN (<%Parent.Parent.CountryCode%>) AND StateCode IN (<%Parent.StateCode%>);Tag=City;Name=Na" +
"me";
excascadetree1.Select = "US\\AK";
excascadetree1.EndUpdate();
|
|
52
|
Aggregate sum, min, max, count, avg, divider, total (view)
// Error event - An internal error occurs.
private void excascadetree1_Error(object sender,int Err,string Description)
{
System.Diagnostics.Debug.Print( "Error" );
System.Diagnostics.Debug.Print( Description.ToString() );
}
//this.excascadetree1.Error += new exontrol.EXCASCADETREELib.exg2antt.ErrorEventHandler(this.excascadetree1_Error);
excascadetree1.BeginUpdate();
excascadetree1.Mode = exontrol.EXCASCADETREELib.CascadeModeEnum.exSplitEqualCascadeMode;
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exSplitBar,Color.FromArgb(196,196,196));
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exSplitBarSize,Color.FromArgb(4,0,0));
excascadetree1.DataSource = "Source=C:\\Program Files\\Exontrol\\ExCascadeTree\\Sample\\Access\\cities.accdb;Member=Select * FROM Countries;Key=CountryCode;" +
"Tag=Country;Name=CountryName >>> Member=Select * FROM States WHERE CountryCode IN (<%Parent.CountryCode%>);Key=StateCode;Name=St" +
"ateName;Tag=State ||| Member=Select * FROM Cities WHERE CountryCode IN (<%Parent.CountryCode%>);Tag=City;Name=Name >>> Member=Se" +
"lect * FROM Cities WHERE CountryCode IN (<%Parent.Parent.CountryCode%>) AND StateCode IN (<%Parent.StateCode%>);Tag=City;Name=Na" +
"me";
excascadetree1.Select = "RO";
exontrol.EXCASCADETREELib.View var_View = excascadetree1.get_DefaultView(null).get_View("Country");
var_View.BeginUpdate();
var_View.ColumnAutoResize = true;
var_View.Columns[0].Visible = false;
exontrol.EXCASCADETREELib.Items var_Items = var_View.Items;
var_Items.set_LockedItemCount(exontrol.EXCASCADETREELib.VAlignmentEnum.exTop,1);
int h = var_Items.get_LockedItem(exontrol.EXCASCADETREELib.VAlignmentEnum.exTop,0);
var_Items.set_ItemDivider(h,0);
var_Items.set_CellValueFormat(h,0,exontrol.EXCASCADETREELib.ValueFormatEnum.exTotalField | exontrol.EXCASCADETREELib.ValueFormatEnum.exHTML);
var_Items.set_CellValue(h,0,"count(all,all,1)");
var_Items.set_FormatCell(h,0,"`<r>Countries: <b>`+ (value format `0`)");
var_View.EndUpdate();
excascadetree1.EndUpdate();
|
|
51
|
Aggregate sum, min, max, count, avg, divider, total
// CreateView event - A view has been created.
private void excascadetree1_CreateView(object sender,exontrol.EXCASCADETREELib.View View)
{
excascadetree1.View.HeaderVisible = false;
exontrol.EXCASCADETREELib.View var_View = excascadetree1.get_DefaultView(null);
exontrol.EXCASCADETREELib.View var_View1 = var_View.get_View("Country");
var_View1.BeginUpdate();
var_View1.ColumnAutoResize = true;
var_View1.Columns[0].Visible = false;
exontrol.EXCASCADETREELib.Items var_Items = var_View1.Items;
var_Items.set_LockedItemCount(exontrol.EXCASCADETREELib.VAlignmentEnum.exTop,1);
int h = var_Items.get_LockedItem(exontrol.EXCASCADETREELib.VAlignmentEnum.exTop,0);
var_Items.set_ItemDivider(h,0);
var_Items.set_CellValueFormat(h,0,exontrol.EXCASCADETREELib.ValueFormatEnum.exTotalField | exontrol.EXCASCADETREELib.ValueFormatEnum.exHTML);
var_Items.set_CellValue(h,0,"count(all,all,1)");
var_Items.set_FormatCell(h,0,"`<r>Countries: <b>`+ (value format `0`)");
var_View1.EndUpdate();
exontrol.EXCASCADETREELib.View var_View2 = var_View.get_View("State");
var_View2.BeginUpdate();
var_View2.SingleSel = false;
var_View2.ColumnAutoResize = true;
var_View2.Columns[0].Visible = false;
var_View2.Columns[1].Visible = false;
exontrol.EXCASCADETREELib.Items var_Items1 = var_View2.Items;
var_Items1.set_LockedItemCount(exontrol.EXCASCADETREELib.VAlignmentEnum.exTop,1);
h = var_Items1.get_LockedItem(exontrol.EXCASCADETREELib.VAlignmentEnum.exTop,0);
var_Items1.set_ItemDivider(h,0);
var_Items1.set_CellValueFormat(h,0,exontrol.EXCASCADETREELib.ValueFormatEnum.exTotalField | exontrol.EXCASCADETREELib.ValueFormatEnum.exHTML);
var_Items1.set_CellValue(h,0,"count(all,all,1)");
var_Items1.set_FormatCell(h,0,"`<r>States: <b>`+ (value format `0`)");
var_View2.EndUpdate();
exontrol.EXCASCADETREELib.View var_View3 = var_View.get_View("City");
var_View3.BeginUpdate();
var_View3.Columns[0].Visible = false;
var_View3.Columns[1].Visible = false;
exontrol.EXCASCADETREELib.Column var_Column = var_View3.Columns[2];
var_Column.Width = 128;
var_Column.HTMLCaption = "CityName";
exontrol.EXCASCADETREELib.Items var_Items2 = var_View3.Items;
var_Items2.set_LockedItemCount(exontrol.EXCASCADETREELib.VAlignmentEnum.exTop,1);
h = var_Items2.get_LockedItem(exontrol.EXCASCADETREELib.VAlignmentEnum.exTop,0);
var_Items2.set_ItemDivider(h,0);
var_Items2.set_CellValueFormat(h,0,exontrol.EXCASCADETREELib.ValueFormatEnum.exTotalField | exontrol.EXCASCADETREELib.ValueFormatEnum.exHTML);
var_Items2.set_CellValue(h,0,"count(all,all,1)");
var_Items2.set_FormatCell(h,0,"`<r>Cities: <b>`+ (value format `0`)");
var_View3.EndUpdate();
}
//this.excascadetree1.CreateView += new exontrol.EXCASCADETREELib.exg2antt.CreateViewEventHandler(this.excascadetree1_CreateView);
// Error event - An internal error occurs.
private void excascadetree1_Error(object sender,int Err,string Description)
{
System.Diagnostics.Debug.Print( "Error" );
System.Diagnostics.Debug.Print( Description.ToString() );
}
//this.excascadetree1.Error += new exontrol.EXCASCADETREELib.exg2antt.ErrorEventHandler(this.excascadetree1_Error);
excascadetree1.BeginUpdate();
excascadetree1.Mode = exontrol.EXCASCADETREELib.CascadeModeEnum.exSplitFixCascadeMode;
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exSplitBar,Color.FromArgb(196,196,196));
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exSplitBarSize,Color.FromArgb(4,0,0));
excascadetree1.DataSource = "Source=C:\\Program Files\\Exontrol\\ExCascadeTree\\Sample\\Access\\cities.accdb;Member=Select * FROM Countries;Key=CountryCode;" +
"Tag=Country;Name=CountryName >>> Member=Select * FROM States WHERE CountryCode IN (<%Parent.CountryCode%>);Key=StateCode;Name=St" +
"ateName;Tag=State ||| Member=Select * FROM Cities WHERE CountryCode IN (<%Parent.CountryCode%>);Tag=City;Name=Name >>> Member=Se" +
"lect * FROM Cities WHERE CountryCode IN (<%Parent.Parent.CountryCode%>) AND StateCode IN (<%Parent.StateCode%>);Tag=City;Name=Na" +
"me";
excascadetree1.Select = "US\\AK";
excascadetree1.EndUpdate();
|
|
50
|
How can I add a check-box column (view)
// Error event - An internal error occurs.
private void excascadetree1_Error(object sender,int Err,string Description)
{
System.Diagnostics.Debug.Print( "Error" );
System.Diagnostics.Debug.Print( Description.ToString() );
}
//this.excascadetree1.Error += new exontrol.EXCASCADETREELib.exg2antt.ErrorEventHandler(this.excascadetree1_Error);
excascadetree1.BeginUpdate();
excascadetree1.StatusBarVisible = exontrol.EXCASCADETREELib.StatusBarAnchorEnum.exStatusBarAnchorTop;
excascadetree1.StatusBarLabel = "<c>Select multiple-items in the City view, and press <b>SPACE</b> key";
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exStatusBackColor,excascadetree1.BackColor);
excascadetree1.VisualAppearance.Add(1,"gBFLBCJwBAEHhEJAAEhABO0GACAADACAxRDgMQBQKAAzAJBIYhiG4cYCgMYxXDOCYXABCEYRXBKUQSDqEYyjGLIXAWCYSAAMIwDKAUEhqGiUBihaQhRgyJI3RlJGaoD" +
"iKIokShKEpDLKlCx3H6OKQjOZgAoySo4SbDMp0NAkRBlFqcJCCCLAUgmTpQUBOYyiLKNRxQGoYLIlayZIiSIpMRbWcB3BYEOSFFasAAleYZTg2Jp1TbPAAYFL1ISDKSi" +
"IZqTA6PheT5yUzCNazbgEMTvRKqcSnO6bOgnEKQZKAGg4bg1RTVAYZLKtPR7aqyUJvZ5sMB6DiuLYRPKXZoucaNExSS5ebJtOzQJbEXBpXSpBwzSieBozIaQcJUOoaVx" +
"PFkaJrGuIx3h2BZPgOUIQmUcIwDARAkiAaQxh0DonCMLAeBKZobBCCY+niWJaBIKJJH4MoBgiQpCmmUR/ooBgCgCYBIBYBoBmCBYAn+ApgkgNgOgOYQIEYBIEGESBWBS" +
"BJhGgZgZgYIYoHYEIHCGaIGAuCAiCgegkgkYYoh4KIFiKKIuBeAJimiGgwgwYoYk4NILCCGJmDqDpjkidg+gGTo1jUAxAEAgI");
excascadetree1.SelBackColor32 = 0x1000000;
excascadetree1.SelForeColor = excascadetree1.ForeColor;
excascadetree1.Mode = exontrol.EXCASCADETREELib.CascadeModeEnum.exSplitFixCascadeMode;
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exSplitBar,Color.FromArgb(196,196,196));
excascadetree1.DataSource = "Source=C:\\Program Files\\Exontrol\\ExCascadeTree\\Sample\\Access\\cities.accdb;Member=Select * FROM Countries;Key=CountryCode;" +
"Tag=Country;Name=CountryName >>> Member=Select * FROM States WHERE CountryCode IN (<%Parent.CountryCode%>);Key=StateCode;Name=St" +
"ateName;Tag=State ||| Member=Select * FROM Cities WHERE CountryCode IN (<%Parent.CountryCode%>);Tag=City;Name=Name >>> Member=Se" +
"lect * FROM Cities WHERE CountryCode IN (<%Parent.Parent.CountryCode%>) AND StateCode IN (<%Parent.StateCode%>);Tag=City;Name=Na" +
"me";
excascadetree1.Select = "US\\AK";
exontrol.EXCASCADETREELib.View var_View = excascadetree1.get_DefaultView(null).get_View("City");
var_View.BeginUpdate();
var_View.ShowFocusRect = false;
var_View.SingleSel = false;
var_View.Columns[0].Visible = false;
var_View.Columns[1].Visible = false;
exontrol.EXCASCADETREELib.Column var_Column = var_View.Columns[2];
var_Column.HTMLCaption = "City <off 4><fgcolor=808080>Name";
var_Column.Width = 128;
var_Column.set_Def(exontrol.EXCASCADETREELib.DefColumnEnum.exCellHasCheckBox,true);
var_View.SearchColumnIndex = var_View.Columns["Name"].Index;
exontrol.EXCASCADETREELib.Column var_Column1 = (var_View.Columns.Add("Pos") as exontrol.EXCASCADETREELib.Column);
var_Column1.Position = 0;
var_Column1.Width = 32;
var_Column1.FormatColumn = "1 pos ``";
exontrol.EXCASCADETREELib.ConditionalFormats var_ConditionalFormats = var_View.ConditionalFormats;
var_ConditionalFormats.Add("%CS2 = 1",null).BackColor = Color.FromArgb(190,190,190);
exontrol.EXCASCADETREELib.ConditionalFormat var_ConditionalFormat = var_ConditionalFormats.Add("%CS2 = 1",null);
var_ConditionalFormat.Bold = true;
var_ConditionalFormat.ApplyTo = (exontrol.EXCASCADETREELib.FormatApplyToEnum)0x8;
exontrol.EXCASCADETREELib.Items var_Items = var_View.Items;
var_Items.set_CellState(var_Items[1],2,1);
var_Items.set_CellState(var_Items[3],2,1);
var_Items.set_CellState(var_Items[5],2,1);
var_View.EndUpdate();
excascadetree1.EndUpdate();
|
|
49
|
How can I add a check-box column
// CreateView event - A view has been created.
private void excascadetree1_CreateView(object sender,exontrol.EXCASCADETREELib.View View)
{
exontrol.EXCASCADETREELib.View var_View = excascadetree1.View;
var_View.HeaderAppearance = exontrol.EXCASCADETREELib.AppearanceEnum.Etched;
var_View.HeaderHeight = 24;
var_View.DrawGridLines = exontrol.EXCASCADETREELib.GridLinesEnum.exVLines;
var_View.GridLineStyle = exontrol.EXCASCADETREELib.GridLinesStyleEnum.exGridLinesDash;
exontrol.EXCASCADETREELib.View var_View1 = excascadetree1.get_DefaultView(null);
exontrol.EXCASCADETREELib.View var_View2 = var_View1.get_View("Country");
var_View2.BeginUpdate();
var_View2.ColumnAutoResize = true;
var_View2.Columns[0].Visible = false;
var_View2.Columns[1].HTMLCaption = "Country <off 4><fgcolor=808080>Name";
var_View2.EndUpdate();
exontrol.EXCASCADETREELib.View var_View3 = var_View1.get_View("State");
var_View3.BeginUpdate();
var_View3.ColumnAutoResize = true;
var_View3.Columns[0].Visible = false;
var_View3.Columns[1].Visible = false;
var_View3.Columns[2].HTMLCaption = "State <off 4><fgcolor=808080>Name";
var_View3.EndUpdate();
exontrol.EXCASCADETREELib.View var_View4 = var_View1.get_View("City");
var_View4.BeginUpdate();
var_View4.ShowFocusRect = false;
var_View4.SingleSel = false;
var_View4.Columns[0].Visible = false;
var_View4.Columns[1].Visible = false;
exontrol.EXCASCADETREELib.Column var_Column = var_View4.Columns[2];
var_Column.HTMLCaption = "City <off 4><fgcolor=808080>Name";
var_Column.Width = 128;
var_Column.set_Def(exontrol.EXCASCADETREELib.DefColumnEnum.exCellHasCheckBox,true);
var_View4.SearchColumnIndex = var_View4.Columns["Name"].Index;
exontrol.EXCASCADETREELib.Column var_Column1 = (var_View4.Columns.Add("Pos") as exontrol.EXCASCADETREELib.Column);
var_Column1.Position = 0;
var_Column1.Width = 32;
var_Column1.FormatColumn = "1 pos ``";
exontrol.EXCASCADETREELib.ConditionalFormats var_ConditionalFormats = var_View4.ConditionalFormats;
var_ConditionalFormats.Add("%CS2 = 1",null).BackColor = Color.FromArgb(190,190,190);
exontrol.EXCASCADETREELib.ConditionalFormat var_ConditionalFormat = var_ConditionalFormats.Add("%CS2 = 1",null);
var_ConditionalFormat.Bold = true;
var_ConditionalFormat.ApplyTo = (exontrol.EXCASCADETREELib.FormatApplyToEnum)0x8;
exontrol.EXCASCADETREELib.Items var_Items = var_View4.Items;
var_Items.set_CellState(var_Items[1],2,1);
var_Items.set_CellState(var_Items[3],2,1);
var_Items.set_CellState(var_Items[5],2,1);
var_View4.EndUpdate();
}
//this.excascadetree1.CreateView += new exontrol.EXCASCADETREELib.exg2antt.CreateViewEventHandler(this.excascadetree1_CreateView);
// Error event - An internal error occurs.
private void excascadetree1_Error(object sender,int Err,string Description)
{
System.Diagnostics.Debug.Print( "Error" );
System.Diagnostics.Debug.Print( Description.ToString() );
}
//this.excascadetree1.Error += new exontrol.EXCASCADETREELib.exg2antt.ErrorEventHandler(this.excascadetree1_Error);
excascadetree1.BeginUpdate();
excascadetree1.StatusBarVisible = exontrol.EXCASCADETREELib.StatusBarAnchorEnum.exStatusBarAnchorTop;
excascadetree1.StatusBarLabel = "<c>Select multiple-items in the City view, and press <b>SPACE</b> key";
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exStatusBackColor,excascadetree1.BackColor);
excascadetree1.VisualAppearance.Add(1,"gBFLBCJwBAEHhEJAAEhABO0GACAADACAxRDgMQBQKAAzAJBIYhiG4cYCgMYxXDOCYXABCEYRXBKUQSDqEYyjGLIXAWCYSAAMIwDKAUEhqGiUBihaQhRgyJI3RlJGaoD" +
"iKIokShKEpDLKlCx3H6OKQjOZgAoySo4SbDMp0NAkRBlFqcJCCCLAUgmTpQUBOYyiLKNRxQGoYLIlayZIiSIpMRbWcB3BYEOSFFasAAleYZTg2Jp1TbPAAYFL1ISDKSi" +
"IZqTA6PheT5yUzCNazbgEMTvRKqcSnO6bOgnEKQZKAGg4bg1RTVAYZLKtPR7aqyUJvZ5sMB6DiuLYRPKXZoucaNExSS5ebJtOzQJbEXBpXSpBwzSieBozIaQcJUOoaVx" +
"PFkaJrGuIx3h2BZPgOUIQmUcIwDARAkiAaQxh0DonCMLAeBKZobBCCY+niWJaBIKJJH4MoBgiQpCmmUR/ooBgCgCYBIBYBoBmCBYAn+ApgkgNgOgOYQIEYBIEGESBWBS" +
"BJhGgZgZgYIYoHYEIHCGaIGAuCAiCgegkgkYYoh4KIFiKKIuBeAJimiGgwgwYoYk4NILCCGJmDqDpjkidg+gGTo1jUAxAEAgI");
excascadetree1.SelBackColor32 = 0x1000000;
excascadetree1.SelForeColor = excascadetree1.ForeColor;
excascadetree1.Mode = exontrol.EXCASCADETREELib.CascadeModeEnum.exSplitFixCascadeMode;
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exSplitBar,Color.FromArgb(196,196,196));
excascadetree1.DataSource = "Source=C:\\Program Files\\Exontrol\\ExCascadeTree\\Sample\\Access\\cities.accdb;Member=Select * FROM Countries;Key=CountryCode;" +
"Tag=Country;Name=CountryName >>> Member=Select * FROM States WHERE CountryCode IN (<%Parent.CountryCode%>);Key=StateCode;Name=St" +
"ateName;Tag=State ||| Member=Select * FROM Cities WHERE CountryCode IN (<%Parent.CountryCode%>);Tag=City;Name=Name >>> Member=Se" +
"lect * FROM Cities WHERE CountryCode IN (<%Parent.Parent.CountryCode%>) AND StateCode IN (<%Parent.StateCode%>);Tag=City;Name=Na" +
"me";
excascadetree1.Select = "US\\AK";
excascadetree1.EndUpdate();
|
|
48
|
How can I access a view
// CreateView event - A view has been created.
private void excascadetree1_CreateView(object sender,exontrol.EXCASCADETREELib.View View)
{
exontrol.EXCASCADETREELib.View var_View = excascadetree1.View;
var_View.HeaderAppearance = exontrol.EXCASCADETREELib.AppearanceEnum.Etched;
var_View.HeaderHeight = 24;
var_View.DrawGridLines = exontrol.EXCASCADETREELib.GridLinesEnum.exAllLines;
var_View.GridLineStyle = exontrol.EXCASCADETREELib.GridLinesStyleEnum.exGridLinesDash;
exontrol.EXCASCADETREELib.View var_View1 = excascadetree1.get_DefaultView(null);
exontrol.EXCASCADETREELib.View var_View2 = var_View1.get_View("Country");
var_View2.BeginUpdate();
var_View2.ColumnAutoResize = true;
var_View2.Columns[0].Visible = false;
var_View2.Columns[1].HTMLCaption = "Country <off 4><fgcolor=808080>Name";
var_View2.EndUpdate();
exontrol.EXCASCADETREELib.View var_View3 = var_View1.get_View("State");
var_View3.BeginUpdate();
var_View3.ColumnAutoResize = true;
var_View3.Columns[0].Visible = false;
var_View3.Columns[1].Visible = false;
var_View3.Columns[2].HTMLCaption = "State <off 4><fgcolor=808080>Name";
var_View3.EndUpdate();
exontrol.EXCASCADETREELib.View var_View4 = var_View1.get_View("City");
var_View4.BeginUpdate();
var_View4.Columns[0].Visible = false;
var_View4.Columns[1].Visible = false;
exontrol.EXCASCADETREELib.Column var_Column = var_View4.Columns[2];
var_Column.HTMLCaption = "City <off 4><fgcolor=808080>Name";
var_Column.Width = 128;
var_Column.set_Def(exontrol.EXCASCADETREELib.DefColumnEnum.exCellBackColor,15790320);
var_View4.CountLockedColumns = 1;
var_View4.EndUpdate();
}
//this.excascadetree1.CreateView += new exontrol.EXCASCADETREELib.exg2antt.CreateViewEventHandler(this.excascadetree1_CreateView);
// Error event - An internal error occurs.
private void excascadetree1_Error(object sender,int Err,string Description)
{
System.Diagnostics.Debug.Print( "Error" );
System.Diagnostics.Debug.Print( Description.ToString() );
}
//this.excascadetree1.Error += new exontrol.EXCASCADETREELib.exg2antt.ErrorEventHandler(this.excascadetree1_Error);
excascadetree1.BeginUpdate();
excascadetree1.Mode = exontrol.EXCASCADETREELib.CascadeModeEnum.exSplitFixCascadeMode;
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exSplitBar,Color.FromArgb(196,196,196));
excascadetree1.DataSource = "Source=C:\\Program Files\\Exontrol\\ExCascadeTree\\Sample\\Access\\cities.accdb;Member=Select * FROM Countries;Key=CountryCode;" +
"Tag=Country;Name=CountryName >>> Member=Select * FROM States WHERE CountryCode IN (<%Parent.CountryCode%>);Key=StateCode;Name=St" +
"ateName;Tag=State ||| Member=Select * FROM Cities WHERE CountryCode IN (<%Parent.CountryCode%>);Tag=City;Name=Name >>> Member=Se" +
"lect * FROM Cities WHERE CountryCode IN (<%Parent.Parent.CountryCode%>) AND StateCode IN (<%Parent.StateCode%>);Tag=City;Name=Na" +
"me";
excascadetree1.Select = "US\\AK";
excascadetree1.EndUpdate();
|
|
47
|
Conditional Format (check)
// CreateView event - A view has been created.
private void excascadetree1_CreateView(object sender,exontrol.EXCASCADETREELib.View View)
{
exontrol.EXCASCADETREELib.View var_View = excascadetree1.View;
exontrol.EXCASCADETREELib.ConditionalFormat var_ConditionalFormat = var_View.ConditionalFormats.Add("%CS0 = 1",null);
var_ConditionalFormat.Bold = true;
var_View.Columns[0].set_Def(exontrol.EXCASCADETREELib.DefColumnEnum.exCellHasCheckBox,true);
exontrol.EXCASCADETREELib.Items var_Items = var_View.Items;
var_Items.set_CellState(var_Items.FocusItem,0,1);
}
//this.excascadetree1.CreateView += new exontrol.EXCASCADETREELib.exg2antt.CreateViewEventHandler(this.excascadetree1_CreateView);
// Error event - An internal error occurs.
private void excascadetree1_Error(object sender,int Err,string Description)
{
System.Diagnostics.Debug.Print( "Error" );
System.Diagnostics.Debug.Print( Description.ToString() );
}
//this.excascadetree1.Error += new exontrol.EXCASCADETREELib.exg2antt.ErrorEventHandler(this.excascadetree1_Error);
excascadetree1.BeginUpdate();
excascadetree1.Mode = exontrol.EXCASCADETREELib.CascadeModeEnum.exSplitFixCascadeMode;
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exSplitBar,Color.FromArgb(196,196,196));
excascadetree1.DataSource = "Source=C:\\Program Files\\Exontrol\\ExCascadeTree\\Sample\\Access\\cities.accdb;Member=Select * FROM Countries;Key=CountryCode;" +
"Tag=Country;Name=CountryName >>> Member=Select * FROM States WHERE CountryCode IN (<%Parent.CountryCode%>);Key=StateCode;Name=St" +
"ateName;Tag=State ||| Member=Select * FROM Cities WHERE CountryCode IN (<%Parent.CountryCode%>);Tag=City;Name=Name >>> Member=Se" +
"lect * FROM Cities WHERE CountryCode IN (<%Parent.Parent.CountryCode%>) AND StateCode IN (<%Parent.StateCode%>);Tag=City;Name=Na" +
"me";
excascadetree1.Select = "US\\AK";
excascadetree1.EndUpdate();
|
|
46
|
Conditional Format (view)
// Error event - An internal error occurs.
private void excascadetree1_Error(object sender,int Err,string Description)
{
System.Diagnostics.Debug.Print( "Error" );
System.Diagnostics.Debug.Print( Description.ToString() );
}
//this.excascadetree1.Error += new exontrol.EXCASCADETREELib.exg2antt.ErrorEventHandler(this.excascadetree1_Error);
excascadetree1.BeginUpdate();
excascadetree1.Mode = exontrol.EXCASCADETREELib.CascadeModeEnum.exSplitFixCascadeMode;
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exSplitBar,Color.FromArgb(196,196,196));
excascadetree1.DataSource = "Source=C:\\Program Files\\Exontrol\\ExCascadeTree\\Sample\\Access\\cities.accdb;Member=Select * FROM Countries;Key=CountryCode;" +
"Tag=Country;Name=CountryName >>> Member=Select * FROM States WHERE CountryCode IN (<%Parent.CountryCode%>);Key=StateCode;Name=St" +
"ateName;Tag=State ||| Member=Select * FROM Cities WHERE CountryCode IN (<%Parent.CountryCode%>);Tag=City;Name=Name >>> Member=Se" +
"lect * FROM Cities WHERE CountryCode IN (<%Parent.Parent.CountryCode%>) AND StateCode IN (<%Parent.StateCode%>);Tag=City;Name=Na" +
"me";
excascadetree1.Select = "US\\AK";
exontrol.EXCASCADETREELib.View var_View = excascadetree1.get_DefaultView(null).get_View("City");
exontrol.EXCASCADETREELib.ConditionalFormat var_ConditionalFormat = var_View.ConditionalFormats.Add("(%0 = `US`) and (%2 like `Al*`)",null);
var_ConditionalFormat.Bold = true;
var_ConditionalFormat.BackColor = Color.FromArgb(240,240,240);
excascadetree1.EndUpdate();
|
|
45
|
Conditional Format
// CreateView event - A view has been created.
private void excascadetree1_CreateView(object sender,exontrol.EXCASCADETREELib.View View)
{
exontrol.EXCASCADETREELib.View var_View = excascadetree1.View;
exontrol.EXCASCADETREELib.ConditionalFormat var_ConditionalFormat = var_View.ConditionalFormats.Add("%0 = `US`",null);
var_ConditionalFormat.Bold = true;
}
//this.excascadetree1.CreateView += new exontrol.EXCASCADETREELib.exg2antt.CreateViewEventHandler(this.excascadetree1_CreateView);
// Error event - An internal error occurs.
private void excascadetree1_Error(object sender,int Err,string Description)
{
System.Diagnostics.Debug.Print( "Error" );
System.Diagnostics.Debug.Print( Description.ToString() );
}
//this.excascadetree1.Error += new exontrol.EXCASCADETREELib.exg2antt.ErrorEventHandler(this.excascadetree1_Error);
excascadetree1.BeginUpdate();
excascadetree1.Mode = exontrol.EXCASCADETREELib.CascadeModeEnum.exSplitFixCascadeMode;
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exSplitBar,Color.FromArgb(196,196,196));
excascadetree1.DataSource = "Source=C:\\Program Files\\Exontrol\\ExCascadeTree\\Sample\\Access\\cities.accdb;Member=Select * FROM Countries;Key=CountryCode;" +
"Tag=Country;Name=CountryName >>> Member=Select * FROM States WHERE CountryCode IN (<%Parent.CountryCode%>);Key=StateCode;Name=St" +
"ateName;Tag=State ||| Member=Select * FROM Cities WHERE CountryCode IN (<%Parent.CountryCode%>);Tag=City;Name=Name >>> Member=Se" +
"lect * FROM Cities WHERE CountryCode IN (<%Parent.Parent.CountryCode%>) AND StateCode IN (<%Parent.StateCode%>);Tag=City;Name=Na" +
"me";
excascadetree1.Select = "US\\AK";
excascadetree1.EndUpdate();
|
|
44
|
I've seen the AllowSplitView property, the question is how can I load data to
// Error event - An internal error occurs.
private void excascadetree1_Error(object sender,int Err,string Description)
{
System.Diagnostics.Debug.Print( "Error" );
System.Diagnostics.Debug.Print( Description.ToString() );
}
//this.excascadetree1.Error += new exontrol.EXCASCADETREELib.exg2antt.ErrorEventHandler(this.excascadetree1_Error);
excascadetree1.BeginUpdate();
excascadetree1.Mode = exontrol.EXCASCADETREELib.CascadeModeEnum.exSplitFixCascadeMode;
excascadetree1.DataSource = "Source=C:\\Program Files\\Exontrol\\ExCascadeTree\\Sample\\Access\\cities.accdb;Member=Select * FROM Countries;Key=CountryCode;" +
"Tag=Country;Name=CountryName >>> Member=Select * FROM States WHERE CountryCode IN (<%Parent.CountryCode%>);Key=StateCode;Name=St" +
"ateName;Tag=State ||| Member=Select * FROM Cities WHERE CountryCode IN (<%Parent.CountryCode%>);Tag=City;Name=Name >>> Member=Se" +
"lect * FROM Cities WHERE CountryCode IN (<%Parent.Parent.CountryCode%>) AND StateCode IN (<%Parent.StateCode%>);Tag=City;Name=Na" +
"me";
excascadetree1.Select = "US\\AK";
excascadetree1.AllowSplitView = exontrol.EXCASCADETREELib.AllowSplitViewEnum.exAllowOneSplitView;
excascadetree1.SplitViewHeight = 256.ToString();
Object var_Object = (excascadetree1.get_DefaultView(1) as Object);
excascadetree1.EndUpdate();
|
|
43
|
How can I group the items (view)
// CreateView event - A view has been created.
private void excascadetree1_CreateView(object sender,exontrol.EXCASCADETREELib.View View)
{
excascadetree1.View.SingleSel = false;
}
//this.excascadetree1.CreateView += new exontrol.EXCASCADETREELib.exg2antt.CreateViewEventHandler(this.excascadetree1_CreateView);
// Error event - An internal error occurs.
private void excascadetree1_Error(object sender,int Err,string Description)
{
System.Diagnostics.Debug.Print( "Error" );
System.Diagnostics.Debug.Print( Description.ToString() );
}
//this.excascadetree1.Error += new exontrol.EXCASCADETREELib.exg2antt.ErrorEventHandler(this.excascadetree1_Error);
excascadetree1.BeginUpdate();
exontrol.EXCASCADETREELib.Appearance var_Appearance = excascadetree1.VisualAppearance;
var_Appearance.Add(1,"gBFLBCJwBAEHhEJAAEhABa0GACAADACAxRDgMQBQKAAzAJBIYhiG4cYCgMYxXDOCYXABCEYRXBIZQ7BKNIxjSJwFgkAoJDYOMjwlDKEgADDFEgjJBkRxtDCPIDnGQoD" +
"iGI4vSrCQ4yDA8GxCGSfIrjKiYbiGNY8RgZCiOMAFJSpC6gZRoSq4doGGJLQiDMaAdBNHyZKqpbQqeCZPDINQlWzbcrjKKFYQTOi7I4sCbYcqKA5PTbNdYyVBMWxfGIb" +
"aIkXAcBjuO4hWbFdASRQdDYtHTIbzjCxLcgMD4gRwWCYNSAGRZJLDKK4gSh6eorHQAX4AGabFBOP5fC7TNJ0OKLRrkAJub5eFx3LJ97ohbLsOzYZK2ByDFqiMLGQZMZx" +
"vGWUBAnYfJImcOwLEiBp0gaGpekSBxjE+WZ2jse5Im2S5ZkGYhdn4EY6A4Q4vAOWJ6H0V4oEgIgSFAGhGDGUB1ByBhVBUAwyhKMQIE2AgRjCWQJAoEIWk2SxCAGBBghQ" +
"eJYkMZIYBYIYoHIG4HGICB+CKB4iEiBglgaUAzhiJAZA+Q4Qk2CxiniOgwgyYwolYMYNmMQw2CoGQihiLg5g+YxpAIOINiOOJ2CyEBkgkDhKhCJBQAI2IlAkJhMgqZBp" +
"EYS4UiSGQ2E+FglHkdg5haI5pHIVoViYCQeF6vZJhYY4aCWWYqGyGpkimOhnhyZQ4nIToYGcSY+ESFQnHmGhwh+YpphYO4gmKOlEiGKIKBaCohmeQ4tkUQJQBAgI=");
var_Appearance.Add(2,"gBFLBCJwBAEHhEJAAEhABO0GACAADACAxRDgMQBQKAAzAJBIYhiG4cYCgMYxXDOCYXABCEYRXBIZQ7BKNIxjSJwFgkAoJDYOMjwlDKEgADDFEgjDBkRxtDCPIDnGQoD" +
"iGI4vSrCQ4zHQkOx9C6NKLjOQaMhwcJPABTZwRRQMUyLAiQRioGKKJgkC4cAxIFhRXSVIyhC6XRiGURbJquLw1DBbEI3BaUOS7HqOK7vCZ7cACVYqQjLMrzCK8ZxLPqb" +
"ZznOjZXoCKJDQzVYADFRVd4rMK9QABWw4YqWZYXX7kUDxbTdEYzPQAMw1GCcbxmF6eWbCNq3LidXTnOK3dwkO55cyuA6oazi8T6Bi2M6DDQNGSzZiuGZ9YSOOIwHJIN4" +
"QDSUpYmQOoJA6KxVlCDBsnwOx9iWUhfiCThzjUHZun2WgSAiBIUA0JgziGVJkGWUZAkEUoyBEN51BsDYQhCIQJGqHAUCAGBGA0RwtDcVIgkgNgOgOYQIDiXYEmESBWBa" +
"BZhggTgSgYYZIHYGoDGGaIGBiBpiCiFJdgkIksiiChhliLgsgYYpoj4F4MGMKBWDSDRhngMg4gcIQYnYPoEE6N4ZAMQBAICA=");
excascadetree1.SelBackColor32 = 0x1000000;
excascadetree1.SelForeColor = Color.FromArgb(0,0,0);
excascadetree1.BackColorHeader32 = 0x2000000;
excascadetree1.set_ScrollPartVisible(exontrol.EXCASCADETREELib.ScrollBarEnum.exVScroll,exontrol.EXCASCADETREELib.ScrollPartEnum.exExtentThumbPart,true);
excascadetree1.set_ScrollPartVisible(exontrol.EXCASCADETREELib.ScrollBarEnum.exHScroll,exontrol.EXCASCADETREELib.ScrollPartEnum.exExtentThumbPart,true);
excascadetree1.set_ScrollPartVisible(exontrol.EXCASCADETREELib.ScrollBarEnum.exScroll,exontrol.EXCASCADETREELib.ScrollPartEnum.exExtentThumbPart,true);
excascadetree1.ScrollWidth = 4;
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exVSBack,Color.FromArgb(240,240,240));
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exVSThumb,Color.FromArgb(128,128,128));
excascadetree1.ScrollHeight = 4;
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exHSBack,excascadetree1.get_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exVSBack));
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exHSThumb,excascadetree1.get_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exVSThumb));
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exScrollSizeGrip,excascadetree1.get_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exVSBack));
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exSplitBar,Color.FromArgb(196,196,196));
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exCSplitBar,excascadetree1.get_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exSplitBar));
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exHSplitBar,excascadetree1.get_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exSplitBar));
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exSplitBarSize,Color.FromArgb(2,0,0));
excascadetree1.BackColorSortBar = excascadetree1.BackColor;
excascadetree1.EndUpdate();
excascadetree1.BeginUpdate();
excascadetree1.Mode = exontrol.EXCASCADETREELib.CascadeModeEnum.exSplitFixCascadeMode;
excascadetree1.DataSource = "Source=C:\\Program Files\\Exontrol\\ExCascadeTree\\Sample\\Access\\cities.accdb;Member=Select * FROM Countries;Key=CountryCode;" +
"Tag=Country;Name=CountryName >>> Member=Select * FROM States WHERE CountryCode IN (<%Parent.CountryCode%>);Key=StateCode;Name=St" +
"ateName;Tag=State ||| Member=Select * FROM Cities WHERE CountryCode IN (<%Parent.CountryCode%>);Tag=City;Name=Name >>> Member=Se" +
"lect * FROM Cities WHERE CountryCode IN (<%Parent.Parent.CountryCode%>) AND StateCode IN (<%Parent.StateCode%>);Tag=City;Name=Na" +
"me";
excascadetree1.Select = "RO\\CJ|BV|CS";
exontrol.EXCASCADETREELib.View var_View = excascadetree1.get_DefaultView(null).get_View("City");
var_View.BeginUpdate();
exontrol.EXCASCADETREELib.Columns var_Columns = var_View.Columns;
var_Columns["CountryCode"].Visible = false;
exontrol.EXCASCADETREELib.Column var_Column = var_Columns["Name"];
var_Column.SortOrder = exontrol.EXCASCADETREELib.SortOrderEnum.SortAscending;
var_Column.Width = 128;
var_View.SortBarVisible = true;
var_View.AllowGroupBy = true;
var_View.SingleSort = false;
var_View.Columns["StateCode"].SortOrder = exontrol.EXCASCADETREELib.SortOrderEnum.SortAscending;
var_View.TreeColumnIndex = var_View.Columns["Name"].Index;
var_View.EndUpdate();
excascadetree1.EndUpdate();
|
|
42
|
How can I group the items
// CreateView event - A view has been created.
private void excascadetree1_CreateView(object sender,exontrol.EXCASCADETREELib.View View)
{
// Columns("StateCode").Visible = False
// Columns("StateName").SortOrder = 1
// Columns("StateCode").SortOrder = nGroupByIfCity
object nGroupByIfCity = excascadetree1.FormatABC("( A = `City`) ? 1 : 0",excascadetree1.View.Tag,null,null);
object bColumnAutoResize = excascadetree1.FormatABC(" (A = `City`) ? 0 : -1",excascadetree1.View.Tag,null,null);
exontrol.EXCASCADETREELib.View var_View = excascadetree1.View;
var_View.BeginUpdate();
var_View.SingleSel = false;
var_View.Columns["CountryCode"].Visible = false;
var_View.Columns["CountryName"].SortOrder = exontrol.EXCASCADETREELib.SortOrderEnum.SortAscending;
Object var_Object = var_View.Columns[2];
var_View.TreeColumnIndex = 2;
var_View.AllowGroupBy = true;
var_View.SingleSort = false;
var_View.SortBarVisible = false;
var_View.ColumnAutoResize = false;
var_View.EndUpdate();
}
//this.excascadetree1.CreateView += new exontrol.EXCASCADETREELib.exg2antt.CreateViewEventHandler(this.excascadetree1_CreateView);
// Error event - An internal error occurs.
private void excascadetree1_Error(object sender,int Err,string Description)
{
System.Diagnostics.Debug.Print( "Error" );
System.Diagnostics.Debug.Print( Description.ToString() );
}
//this.excascadetree1.Error += new exontrol.EXCASCADETREELib.exg2antt.ErrorEventHandler(this.excascadetree1_Error);
excascadetree1.BeginUpdate();
exontrol.EXCASCADETREELib.Appearance var_Appearance = excascadetree1.VisualAppearance;
var_Appearance.Add(1,"gBFLBCJwBAEHhEJAAEhABa0GACAADACAxRDgMQBQKAAzAJBIYhiG4cYCgMYxXDOCYXABCEYRXBIZQ7BKNIxjSJwFgkAoJDYOMjwlDKEgADDFEgjJBkRxtDCPIDnGQoD" +
"iGI4vSrCQ4yDA8GxCGSfIrjKiYbiGNY8RgZCiOMAFJSpC6gZRoSq4doGGJLQiDMaAdBNHyZKqpbQqeCZPDINQlWzbcrjKKFYQTOi7I4sCbYcqKA5PTbNdYyVBMWxfGIb" +
"aIkXAcBjuO4hWbFdASRQdDYtHTIbzjCxLcgMD4gRwWCYNSAGRZJLDKK4gSh6eorHQAX4AGabFBOP5fC7TNJ0OKLRrkAJub5eFx3LJ97ohbLsOzYZK2ByDFqiMLGQZMZx" +
"vGWUBAnYfJImcOwLEiBp0gaGpekSBxjE+WZ2jse5Im2S5ZkGYhdn4EY6A4Q4vAOWJ6H0V4oEgIgSFAGhGDGUB1ByBhVBUAwyhKMQIE2AgRjCWQJAoEIWk2SxCAGBBghQ" +
"eJYkMZIYBYIYoHIG4HGICB+CKB4iEiBglgaUAzhiJAZA+Q4Qk2CxiniOgwgyYwolYMYNmMQw2CoGQihiLg5g+YxpAIOINiOOJ2CyEBkgkDhKhCJBQAI2IlAkJhMgqZBp" +
"EYS4UiSGQ2E+FglHkdg5haI5pHIVoViYCQeF6vZJhYY4aCWWYqGyGpkimOhnhyZQ4nIToYGcSY+ESFQnHmGhwh+YpphYO4gmKOlEiGKIKBaCohmeQ4tkUQJQBAgI=");
var_Appearance.Add(2,"gBFLBCJwBAEHhEJAAEhABO0GACAADACAxRDgMQBQKAAzAJBIYhiG4cYCgMYxXDOCYXABCEYRXBIZQ7BKNIxjSJwFgkAoJDYOMjwlDKEgADDFEgjDBkRxtDCPIDnGQoD" +
"iGI4vSrCQ4zHQkOx9C6NKLjOQaMhwcJPABTZwRRQMUyLAiQRioGKKJgkC4cAxIFhRXSVIyhC6XRiGURbJquLw1DBbEI3BaUOS7HqOK7vCZ7cACVYqQjLMrzCK8ZxLPqb" +
"ZznOjZXoCKJDQzVYADFRVd4rMK9QABWw4YqWZYXX7kUDxbTdEYzPQAMw1GCcbxmF6eWbCNq3LidXTnOK3dwkO55cyuA6oazi8T6Bi2M6DDQNGSzZiuGZ9YSOOIwHJIN4" +
"QDSUpYmQOoJA6KxVlCDBsnwOx9iWUhfiCThzjUHZun2WgSAiBIUA0JgziGVJkGWUZAkEUoyBEN51BsDYQhCIQJGqHAUCAGBGA0RwtDcVIgkgNgOgOYQIDiXYEmESBWBa" +
"BZhggTgSgYYZIHYGoDGGaIGBiBpiCiFJdgkIksiiChhliLgsgYYpoj4F4MGMKBWDSDRhngMg4gcIQYnYPoEE6N4ZAMQBAICA=");
excascadetree1.SelBackColor32 = 0x1000000;
excascadetree1.SelForeColor = Color.FromArgb(0,0,0);
excascadetree1.BackColorHeader32 = 0x2000000;
excascadetree1.set_ScrollPartVisible(exontrol.EXCASCADETREELib.ScrollBarEnum.exVScroll,exontrol.EXCASCADETREELib.ScrollPartEnum.exExtentThumbPart,true);
excascadetree1.set_ScrollPartVisible(exontrol.EXCASCADETREELib.ScrollBarEnum.exHScroll,exontrol.EXCASCADETREELib.ScrollPartEnum.exExtentThumbPart,true);
excascadetree1.set_ScrollPartVisible(exontrol.EXCASCADETREELib.ScrollBarEnum.exScroll,exontrol.EXCASCADETREELib.ScrollPartEnum.exExtentThumbPart,true);
excascadetree1.ScrollWidth = 4;
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exVSBack,Color.FromArgb(240,240,240));
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exVSThumb,Color.FromArgb(128,128,128));
excascadetree1.ScrollHeight = 4;
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exHSBack,excascadetree1.get_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exVSBack));
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exHSThumb,excascadetree1.get_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exVSThumb));
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exScrollSizeGrip,excascadetree1.get_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exVSBack));
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exSplitBar,Color.FromArgb(196,196,196));
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exCSplitBar,excascadetree1.get_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exSplitBar));
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exHSplitBar,excascadetree1.get_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exSplitBar));
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exSplitBarSize,Color.FromArgb(2,0,0));
excascadetree1.BackColorSortBar = excascadetree1.BackColor;
excascadetree1.EndUpdate();
excascadetree1.BeginUpdate();
excascadetree1.Mode = exontrol.EXCASCADETREELib.CascadeModeEnum.exSplitFixCascadeMode;
excascadetree1.DataSource = "Source=C:\\Program Files\\Exontrol\\ExCascadeTree\\Sample\\Access\\cities.accdb;Member=Select * FROM Countries;Key=CountryCode;" +
"Tag=Country;Name=CountryName >>> Member=Select * FROM States WHERE CountryCode IN (<%Parent.CountryCode%>);Key=StateCode;Name=St" +
"ateName;Tag=State ||| Member=Select * FROM Cities WHERE CountryCode IN (<%Parent.CountryCode%>);Tag=City;Name=Name >>> Member=Se" +
"lect * FROM Cities WHERE CountryCode IN (<%Parent.Parent.CountryCode%>) AND StateCode IN (<%Parent.StateCode%>);Tag=City;Name=Na" +
"me";
excascadetree1.Select = "RO\\CJ|BV|CS";
excascadetree1.EndUpdate();
|
|
41
|
How can I change the visual appearance of the selection/header
// CreateView event - A view has been created.
private void excascadetree1_CreateView(object sender,exontrol.EXCASCADETREELib.View View)
{
// Columns("StateCode").Visible = False
// Columns("StateName").SortOrder = 1
exontrol.EXCASCADETREELib.View var_View = excascadetree1.View;
var_View.BeginUpdate();
var_View.ColumnAutoResize = true;
var_View.Columns["CountryCode"].Visible = false;
var_View.Columns["CountryName"].SortOrder = exontrol.EXCASCADETREELib.SortOrderEnum.SortAscending;
Object var_Object = var_View.Columns["Name"];
var_View.EndUpdate();
}
//this.excascadetree1.CreateView += new exontrol.EXCASCADETREELib.exg2antt.CreateViewEventHandler(this.excascadetree1_CreateView);
// Error event - An internal error occurs.
private void excascadetree1_Error(object sender,int Err,string Description)
{
System.Diagnostics.Debug.Print( "Error" );
System.Diagnostics.Debug.Print( Description.ToString() );
}
//this.excascadetree1.Error += new exontrol.EXCASCADETREELib.exg2antt.ErrorEventHandler(this.excascadetree1_Error);
excascadetree1.BeginUpdate();
exontrol.EXCASCADETREELib.Appearance var_Appearance = excascadetree1.VisualAppearance;
var_Appearance.Add(1,"gBFLBCJwBAEHhEJAAEhABWYDg6AADACAxRDgMQBQKAAzAJBIYhiG4cYCgMYxXDOCYXABCEYRXBIZQ7BKNIxjSJwFgmEgADCNAwgFBIcBhE4ZIKkEYoMiONoYR5Ac4yF" +
"AcQxHE6TZRgeDZToWN48TZLEB0VRFGL1J4AKbfKKKBiqIZDTpMdKSHIIFQ4BiEaYkGjqQpKVIdDSJMwWTI4ahhNSEbauCZ7DhyXpLUbeNSyXJsXw7GSOZJvGZ5bjuIY+" +
"RxQEK1NQkOyNOiOAosGCQWiDE4DWZZUT3XS+HgAGStY4rWCcSgOYIDZTPOT1DYtIY3NC5c7tS4bPq3NZHXTAeigBa4AZTQafcTvSA5OjOQQ2VhNWIXRxgAZ3YCNbzpTg" +
"sHeD5DmUQh3jSTQ/DuIZBh0bJ8BsG4WlsYwXjEapphuXh/HsRQJAQQhKAaEwZlCahyDKchJlEIgRDedQbA2EIQiECR3BudAgBgRgBgSHZQFSCwzECV4DGCeA6BCBJhCg" +
"VgRgWs4YkgNJKCOMJ2C0T4Dn4IIIiIGIOCaCRiy0HQ9iGIxMhgMAMmKZJ2D+SQThININgiM4In+DhPnIDJhD+RxzgCfwaE2c58F0N4PniSJ/guTJiCiOAygwCJODyDwI" +
"FifhVD+R5JBQcIREYOQgFgNwPnkRJ/qOIgIjEMYMFOVg9hESA5BQfYSCbQx1DcZA5lAXQ2vURh4hoT55hiRgfEqYwMkUPQPnGahgiGJwpmAdYeAaWZgGINoPnEWoQBKa" +
"QKAyf4gAwMZoisMIMGOTJ/B0KQK0EG5NhqDolBmKhRG6JQUX8GJYD+aZaBaGweAqEwEkYPNpDaL4u2kIJXi8a5xgKPwViucQuj8EBrnqXJ/i0DARlyJwwCyIYglaLxtD" +
"GDpVjSRY7EwUY0kQexMD+MhrgsOJAB2LJzCKOAZG0O4gn8GANFuLptBaLpREKUwRG0MJylOOYPnuEpjjOTIamAYo7G/QxfDUMAsBAWI7ESe40ZuQ5bjafY+GycZcigMB" +
"ODOZJ/CoTo8F8GZGDGI58iaRhKEwZIhkYSZ8GcFYQVeZIqDCThsFiMQ7g+fI8n8LAOlyTw1CuMxSjMNQqHMUojDWSxPnyKJDB8CpjBSag+iSE4/EmUpLh0KI2lKCxNCi" +
"Mvkg0KxHhYNBSACMQyA6c5wn8MJrg2Axflga4DAaOAviuApyjgLorg0dJ/laDICAyNQyg8LR47INxznzfI3jOPkS4NQMDzCoPgMQUBNqzFyJAco0ROLRFOPkVIEB4v7F" +
"WBAeT/xTB7E+OYR4MAzjzAMG8GIxgPj8CSJwIolxjCJTeB8cw7hIjVDqD0LwkA3BpAMNYFgbAxDGF8C0aYxw+gpA8GEeI/QgjJFeHcc4/xBjggePEYgfRPjnAOJAN4+Q" +
"DjHCiN0TQhBMiODWOkA4+RqjGH0P4W4sRjCdB4GkaIxhOD6HiM0V4ehfCRFcEsDIZhkjcD4J8PwQR/j3D8Acf43x8h+B+Jkf49RPh/CCLIVIEwTBxFsP8L4+x/CAAgA4" +
"AIQAsADACMoSA6wghEAYIAQBAQA==");
var_Appearance.Add(2,"gBFLBCJwBAEHhEJAAEhABEwFg6AADACAxRDgMQBQKAAzAJBIYhiG4cYCgMYxXDOCYXABCEYRXBIZQ7BKNIxjSJwFgkAoJDaMUjwlDiEgADCNAySCKkGRHG6MI6gOapC" +
"gOIYjS7KYASTIMDw7EIZJ7jSioboKNo9ABQT71GAFJr/DChKIhWiKIoKI4hAZHAIQTR8QylKirIwlcYhVCWa5tS82CzoJrKdI4WZHFgwHR8cRxLKVJQlaDZSoIMQ2STf" +
"V7TZLkQyZNSTJQpGq6HxWeIcETkMBlLIGNSrNCqIrwChach2XpLQjeYAZTAdR43TqBbLqeyYXq+dwAWxtdzXDacXy/TzWAA1LLMKr/EpZDhSxARVDbD4XY7TdBcDwsOY" +
"AmQcohjyXQ8G6QRkgSa41H0WY+luSx1l6eZ2noLYFEePwDlUdQ8HufRsCSIBpDGHQOicIwtBoBguGuBAhDWfxGkMZAkCgeAQhcEQiAYEYDmABx8hANRYmQMhKHMTItB+" +
"IRoGIF4GGEMoeBKBQhGGfRWgiYhIgYHYIE+c5Ym8P5OlMWgsguIpYj4KQ7mIExMi6CIVGOKJTD/OxyDuDxVDiWB/g2CAIgyZwzk+eQeEmEgkikBIuCADRJD4Iw5AyU5+" +
"FSFYlFkXRThQZQJEkVg4gyM5+GCGImBmDhbhOTRCj4RRVg4Ewkn+GxmnmOhwhaZopiYaxUk4Awgn+Hhnjmah8h0JQJioI4fCgSZ6HqIAnGoDoGh8aJKCCMAgGiKgygUV" +
"YNEoPoViQFRqE6E4WmkYpAgKJBpioHJ/iUSAqhKIIimeeoOh4NQLBIDoniSKgqjCA4szqYJoDcKxqmKN4uGkSo2oGKxam6Qoug2Sp0gRggiBaQYxCuGpyFuMhsgsKRTj" +
"MbA7DqI40AsIgakuNQsEoUpZYIOxqlONRsDoUphjgCB7G6ZIxGWMpMgeOgsBMbo2jyDoLlCW45i6cpSmmOJvGuTpziUL4jFCNAiC8G56nWP5ljwDJVC0CIcBcB5Dm8dR" +
"PZyTRSlcDY/DAa5ZFaRRxEKVIKkOL5blcG5Hg0UpYgsVYPhuVwpDaco87eSYyFyHRTkscoslcEQ/nMExYjYIwygyWw0k2c4iDCVgtkiXJ3CyT4yCUTxDCMdI9BsP5LjS" +
"LQTEMI40m0IxAd4YxYjgI51NsXhVjWIg8leVp1lzLJYnYIpkhCWRzG2HxqDWS4SEcbJXlUPZAhGXAJC2TxQD+O8AwuQ6i8HMGcIItRKDwD4BcBIsx3j7HiCcTw8BeBvA" +
"eLoS4RBMiwC6JITgZwEjLHgEoW4JglBzD4LcBozxNotBSM4eAPA7hBGiHMQo2QVjPDoWcU4yRJCmGCHgJYdRODHC4H8ewRGWhLHsL0H4XgvASHMMkPY3g6C9FuB4P4+A" +
"vAJD0EwO4vA1CtHCBMDwEQZjmHwP4SIsgvh6D8C8II6h9geFyDUdQcwVCfF4G0C4xBvjBG2PwQg2RaBfH4MoTI9Rgh9HMNccY+BVDfC+NQL4kxFC3HOPgP4nwjjwBsIY" +
"AAnQ/hPHqP0XwiABgABABMdwgBHj1H0MACItgYAEHoAMPwUAWjbGAPEHgNhjAIE+IIKAFR9AVBwDAE44B+AbEEIULQDxgiBCAP4Q4Sx5CFBGOoCowhMBIBgEUAA2wMBC" +
"EMBQIQqA2gLBAKwGYhgoDRHuEIbAbwFigHoDMDYgwEBRCGFgOIERxAAH+IgMQiA3AMBwIsB4RhuAsEUCMUwKRZh4E2BMAwGBRiFAiFYFIRQRCtAmEUDgTQKCRDcC4YoS" +
"BeBUHGBAbgGBIiMFSI8XAqQNiGG4HARwEQ/A1GMKEJQVRDjYHUBsSI5gejHFQPkDoBQWB2BUMMeAeAHCJASCEUgLBDiQAGHQMQig0gGB4AcHghBJAyCEEkCoaQMApFIL" +
"wR4kg5BuCUJUHILwRgQHiFMSQUhHBKCSAkFgMQig8EYBUCQPA5hICSFpKgeBzCUHEKANwjAwhTBAMcPgrRLgjHkF0ZYmQWgtFKKwW4lApDCCuEwLIYQXjFCYLUCochwB" +
"yGWMkTQOxzB4HKJccQrgyhMGSJ0Go5hCDTA2MMDwZRKgxH2DQEw+ByicBmIQVYTRYhXBsMUMIVhNjjEkHUZw0RvA5BOCgY4FRJiiDqE4BI7QcCmGSFMToExogVCcOkbI" +
"OxzhaBmJ0AYnA1AMdoCsKIJQEgfHoB4QQDAJCtCGGgHoEQMDiFtPIKQrAdDNHiAMEAICAgA==");
excascadetree1.SelBackColor32 = 0x1000000;
excascadetree1.SelForeColor = Color.FromArgb(0,0,0);
excascadetree1.BackColorHeader32 = 0x2000000;
excascadetree1.set_ScrollPartVisible(exontrol.EXCASCADETREELib.ScrollBarEnum.exVScroll,exontrol.EXCASCADETREELib.ScrollPartEnum.exExtentThumbPart,true);
excascadetree1.set_ScrollPartVisible(exontrol.EXCASCADETREELib.ScrollBarEnum.exHScroll,exontrol.EXCASCADETREELib.ScrollPartEnum.exExtentThumbPart,true);
excascadetree1.set_ScrollPartVisible(exontrol.EXCASCADETREELib.ScrollBarEnum.exScroll,exontrol.EXCASCADETREELib.ScrollPartEnum.exExtentThumbPart,true);
excascadetree1.ScrollWidth = 4;
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exVSBack,Color.FromArgb(240,240,240));
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exVSThumb,Color.FromArgb(128,128,128));
excascadetree1.ScrollHeight = 4;
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exHSBack,excascadetree1.get_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exVSBack));
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exHSThumb,excascadetree1.get_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exVSThumb));
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exScrollSizeGrip,excascadetree1.get_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exVSBack));
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exSplitBar,Color.FromArgb(196,196,196));
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exCSplitBar,excascadetree1.get_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exSplitBar));
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exHSplitBar,excascadetree1.get_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exSplitBar));
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exSplitBarSize,Color.FromArgb(2,0,0));
excascadetree1.BackColorSortBar = excascadetree1.BackColor;
excascadetree1.EndUpdate();
excascadetree1.BeginUpdate();
excascadetree1.Mode = exontrol.EXCASCADETREELib.CascadeModeEnum.exSplitFixCascadeMode;
excascadetree1.DataSource = "Source=C:\\Program Files\\Exontrol\\ExCascadeTree\\Sample\\Access\\cities.accdb;Member=Select * FROM Countries;Key=CountryCode;" +
"Tag=Country;Name=CountryName >>> Member=Select * FROM States WHERE CountryCode IN (<%Parent.CountryCode%>);Key=StateCode;Name=St" +
"ateName;Tag=State ||| Member=Select * FROM Cities WHERE CountryCode IN (<%Parent.CountryCode%>);Tag=City;Name=Name >>> Member=Se" +
"lect * FROM Cities WHERE CountryCode IN (<%Parent.Parent.CountryCode%>) AND StateCode IN (<%Parent.StateCode%>);Tag=City;Name=Na" +
"me";
excascadetree1.Select = "RO\\CJ";
excascadetree1.EndUpdate();
|
|
40
|
How can I format a column so it display its content in a different way
// CreateView event - A view has been created.
private void excascadetree1_CreateView(object sender,exontrol.EXCASCADETREELib.View View)
{
// Columns("StateCode").Visible = False
exontrol.EXCASCADETREELib.View var_View = excascadetree1.View;
var_View.BeginUpdate();
var_View.ContinueColumnScroll = false;
var_View.ScrollBySingleLine = true;
var_View.DrawGridLines = exontrol.EXCASCADETREELib.GridLinesEnum.exAllLines;
var_View.EnsureVisibleColumn("Date");
var_View.Columns["CountryCode"].Visible = false;
Object var_Object = var_View.Columns["Date"];
Object var_Object1 = var_View.Columns["Function"];
Object var_Object2 = var_View.Columns["Coordinates"];
Object var_Object3 = var_View.Columns["Status"];
var_View.EndUpdate();
}
//this.excascadetree1.CreateView += new exontrol.EXCASCADETREELib.exg2antt.CreateViewEventHandler(this.excascadetree1_CreateView);
// Error event - An internal error occurs.
private void excascadetree1_Error(object sender,int Err,string Description)
{
System.Diagnostics.Debug.Print( "Error" );
System.Diagnostics.Debug.Print( Description.ToString() );
}
//this.excascadetree1.Error += new exontrol.EXCASCADETREELib.exg2antt.ErrorEventHandler(this.excascadetree1_Error);
excascadetree1.BeginUpdate();
excascadetree1.FitCascadeColumns = 7;
excascadetree1.Mode = exontrol.EXCASCADETREELib.CascadeModeEnum.exSplitFixCascadeMode;
excascadetree1.ScrollWidth = 4;
excascadetree1.ScrollHeight = 4;
excascadetree1.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" +
"lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" +
"0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" +
"NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=");
excascadetree1.DataSource = "Source=C:\\Program Files\\Exontrol\\ExCascadeTree\\Sample\\Access\\cities.accdb;Member=Select * FROM Countries;Key=CountryCode;" +
"Tag=Country;Name=CountryName >>> Member=Select * FROM States WHERE CountryCode IN (<%Parent.CountryCode%>);Key=StateCode;Name=St" +
"ateName;Tag=State ||| Member=Select * FROM Cities WHERE CountryCode IN (<%Parent.CountryCode%>);Tag=City;Name=Name >>> Member=Se" +
"lect * FROM Cities WHERE CountryCode IN (<%Parent.Parent.CountryCode%>) AND StateCode IN (<%Parent.StateCode%>);Tag=City;Name=Na" +
"me";
excascadetree1.Select = "US\\OR";
excascadetree1.EndUpdate();
|
|
39
|
How can I add a position column
// CreateView event - A view has been created.
private void excascadetree1_CreateView(object sender,exontrol.EXCASCADETREELib.View View)
{
exontrol.EXCASCADETREELib.View var_View = excascadetree1.View;
exontrol.EXCASCADETREELib.Column var_Column = (var_View.Columns.Add("Pos") as exontrol.EXCASCADETREELib.Column);
var_Column.Width = 32;
var_Column.AllowSizing = false;
var_Column.Position = 0;
var_Column.FormatColumn = "1 pos ``";
var_Column.set_Def(exontrol.EXCASCADETREELib.DefColumnEnum.exCellBackColor,15790320);
var_Column.Alignment = exontrol.EXCASCADETREELib.AlignmentEnum.RightAlignment;
var_Column.HeaderAlignment = var_Column.Alignment;
var_Column.set_Def(exontrol.EXCASCADETREELib.DefColumnEnum.exCellPaddingRight,2);
var_Column.set_Def(exontrol.EXCASCADETREELib.DefColumnEnum.exCellPaddingLeft,2);
var_Column.set_Def(exontrol.EXCASCADETREELib.DefColumnEnum.exHeaderPaddingLeft,2);
var_Column.set_Def(exontrol.EXCASCADETREELib.DefColumnEnum.exHeaderPaddingRight,2);
var_View.CountLockedColumns = 1;
}
//this.excascadetree1.CreateView += new exontrol.EXCASCADETREELib.exg2antt.CreateViewEventHandler(this.excascadetree1_CreateView);
// Error event - An internal error occurs.
private void excascadetree1_Error(object sender,int Err,string Description)
{
System.Diagnostics.Debug.Print( "Error" );
System.Diagnostics.Debug.Print( Description.ToString() );
}
//this.excascadetree1.Error += new exontrol.EXCASCADETREELib.exg2antt.ErrorEventHandler(this.excascadetree1_Error);
excascadetree1.BeginUpdate();
excascadetree1.Mode = exontrol.EXCASCADETREELib.CascadeModeEnum.exSplitFixCascadeMode;
excascadetree1.DataSource = "Source=C:\\Program Files\\Exontrol\\ExCascadeTree\\Sample\\Access\\cities.accdb;Member=Select * FROM Countries;Key=CountryCode;" +
"Tag=Country;Name=CountryName >>> Member=Select * FROM States WHERE CountryCode IN (<%Parent.CountryCode%>);Key=StateCode;Name=St" +
"ateName;Tag=State ||| Member=Select * FROM Cities WHERE CountryCode IN (<%Parent.CountryCode%>);Tag=City;Name=Name >>> Member=Se" +
"lect * FROM Cities WHERE CountryCode IN (<%Parent.Parent.CountryCode%>) AND StateCode IN (<%Parent.StateCode%>);Tag=City;Name=Na" +
"me";
excascadetree1.Select = "US\\IA";
excascadetree1.EndUpdate();
|
|
38
|
How can I display icons or images
// CreateView event - A view has been created.
private void excascadetree1_CreateView(object sender,exontrol.EXCASCADETREELib.View View)
{
exontrol.EXCASCADETREELib.View var_View = excascadetree1.View;
var_View.EnsureVisibleColumn("Function");
Object var_Object = var_View.Columns["Function"];
}
//this.excascadetree1.CreateView += new exontrol.EXCASCADETREELib.exg2antt.CreateViewEventHandler(this.excascadetree1_CreateView);
// Error event - An internal error occurs.
private void excascadetree1_Error(object sender,int Err,string Description)
{
System.Diagnostics.Debug.Print( "Error" );
System.Diagnostics.Debug.Print( Description.ToString() );
}
//this.excascadetree1.Error += new exontrol.EXCASCADETREELib.exg2antt.ErrorEventHandler(this.excascadetree1_Error);
excascadetree1.BeginUpdate();
excascadetree1.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" +
"lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" +
"0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" +
"NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=");
excascadetree1.Mode = exontrol.EXCASCADETREELib.CascadeModeEnum.exSplitFixCascadeMode;
excascadetree1.DataSource = "Source=C:\\Program Files\\Exontrol\\ExCascadeTree\\Sample\\Access\\cities.accdb;Member=Select * FROM Countries;Key=CountryCode;" +
"Tag=Country;Name=CountryName >>> Member=Select * FROM States WHERE CountryCode IN (<%Parent.CountryCode%>);Key=StateCode;Name=St" +
"ateName;Tag=State ||| Member=Select * FROM Cities WHERE CountryCode IN (<%Parent.CountryCode%>);Tag=City;Name=Name >>> Member=Se" +
"lect * FROM Cities WHERE CountryCode IN (<%Parent.Parent.CountryCode%>) AND StateCode IN (<%Parent.StateCode%>);Tag=City;Name=Na" +
"me";
excascadetree1.Select = "US\\MN";
excascadetree1.EndUpdate();
|
|
37
|
How can I turn-on the control's status bar
// CreateView event - A view has been created.
private void excascadetree1_CreateView(object sender,exontrol.EXCASCADETREELib.View View)
{
excascadetree1.StatusBarLabel = excascadetree1.FormatABC("`<b>` + ( value replace `\\\\` with ` </b><font ;6><off 4>` )",excascadetree1.Name,null,null).ToString();
}
//this.excascadetree1.CreateView += new exontrol.EXCASCADETREELib.exg2antt.CreateViewEventHandler(this.excascadetree1_CreateView);
// Error event - An internal error occurs.
private void excascadetree1_Error(object sender,int Err,string Description)
{
System.Diagnostics.Debug.Print( "Error" );
System.Diagnostics.Debug.Print( Description.ToString() );
}
//this.excascadetree1.Error += new exontrol.EXCASCADETREELib.exg2antt.ErrorEventHandler(this.excascadetree1_Error);
// ViewEndChanging event - Occurs once the user is about to change the view.
private void excascadetree1_ViewEndChanging(object sender,exontrol.EXCASCADETREELib.ViewOperationEnum Operation)
{
excascadetree1.StatusBarLabel = excascadetree1.FormatABC("`<b>` + ( value replace `\\\\` with ` </b><font ;6><off 4>` )",excascadetree1.Name,null,null).ToString();
}
//this.excascadetree1.ViewEndChanging += new exontrol.EXCASCADETREELib.exg2antt.ViewEndChangingEventHandler(this.excascadetree1_ViewEndChanging);
excascadetree1.BeginUpdate();
excascadetree1.StatusBarVisible = exontrol.EXCASCADETREELib.StatusBarAnchorEnum.exStatusBarAnchorTop;
excascadetree1.StatusBarHeight = 24;
excascadetree1.Mode = exontrol.EXCASCADETREELib.CascadeModeEnum.exSplitFixCascadeMode;
excascadetree1.DataSource = "Source=C:\\Program Files\\Exontrol\\ExCascadeTree\\Sample\\Access\\cities.accdb;Member=Select * FROM Countries;Key=CountryCode;" +
"Tag=Country;Name=CountryName >>> Member=Select * FROM States WHERE CountryCode IN (<%Parent.CountryCode%>);Key=StateCode;Name=St" +
"ateName;Tag=State ||| Member=Select * FROM Cities WHERE CountryCode IN (<%Parent.CountryCode%>);Tag=City;Name=Name >>> Member=Se" +
"lect * FROM Cities WHERE CountryCode IN (<%Parent.Parent.CountryCode%>) AND StateCode IN (<%Parent.StateCode%>);Tag=City;Name=Na" +
"me";
excascadetree1.Name = "Romania\\Cluj\\Baciu*";
excascadetree1.EndUpdate();
|
|
36
|
How can I disable incremental searching
// CreateView event - A view has been created.
private void excascadetree1_CreateView(object sender,exontrol.EXCASCADETREELib.View View)
{
excascadetree1.View.AutoSearch = false;
}
//this.excascadetree1.CreateView += new exontrol.EXCASCADETREELib.exg2antt.CreateViewEventHandler(this.excascadetree1_CreateView);
// Error event - An internal error occurs.
private void excascadetree1_Error(object sender,int Err,string Description)
{
System.Diagnostics.Debug.Print( "Error" );
System.Diagnostics.Debug.Print( Description.ToString() );
}
//this.excascadetree1.Error += new exontrol.EXCASCADETREELib.exg2antt.ErrorEventHandler(this.excascadetree1_Error);
excascadetree1.BeginUpdate();
excascadetree1.Mode = exontrol.EXCASCADETREELib.CascadeModeEnum.exSplitFixCascadeMode;
excascadetree1.DataSource = "Source=C:\\Program Files\\Exontrol\\ExCascadeTree\\Sample\\Access\\cities.accdb;Member=Select * FROM Countries;Key=CountryCode;" +
"Tag=Country;Name=CountryName >>> Member=Select * FROM States WHERE CountryCode IN (<%Parent.CountryCode%>);Key=StateCode;Name=St" +
"ateName;Tag=State ||| Member=Select * FROM Cities WHERE CountryCode IN (<%Parent.CountryCode%>);Tag=City;Name=Name >>> Member=Se" +
"lect * FROM Cities WHERE CountryCode IN (<%Parent.Parent.CountryCode%>) AND StateCode IN (<%Parent.StateCode%>);Tag=City;Name=Na" +
"me";
excascadetree1.Select = "US\\AK";
excascadetree1.EndUpdate();
|
|
35
|
ScrollBar extension
// CreateView event - A view has been created.
private void excascadetree1_CreateView(object sender,exontrol.EXCASCADETREELib.View View)
{
// Columns("StateCode").Visible = False
exontrol.EXCASCADETREELib.View var_View = excascadetree1.View;
var_View.ColumnAutoResize = true;
var_View.Columns["CountryCode"].Visible = false;
}
//this.excascadetree1.CreateView += new exontrol.EXCASCADETREELib.exg2antt.CreateViewEventHandler(this.excascadetree1_CreateView);
// Error event - An internal error occurs.
private void excascadetree1_Error(object sender,int Err,string Description)
{
System.Diagnostics.Debug.Print( "Error" );
System.Diagnostics.Debug.Print( Description.ToString() );
}
//this.excascadetree1.Error += new exontrol.EXCASCADETREELib.exg2antt.ErrorEventHandler(this.excascadetree1_Error);
excascadetree1.BeginUpdate();
excascadetree1.set_ScrollPartVisible(exontrol.EXCASCADETREELib.ScrollBarEnum.exVScroll,exontrol.EXCASCADETREELib.ScrollPartEnum.exExtentThumbPart,true);
excascadetree1.set_ScrollPartVisible(exontrol.EXCASCADETREELib.ScrollBarEnum.exHScroll,exontrol.EXCASCADETREELib.ScrollPartEnum.exExtentThumbPart,true);
excascadetree1.set_ScrollPartVisible(exontrol.EXCASCADETREELib.ScrollBarEnum.exScroll,exontrol.EXCASCADETREELib.ScrollPartEnum.exExtentThumbPart,true);
excascadetree1.ScrollWidth = 4;
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exVSBack,Color.FromArgb(240,240,240));
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exVSThumb,Color.FromArgb(128,128,128));
excascadetree1.ScrollHeight = 4;
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exHSBack,excascadetree1.get_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exVSBack));
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exHSThumb,excascadetree1.get_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exVSThumb));
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exScrollSizeGrip,excascadetree1.get_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exVSBack));
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exSplitBar,Color.FromArgb(196,196,196));
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exCSplitBar,excascadetree1.get_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exSplitBar));
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exHSplitBar,excascadetree1.get_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exSplitBar));
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exSplitBarSize,Color.FromArgb(2,0,0));
excascadetree1.EndUpdate();
excascadetree1.BeginUpdate();
excascadetree1.Mode = exontrol.EXCASCADETREELib.CascadeModeEnum.exSplitFixCascadeMode;
excascadetree1.DataSource = "Source=C:\\Program Files\\Exontrol\\ExCascadeTree\\Sample\\Access\\cities.accdb;Member=Select * FROM Countries;Key=CountryCode;" +
"Tag=Country;Name=CountryName >>> Member=Select * FROM States WHERE CountryCode IN (<%Parent.CountryCode%>);Key=StateCode;Name=St" +
"ateName;Tag=State ||| Member=Select * FROM Cities WHERE CountryCode IN (<%Parent.CountryCode%>);Tag=City;Name=Name >>> Member=Se" +
"lect * FROM Cities WHERE CountryCode IN (<%Parent.Parent.CountryCode%>) AND StateCode IN (<%Parent.StateCode%>);Tag=City;Name=Na" +
"me";
excascadetree1.Select = "US\\AK";
excascadetree1.get_DefaultView(null).Columns["CountryName"].SortOrder = exontrol.EXCASCADETREELib.SortOrderEnum.SortAscending;
excascadetree1.get_DefaultView(null).NextView.Columns["StateName"].SortOrder = exontrol.EXCASCADETREELib.SortOrderEnum.SortAscending;
exontrol.EXCASCADETREELib.View var_View = excascadetree1.get_DefaultView(null).NextView.NextView;
var_View.ColumnAutoResize = false;
exontrol.EXCASCADETREELib.Column var_Column = var_View.Columns["Name"];
var_Column.SortOrder = exontrol.EXCASCADETREELib.SortOrderEnum.SortAscending;
var_Column.Width = 128;
exontrol.EXCASCADETREELib.Items var_Items = var_View.Items;
var_Items.set_SelectItem(var_Items.get_FindItem("Anchorage","Name",null),true);
excascadetree1.EndUpdate();
|
|
34
|
How can I access the next/prev/parent/child view
// CreateView event - A view has been created.
private void excascadetree1_CreateView(object sender,exontrol.EXCASCADETREELib.View View)
{
// Columns("StateCode").Visible = False
exontrol.EXCASCADETREELib.View var_View = excascadetree1.View;
var_View.ColumnAutoResize = true;
var_View.Columns["CountryCode"].Visible = false;
}
//this.excascadetree1.CreateView += new exontrol.EXCASCADETREELib.exg2antt.CreateViewEventHandler(this.excascadetree1_CreateView);
// Error event - An internal error occurs.
private void excascadetree1_Error(object sender,int Err,string Description)
{
System.Diagnostics.Debug.Print( "Error" );
System.Diagnostics.Debug.Print( Description.ToString() );
}
//this.excascadetree1.Error += new exontrol.EXCASCADETREELib.exg2antt.ErrorEventHandler(this.excascadetree1_Error);
excascadetree1.BeginUpdate();
excascadetree1.Mode = exontrol.EXCASCADETREELib.CascadeModeEnum.exSplitEqualCascadeMode;
excascadetree1.DataSource = "Source=C:\\Program Files\\Exontrol\\ExCascadeTree\\Sample\\Access\\cities.accdb;Member=Select * FROM Countries;Key=CountryCode;" +
"Tag=Country;Name=CountryName >>> Member=Select * FROM States WHERE CountryCode IN (<%Parent.CountryCode%>);Key=StateCode;Name=St" +
"ateName;Tag=State ||| Member=Select * FROM Cities WHERE CountryCode IN (<%Parent.CountryCode%>);Tag=City;Name=Name >>> Member=Se" +
"lect * FROM Cities WHERE CountryCode IN (<%Parent.Parent.CountryCode%>) AND StateCode IN (<%Parent.StateCode%>);Tag=City;Name=Na" +
"me";
excascadetree1.Select = "RO\\CJ";
excascadetree1.get_DefaultView(null).Columns["CountryName"].SortOrder = exontrol.EXCASCADETREELib.SortOrderEnum.SortAscending;
excascadetree1.get_DefaultView(null).NextView.Columns["StateName"].SortOrder = exontrol.EXCASCADETREELib.SortOrderEnum.SortAscending;
exontrol.EXCASCADETREELib.View var_View = excascadetree1.get_DefaultView(null).NextView.NextView;
var_View.BeginUpdate();
var_View.ColumnAutoResize = false;
exontrol.EXCASCADETREELib.Column var_Column = var_View.Columns["Name"];
var_Column.Width = 128;
var_Column.SortOrder = exontrol.EXCASCADETREELib.SortOrderEnum.SortAscending;
var_View.SingleSort = false;
var_View.AllowGroupBy = true;
var_View.Columns["Status"].SortOrder = exontrol.EXCASCADETREELib.SortOrderEnum.SortDescending;
var_View.TreeColumnIndex = var_View.Columns["Name"].Index;
var_View.EndUpdate();
excascadetree1.EndUpdate();
|
|
33
|
Predefined Keywords of ShowContextMenu property
// CreateView event - A view has been created.
private void excascadetree1_CreateView(object sender,exontrol.EXCASCADETREELib.View View)
{
// Columns("StateCode").Visible = False
exontrol.EXCASCADETREELib.View var_View = excascadetree1.View;
var_View.ColumnAutoResize = true;
var_View.Columns["CountryCode"].Visible = false;
excascadetree1.StatusBarLabel = excascadetree1.FormatABC("`<b>` + ( value replace `\\\\` with ` </b><font ;6><off 4>` )",excascadetree1.Name,null,null).ToString();
}
//this.excascadetree1.CreateView += new exontrol.EXCASCADETREELib.exg2antt.CreateViewEventHandler(this.excascadetree1_CreateView);
// Error event - An internal error occurs.
private void excascadetree1_Error(object sender,int Err,string Description)
{
System.Diagnostics.Debug.Print( "Error" );
System.Diagnostics.Debug.Print( Description.ToString() );
}
//this.excascadetree1.Error += new exontrol.EXCASCADETREELib.exg2antt.ErrorEventHandler(this.excascadetree1_Error);
// ViewEndChanging event - Occurs once the user is about to change the view.
private void excascadetree1_ViewEndChanging(object sender,exontrol.EXCASCADETREELib.ViewOperationEnum Operation)
{
excascadetree1.StatusBarLabel = excascadetree1.FormatABC("`<b>` + ( value replace `\\\\` with ` </b><font ;6><off 4>` )",excascadetree1.Name,null,null).ToString();
excascadetree1.ExecuteContextMenu = 0;
}
//this.excascadetree1.ViewEndChanging += new exontrol.EXCASCADETREELib.exg2antt.ViewEndChangingEventHandler(this.excascadetree1_ViewEndChanging);
excascadetree1.BeginUpdate();
excascadetree1.AllowSplitView = exontrol.EXCASCADETREELib.AllowSplitViewEnum.exAllowOneSplitView;
excascadetree1.FitCascadeColumns = 3;
excascadetree1.Mode = exontrol.EXCASCADETREELib.CascadeModeEnum.exSplitEqualCascadeMode;
excascadetree1.StatusBarVisible = exontrol.EXCASCADETREELib.StatusBarAnchorEnum.exStatusBarAnchorTop;
excascadetree1.StatusBarHeight = 24;
excascadetree1.set_ScrollPartVisible(exontrol.EXCASCADETREELib.ScrollBarEnum.exVScroll,exontrol.EXCASCADETREELib.ScrollPartEnum.exExtentThumbPart,true);
excascadetree1.set_ScrollPartVisible(exontrol.EXCASCADETREELib.ScrollBarEnum.exHScroll,exontrol.EXCASCADETREELib.ScrollPartEnum.exExtentThumbPart,true);
excascadetree1.set_ScrollPartVisible(exontrol.EXCASCADETREELib.ScrollBarEnum.exScroll,exontrol.EXCASCADETREELib.ScrollPartEnum.exExtentThumbPart,true);
excascadetree1.ScrollWidth = 4;
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exVSBack,Color.FromArgb(240,240,240));
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exVSThumb,Color.FromArgb(128,128,128));
excascadetree1.ScrollHeight = 4;
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exHSBack,excascadetree1.get_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exVSBack));
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exHSThumb,excascadetree1.get_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exVSThumb));
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exScrollSizeGrip,excascadetree1.get_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exVSBack));
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exSplitBar,Color.FromArgb(196,196,196));
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exCSplitBar,excascadetree1.get_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exSplitBar));
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exHSplitBar,excascadetree1.get_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exSplitBar));
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exSplitBarSize,Color.FromArgb(2,0,0));
excascadetree1.DataSource = "Source=C:\\Program Files\\Exontrol\\ExCascadeTree\\Sample\\Access\\cities.accdb;Member=Select * FROM Countries;Key=CountryCode;" +
"Tag=Country;Name=CountryName >>> Member=Select * FROM States WHERE CountryCode IN (<%Parent.CountryCode%>);Key=StateCode;Name=St" +
"ateName;Tag=State ||| Member=Select * FROM Cities WHERE CountryCode IN (<%Parent.CountryCode%>);Tag=City;Name=Name >>> Member=Se" +
"lect * FROM Cities WHERE CountryCode IN (<%Parent.Parent.CountryCode%>) AND StateCode IN (<%Parent.StateCode%>);Tag=City;Name=Na" +
"me";
excascadetree1.Select = "US\\AK";
excascadetree1.ShowContextMenu = "`vlevels=` + vlevels + `,vlevel=` + vlevel + `,hlevels=` + hlevels + `,hlevel=` + hlevel + `,view=` + view ";
excascadetree1.SplitViewHeight = "256";
excascadetree1.EndUpdate();
|
|
32
|
How can I display the identifiers of the control's context menu (debug)
// CreateView event - A view has been created.
private void excascadetree1_CreateView(object sender,exontrol.EXCASCADETREELib.View View)
{
// Columns("StateCode").Visible = False
exontrol.EXCASCADETREELib.View var_View = excascadetree1.View;
var_View.ColumnAutoResize = true;
var_View.Columns["CountryCode"].Visible = false;
}
//this.excascadetree1.CreateView += new exontrol.EXCASCADETREELib.exg2antt.CreateViewEventHandler(this.excascadetree1_CreateView);
// Error event - An internal error occurs.
private void excascadetree1_Error(object sender,int Err,string Description)
{
System.Diagnostics.Debug.Print( "Error" );
System.Diagnostics.Debug.Print( Description.ToString() );
}
//this.excascadetree1.Error += new exontrol.EXCASCADETREELib.exg2antt.ErrorEventHandler(this.excascadetree1_Error);
// ViewEndChanging event - Occurs once the user is about to change the view.
private void excascadetree1_ViewEndChanging(object sender,exontrol.EXCASCADETREELib.ViewOperationEnum Operation)
{
System.Diagnostics.Debug.Print( excascadetree1.ExecuteContextMenu.ToString() );
}
//this.excascadetree1.ViewEndChanging += new exontrol.EXCASCADETREELib.exg2antt.ViewEndChangingEventHandler(this.excascadetree1_ViewEndChanging);
excascadetree1.BeginUpdate();
excascadetree1.Mode = exontrol.EXCASCADETREELib.CascadeModeEnum.exSplitFixCascadeMode;
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exSplitBar,Color.FromArgb(196,196,196));
excascadetree1.DataSource = "Source=C:\\Program Files\\Exontrol\\ExCascadeTree\\Sample\\Access\\cities.accdb;Member=Select * FROM Countries;Key=CountryCode;" +
"Tag=Country;Name=CountryName >>> Member=Select * FROM States WHERE CountryCode IN (<%Parent.CountryCode%>);Key=StateCode;Name=St" +
"ateName;Tag=State ||| Member=Select * FROM Cities WHERE CountryCode IN (<%Parent.CountryCode%>);Tag=City;Name=Name >>> Member=Se" +
"lect * FROM Cities WHERE CountryCode IN (<%Parent.Parent.CountryCode%>) AND StateCode IN (<%Parent.StateCode%>);Tag=City;Name=Na" +
"me";
excascadetree1.Select = "US\\AK";
excascadetree1.ShowContextMenu = "[debug]Popup(Item 1[id=1001],Item 2[id=1002],Item 3[id=1003]),[sep],Exit[def][id=1000]";
excascadetree1.EndUpdate();
|
|
31
|
ShowContextMenu usage
// CreateView event - A view has been created.
private void excascadetree1_CreateView(object sender,exontrol.EXCASCADETREELib.View View)
{
// Columns("StateCode").Visible = False
exontrol.EXCASCADETREELib.View var_View = excascadetree1.View;
var_View.ColumnAutoResize = true;
var_View.Columns["CountryCode"].Visible = false;
}
//this.excascadetree1.CreateView += new exontrol.EXCASCADETREELib.exg2antt.CreateViewEventHandler(this.excascadetree1_CreateView);
// Error event - An internal error occurs.
private void excascadetree1_Error(object sender,int Err,string Description)
{
System.Diagnostics.Debug.Print( "Error" );
System.Diagnostics.Debug.Print( Description.ToString() );
}
//this.excascadetree1.Error += new exontrol.EXCASCADETREELib.exg2antt.ErrorEventHandler(this.excascadetree1_Error);
// ViewEndChanging event - Occurs once the user is about to change the view.
private void excascadetree1_ViewEndChanging(object sender,exontrol.EXCASCADETREELib.ViewOperationEnum Operation)
{
System.Diagnostics.Debug.Print( excascadetree1.ExecuteContextMenu.ToString() );
}
//this.excascadetree1.ViewEndChanging += new exontrol.EXCASCADETREELib.exg2antt.ViewEndChangingEventHandler(this.excascadetree1_ViewEndChanging);
excascadetree1.BeginUpdate();
excascadetree1.Mode = exontrol.EXCASCADETREELib.CascadeModeEnum.exSplitFixCascadeMode;
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exSplitBar,Color.FromArgb(196,196,196));
excascadetree1.DataSource = "Source=C:\\Program Files\\Exontrol\\ExCascadeTree\\Sample\\Access\\cities.accdb;Member=Select * FROM Countries;Key=CountryCode;" +
"Tag=Country;Name=CountryName >>> Member=Select * FROM States WHERE CountryCode IN (<%Parent.CountryCode%>);Key=StateCode;Name=St" +
"ateName;Tag=State ||| Member=Select * FROM Cities WHERE CountryCode IN (<%Parent.CountryCode%>);Tag=City;Name=Name >>> Member=Se" +
"lect * FROM Cities WHERE CountryCode IN (<%Parent.Parent.CountryCode%>) AND StateCode IN (<%Parent.StateCode%>);Tag=City;Name=Na" +
"me";
excascadetree1.Select = "US\\AK";
excascadetree1.ShowContextMenu = "Popup(Item 1[id=1001],Item 2[id=1002],Item 3[id=1003]),[sep],Exit[def][id=1000]";
excascadetree1.EndUpdate();
|
|
30
|
How can I resize automatically all views, when the control is resized
// CreateView event - A view has been created.
private void excascadetree1_CreateView(object sender,exontrol.EXCASCADETREELib.View View)
{
// Columns("StateCode").Visible = False
exontrol.EXCASCADETREELib.View var_View = excascadetree1.View;
var_View.ColumnAutoResize = true;
var_View.Columns["CountryCode"].Visible = false;
}
//this.excascadetree1.CreateView += new exontrol.EXCASCADETREELib.exg2antt.CreateViewEventHandler(this.excascadetree1_CreateView);
// Error event - An internal error occurs.
private void excascadetree1_Error(object sender,int Err,string Description)
{
System.Diagnostics.Debug.Print( "Error" );
System.Diagnostics.Debug.Print( Description.ToString() );
}
//this.excascadetree1.Error += new exontrol.EXCASCADETREELib.exg2antt.ErrorEventHandler(this.excascadetree1_Error);
excascadetree1.BeginUpdate();
excascadetree1.Mode = exontrol.EXCASCADETREELib.CascadeModeEnum.exAutoFitOnResizeClient | exontrol.EXCASCADETREELib.CascadeModeEnum.exSplitFixCascadeMode;
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exSplitBar,Color.FromArgb(196,196,196));
excascadetree1.DataSource = "Source=C:\\Program Files\\Exontrol\\ExCascadeTree\\Sample\\Access\\cities.accdb;Member=Select * FROM Countries;Key=CountryCode;" +
"Tag=Country;Name=CountryName >>> Member=Select * FROM States WHERE CountryCode IN (<%Parent.CountryCode%>);Key=StateCode;Name=St" +
"ateName;Tag=State ||| Member=Select * FROM Cities WHERE CountryCode IN (<%Parent.CountryCode%>);Tag=City;Name=Name >>> Member=Se" +
"lect * FROM Cities WHERE CountryCode IN (<%Parent.Parent.CountryCode%>) AND StateCode IN (<%Parent.StateCode%>);Tag=City;Name=Na" +
"me";
excascadetree1.Select = "US\\AK";
excascadetree1.EndUpdate();
|
|
29
|
How can I hide some columns
// CreateView event - A view has been created.
private void excascadetree1_CreateView(object sender,exontrol.EXCASCADETREELib.View View)
{
// Columns("StateCode").Visible = False
exontrol.EXCASCADETREELib.View var_View = excascadetree1.View;
var_View.ColumnAutoResize = true;
var_View.Columns["CountryCode"].Visible = false;
}
//this.excascadetree1.CreateView += new exontrol.EXCASCADETREELib.exg2antt.CreateViewEventHandler(this.excascadetree1_CreateView);
// Error event - An internal error occurs.
private void excascadetree1_Error(object sender,int Err,string Description)
{
System.Diagnostics.Debug.Print( "Error" );
System.Diagnostics.Debug.Print( Description.ToString() );
}
//this.excascadetree1.Error += new exontrol.EXCASCADETREELib.exg2antt.ErrorEventHandler(this.excascadetree1_Error);
excascadetree1.BeginUpdate();
excascadetree1.Mode = exontrol.EXCASCADETREELib.CascadeModeEnum.exSplitFixCascadeMode;
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exSplitBar,Color.FromArgb(196,196,196));
excascadetree1.DataSource = "Source=C:\\Program Files\\Exontrol\\ExCascadeTree\\Sample\\Access\\cities.accdb;Member=Select * FROM Countries;Key=CountryCode;" +
"Tag=Country;Name=CountryName >>> Member=Select * FROM States WHERE CountryCode IN (<%Parent.CountryCode%>);Key=StateCode;Name=St" +
"ateName;Tag=State ||| Member=Select * FROM Cities WHERE CountryCode IN (<%Parent.CountryCode%>);Tag=City;Name=Name >>> Member=Se" +
"lect * FROM Cities WHERE CountryCode IN (<%Parent.Parent.CountryCode%>) AND StateCode IN (<%Parent.StateCode%>);Tag=City;Name=Na" +
"me";
excascadetree1.Select = "US\\AK";
excascadetree1.EndUpdate();
|
|
28
|
Is it possible to disable resizing the cascade columns
// CreateView event - A view has been created.
private void excascadetree1_CreateView(object sender,exontrol.EXCASCADETREELib.View View)
{
excascadetree1.View.ColumnAutoResize = true;
}
//this.excascadetree1.CreateView += new exontrol.EXCASCADETREELib.exg2antt.CreateViewEventHandler(this.excascadetree1_CreateView);
// Error event - An internal error occurs.
private void excascadetree1_Error(object sender,int Err,string Description)
{
System.Diagnostics.Debug.Print( "Error" );
System.Diagnostics.Debug.Print( Description.ToString() );
}
//this.excascadetree1.Error += new exontrol.EXCASCADETREELib.exg2antt.ErrorEventHandler(this.excascadetree1_Error);
excascadetree1.BeginUpdate();
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exSplitBar,Color.FromArgb(196,196,196));
excascadetree1.Mode = exontrol.EXCASCADETREELib.CascadeModeEnum.exAutoFitOnResizeClient | exontrol.EXCASCADETREELib.CascadeModeEnum.exDisableResizeCascadeColumns | exontrol.EXCASCADETREELib.CascadeModeEnum.exSplitFixCascadeMode;
excascadetree1.DataSource = "Source=C:\\Program Files\\Exontrol\\ExCascadeTree\\Sample\\Access\\cities.accdb;Member=Select * FROM Countries;Key=CountryCode;" +
"Tag=Country;Name=CountryName >>> Member=Select * FROM States WHERE CountryCode IN (<%Parent.CountryCode%>);Key=StateCode;Name=St" +
"ateName;Tag=State ||| Member=Select * FROM Cities WHERE CountryCode IN (<%Parent.CountryCode%>);Tag=City;Name=Name >>> Member=Se" +
"lect * FROM Cities WHERE CountryCode IN (<%Parent.Parent.CountryCode%>) AND StateCode IN (<%Parent.StateCode%>);Tag=City;Name=Na" +
"me";
excascadetree1.Select = "US\\AK";
excascadetree1.EndUpdate();
|
|
27
|
SplitFixCascadeMode Mode
// Error event - An internal error occurs.
private void excascadetree1_Error(object sender,int Err,string Description)
{
System.Diagnostics.Debug.Print( "Error" );
System.Diagnostics.Debug.Print( Description.ToString() );
}
//this.excascadetree1.Error += new exontrol.EXCASCADETREELib.exg2antt.ErrorEventHandler(this.excascadetree1_Error);
excascadetree1.BeginUpdate();
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exSplitBar,Color.FromArgb(196,196,196));
excascadetree1.Mode = exontrol.EXCASCADETREELib.CascadeModeEnum.exSplitFixCascadeMode;
excascadetree1.DataSource = "Source=C:\\Program Files\\Exontrol\\ExCascadeTree\\Sample\\Access\\cities.accdb;Member=Select * FROM Countries;Key=CountryCode;" +
"Tag=Country;Name=CountryName >>> Member=Select * FROM States WHERE CountryCode IN (<%Parent.CountryCode%>);Key=StateCode;Name=St" +
"ateName;Tag=State ||| Member=Select * FROM Cities WHERE CountryCode IN (<%Parent.CountryCode%>);Tag=City;Name=Name >>> Member=Se" +
"lect * FROM Cities WHERE CountryCode IN (<%Parent.Parent.CountryCode%>) AND StateCode IN (<%Parent.StateCode%>);Tag=City;Name=Na" +
"me";
excascadetree1.Select = "US\\AK";
excascadetree1.EndUpdate();
|
|
26
|
FixCascadeMode Mode
// Error event - An internal error occurs.
private void excascadetree1_Error(object sender,int Err,string Description)
{
System.Diagnostics.Debug.Print( "Error" );
System.Diagnostics.Debug.Print( Description.ToString() );
}
//this.excascadetree1.Error += new exontrol.EXCASCADETREELib.exg2antt.ErrorEventHandler(this.excascadetree1_Error);
excascadetree1.BeginUpdate();
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exSplitBar,Color.FromArgb(196,196,196));
excascadetree1.DefColumnWidth = 96;
excascadetree1.Mode = exontrol.EXCASCADETREELib.CascadeModeEnum.exFixCascadeMode;
excascadetree1.DataSource = "Source=C:\\Program Files\\Exontrol\\ExCascadeTree\\Sample\\Access\\cities.accdb;Member=Select * FROM Countries;Key=CountryCode;" +
"Tag=Country;Name=CountryName >>> Member=Select * FROM States WHERE CountryCode IN (<%Parent.CountryCode%>);Key=StateCode;Name=St" +
"ateName;Tag=State ||| Member=Select * FROM Cities WHERE CountryCode IN (<%Parent.CountryCode%>);Tag=City;Name=Name >>> Member=Se" +
"lect * FROM Cities WHERE CountryCode IN (<%Parent.Parent.CountryCode%>) AND StateCode IN (<%Parent.StateCode%>);Tag=City;Name=Na" +
"me";
excascadetree1.Select = "US\\AK";
excascadetree1.EndUpdate();
|
|
25
|
SplitEqualCascadeMode Mode
// Error event - An internal error occurs.
private void excascadetree1_Error(object sender,int Err,string Description)
{
System.Diagnostics.Debug.Print( "Error" );
System.Diagnostics.Debug.Print( Description.ToString() );
}
//this.excascadetree1.Error += new exontrol.EXCASCADETREELib.exg2antt.ErrorEventHandler(this.excascadetree1_Error);
excascadetree1.BeginUpdate();
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exSplitBar,Color.FromArgb(196,196,196));
excascadetree1.Mode = exontrol.EXCASCADETREELib.CascadeModeEnum.exSplitEqualCascadeMode;
excascadetree1.DataSource = "Source=C:\\Program Files\\Exontrol\\ExCascadeTree\\Sample\\Access\\cities.accdb;Member=Select * FROM Countries;Key=CountryCode;" +
"Tag=Country;Name=CountryName >>> Member=Select * FROM States WHERE CountryCode IN (<%Parent.CountryCode%>);Key=StateCode;Name=St" +
"ateName;Tag=State ||| Member=Select * FROM Cities WHERE CountryCode IN (<%Parent.CountryCode%>);Tag=City;Name=Name >>> Member=Se" +
"lect * FROM Cities WHERE CountryCode IN (<%Parent.Parent.CountryCode%>) AND StateCode IN (<%Parent.StateCode%>);Tag=City;Name=Na" +
"me";
excascadetree1.Select = "US\\AK";
excascadetree1.EndUpdate();
|
|
24
|
Default Mode
// Error event - An internal error occurs.
private void excascadetree1_Error(object sender,int Err,string Description)
{
System.Diagnostics.Debug.Print( "Error" );
System.Diagnostics.Debug.Print( Description.ToString() );
}
//this.excascadetree1.Error += new exontrol.EXCASCADETREELib.exg2antt.ErrorEventHandler(this.excascadetree1_Error);
excascadetree1.BeginUpdate();
excascadetree1.set_Background(exontrol.EXCASCADETREELib.BackgroundPartEnum.exSplitBar,Color.FromArgb(196,196,196));
excascadetree1.DataSource = "Source=C:\\Program Files\\Exontrol\\ExCascadeTree\\Sample\\Access\\cities.accdb;Member=Select * FROM Countries;Key=CountryCode;" +
"Tag=Country;Name=CountryName >>> Member=Select * FROM States WHERE CountryCode IN (<%Parent.CountryCode%>);Key=StateCode;Name=St" +
"ateName;Tag=State ||| Member=Select * FROM Cities WHERE CountryCode IN (<%Parent.CountryCode%>);Tag=City;Name=Name >>> Member=Se" +
"lect * FROM Cities WHERE CountryCode IN (<%Parent.Parent.CountryCode%>) AND StateCode IN (<%Parent.StateCode%>);Tag=City;Name=Na" +
"me";
excascadetree1.Select = "US\\AK";
excascadetree1.EndUpdate();
|
|
23
|
SingleCascadeMode ( single-view )
// Error event - An internal error occurs.
private void excascadetree1_Error(object sender,int Err,string Description)
{
System.Diagnostics.Debug.Print( "Error" );
System.Diagnostics.Debug.Print( Description.ToString() );
}
//this.excascadetree1.Error += new exontrol.EXCASCADETREELib.exg2antt.ErrorEventHandler(this.excascadetree1_Error);
excascadetree1.BeginUpdate();
excascadetree1.Mode = exontrol.EXCASCADETREELib.CascadeModeEnum.exSingleCascadeMode;
exontrol.EXCASCADETREELib.View var_View = excascadetree1.get_DefaultView(null);
var_View.DataSource = "Source=C:\\Program Files\\Exontrol\\ExCascadeTree\\Sample\\Access\\cities.accdb;Member=Select * FROM Cities Where CountryCode =" +
" 'RO' ";
var_View.AllowGroupBy = true;
var_View.SortBarVisible = true;
var_View.Columns["StateCode"].SortOrder = exontrol.EXCASCADETREELib.SortOrderEnum.SortAscending;
var_View.Name = "Name";
excascadetree1.Name = "Isaccea";
excascadetree1.EndUpdate();
|
|
22
|
How can I display the current selection, as a path
// CreateView event - A view has been created.
private void excascadetree1_CreateView(object sender,exontrol.EXCASCADETREELib.View View)
{
excascadetree1.StatusBarLabel = excascadetree1.Name;
}
//this.excascadetree1.CreateView += new exontrol.EXCASCADETREELib.exg2antt.CreateViewEventHandler(this.excascadetree1_CreateView);
// Error event - An internal error occurs.
private void excascadetree1_Error(object sender,int Err,string Description)
{
System.Diagnostics.Debug.Print( "Error" );
System.Diagnostics.Debug.Print( Description.ToString() );
}
//this.excascadetree1.Error += new exontrol.EXCASCADETREELib.exg2antt.ErrorEventHandler(this.excascadetree1_Error);
// ViewEndChanging event - Occurs once the user is about to change the view.
private void excascadetree1_ViewEndChanging(object sender,exontrol.EXCASCADETREELib.ViewOperationEnum Operation)
{
excascadetree1.StatusBarLabel = excascadetree1.Name;
}
//this.excascadetree1.ViewEndChanging += new exontrol.EXCASCADETREELib.exg2antt.ViewEndChangingEventHandler(this.excascadetree1_ViewEndChanging);
excascadetree1.BeginUpdate();
excascadetree1.StatusBarVisible = exontrol.EXCASCADETREELib.StatusBarAnchorEnum.exStatusBarAnchorTop;
excascadetree1.Mode = exontrol.EXCASCADETREELib.CascadeModeEnum.exSplitFixCascadeMode;
excascadetree1.DataSource = "Source=C:\\Program Files\\Exontrol\\ExCascadeTree\\Sample\\Access\\cities.accdb;Member=Select * FROM Countries;Key=CountryCode;" +
"Tag=Country;Name=CountryName >>> Member=Select * FROM States WHERE CountryCode IN (<%Parent.CountryCode%>);Key=StateCode;Name=St" +
"ateName;Tag=State ||| Member=Select * FROM Cities WHERE CountryCode IN (<%Parent.CountryCode%>);Tag=City;Name=Name >>> Member=Se" +
"lect * FROM Cities WHERE CountryCode IN (<%Parent.Parent.CountryCode%>) AND StateCode IN (<%Parent.StateCode%>);Tag=City;Name=Na" +
"me";
excascadetree1.Select = "US\\AK";
excascadetree1.EndUpdate();
|
|
21
|
How can I add multiple-views to the control
// Error event - An internal error occurs.
private void excascadetree1_Error(object sender,int Err,string Description)
{
System.Diagnostics.Debug.Print( "Error" );
System.Diagnostics.Debug.Print( Description.ToString() );
}
//this.excascadetree1.Error += new exontrol.EXCASCADETREELib.exg2antt.ErrorEventHandler(this.excascadetree1_Error);
excascadetree1.BeginUpdate();
excascadetree1.Mode = exontrol.EXCASCADETREELib.CascadeModeEnum.exSplitFixCascadeMode;
excascadetree1.DataSource = "Source=C:\\Program Files\\Exontrol\\ExCascadeTree\\Sample\\Access\\cities.accdb;Member=Select * FROM Countries;Key=CountryCode;" +
"Tag=Country;Name=CountryName >>> Member=Select * FROM States WHERE CountryCode IN (<%Parent.CountryCode%>);Key=StateCode;Name=St" +
"ateName;Tag=State ||| Member=Select * FROM Cities WHERE CountryCode IN (<%Parent.CountryCode%>);Tag=City;Name=Name >>> Member=Se" +
"lect * FROM Cities WHERE CountryCode IN (<%Parent.Parent.CountryCode%>) AND StateCode IN (<%Parent.StateCode%>);Tag=City;Name=Na" +
"me";
excascadetree1.Select = "US\\AK";
excascadetree1.EndUpdate();
|
|
20
|
I wish I select items based on names, rather than keys. Is that possible
// CreateView event - A view has been created.
private void excascadetree1_CreateView(object sender,exontrol.EXCASCADETREELib.View View)
{
excascadetree1.View.ColumnAutoResize = false;
object label = excascadetree1.FormatABC("`<b>Select = </b>` + value",excascadetree1.Select,null,null);
label = excascadetree1.FormatABC("A + `<br>` + `<b>Name = </b>` + B replace `|` with ` `",label,excascadetree1.Name,null);
excascadetree1.StatusBarLabel = label.ToString();
}
//this.excascadetree1.CreateView += new exontrol.EXCASCADETREELib.exg2antt.CreateViewEventHandler(this.excascadetree1_CreateView);
// Error event - An internal error occurs.
private void excascadetree1_Error(object sender,int Err,string Description)
{
System.Diagnostics.Debug.Print( "Error" );
System.Diagnostics.Debug.Print( Description.ToString() );
}
//this.excascadetree1.Error += new exontrol.EXCASCADETREELib.exg2antt.ErrorEventHandler(this.excascadetree1_Error);
// ViewEndChanging event - Occurs once the user is about to change the view.
private void excascadetree1_ViewEndChanging(object sender,exontrol.EXCASCADETREELib.ViewOperationEnum Operation)
{
object label = excascadetree1.FormatABC("`<b>Select = </b>` + value",excascadetree1.Select,null,null);
label = excascadetree1.FormatABC("A + `<br>` + `<b>Name = </b>` + B replace `|` with ` `",label,excascadetree1.Name,null);
excascadetree1.StatusBarLabel = label.ToString();
}
//this.excascadetree1.ViewEndChanging += new exontrol.EXCASCADETREELib.exg2antt.ViewEndChangingEventHandler(this.excascadetree1_ViewEndChanging);
excascadetree1.BeginUpdate();
excascadetree1.Mode = exontrol.EXCASCADETREELib.CascadeModeEnum.exSplitEqualCascadeMode;
excascadetree1.StatusBarVisible = exontrol.EXCASCADETREELib.StatusBarAnchorEnum.exStatusBarWordWrap | exontrol.EXCASCADETREELib.StatusBarAnchorEnum.exStatusBarAnchorTop;
string ds = "Source=C:\\Program Files\\Exontrol\\ExCascadeTree\\Sample\\Access\\cities.accdb";
string dm1 = "Member=Select * FROM Countries;Key=CountryCode;Tag=Country;Name=CountryName";
ds = excascadetree1.FormatABC("A + `;` + B",ds,dm1,null);
string dm2 = "Member=Select * FROM States WHERE CountryCode IN (<%Parent.CountryCode%>);Key=StateCode;Name=StateName;Tag=State ||| Member=Sel" +
"ect * FROM Cities WHERE CountryCode IN (<%Parent.CountryCode%>);Tag=City;Name=Name";
ds = excascadetree1.FormatABC("A + ` >>> ` + B",ds,dm2,null);
string dm3 = "Member=Select * FROM Cities WHERE CountryCode IN (<%Parent.Parent.CountryCode%>) AND StateCode IN (<%Parent.StateCode%>);Tag=Ci" +
"ty;Name=Name";
ds = excascadetree1.FormatABC("A + ` >>> ` + B",ds,dm3,null);
excascadetree1.DataSource = ds;
excascadetree1.Name = "Romania\\Cluj\\Baciu*";
excascadetree1.EndUpdate();
|
|
19
|
I've noticed that I can't select multiple items. How can I do that
// CreateView event - A view has been created.
private void excascadetree1_CreateView(object sender,exontrol.EXCASCADETREELib.View View)
{
object bColumnAutoResize = excascadetree1.FormatABC("not(A = `City`)",excascadetree1.View.Tag,null,null);
exontrol.EXCASCADETREELib.View var_View = excascadetree1.View;
var_View.SingleSel = false;
var_View.ColumnAutoResize = false;
object label = excascadetree1.FormatABC("`<b>Select = </b>` + value",excascadetree1.Select,null,null);
label = excascadetree1.FormatABC("A + `<br>` + `<b>Name = </b>` + B replace `|` with ` `",label,excascadetree1.Name,null);
excascadetree1.StatusBarLabel = label.ToString();
}
//this.excascadetree1.CreateView += new exontrol.EXCASCADETREELib.exg2antt.CreateViewEventHandler(this.excascadetree1_CreateView);
// Error event - An internal error occurs.
private void excascadetree1_Error(object sender,int Err,string Description)
{
System.Diagnostics.Debug.Print( "Error" );
System.Diagnostics.Debug.Print( Description.ToString() );
}
//this.excascadetree1.Error += new exontrol.EXCASCADETREELib.exg2antt.ErrorEventHandler(this.excascadetree1_Error);
// ViewEndChanging event - Occurs once the user is about to change the view.
private void excascadetree1_ViewEndChanging(object sender,exontrol.EXCASCADETREELib.ViewOperationEnum Operation)
{
object label = excascadetree1.FormatABC("`<b>Select = </b>` + value",excascadetree1.Select,null,null);
label = excascadetree1.FormatABC("A + `<br>` + `<b>Name = </b>` + B replace `|` with ` `",label,excascadetree1.Name,null);
excascadetree1.StatusBarLabel = label.ToString();
}
//this.excascadetree1.ViewEndChanging += new exontrol.EXCASCADETREELib.exg2antt.ViewEndChangingEventHandler(this.excascadetree1_ViewEndChanging);
excascadetree1.BeginUpdate();
excascadetree1.Mode = exontrol.EXCASCADETREELib.CascadeModeEnum.exSplitEqualCascadeMode;
excascadetree1.StatusBarVisible = exontrol.EXCASCADETREELib.StatusBarAnchorEnum.exStatusBarWordWrap | exontrol.EXCASCADETREELib.StatusBarAnchorEnum.exStatusBarAnchorTop;
excascadetree1.StatusBarHeight = 48;
string ds = "Source=C:\\Program Files\\Exontrol\\ExCascadeTree\\Sample\\Access\\cities.accdb";
string dm1 = "Member=Select * FROM Countries;Key=CountryCode;Tag=Country;Name=CountryName";
ds = excascadetree1.FormatABC("A + `;` + B",ds,dm1,null);
string dm2 = "Member=Select * FROM States WHERE CountryCode IN (<%Parent.CountryCode%>);Key=StateCode;Name=StateName;Tag=State ||| Member=Sel" +
"ect * FROM Cities WHERE CountryCode IN (<%Parent.CountryCode%>);Tag=City;Name=Name";
ds = excascadetree1.FormatABC("A + ` >>> ` + B",ds,dm2,null);
string dm3 = "Member=Select * FROM Cities WHERE CountryCode IN (<%Parent.Parent.CountryCode%>) AND StateCode IN (<%Parent.StateCode%>);Tag=Ci" +
"ty;Name=Name";
ds = excascadetree1.FormatABC("A + ` >>> ` + B",ds,dm3,null);
excascadetree1.DataSource = ds;
excascadetree1.Select = "RO\\CJ|D*";
excascadetree1.EndUpdate();
|
|
18
|
How do I programmatically selects a path/item
// CreateView event - A view has been created.
private void excascadetree1_CreateView(object sender,exontrol.EXCASCADETREELib.View View)
{
object bColumnAutoResize = excascadetree1.FormatABC("not(A = `City`)",excascadetree1.View.Tag,null,null);
excascadetree1.View.ColumnAutoResize = false;
}
//this.excascadetree1.CreateView += new exontrol.EXCASCADETREELib.exg2antt.CreateViewEventHandler(this.excascadetree1_CreateView);
// Error event - An internal error occurs.
private void excascadetree1_Error(object sender,int Err,string Description)
{
System.Diagnostics.Debug.Print( "Error" );
System.Diagnostics.Debug.Print( Description.ToString() );
}
//this.excascadetree1.Error += new exontrol.EXCASCADETREELib.exg2antt.ErrorEventHandler(this.excascadetree1_Error);
// ViewEndChanging event - Occurs once the user is about to change the view.
private void excascadetree1_ViewEndChanging(object sender,exontrol.EXCASCADETREELib.ViewOperationEnum Operation)
{
excascadetree1.StatusBarLabel = excascadetree1.Select;
}
//this.excascadetree1.ViewEndChanging += new exontrol.EXCASCADETREELib.exg2antt.ViewEndChangingEventHandler(this.excascadetree1_ViewEndChanging);
excascadetree1.BeginUpdate();
excascadetree1.Mode = exontrol.EXCASCADETREELib.CascadeModeEnum.exSplitEqualCascadeMode;
excascadetree1.StatusBarVisible = exontrol.EXCASCADETREELib.StatusBarAnchorEnum.exStatusBarAnchorBottom;
string ds = "Source=C:\\Program Files\\Exontrol\\ExCascadeTree\\Sample\\Access\\cities.accdb";
string dm1 = "Member=Select * FROM Countries;Key=CountryCode;Tag=Country";
ds = excascadetree1.FormatABC("A + `;` + B",ds,dm1,null);
string dm2 = "Member=Select * FROM States WHERE CountryCode IN (<%Parent.CountryCode%>);Key=StateCode;Tag=State ||| Member=Select * FROM Citi" +
"es WHERE CountryCode IN (<%Parent.CountryCode%>);Tag=City";
ds = excascadetree1.FormatABC("A + ` >>> ` + B",ds,dm2,null);
string dm3 = "Member=Select * FROM Cities WHERE CountryCode IN (<%Parent.Parent.CountryCode%>) AND StateCode IN (<%Parent.StateCode%>);Tag=Ci" +
"ty";
ds = excascadetree1.FormatABC("A + ` >>> ` + B",ds,dm3,null);
excascadetree1.DataSource = ds;
excascadetree1.Select = "RO\\CJ";
excascadetree1.EndUpdate();
|
|
17
|
DataSource/DataMember/Key/Tag
// CreateView event - A view has been created.
private void excascadetree1_CreateView(object sender,exontrol.EXCASCADETREELib.View View)
{
excascadetree1.StatusBarLabel = excascadetree1.FormatABC("value replace `data source` with `<b><fgcolor=808080>Source</fgcolor></b>` replace `Source` with `<b><fgcolor=808080>Source</fg" +
"color></b>` replace `Member` with `<b><fgcolor=808080>Member</fgcolor></b>` replace `Key` with `<b><fgcolor=808080>Key</fgcolor>" +
"</b>` replace `Tag` with `<b><fgcolor=808080>Tag</fgcolor></b>` replace `;` with `;<br>`",excascadetree1.View.DataSource,null,null).ToString();
object bColumnAutoResize = excascadetree1.FormatABC("not(A = `City`)",excascadetree1.View.Tag,null,null);
object nWidth = excascadetree1.FormatABC("A = `City` ? B : C",excascadetree1.View.Tag,excascadetree1.View.WidthToFit,excascadetree1.View.Width);
exontrol.EXCASCADETREELib.View var_View = excascadetree1.View;
var_View.ColumnAutoResize = false;
var_View.Width = nWidth;
}
//this.excascadetree1.CreateView += new exontrol.EXCASCADETREELib.exg2antt.CreateViewEventHandler(this.excascadetree1_CreateView);
// Error event - An internal error occurs.
private void excascadetree1_Error(object sender,int Err,string Description)
{
System.Diagnostics.Debug.Print( "Error" );
System.Diagnostics.Debug.Print( Description.ToString() );
}
//this.excascadetree1.Error += new exontrol.EXCASCADETREELib.exg2antt.ErrorEventHandler(this.excascadetree1_Error);
excascadetree1.BeginUpdate();
excascadetree1.StatusBarHeight = 58;
excascadetree1.StatusBarVisible = exontrol.EXCASCADETREELib.StatusBarAnchorEnum.exStatusBarWordWrap | exontrol.EXCASCADETREELib.StatusBarAnchorEnum.exStatusBarAnchorTop;
string ds = "Source=C:\\Program Files\\Exontrol\\ExCascadeTree\\Sample\\Access\\cities.accdb";
string dm1 = "Member=Select * FROM Countries;Key=CountryCode;Tag=Country";
ds = excascadetree1.FormatABC("A + `;` + B",ds,dm1,null);
string dm2 = "Member=Select * FROM States WHERE CountryCode IN (<%Parent.CountryCode%>);Key=StateCode;Tag=State ||| Member=Select * FROM Citi" +
"es WHERE CountryCode IN (<%Parent.CountryCode%>);Tag=City";
ds = excascadetree1.FormatABC("A + ` >>> ` + B",ds,dm2,null);
string dm3 = "Member=Select * FROM Cities WHERE CountryCode IN (<%Parent.Parent.CountryCode%>) AND StateCode IN (<%Parent.StateCode%>);Tag=Ci" +
"ty";
ds = excascadetree1.FormatABC("A + ` >>> ` + B",ds,dm3,null);
excascadetree1.DataSource = ds;
excascadetree1.EndUpdate();
|
|
16
|
DataSource (view, data source, data member, ACCDB)
// Error event - An internal error occurs.
private void excascadetree1_Error(object sender,int Err,string Description)
{
System.Diagnostics.Debug.Print( "Error" );
System.Diagnostics.Debug.Print( Description.ToString() );
}
//this.excascadetree1.Error += new exontrol.EXCASCADETREELib.exg2antt.ErrorEventHandler(this.excascadetree1_Error);
excascadetree1.BeginUpdate();
excascadetree1.StatusBarVisible = exontrol.EXCASCADETREELib.StatusBarAnchorEnum.exStatusBarAnchorTop;
excascadetree1.StatusBarLabel = "<b>DataSource</b> could \"Data Source=...;Data Member=...\" or \"Source=...;Member=...\" ";
excascadetree1.DefColumnWidth = 336;
string ds = "Data Source=C:\\Program Files\\Exontrol\\ExCascadeTree\\Sample\\Access\\cities.accdb";
string dm = "Data Member=Select * FROM Countries";
exontrol.EXCASCADETREELib.View var_View = excascadetree1.get_DefaultView(null);
var_View.DataSource = excascadetree1.FormatABC("A + `;` + B",ds,dm,null);
var_View.ColumnAutoResize = true;
excascadetree1.EndUpdate();
|
|
15
|
DataSource (view, data source, data member, MDB)
// Error event - An internal error occurs.
private void excascadetree1_Error(object sender,int Err,string Description)
{
System.Diagnostics.Debug.Print( "Error" );
System.Diagnostics.Debug.Print( Description.ToString() );
}
//this.excascadetree1.Error += new exontrol.EXCASCADETREELib.exg2antt.ErrorEventHandler(this.excascadetree1_Error);
excascadetree1.BeginUpdate();
excascadetree1.StatusBarVisible = exontrol.EXCASCADETREELib.StatusBarAnchorEnum.exStatusBarAnchorTop;
excascadetree1.StatusBarLabel = "<b>DataSource</b> could \"Data Source=...;Data Member=...\" or \"Source=...;Member=...\" ";
excascadetree1.DefColumnWidth = 336;
string ds = "Data Source=C:\\Program Files\\Exontrol\\ExCascadeTree\\Sample\\Access\\cities.mdb";
string dm = "Data Member=Select * FROM Countries";
exontrol.EXCASCADETREELib.View var_View = excascadetree1.get_DefaultView(null);
var_View.DataSource = excascadetree1.FormatABC("A + `;` + B",ds,dm,null);
var_View.ColumnAutoResize = true;
excascadetree1.EndUpdate();
|
|
14
|
DataSource (view, ADODB, ACCDB)
// Error event - An internal error occurs.
private void excascadetree1_Error(object sender,int Err,string Description)
{
System.Diagnostics.Debug.Print( "Error" );
System.Diagnostics.Debug.Print( Description.ToString() );
}
//this.excascadetree1.Error += new exontrol.EXCASCADETREELib.exg2antt.ErrorEventHandler(this.excascadetree1_Error);
excascadetree1.BeginUpdate();
excascadetree1.StatusBarVisible = exontrol.EXCASCADETREELib.StatusBarAnchorEnum.exStatusBarAnchorTop;
excascadetree1.StatusBarLabel = "<b>DataSource</b> could be string (Source/Member), ADO or DAO objects";
excascadetree1.DefColumnWidth = 336;
// Add 'Microsoft ActiveX Data Objects 6.1 Library(msado15.dll)' reference to your project.
ADODB.Recordset ado = new ADODB.Recordset();
ado.Open("Countries","Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Program Files\\Exontrol\\ExCascadeTree\\Sample\\Access\\cities.accdb",exontrol.ADODB.CursorTypeEnum.adOpenStatic,exontrol.ADODB.LockTypeEnum.adLockOptimistic,0);
exontrol.EXCASCADETREELib.View var_View = excascadetree1.get_DefaultView(null);
var_View.DataSource = (ado as ADODB.Recordset);
var_View.ColumnAutoResize = true;
excascadetree1.EndUpdate();
|
|
13
|
DataSource (view, ADODB, MDB)
// Error event - An internal error occurs.
private void excascadetree1_Error(object sender,int Err,string Description)
{
System.Diagnostics.Debug.Print( "Error" );
System.Diagnostics.Debug.Print( Description.ToString() );
}
//this.excascadetree1.Error += new exontrol.EXCASCADETREELib.exg2antt.ErrorEventHandler(this.excascadetree1_Error);
excascadetree1.BeginUpdate();
excascadetree1.StatusBarVisible = exontrol.EXCASCADETREELib.StatusBarAnchorEnum.exStatusBarAnchorTop;
excascadetree1.StatusBarLabel = "<b>DataSource</b> could be string (Source/Member), ADO or DAO objects";
excascadetree1.DefColumnWidth = 336;
// Add 'Microsoft ActiveX Data Objects 6.1 Library(msado15.dll)' reference to your project.
ADODB.Recordset ado = new ADODB.Recordset();
ado.Open("Countries","Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Program Files\\Exontrol\\ExCascadeTree\\Sample\\Access\\cities.mdb",exontrol.ADODB.CursorTypeEnum.adOpenStatic,exontrol.ADODB.LockTypeEnum.adLockOptimistic,0);
exontrol.EXCASCADETREELib.View var_View = excascadetree1.get_DefaultView(null);
var_View.DataSource = (ado as ADODB.Recordset);
var_View.ColumnAutoResize = true;
excascadetree1.EndUpdate();
|
|
12
|
DataSource (control, data source, data member, ACCDB)
// Error event - An internal error occurs.
private void excascadetree1_Error(object sender,int Err,string Description)
{
System.Diagnostics.Debug.Print( "Error" );
System.Diagnostics.Debug.Print( Description.ToString() );
}
//this.excascadetree1.Error += new exontrol.EXCASCADETREELib.exg2antt.ErrorEventHandler(this.excascadetree1_Error);
excascadetree1.BeginUpdate();
excascadetree1.StatusBarVisible = exontrol.EXCASCADETREELib.StatusBarAnchorEnum.exStatusBarAnchorTop;
excascadetree1.StatusBarLabel = "<b>DataSource</b> could \"Data Source=...;Data Member=...\" or \"Source=...;Member=...\" ";
excascadetree1.DefColumnWidth = 336;
string ds = "Data Source=C:\\Program Files\\Exontrol\\ExCascadeTree\\Sample\\Access\\cities.accdb";
string dm = "Data Member=Select * FROM Countries";
excascadetree1.DataSource = excascadetree1.FormatABC("A + `;` + B",ds,dm,null);
excascadetree1.View.ColumnAutoResize = true;
excascadetree1.EndUpdate();
|
|
11
|
DataSource (control, data source, data member, MDB)
// Error event - An internal error occurs.
private void excascadetree1_Error(object sender,int Err,string Description)
{
System.Diagnostics.Debug.Print( "Error" );
System.Diagnostics.Debug.Print( Description.ToString() );
}
//this.excascadetree1.Error += new exontrol.EXCASCADETREELib.exg2antt.ErrorEventHandler(this.excascadetree1_Error);
excascadetree1.BeginUpdate();
excascadetree1.StatusBarVisible = exontrol.EXCASCADETREELib.StatusBarAnchorEnum.exStatusBarAnchorTop;
excascadetree1.StatusBarLabel = "<b>DataSource</b> could \"Data Source=...;Data Member=...\" or \"Source=...;Member=...\" ";
excascadetree1.DefColumnWidth = 336;
string ds = "Data Source=C:\\Program Files\\Exontrol\\ExCascadeTree\\Sample\\Access\\cities.mdb";
string dm = "Data Member=Select * FROM Countries";
excascadetree1.DataSource = excascadetree1.FormatABC("A + `;` + B",ds,dm,null);
excascadetree1.View.ColumnAutoResize = true;
excascadetree1.EndUpdate();
|
|
10
|
DataSource (control, ADODB, ACCDB)
// Error event - An internal error occurs.
private void excascadetree1_Error(object sender,int Err,string Description)
{
System.Diagnostics.Debug.Print( "Error" );
System.Diagnostics.Debug.Print( Description.ToString() );
}
//this.excascadetree1.Error += new exontrol.EXCASCADETREELib.exg2antt.ErrorEventHandler(this.excascadetree1_Error);
excascadetree1.BeginUpdate();
excascadetree1.StatusBarVisible = exontrol.EXCASCADETREELib.StatusBarAnchorEnum.exStatusBarAnchorTop;
excascadetree1.StatusBarLabel = "<b>DataSource</b> could be string (Source/Member), ADO or DAO objects";
excascadetree1.DefColumnWidth = 336;
// Add 'Microsoft ActiveX Data Objects 6.1 Library(msado15.dll)' reference to your project.
ADODB.Recordset ado = new ADODB.Recordset();
ado.Open("Countries","Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Program Files\\Exontrol\\ExCascadeTree\\Sample\\Access\\cities.accdb",exontrol.ADODB.CursorTypeEnum.adOpenStatic,exontrol.ADODB.LockTypeEnum.adLockOptimistic,0);
excascadetree1.DataSource = (ado as ADODB.Recordset);
excascadetree1.View.ColumnAutoResize = true;
excascadetree1.EndUpdate();
|
|
9
|
DataSource (control, ADODB, MDB)
// Error event - An internal error occurs.
private void excascadetree1_Error(object sender,int Err,string Description)
{
System.Diagnostics.Debug.Print( "Error" );
System.Diagnostics.Debug.Print( Description.ToString() );
}
//this.excascadetree1.Error += new exontrol.EXCASCADETREELib.exg2antt.ErrorEventHandler(this.excascadetree1_Error);
excascadetree1.BeginUpdate();
excascadetree1.StatusBarVisible = exontrol.EXCASCADETREELib.StatusBarAnchorEnum.exStatusBarAnchorTop;
excascadetree1.StatusBarLabel = "<b>DataSource</b> could be string (Source/Member), ADO or DAO objects";
excascadetree1.DefColumnWidth = 336;
// Add 'Microsoft ActiveX Data Objects 6.1 Library(msado15.dll)' reference to your project.
ADODB.Recordset ado = new ADODB.Recordset();
ado.Open("Countries","Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Program Files\\Exontrol\\ExCascadeTree\\Sample\\Access\\cities.mdb",exontrol.ADODB.CursorTypeEnum.adOpenStatic,exontrol.ADODB.LockTypeEnum.adLockOptimistic,0);
excascadetree1.DataSource = (ado as ADODB.Recordset);
excascadetree1.View.ColumnAutoResize = true;
excascadetree1.EndUpdate();
|
|
8
|
DataSource (view, XMLDOMDocument)
// Error event - An internal error occurs.
private void excascadetree1_Error(object sender,int Err,string Description)
{
System.Diagnostics.Debug.Print( "Error" );
System.Diagnostics.Debug.Print( Description.ToString() );
}
//this.excascadetree1.Error += new exontrol.EXCASCADETREELib.exg2antt.ErrorEventHandler(this.excascadetree1_Error);
excascadetree1.BeginUpdate();
excascadetree1.StatusBarVisible = exontrol.EXCASCADETREELib.StatusBarAnchorEnum.exStatusBarAnchorTop;
excascadetree1.StatusBarLabel = "<b>DataSource</b> could be a XML file name, a URL, an IStream, an IXMLDOMDocument";
excascadetree1.DefColumnWidth = 336;
exontrol.EXCASCADETREELib.View var_View = excascadetree1.get_DefaultView(null);
// Add 'Microsoft XML, v3.0(msxml3.dll)' reference to your project.
MSXML2.FreeThreadedDOMDocument30 xml = new MSXML2.FreeThreadedDOMDocument30();
xml.load("C:\\Program Files\\Exontrol\\ExCascadeTree\\Sample\\Testing.xml");
var_View.DataSource = (xml as MSXML2.FreeThreadedDOMDocument30);
var_View.ColumnAutoResize = true;
excascadetree1.EndUpdate();
|
|
7
|
DataSource (view, XML, file)
// Error event - An internal error occurs.
private void excascadetree1_Error(object sender,int Err,string Description)
{
System.Diagnostics.Debug.Print( "Error" );
System.Diagnostics.Debug.Print( Description.ToString() );
}
//this.excascadetree1.Error += new exontrol.EXCASCADETREELib.exg2antt.ErrorEventHandler(this.excascadetree1_Error);
excascadetree1.BeginUpdate();
excascadetree1.StatusBarVisible = exontrol.EXCASCADETREELib.StatusBarAnchorEnum.exStatusBarAnchorTop;
excascadetree1.StatusBarLabel = "<b>DataSource</b> could be a XML file name, a URL, an IStream, an IXMLDOMDocument";
excascadetree1.DefColumnWidth = 336;
exontrol.EXCASCADETREELib.View var_View = excascadetree1.get_DefaultView(null);
var_View.DataSource = "http://www.exontrol.net/testing.xml";
var_View.ColumnAutoResize = true;
excascadetree1.EndUpdate();
|
|
6
|
DataSource (control, XMLDOMDocument)
// Error event - An internal error occurs.
private void excascadetree1_Error(object sender,int Err,string Description)
{
System.Diagnostics.Debug.Print( "Error" );
System.Diagnostics.Debug.Print( Description.ToString() );
}
//this.excascadetree1.Error += new exontrol.EXCASCADETREELib.exg2antt.ErrorEventHandler(this.excascadetree1_Error);
excascadetree1.BeginUpdate();
excascadetree1.StatusBarVisible = exontrol.EXCASCADETREELib.StatusBarAnchorEnum.exStatusBarAnchorTop;
excascadetree1.StatusBarLabel = "<b>DataSource</b> could be a XML file name, a URL, an IStream, an IXMLDOMDocument";
excascadetree1.DefColumnWidth = 336;
// Add 'Microsoft XML, v3.0(msxml3.dll)' reference to your project.
MSXML2.FreeThreadedDOMDocument30 xml = new MSXML2.FreeThreadedDOMDocument30();
xml.load("C:\\Program Files\\Exontrol\\ExCascadeTree\\Sample\\Testing.xml");
excascadetree1.DataSource = (xml as MSXML2.FreeThreadedDOMDocument30);
excascadetree1.View.ColumnAutoResize = true;
excascadetree1.EndUpdate();
|
|
5
|
DataSource (control, XML, file)
// Error event - An internal error occurs.
private void excascadetree1_Error(object sender,int Err,string Description)
{
System.Diagnostics.Debug.Print( "Error" );
System.Diagnostics.Debug.Print( Description.ToString() );
}
//this.excascadetree1.Error += new exontrol.EXCASCADETREELib.exg2antt.ErrorEventHandler(this.excascadetree1_Error);
excascadetree1.BeginUpdate();
excascadetree1.StatusBarVisible = exontrol.EXCASCADETREELib.StatusBarAnchorEnum.exStatusBarAnchorTop;
excascadetree1.StatusBarLabel = "<b>DataSource</b> could be a XML file name, a URL, an IStream, an IXMLDOMDocument";
excascadetree1.DefColumnWidth = 336;
excascadetree1.DataSource = "http://www.exontrol.net/testing.xml";
excascadetree1.View.ColumnAutoResize = true;
excascadetree1.EndUpdate();
|
|
4
|
How can I get the selected items (sample 1)
// CreateView event - A view has been created.
private void excascadetree1_CreateView(object sender,exontrol.EXCASCADETREELib.View View)
{
exontrol.EXCASCADETREELib.View var_View = excascadetree1.View;
object k = var_View.ParentView.get_Value(null);
var_View.BeginUpdate();
var_View.ColumnAutoResize = true;
var_View.Key = -1;
var_View.Columns.Add(k.ToString());
exontrol.EXCASCADETREELib.Items var_Items = var_View.Items;
var_Items.AddItem(excascadetree1.FormatABC("A + `-> Sub-Item 1`",k,null,null));
var_Items.AddItem(excascadetree1.FormatABC("A + `-> Sub-Item 2`",k,null,null));
var_Items.AddItem(excascadetree1.FormatABC("A + `-> Sub-Item 3`",k,null,null));
var_View.EndUpdate();
}
//this.excascadetree1.CreateView += new exontrol.EXCASCADETREELib.exg2antt.CreateViewEventHandler(this.excascadetree1_CreateView);
// ViewEndChanging event - Occurs once the user is about to change the view.
private void excascadetree1_ViewEndChanging(object sender,exontrol.EXCASCADETREELib.ViewOperationEnum Operation)
{
System.Diagnostics.Debug.Print( "End" );
System.Diagnostics.Debug.Print( Operation.ToString() );
exontrol.EXCASCADETREELib.Items var_Items = excascadetree1.View.Items;
System.Diagnostics.Debug.Print( "FocusItem" );
System.Diagnostics.Debug.Print( var_Items.get_CellCaption(var_Items.FocusItem,0) );
System.Diagnostics.Debug.Print( "SelectedItem" );
System.Diagnostics.Debug.Print( var_Items.get_CellCaption(var_Items.get_SelectedItem(0),0) );
}
//this.excascadetree1.ViewEndChanging += new exontrol.EXCASCADETREELib.exg2antt.ViewEndChangingEventHandler(this.excascadetree1_ViewEndChanging);
// ViewStartChanging event - Occurs once the user is about to change the view.
private void excascadetree1_ViewStartChanging(object sender,exontrol.EXCASCADETREELib.ViewOperationEnum Operation)
{
System.Diagnostics.Debug.Print( "Start" );
System.Diagnostics.Debug.Print( Operation.ToString() );
}
//this.excascadetree1.ViewStartChanging += new exontrol.EXCASCADETREELib.exg2antt.ViewStartChangingEventHandler(this.excascadetree1_ViewStartChanging);
excascadetree1.BeginUpdate();
exontrol.EXCASCADETREELib.View var_View = excascadetree1.View;
var_View.BeginUpdate();
var_View.ColumnAutoResize = true;
var_View.Columns.Add("Default");
var_View.Key = 0;
var_View.LinesAtRoot = exontrol.EXCASCADETREELib.LinesAtRootEnum.exLinesAtRoot;
exontrol.EXCASCADETREELib.Items var_Items = var_View.Items;
var_Items.AddItem("Item A");
var_Items.set_SelectItem(var_Items.AddItem("Item B"),true);
var_Items.AddItem("Item C");
var_View.EndUpdate();
excascadetree1.EndUpdate();
|
|
3
|
Can I use this control as a simple tree
excascadetree1.BeginUpdate();
excascadetree1.Mode = exontrol.EXCASCADETREELib.CascadeModeEnum.exSingleCascadeMode;
exontrol.EXCASCADETREELib.View var_View = excascadetree1.View;
var_View.BeginUpdate();
var_View.ColumnAutoResize = true;
var_View.Columns.Add("Default");
var_View.Key = -1;
var_View.LinesAtRoot = exontrol.EXCASCADETREELib.LinesAtRootEnum.exLinesAtRoot;
exontrol.EXCASCADETREELib.Items var_Items = var_View.Items;
var_Items.AddItem("Item A");
var_Items.InsertItem(var_Items.AddItem("Item B"),null,"Child");
var_Items.AddItem("Item C");
var_View.EndUpdate();
excascadetree1.EndUpdate();
|
|
2
|
How can I use this control
// CreateView event - A view has been created.
private void excascadetree1_CreateView(object sender,exontrol.EXCASCADETREELib.View View)
{
exontrol.EXCASCADETREELib.View var_View = excascadetree1.View;
object k = var_View.ParentView.get_Value(null);
var_View.BeginUpdate();
var_View.ColumnAutoResize = true;
var_View.Columns.Add(k.ToString());
exontrol.EXCASCADETREELib.Items var_Items = var_View.Items;
var_Items.AddItem(excascadetree1.FormatABC("A + `-> Sub-Item 1`",k,null,null));
var_Items.AddItem(excascadetree1.FormatABC("A + `-> Sub-Item 2`",k,null,null));
var_Items.AddItem(excascadetree1.FormatABC("A + `-> Sub-Item 3`",k,null,null));
var_View.EndUpdate();
}
//this.excascadetree1.CreateView += new exontrol.EXCASCADETREELib.exg2antt.CreateViewEventHandler(this.excascadetree1_CreateView);
excascadetree1.BeginUpdate();
exontrol.EXCASCADETREELib.View var_View = excascadetree1.View;
var_View.BeginUpdate();
var_View.ColumnAutoResize = true;
var_View.Columns.Add("Default");
var_View.Key = 0;
exontrol.EXCASCADETREELib.Items var_Items = var_View.Items;
var_Items.AddItem("Item A");
var_Items.set_SelectItem(var_Items.AddItem("Item B"),true);
var_Items.AddItem("Item C");
var_View.EndUpdate();
excascadetree1.EndUpdate();
|
|
1
|
How do I change the control's background color
excascadetree1.BackColor = Color.FromArgb(240,240,240);
|