76ad5bec-9652-474d-be71-f0c58f4ad0bd Jiwa Grid Extensions Adds some extension methods to the Jiwa Grid to allow easy Delete, Rename and Hide of columns true false 0 Stuart Barnes

using Microsoft.VisualBasic;
using System;
using System.Collections;
using System.Collections.Generic;
using System.Data;
using System.Diagnostics;
using JiwaFinancials.Jiwa;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.Drawing;
using ServiceStack;
using ServiceStack.DataAnnotations;
using ServiceStack.Model;

public static class JiwaGridExtensions
{

  
  public static void DeleteColumn(this JiwaFinancials.Jiwa.JiwaApplication.Controls.JiwaGrid Grid, string ColumnName)
  {
     FarPoint.Win.Spread.Column columnToRemove = Grid.ActiveSheet.GetColumnFromTag(null, ColumnName);
        Grid.ActiveSheet.Columns.Remove(columnToRemove.Index, 1);
  }
  
  
  public static void HideColumn(this JiwaFinancials.Jiwa.JiwaApplication.Controls.JiwaGrid Grid, string ColumnName, bool Hide = true)
  {
      FarPoint.Win.Spread.Column columnToHide = Grid.ActiveSheet.GetColumnFromTag(null, ColumnName);
         Grid.ActiveSheet.Columns[columnToHide.Index].Visible = !Hide;
  }
  
  
  public static void RenameColumn(this JiwaFinancials.Jiwa.JiwaApplication.Controls.JiwaGrid Grid, string ColumnName , string NewColumnName)
  {
     FarPoint.Win.Spread.Column columnToRename = Grid.ActiveSheet.GetColumnFromTag(null, ColumnName);
        columnToRename.Tag = NewColumnName;
  }
  
  public static void ChangeColumnCaption(this JiwaFinancials.Jiwa.JiwaApplication.Controls.JiwaGrid Grid, string ColumnName , string NewCaption)
  {
     FarPoint.Win.Spread.Column columnToRename = Grid.ActiveSheet.GetColumnFromTag(null, ColumnName);
        columnToRename.Label  = NewCaption;
  }      
  
}

