Local Data Driven Test

Let's create a new, Local Data Driven test. We'll go through five iterations of the test, each with a different search text.

1.Create a new Web Test and click Record.

2.Navigate to www.google.com, enter Telerik in the Google search box, and hit the Search button.

3.Click the Pause button in the docked recorder toolbar.

4.Click the Local Data button in the bottom of the test or the Data tab in Visual Studio.

Standalone Version

VS Plugin

5.There are few buttons at the top of this pane and currently only Create a new data table is enabled. Click it to add a new data grid.

6.The default grid will have five columns and a single row. Also the rest of the buttons get active and allows you to modify the grid.

• Set number of rows and columns (columns are limited to 50) and update the grid

• Create new data table or remove current data table (both will prompt you the current data will be lost if you proceed)

• Add a row/Delete the last row or Add a column/Delete the last column

Add/Delete Row

Add/Delete Column

7.For this example we want to execute five iterations of the test entering different search text for each iteration. Therefore modify the table to have a single column and 5 rows and click on Update.

8.Enter random values in each of the cells in that column. Right click Col1 and choose Rename Column to enter a meaningful to you name for the column. Then save the modified test.

9.Save the test.

10.Click the Test Steps at the button of the test or the Step tab in Visual Studio to return to the Test Steps View

Standalone Version

VS Plugin

11.Data from an array can be used in recorded steps and code behind methods. To bind data from a data array to a recorded step, continue to the next step. To use reference data from the data array in a code behind method, skip to step 19.

12.Highlight step 2. This is the recorded step that sets the value of the Google search text box.

13.The properties for this step appear in the Properties pane, located on the right of the screen.

14.Click the '...' button for (Bindings).

15.Choose the 'Numbers' from the drop down for Text.

16.Click the Set button.

17.The data for the column named Numbers from the data array is now bound to the Text property for that step. Instead of entering Telerik into the search box, the data stored in the array will be entered.

18.Save and execute the test. Note that the test will execute for each row in the data array, for a total of five iterations.

19.To use reference data from the data array in a code behind method, follow the below directions:

20.Highlight step 2. This is the recorded step that sets the value of the Google search text box. Right click the step and select Customize Step in Code.

21.Choose Visual Basic or C#.

22.Use the Data property followed by the index of the column to reference data from the grid. For example:

//Reference a column by name 
Pages.Bing.SbFormQText.Text = Data["Numbers"].ToString(); 
//Reference a column by index (zero based) 
Pages.Bing.SbFormQText.Text = Data[0].ToString(); 

'Reference a column by name 
Pages.Bing.SbFormQText.Text = Data("Numbers").ToString() 
'Reference a column by index (zero based) 
Pages.Bing.SbFormQText.Text = Data(0).ToString() 

23.Save and build project.

24.Execute your test. Note that the test will be executed for each row in the data array.