RulesManager for WinForms
クイックスタート

This quick start will guide you through the steps of adding C1FlexGrid and C1RulesManager controls, binding C1FlexGrid to data source, integrate C1RulesManager to the C1FlexGrid control, and applying conditional formatting on the grid data.

You can achieve the following output through the design view or completely through the code.

Using Rule Manager with a FlexGrid control to apply condiitonal formatting on the grid data.

Note: WinForms .NET 5 Edition has only runtime assemblies. Due to the new design-time model in VS2019 Preview, which is not complete yet from the Microsoft side, we do not supply any special design-time features as of yet. So, a RulesManager application for .NET 5 can only be created programmatically for now. For the programmatic steps for this quick start sample, see the "Through Code View" implementation tab.

Set up the application

  1. Create a new Windows Forms App.
  2. Drag and drop the C1FlexGrid and C1RulesManager controls from the Toolbox onto the Form.
  3. From the Properties window, set the Name property of the C1RulesManager control to rulesManager and C1FlexGrid to flexGrid.

Bind FlexGrid to a data source

  1. Click on the C1FlexGrid's smart tag () to open the C1FlexGrid Tasks menu.
  2. In the C1FlexGrid Tasks menu, click the Choose Data Source drop-down arrow and select the Add Project Data Source link from the drop-down box.
  3. The Data Source Configuration Wizard appears. Leave the default setting, Database, selected on the Choose a Data Source Type page, and click Next.
  4. On the Choose a Database Model page, leave Dataset selected and click Next.
  5. Click the New Connection button to create a new connection or choose one from the drop-down list. When you click New Connection, the Add Connection dialog box appears.
  6. Leave Microsoft Access Database File as the Data source.
  7. Click the Browse button under Database file name. In the Select Microsoft Access Database File dialog box, browse to the C1NWind.mdb database in the Documents\ComponentOne Samples\Common directory. Select the C1NWind.mdb file and click Open.
  8. In the Add Connection dialog box, click the Test Connection button to make sure that you have successfully connected to the database or server and click OK.
  9. Click OK again to close the Add Connection dialog box.
  10. Click the Next button to continue. A dialog box will appear asking if you would like to add the data file to your project and modify the connection string. Since it is not necessary to copy the database to your project, click No.
  11. Save the connection string in the application configuration file by checking the Yes, save the connection as box and entering a name. Click the Next button to continue.
  12. On the Choose Your Database Objects page, expand the Tables node, and select the Products table. Click Finish to exit the wizard.
  13. A DataSet and connection string are added to your project. Additionally, Visual Studio automatically creates the following code to fill the DataSet.
    C#
    コードのコピー 
    this.productsTableAdapter.Fill(this.c1NWindDataSet.Products);

Integrate RulesManager with FlexGrid

To integrate RulesManager with FlexGrid, use the following code:

C#
コードのコピー 
rulesManager.SetC1RulesManager(flexGrid, rulesManager);

Apply conditional formatting

  1. Click on the C1RuleManager's smart tag () to open the C1RuleManager Tasks menu.
  2. In the C1RuleManager Tasks menu, select Edit Rule. This opens the IRule Collection Editor.
  3. In the IRule Collection Editor, click Add to add a rule and set the following properties:
    Property Value
    Name Many In Stock
    Expression = [UnitsInStock] > 20
    Style > BackColor Green
    Style > ForeColor White
  4. In the IRule Collection Editor, click the AppliesTo ellipsis button. This opens the IItemRange Collection Editor.
  5. In the IItemRange Collection Editor, click Add, set the Fields property to "UnitsInStock" and click OK. This closes the editor and applies the rule you set to the "UnitsInStock" column of the grid.
  6. Click OK to close the IRule Collection Editor. Observe that the rule you just created gets added in the RulesManager control in the design view.

Set up the application

  1. Create a new Windows Forms App.
  2. Switch to the code view and add the following references:
    • using C1.Win.FlexGrid;
    • using C1.Win.RulesManager;
  3. Initialize an instance of the C1FlexGrid and C1RulesManager class using the following code:
    C#
    コードのコピー 
    C1FlexGrid c1FlexGrid = new C1FlexGrid();
C1RulesManager rulesManager = new C1RulesManager();

Bind FlexGrid to a data source

  1. Set the data source for FlexGrid.
    C#
    コードのコピー 
    //Set datasource for FlexGrid
        private DataTable GetDataSource()
        {
            var rs = "select * from Products;";
            var cn = GetConnectionString();
            var da = new OleDbDataAdapter(rs, cn);
            var dt = new DataTable();
            da.Fill(dt);
            return dt;
        }

        static string GetConnectionString()
        {
            var path = Environment.GetFolderPath(Environment.SpecialFolder.Personal) + @"\ComponentOne Samples\Common";
            var conn = @"provider=microsoft.jet.oledb.4.0;data source={0}\c1nwind.mdb;";
            return string.Format(conn, path);
        }
  2. Assign data source to the FlexGrid control.
    C#
    コードのコピー 
    flexGrid.DataSource = GetDataSource();

Integrate RulesManager with FlexGrid

To integrate RulesManager with FlexGrid, use SetC1RulesManager method of the RulesManager class as shown in the following code:

C#
コードのコピー 
rulesManager.SetC1RulesManager(flexGrid, rulesManager);

Apply conditional formatting

  1. Create a method, say ApplyPredefinedRules, to add rules to RulesManager which are to applied to the FlexGrid control and define the rule in RulesManager, using the Name, Expression and Style properties of the Rule class.
    In the following example, rule applies to "UnitsInStock" column where the fore color of the cell is set to White and the back color is set to Green if the value in the cells of the "UnitsInStock" column is greater than 20.
    C#
    コードのコピー 
    private void ApplyPredefinedRules()
        {
            //Define the rule in RulesManager
            var rule1 = new C1.Win.RulesManager.Rule()
            {
                Name = "Many In Stock",
                Expression = "= [UnitsInStock] > 20",
                Style = new ItemStyle()
                {
                    ForeColor = Color.White,
                    BackColor = Color.Green
                }
            };
  2. Add the "UnitsInStock" column to which the rule applies using the FieldRange class.
    C#
    コードのコピー 
    rule1.AppliesTo.Add(new FieldRange(new string[] { "UnitsInStock" }));
  3. Add the rule to the RuleManager.
    C#
    コードのコピー 
    rulesManager.Rules.Add(rule1);
  4. Invoke the method used to add rules to RulesMangager and apply to FlexGrid in the Form's Load method.
    C#
    コードのコピー 
    ApplyPredefinedRules();

 

 

Copyright © GrapeCity, Inc. All rights reserved.