Report CSharp e0fa5a8b-ea94-4535-aae4-5c5054286dac JiwaApplication, Version=7.1.0.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaApplication.dll C:\VSTS\7.01.00\Built Files\JiwaApplication.dll ea8ee061-0cd3-4ee4-a3fb-e74ff99a70e1 mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 mscorlib.dll C:\Windows\Microsoft.NET\Framework\v4.0.30319\mscorlib.dll 9f52ec2d-babd-434d-b675-3ec7a6787eb0 System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 System.dll C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System\v4.0_4.0.0.0__b77a5c561934e089\System.dll 70a06e3e-ad3c-42f8-82d1-acc84289b8f9 Microsoft.VisualBasic, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a Microsoft.VisualBasic.dll C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\Microsoft.VisualBasic\v4.0_10.0.0.0__b03f5f7f11d50a3a\Microsoft.VisualBasic.dll fd3f3ca6-30a9-4fca-aec5-e142bd736287 System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a System.Drawing.dll C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Drawing\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Drawing.dll 6ca45223-6121-4d1f-9470-2bb4803981a3 JiwaODBC, Version=7.1.0.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaODBC.dll C:\VSTS\7.01.00\Built Files\JiwaODBC.dll 93f4dfa3-dde0-4050-a979-52f4d1064af8 System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 System.Data.dll C:\WINDOWS\Microsoft.Net\assembly\GAC_32\System.Data\v4.0_4.0.0.0__b77a5c561934e089\System.Data.dll d0c44607-7e23-41db-a95c-87253f06ec06 System.Xml, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 System.Xml.dll C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Xml\v4.0_4.0.0.0__b77a5c561934e089\System.Xml.dll 55cbfeb3-9596-4afc-81dd-97c66ef85fd0 System.Runtime.Serialization, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 System.Runtime.Serialization.dll C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Runtime.Serialization\v4.0_4.0.0.0__b77a5c561934e089\System.Runtime.Serialization.dll 1d0c6ea6-1eb6-45dd-b623-7e998e5d8274 System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 System.Windows.Forms.dll C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Windows.Forms\v4.0_4.0.0.0__b77a5c561934e089\System.Windows.Forms.dll c2885432-1906-468b-a74c-4c7007bfe6d1 JiwaServiceModel, Version=7.1.0.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaServiceModel.dll C:\VSTS\7.01.00\Built Files\JiwaServiceModel.dll ff40f8b5-db18-431e-b489-89f341fff37a Infragistics4.Win.Misc.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.Misc.v13.1.dll C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\Infragistics4.Win.Misc.v13.1\v4.0_13.1.20131.2060__7dd5c3163f2cd0cb\Infragistics4.Win.Misc.v13.1.dll 2c87a174-46c4-4efa-b465-5e0dd0ec6043 Infragistics4.Win.UltraWinEditors.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinEditors.v13.1.dll C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\Infragistics4.Win.UltraWinEditors.v13.1\v4.0_13.1.20131.2060__7dd5c3163f2cd0cb\Infragistics4.Win.UltraWinEditors.v13.1.dll 19787d8a-abed-43cb-96b5-22374a2e8459 Infragistics4.Win.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.v13.1.dll C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\Infragistics4.Win.v13.1\v4.0_13.1.20131.2060__7dd5c3163f2cd0cb\Infragistics4.Win.v13.1.dll 14ab7d58-a041-4033-a522-b6c0046c22ed Microsoft.SqlServer.Smo, Version=14.100.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 Microsoft.SqlServer.Smo.dll C:\VSTS\7.01.00\Built Files\Microsoft.SqlServer.Smo.dll 53b69994-c674-4535-9776-e18bab760dd8 Microsoft.SqlServer.ConnectionInfo, Version=14.100.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 Microsoft.SqlServer.ConnectionInfo.dll C:\VSTS\7.01.00\Built Files\Microsoft.SqlServer.ConnectionInfo.dll 8577a988-ba1a-407c-a7f4-62a8f310faec Infragistics4.Win.UltraWinExplorerBar.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinExplorerBar.v13.1.dll C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\Infragistics4.Win.UltraWinExplorerBar.v13.1\v4.0_13.1.20131.2060__7dd5c3163f2cd0cb\Infragistics4.Win.UltraWinExplorerBar.v13.1.dll 63e90a37-46ae-44c6-99bd-7d43a912109c Infragistics4.Win.UltraWinTree.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinTree.v13.1.dll C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\Infragistics4.Win.UltraWinTree.v13.1\v4.0_13.1.20131.2060__7dd5c3163f2cd0cb\Infragistics4.Win.UltraWinTree.v13.1.dll 5729253f-c319-414d-9d80-2b1473b2064f FarPoint.Win.Spread, Version=8.35.20151.0, Culture=neutral, PublicKeyToken=327c3516b1b18457 FarPoint.Win.Spread.dll C:\WINDOWS\assembly\GAC_MSIL\FarPoint.Win.Spread\8.35.20151.0__327c3516b1b18457\FarPoint.Win.Spread.dll b22026ff-3717-497a-9477-e79691c9889c Infragistics4.Win.UltraWinTabControl.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinTabControl.v13.1.dll C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\Infragistics4.Win.UltraWinTabControl.v13.1\v4.0_13.1.20131.2060__7dd5c3163f2cd0cb\Infragistics4.Win.UltraWinTabControl.v13.1.dll fb827ff4-7f33-4c6d-9bc4-bd77439a0213 Infragistics4.Shared.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Shared.v13.1.dll C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\Infragistics4.Shared.v13.1\v4.0_13.1.20131.2060__7dd5c3163f2cd0cb\Infragistics4.Shared.v13.1.dll e45a0763-a82c-4c37-9343-5295be547f96 Infragistics4.Win.UltraWinToolbars.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinToolbars.v13.1.dll C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\Infragistics4.Win.UltraWinToolbars.v13.1\v4.0_13.1.20131.2060__7dd5c3163f2cd0cb\Infragistics4.Win.UltraWinToolbars.v13.1.dll dff33921-61b6-4833-b054-4ac96739a162 Infragistics4.Win.UltraWinStatusBar.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinStatusBar.v13.1.dll C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\Infragistics4.Win.UltraWinStatusBar.v13.1\v4.0_13.1.20131.2060__7dd5c3163f2cd0cb\Infragistics4.Win.UltraWinStatusBar.v13.1.dll fbcbe629-7927-4aa8-ad6b-bb148c150ed2 Infragistics4.Win.UltraWinSchedule.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinSchedule.v13.1.dll C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\Infragistics4.Win.UltraWinSchedule.v13.1\v4.0_13.1.20131.2060__7dd5c3163f2cd0cb\Infragistics4.Win.UltraWinSchedule.v13.1.dll 607b66b7-78ac-4947-b80c-3e853b586681 Infragistics4.Win.UltraWinListView.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinListView.v13.1.dll C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\Infragistics4.Win.UltraWinListView.v13.1\v4.0_13.1.20131.2060__7dd5c3163f2cd0cb\Infragistics4.Win.UltraWinListView.v13.1.dll 22a9f56b-1680-4539-8d30-24f05851c387 ServiceStack, Version=4.0.0.0, Culture=neutral, PublicKeyToken=e06fbc6124f57c43 ServiceStack.dll C:\VSTS\7.01.00\Built Files\ServiceStack.dll 2f87087f-01a7-4188-9152-47c2e03c424e EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 EntityFramework.dll C:\VSTS\7.01.00\Built Files\EntityFramework.dll 8b6129e0-75fd-4b1c-aa4e-c3275c178fbb System.Core, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 System.Core.dll C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Core\v4.0_4.0.0.0__b77a5c561934e089\System.Core.dll 48441b3b-15f2-4244-a32e-a610ac753b72 ActiproSoftware.SyntaxEditor.WinForms, Version=16.1.330.0, Culture=neutral, PublicKeyToken=c27e062d3c1a4763 ActiproSoftware.SyntaxEditor.WinForms.dll C:\WINDOWS\assembly\GAC_MSIL\ActiproSoftware.SyntaxEditor.WinForms\16.1.330.0__c27e062d3c1a4763\ActiproSoftware.SyntaxEditor.WinForms.dll 5c97dca6-74bd-45fb-bb32-ce1564cee046 ZetaHtmlEditControl, Version=1.1.0.3, Culture=neutral, PublicKeyToken=2e2e5ba5da72b6c0 ZetaHtmlEditControl.dll C:\VSTS\7.01.00\Built Files\ZetaHtmlEditControl.dll 02a1a261-b720-4126-9352-09974330f5fb ActiproSoftware.SyntaxEditor.Addons.DotNet.WinForms, Version=16.1.330.0, Culture=neutral, PublicKeyToken=c27e062d3c1a4763 ActiproSoftware.SyntaxEditor.Addons.DotNet.WinForms.dll C:\WINDOWS\assembly\GAC_MSIL\ActiproSoftware.SyntaxEditor.Addons.DotNet.WinForms\16.1.330.0__c27e062d3c1a4763\ActiproSoftware.SyntaxEditor.Addons.DotNet.WinForms.dll 3cf00b19-db59-4375-818b-3ddf01ab0421 JiwaEncryption, Version=7.1.0.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaEncryption.dll C:\VSTS\7.01.00\Built Files\JiwaEncryption.dll b3c01c2c-334b-4a44-afe7-abf3d37d2e91 System.Security, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a System.Security.dll C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Security\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Security.dll 53d5aa4a-376c-421f-ba12-7373cf4122dd Infragistics4.Win.UltraWinGrid.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinGrid.v13.1.dll C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\Infragistics4.Win.UltraWinGrid.v13.1\v4.0_13.1.20131.2060__7dd5c3163f2cd0cb\Infragistics4.Win.UltraWinGrid.v13.1.dll 8c72d576-5ea5-492f-92da-8149a0899b37 Microsoft.SqlServer.Dac, Version=14.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a Microsoft.SqlServer.Dac.dll C:\VSTS\7.01.00\Built Files\Microsoft.SqlServer.Dac.dll 2c1d08cc-4027-491f-9c08-7ed2d00ef0cc CrystalDecisions.CrystalReports.Engine, Version=13.0.3500.0, Culture=neutral, PublicKeyToken=692fbea5521e1304 CrystalDecisions.CrystalReports.Engine.dll C:\WINDOWS\assembly\GAC_MSIL\CrystalDecisions.CrystalReports.Engine\13.0.3500.0__692fbea5521e1304\CrystalDecisions.CrystalReports.Engine.dll c12fbd56-f159-469a-b77a-2cd1a5c18d10 CrystalDecisions.Shared, Version=13.0.3500.0, Culture=neutral, PublicKeyToken=692fbea5521e1304 CrystalDecisions.Shared.dll C:\WINDOWS\assembly\GAC_MSIL\CrystalDecisions.Shared\13.0.3500.0__692fbea5521e1304\CrystalDecisions.Shared.dll 2ee6f81c-b581-45bd-a446-7be6c5c9f843 Infragistics4.Win.AppStylistSupport.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.AppStylistSupport.v13.1.dll C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\Infragistics4.Win.AppStylistSupport.v13.1\v4.0_13.1.20131.2060__7dd5c3163f2cd0cb\Infragistics4.Win.AppStylistSupport.v13.1.dll a3e911e0-b096-46e7-871c-d2ad14473843 JiwaLib, Version=7.1.0.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaLib.dll C:\VSTS\7.01.00\Built Files\JiwaLib.dll e64582d4-13df-40ac-b6d6-1caed51c2705 Microsoft.ApplicationInsights, Version=2.4.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35 Microsoft.ApplicationInsights.dll C:\VSTS\7.01.00\Built Files\Microsoft.ApplicationInsights.dll 4de99d99-d586-4b75-ad2a-5a2d7f3d9bc0 CrystalDecisions.Windows.Forms, Version=13.0.3500.0, Culture=neutral, PublicKeyToken=692fbea5521e1304 CrystalDecisions.Windows.Forms.dll C:\WINDOWS\assembly\GAC_MSIL\CrystalDecisions.Windows.Forms\13.0.3500.0__692fbea5521e1304\CrystalDecisions.Windows.Forms.dll c1602a9c-6cd7-41e2-b96e-79e53b16ba53 EntityFramework.SqlServer, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 EntityFramework.SqlServer.dll C:\VSTS\7.01.00\Built Files\EntityFramework.SqlServer.dll 0b8154fa-6da2-478d-8a4c-680a89441fdf ActiproSoftware.Shared.WinForms, Version=16.1.330.0, Culture=neutral, PublicKeyToken=c27e062d3c1a4763 ActiproSoftware.Shared.WinForms.dll C:\WINDOWS\assembly\GAC_MSIL\ActiproSoftware.Shared.WinForms\16.1.330.0__c27e062d3c1a4763\ActiproSoftware.Shared.WinForms.dll 1a4a29ff-df9d-4753-aae1-2b75c8de17e3 ServiceStack.Text, Version=4.0.0.0, Culture=neutral, PublicKeyToken=e06fbc6124f57c43 ServiceStack.Text.dll C:\VSTS\7.01.00\Built Files\ServiceStack.Text.dll 3d18741e-4402-4085-89d4-aa04c52499c3 FarPoint.Win, Version=8.35.20151.0, Culture=neutral, PublicKeyToken=327c3516b1b18457 FarPoint.Win.dll C:\WINDOWS\assembly\GAC_MSIL\FarPoint.Win\8.35.20151.0__327c3516b1b18457\FarPoint.Win.dll 7c8a496e-5a06-4631-b6fd-269055e1e97e ServiceStack.Interfaces, Version=4.0.0.0, Culture=neutral, PublicKeyToken=e06fbc6124f57c43 ServiceStack.Interfaces.dll C:\VSTS\7.01.00\Built Files\ServiceStack.Interfaces.dll f386580a-e9fd-42c9-9ef8-5784989ee5d4 ServiceStack.Server, Version = 4.0.0.0, Culture = neutral, PublicKeyToken = e06fbc6124f57c43 ServiceStack.Server.dll C:\VSTS\7.01.00\Built Files\ServiceStack.Server.dll bd53114b-748e-4783-8beb-fa93fddf9006 ServiceStack.OrmLite, Version = 4.0.0.0, Culture = neutral, PublicKeyToken = e06fbc6124f57c43 ServiceStack.OrmLite.dll C:\VSTS\7.01.00\Built Files\ServiceStack.OrmLite.dll