Walkthrough: Adding Data Binding to a Web Test (CSV File)

Article
11/16/2012

In this walkthrough, you will bind a Web test to a CSV file and verify that it works correctly.

By using data binding, a database can provide data for a Web Test. You can bind data from a data source to a part of a Web request that requires data, such as a form post parameter. For more information, see About Data Binding in Web Tests.

In this walkthrough, you will perform the following tasks:

Add data binding to a Web test
Run the Web test to verify that it works correctly

Prerequisites

To complete this walkthrough, you need the following:

Visual Studio Team System Test Edition
The Web application that you created in Walkthrough: Creating a Simple Web Application
The Web test that you created in Walkthrough: Recording and Running a Web Test

Preparing for the Walkthrough

For this walkthrough, you will need a sample data source to bind to. You will create a simple CSV file data source.

To prepare the data source

Create a new folder and name it Data.
In the Data folder, create a new text file and name it ColorData.csv.

Note

You can use any text editor, for example Notepad, to create the file.
Add the following to the text file:
```
ColorId, ColorName
0,Red
1,Blue
```
Important Note:

In this walkthrough your CSV file must have column headings.
Save and close the file.

Tip

You can open the file in Excel and confirm that the data separated by the commas appears in separate columns.

Important Note:
In this walkthrough your CSV file must have column headings.

To prepare the Web test

Open the Web application you created in Walkthrough: Creating a Simple Web Application.
Press CTRL+F5 to run the Web application in the browser. You will see the first page. Close the browser.

Note

This starts the ASP.Net Development Server that runs the Web application your Web test will test. You will see the ASP.Net Development Server icon in the notification area, at the far right of the taskbar.
Open the Web application you created in Walkthrough: Recording and Running a Web Test.
In Solution Explorer, double-click ColorWebTest.webtest. The Web Test Editor appears and the list of Web requests is displayed.

Add Data Binding to a Web Test

To add the data source to the Web test

In the Web Test Editor, right-click the top node of your Web test and then click Add Data Source.

The New Test Data Source Wizard appears.
In the Data source name box type ColorsCSV.
In the Data source type list click CSV File.
Click Next.
In the Choose a CSV file box enter the path and name of the file, or click the ellipsis to browse to the file. For example, type the following:

<Your Path>\Data\ColorData.csv

The data from the CSV file appears in the Preview data pane.
Click Finish.

A dialog appears asking you if you want to add the file to your current project.

Click Yes.

A Data Sources node will be added to your Web test, and the text file will appear as a table in the hierarchy.

For the purposes of this walkthrough, it is not necessary to add the file to the project. In the future, you can use the following information to help you decide:

Response	Result	Advantage
Yes	The file is copied to the project.	When the project is deployed, there is no extra work required.
No	The file is not copied to the project. When the project is deployed, you might have to update the path of the file.	Some data files can be very large, and should be maintained separate from the project. Some data files must be shared among several members of a team, and should be maintained in a central location that all members can access.

On the Filemenu click Save ColorWebTest.webtest to save the Web test.

To add data binding to the Web test

In the Web Test Editor, find the request that redirects to the page Red.aspx. This should be the second node in the request list.

Important Note:
The Web application uses a redirect to move from the page Default.aspx to the page Red.aspx. In the Web Test Editor, the request list will show Default.aspx, not Red.aspx, for the request you are trying to find. To find the correct request, expand the request node, expand the Form Post Parameters folder, and confirm that there is an entry RadioButtonList=Red.

Select the RadioButtonList1 node.
In the Properties window, find the Value property. It is currently set to Red because that is what you selected when you recorded the Web test. Click the property, and then click the down arrow that appears.
Expand ColorsCSV, expand the ColorData#csv table, and then select ColorName. The RadioButtonList is now bound to the data source.
On the Test menu point to Edit Test Run Configurations, and then click Local Test Run.
In the localtestrun.testrunconfig dialog box, select Web Test in the left pane, and then select the One run per data source row option in the right pane. This causes the test to run iteratively, one time for each row in the database. On each test iteration, the cursor moves to the next row in the database.
Click Close.
On the Filemenu click Save ColorWebTest.webtest to save the Web test.

Running the Web Test to Verify that it Works Correctly

To verify the Web test

In the Web Test Editor, click Run Test to start your Web test and display the Web Test Viewer.
In the Web Test Viewer there will be two runs of the Web test. Run 1 will use the first row of data, and Run 2 will use the second row of data. Notice that Run 1 visits the page Red.aspx, and Run 2 visits the page Blue.aspx.

Note

You might have to scroll up in the Web Test Viewer to see both test runs.

Next Steps

In this walkthrough you added data binding to a Web test, using a CSV file. To learn about binding to other data sources, see the following:

How to: Add Data Binding to a Web Request

Walkthrough: Adding Data Binding to a Web Test (XML File)

Walkthrough: Adding Data Binding to a Web Test

Share via