using Syncfusion.GridHelperClasses;
using Syncfusion.Windows.Forms.Grid;
using System;
using System.Collections.Generic;
using System.Data;
using System.Windows.Forms;
using Syncfusion.Windows.Forms;

namespace WindowsFormsApp1
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
            GridSettings();
        }

        private void GridSettings()
        {

            gridGroupingControl1.DataSource = GetData();
            gridGroupingControl1.GridVisualStyles = GridVisualStyles.Metro;

            gridGroupingControl1.TableDescriptor.Columns["Gender"].Appearance.AnyRecordFieldCell.CellType = GridCellTypeName.ComboBox;
            gridGroupingControl1.TableDescriptor.Columns["Gender"].Appearance.AnyRecordFieldCell.DataSource = new List<DisplayItem>()
            { new DisplayItem(0, "Male"), new DisplayItem(1, "Female")};
            gridGroupingControl1.TableDescriptor.Columns["Gender"].Appearance.AnyRecordFieldCell.DisplayMember = nameof(DisplayItem.Text);
            gridGroupingControl1.TableDescriptor.Columns["Gender"].Appearance.AnyRecordFieldCell.ValueMember = nameof(DisplayItem.ID);
            gridGroupingControl1.TableDescriptor.Columns["Gender"].AllowFilter = true;

            gridGroupingControl1.TableDescriptor.Columns["Country"].Appearance.AnyRecordFieldCell.CellType = GridCellTypeName.ComboBox;
            gridGroupingControl1.TableDescriptor.Columns["Country"].Appearance.AnyRecordFieldCell.DataSource = new List<DisplayItem>()
            { new DisplayItem(0, "USA"), new DisplayItem(1, "UK"), new DisplayItem(2, "Canada"), new DisplayItem(3, "Australia"), new DisplayItem(4, "Other")};
            gridGroupingControl1.TableDescriptor.Columns["Country"].Appearance.AnyRecordFieldCell.DisplayMember = nameof(DisplayItem.Text);
            gridGroupingControl1.TableDescriptor.Columns["Country"].Appearance.AnyRecordFieldCell.ValueMember = nameof(DisplayItem.ID);
            gridGroupingControl1.TableDescriptor.Columns["Country"].AllowFilter = true;

            GridExcelFilter filter = new GridExcelFilter();
            filter.ColumnFilter = GridExcelFilter.GridFilterMode.DisplayText;
            filter.WireGrid(gridGroupingControl1);
        }

        public static DataTable GetData()
        {
            DataTable dt = new DataTable("MainTable");
            dt.Columns.Add("Gender");
            dt.Columns.Add("Country");
            dt.BeginLoadData();
            Random rnd = new Random();
            for (int i = 0; i < 10; i++)
            {

                DataRow dr = dt.NewRow();
                dr["Gender"] = rnd.Next(0,2);
                dr["Country"] = rnd.Next(0,5);
                dt.Rows.Add(dr);
            }
            dt.EndLoadData();
            return dt;
        }

        public class DisplayItem
        {
            public DisplayItem(int id, string text)
            {
                this.ID = id;
                this.Text = text;
            }
            public int ID { get; set; }
            public string Text { get; set; }
        }
    }
}