How to use DataGridView class of FlaUI.Core.AutomationElements package

Best FlaUI code snippet using FlaUI.Core.AutomationElements.DataGridView

DataGridViewExtensions.cs

Source:DataGridViewExtensions.cs

...5using System.Collections.Generic;6using System.Linq;7namespace WinformsTools.IntegrationTestUtils.Extensions8{9    public static class DataGridViewExtensions10    {11        public static DataGridViewRow[] GetRows(this DataGridView table)12        {13            if (table == null)14            {15                throw new ArgumentNullException(nameof(table));16            }17            return Retry.WhileEmpty(() => GetDataGridViewRow(table)).Result;18        }19        public static IEnumerable<IDictionary<string, DataGridViewCell>> ToDictionary(this DataGridView table)20        {21            var columns = GetCellNames(table);22            return table.Rows.ToDictionary(columns);23        }24        public static IEnumerable<IDictionary<string, DataGridViewCell>> ToDictionary(this DataGridViewRow[] rows)25        {26            var table = rows[0].Parent.AsDataGridView();27            var columns = GetCellNames(table);28            return rows.ToDictionary(columns);29        }30        private static IEnumerable<IDictionary<string, DataGridViewCell>> ToDictionary(this DataGridViewRow[] rows, List<string> columns)31        {32            foreach (var row in rows)33            {34                yield return row.Cells.ToDictionary(columns);35            }36        }37        private static List<string> GetCellNames(DataGridView table)38        {39            var header = GetDataGridViewHeader(table);40            var headerColumns = GetDataGridViewHeaderColumns(header);41            return headerColumns.Select(x => x.Text).ToList();42        }43        public static IDictionary<string, DataGridViewCell> ToDictionary(this DataGridViewCell[] cells, IEnumerable<string> columns)44        {45            var dictionary = new Dictionary<string, DataGridViewCell>();46            for (var i = 0; i < cells.Length; i++)47            {48                dictionary.Add(columns.ElementAt(i), cells[i]);49            }50            return dictionary;51        }52        /// <summary>53        /// <see cref="DataGridView.Rows"/> does not work in culture different than English or German:54        /// <see href="https://github.com/FlaUI/FlaUI/blob/master/src/FlaUI.Core/AutomationElements/DataGridView.cs"/>55        /// <see href="https://github.com/FlaUI/FlaUI/blob/master/src/FlaUI.Core/Tools/LocalizedStrings.cs"/>56        /// </summary>57        /// <param name="dataGridView"></param>58        /// <returns></returns>59        private static DataGridViewRow[] GetDataGridViewRow(DataGridView dataGridView)60        {61            var rows = dataGridView.FindAllChildren(cf =>62                cf.ByControlType(ControlType.Custom)63                    .Or(cf.ByControlType(ControlType.DataItem))64                .And(cf.ByName(CustomLocalizedStrings.DataGridViewHeader).Not())65            );66            // Remove the last row if we have the "add" row67            if (dataGridView.HasAddRow)68            {69                rows = rows.Take(rows.Length - 1).ToArray();70            }71            return rows.Select(x => new DataGridViewRow(x.FrameworkAutomationElement)).ToArray();72        }73        /// <summary>74        /// <see cref="DataGridView.Header"/> does not work in culture different than English or German75        /// <see href="https://github.com/FlaUI/FlaUI/blob/master/src/FlaUI.Core/AutomationElements/DataGridView.cs"/>76        /// <see href="https://github.com/FlaUI/FlaUI/blob/master/src/FlaUI.Core/Tools/LocalizedStrings.cs"/>77        /// </summary>78        /// <param name="dataGridView"></param>79        /// <returns></returns>80        private static DataGridViewHeader GetDataGridViewHeader(DataGridView dataGridView)81        {82            var header = dataGridView.FindFirstChild(cf =>83                cf.ByName(CustomLocalizedStrings.DataGridViewHeader)84                    .Or(cf.ByControlType(ControlType.Header)));85            return header == null ? null : new DataGridViewHeader(header.FrameworkAutomationElement);86        }87        /// <summary>88        /// <see cref="DataGridViewHeader.Columns"/> does not work in culture different than English or German89        /// </summary>90        /// <returns></returns>91        private static DataGridViewHeaderItem[] GetDataGridViewHeaderColumns(DataGridViewHeader dataGridViewHeader)92        {93            // WinForms uses Header control type, WPF uses HeaderItem control type94            var headerItems = dataGridViewHeader.FindAllChildren(cf =>95                cf.ByControlType(ControlType.Header)96                    .Or(cf.ByControlType(ControlType.HeaderItem)));97            var convertedHeaderItems = headerItems.Select(x => new DataGridViewHeaderItem(x.FrameworkAutomationElement))98                .ToList();99            // Remove the top-left header item if it exists (can be the first or last item)100            if (convertedHeaderItems.Last().Text == CustomLocalizedStrings.DataGridViewHeaderItemTopLeft)101            {102                convertedHeaderItems = convertedHeaderItems.Take(convertedHeaderItems.Count - 1).ToList();103            }104            else if (convertedHeaderItems.First().Text == CustomLocalizedStrings.DataGridViewHeaderItemTopLeft)105            {106                convertedHeaderItems = convertedHeaderItems.Skip(1).ToList();107            }108            return convertedHeaderItems.ToArray();109        }110    }111}...

BaseGrid.cs

Source:BaseGrid.cs

...11using FlaUI.Core.Definitions;12using UIAutomation.YouTubePlaylistSyncer.WPF.Extensions;13namespace UIAutomation.YouTubePlaylistSyncer.WPF.Grids {14	public class BaseGrid {15		private DataGridView grid;16		protected DataGridView Grid { 17			get => this.grid; 18			set {19				this.grid = value;20				this.ColumnIndices = this.GenerateColumnIndices();21			} 22		}23		protected DataGridViewRow[] Rows { get => Grid.Rows; }24		protected DataGridViewHeaderItem[] Columns { get => Grid.Header.Columns; }25		protected Dictionary<string, int> ColumnIndices;26		// Forcibly map column names to cell indices here since FlaUI doesn't support searching within a column27		private Dictionary<string, int> GenerateColumnIndices() {28			var dict = new Dictionary<string, int>();29			int i = 0;30			foreach (DataGridViewHeaderItem column in Columns) {31				dict[column.Name] = i;32				i++;33			}34			return dict;35		}36	}37}

RemotePlaylistDataGrid.cs

Source:RemotePlaylistDataGrid.cs

...12using UIAutomation.YouTubePlaylistSyncer.WPF.Extensions;13using UIAutomation.YouTubePlaylistSyncer.WPF.Grids;14namespace UIAutomation.YouTubePlaylistSyncer.WPF.Grids {15	public class RemotePlaylistDataGrid : BaseGrid {16		public RemotePlaylistDataGrid(DataGridView grid) {17			Grid = grid;18		}19		public RemotePlaylistDataGrid T() {20			foreach (var item in this.ColumnIndices) {21				Debug.WriteLine($"colname is {item.Key}, index is {item.Value}");22			}23			return this;24		}25		public RemotePlaylistDataGrid SearchGrid(string column, string value) {26			int i = this.ColumnIndices[column];27			foreach (var row in Rows) {28				var cell = row.Cells[i];29				if (cell.Value == value) {30					cell.Click();...

DataGridView

Using AI Code Generation

1using FlaUI.Core;2using FlaUI.Core.AutomationElements;3using FlaUI.Core.AutomationElements.Infrastructure;4using FlaUI.Core.Definitions;5using FlaUI.Core.EventHandlers;6using FlaUI.Core.Input;7using FlaUI.Core.Tools;8using FlaUI.UIA3;9using System;10using System.Collections.Generic;11using System.Diagnostics;12using System.Linq;13using System.Text;14using System.Threading.Tasks;15{16    {17        static void Main(string[] args)18        {19            var app = Application.Launch(@"C:\Windows\System32\calc.exe");20            var automation = new UIA3Automation();21            var window = app.GetMainWindow(automation);22            var button = window.FindFirstDescendant(cf => cf.ByAutomationId("num8Button"));23            button.Click();24            var button2 = window.FindFirstDescendant(cf => cf.ByAutomationId("num5Button"));25            button2.Click();26            var button3 = window.FindFirstDescendant(cf => cf.ByAutomationId("multiplyButton"));27            button3.Click();28            var button4 = window.FindFirstDescendant(cf => cf.ByAutomationId("num1Button"));29            button4.Click();30            var button5 = window.FindFirstDescendant(cf => cf.ByAutomationId("num2Button"));31            button5.Click();32            var button6 = window.FindFirstDescendant(cf => cf.ByAutomationId("equalButton"));33            button6.Click();34            var button7 = window.FindFirstDescendant(cf => cf.ByAutomationId("clearButton"));35            button7.Click();36            var button8 = window.FindFirstDescendant(cf => cf.ByAutomationId("num7Button"));37            button8.Click();38            var button9 = window.FindFirstDescendant(cf => cf.ByAutomationId("num

DataGridView

Using AI Code Generation

1using System;2using System.Collections.Generic;3using System.Linq;4using System.Text;5using System.Threading.Tasks;6using FlaUI.Core.AutomationElements;7using FlaUI.Core;8using FlaUI.Core.Definitions;9using FlaUI.Core.Input;10using System.Windows.Automation;11using FlaUI.Core.WindowsAPI;12using System.Threading;13using FlaUI.Core.Tools;14using System.Windows.Forms;15using System.IO;16{17    {18        static void Main(string[] args)19        {20            var app = FlaUI.Core.Application.Launch(@"C:\Program Files (x86)\Microsoft Visual Studio\2017\Community\Common7\IDE\devenv.exe");21            var window = app.GetMainWindow(FlaUI.Core.Conditions.ConditionFactory.ByAutomationId("MainWindow"));22            var automation = FlaUI.Core.Automation.AutomationFactory.GetAutomation();23            var menuItem = window.FindFirstDescendant(FlaUI.Core.Conditions.ConditionFactory.ByText("View")).AsMenuItem();24            var subMenuItem = menuItem.FindFirstChild(FlaUI.Core.Conditions.ConditionFactory.ByText("Other Windows")).AsMenuItem();25            subMenuItem.Invoke();26            var win = window.FindFirstDescendant(FlaUI.Core.Conditions.ConditionFactory.ByText("Toolbox")).AsWindow();27            var treeView = win.FindFirstDescendant(FlaUI.Core.Conditions.ConditionFactory.ByClassName("SysTreeView32")).AsTreeView();28            var treeItem = treeView.FindFirstDescendant(FlaUI.Core.Conditions.ConditionFactory.ByText("Windows Forms")).AsTreeItem();29            treeItem.Expand();30            var childTreeItem = treeItem.FindFirstChild(FlaUI.Core.Conditions.ConditionFactory.ByText("DataGridView")).AsTreeItem();31            childTreeItem.Invoke();32            var win1 = window.FindFirstDescendant(FlaUI.Core.Conditions.ConditionFactory.ByText("DataGridView")).AsWindow();33            var dgv = win1.FindFirstDescendant(Fla

DataGridView

Using AI Code Generation

1using FlaUI.Core.AutomationElements;2using FlaUI.Core.Definitions;3using FlaUI.Core.Tools;4using System;5using System.Collections.Generic;6using System.Linq;7using System.Text;8using System.Threading.Tasks;9{10    {11        static void Main(string[] args)12        {13            var application = FlaUI.Core.Application.Launch(@"C:\Program Files (x86)\Microsoft Office\root\Office16\EXCEL.EXE");14            var automation = FlaUI.Core.Automation.AutomationFactory.GetAutomation();15            var window = application.GetMainWindow(automation);16            var grid = window.FindFirstDescendant(cf => cf.ByAutomationId("Grid")).AsDataGridView();17            var cell = grid.Rows[0].Cells[0];18            Console.WriteLine(cell.Value);19            Console.WriteLine(cell.Value);

DataGridView

Using AI Code Generation

1using FlaUI.Core.AutomationElements;2using FlaUI.Core.Definitions;3using FlaUI.Core.Input;4using System;5using System.Collections.Generic;6using System.Linq;7using System.Text;8using System.Threading.Tasks;9using System.Windows.Automation;10using FlaUI.Core;11using FlaUI.Core.Conditions;12using FlaUI.Core.AutomationElements.Infrastructure;13using System.Threading;14using FlaUI.Core.WindowsAPI;15using FlaUI.Core.Tools;16using FlaUI.Core.WindowsAPI;17using System.Diagnostics;18using System.Windows.Automation;19using System.Windows.Automation.Text;20using System.Windows.Automation.Provider;21using System.Windows.Automation.Peers;22using System.Windows.Automation;23using System.Windows.Automation.Text;24using System.Windows.Automation.Provider;25using System.Windows.Automation.Peers;26using System.Windows.Automation;27using System.Windows.Automation.Text;28using System.Windows.Automation.Provider;29using System.Windows.Automation.Peers;30using System.Windows.Automation;31using System.Windows.Automation.Text;32using System.Windows.Automation.Provider;33using System.Windows.Automation.Peers;34using System.Windows.Automation;35using System.Windows.Automation.Text;36using System.Windows.Automation.Provider;37using System.Windows.Automation.Peers;38using System.Windows.Automation;39using System.Windows.Automation.Text;40using System.Windows.Automation.Provider;41using System.Windows.Automation.Peers;42using System.Windows.Automation;43using System.Windows.Automation.Text;44using System.Windows.Automation.Provider;45using System.Windows.Automation.Peers;46using System.Windows.Automation;47using System.Windows.Automation.Text;48using System.Windows.Automation.Provider;49using System.Windows.Automation.Peers;50using System.Windows.Automation;51using System.Windows.Automation.Text;52using System.Windows.Automation.Provider;53using System.Windows.Automation.Peers;54{55    {56        static void Main(string[] args)57        {58            var app = FlaUI.Core.Application.Launch("C:\\Users\\username\\AppData\\Local\\Programs\\Microsoft VS Code\\Code.exe");59            var window = app.GetMainWindow(FlaUI.Core.Conditions.ConditionFactory.ByAutomationId("Code"));60            var child = window.FindFirstChild(FlaUI.Core.Conditions.ConditionFactory.ByAutomationId("workbench.parts.editor"));61            var child1 = child.FindFirstChild(FlaUI.Core.Conditions.ConditionFactory.ByAutomationId("workbench.editor.untitledEditorInput"));

DataGridView

Using AI Code Generation

1using System;2using System.Collections.Generic;3using System.Linq;4using System.Text;5using System.Threading.Tasks;6using FlaUI.Core;7using FlaUI.Core.AutomationElements;8using FlaUI.Core.AutomationElements.Infrastructure;9using FlaUI.Core.Definitions;10using FlaUI.Core.Tools;11using FlaUI.UIA3;12using System.Windows.Automation;13using System.Windows.Automation.Peers;14using System.Windows.Automation.Provider;15{16    {17        static void Main(string[] args)18        {19            using (var automation = new UIA3Automation())20            {21                var app = FlaUI.Core.Application.Launch("C:\\Users\\user\\Documents\\Visual Studio 2017\\Projects\\WpfApp1\\WpfApp1\\bin\\Debug\\WpfApp1.exe");22                var mainWindow = app.GetMainWindow(automation);23                var grid = mainWindow.FindFirstDescendant(cf => cf.ByAutomationId("dataGrid1")).AsDataGridView();24                int rowCount = grid.Rows.Count;25                int colCount = grid.Columns.Count;26                Console.WriteLine("Row count: " + rowCount);27                Console.WriteLine("Column count: " + colCount);

DataGridView

Using AI Code Generation

1using FlaUI.Core.AutomationElements;2using FlaUI.Core.Definitions;3using FlaUI.Core.Tools;4using System;5using System.Collections.Generic;6using System.Linq;7using System.Text;8using System.Threading.Tasks;9{10    {11        static void Main(string[] args)12        {13            var app = FlaUI.Core.Application.Launch("notepad.exe");14            var window = app.GetMainWindow(FlaUI.Core.Conditions.ConditionFactory.ByAutomationId("Notepad"));15            window.WaitWhileBusy();16            window.Focus();17            window.FindFirstDescendant(FlaUI.Core.Conditions.ConditionFactory.ByAutomationId("15")).AsTextBox().Text = "Hello World";18            window.Close();19            window.WaitWhileBusy();20            app.Close();21            Console.ReadLine();22        }23    }24}25using FlaUI.Core.AutomationElements;26using FlaUI.Core.Definitions;27using FlaUI.Core.Tools;28using System;29using System.Collections.Generic;30using System.Linq;31using System.Text;32using System.Threading.Tasks;33{34    {35        static void Main(string[] args)36        {37            var app = FlaUI.Core.Application.Launch("notepad.exe");38            var window = app.GetMainWindow(FlaUI.Core.Conditions.ConditionFactory.ByAutomationId("Notepad"));39            window.WaitWhileBusy();40            window.Focus();41            window.FindFirstDescendant(FlaUI.Core.Conditions.ConditionFactory.ByAutomationId("15")).AsTextBox().Text = "Hello World";42            window.Close();

DataGridView

Using AI Code Generation

1using FlaUI.Core;2using FlaUI.UIA3;3using FlaUI.Core.AutomationElements;4using FlaUI.Core.AutomationElements.Infrastructure;5using System;6using System.Windows.Automation;7{8    {9        static void Main(string[] args)10        {11            var app = Application.Launch("C:\\Windows\\System32\\calc.exe");12            var automation = new UIA3Automation();13            var window = app.GetMainWindow(automation);14            var button = window.FindFirstDescendant(cf => cf.ByAutomationId("num8Button"));15            button.AsButton().Invoke();16            app.Close();17        }18    }19}

Automation Testing Tutorials

Learn to execute automation testing from scratch with LambdaTest Learning Hub. Right from setting up the prerequisites to run your first automation test, to following best practices and diving deeper into advanced test scenarios. LambdaTest Learning Hubs compile a list of step-by-step guides to help you be proficient with different test automation frameworks i.e. Selenium, Cypress, TestNG etc.