{"id":5173,"date":"2012-04-13T14:26:28","date_gmt":"2012-04-13T14:26:28","guid":{"rendered":"https:\/\/blogs.msdn.microsoft.com\/visualstudioalm\/2012\/04\/13\/acceptance-testing-ui-using-visual-studio-2010-microsoft-test-manager-and-fit-style-tables\/"},"modified":"2022-07-26T01:09:54","modified_gmt":"2022-07-26T09:09:54","slug":"acceptance-testing-ui-using-visual-studio-2010-microsoft-test-manager-and-fit-style-tables","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/devops\/acceptance-testing-ui-using-visual-studio-2010-microsoft-test-manager-and-fit-style-tables\/","title":{"rendered":"Acceptance Testing UI using Visual Studio 2010 Microsoft Test Manager and Fit style tables"},"content":{"rendered":"

A while back I was sitting in a class by Rod Claar and he introduced the concept of using Fit tables for improving collaboration in software development.<\/p>\n

The way Fit tables do this is by enabling stakeholders and business analysts to enter expected input and the proper output in a tool they are comfortable with \u2013 like excel.<\/p>\n

A simple example might look like the following table:<\/p>\n

\"image\"<\/p>\n

The developer can then run through these tables using test automation to verify the application is doing what is expected.\u00a0<\/p>\n

Data bound coded UI tests makes doing a piece of cake with Visual Studio 2010.\u00a0<\/p>\n

**So how do you create a data bound Coded UI Test? **<\/p>\n

1. Create a Test Case in Microsoft Text Manager.\u00a0\u00a0 Note the name of the Test Steps such as \u201cEnter First Number\u201d\u2026as they are important later on.<\/p>\n

\"image\"<\/p>\n

2. Record the actions in the test case<\/p>\n

\"image\"<\/p>\n

3. Create a Coded UI Test (Test > New Test)<\/p>\n

\"image\"<\/p>\n

4. Create the CodeUI Test from the test case<\/p>\n

\"image\"\"image\"<\/p>\n

Below is the resultant test.\u00a0<\/p>\n

\n

<CodedUITest()>
\n Public Class CodedUITest1<\/strong><\/p>\n

\u00a0\u00a0\u00a0\u00a0 Public Sub CodedUITestMethod1()
\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ‘\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0
\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ‘ To generate code for this test, select “Generate Code for Coded UI Test” from the shortcut menu and select one of the menu items.
\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ‘ For more information on generated code, see **http:\/\/go.microsoft.com\/fwlink\/?LinkId=179463<\/a>
\n **\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Me.UIMap.Enterfirstnumber()
\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Me.UIMap.Entersecondnumber()
\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Me.UIMap.PressAdd()<\/strong><\/p>\n

\u00a0 End Sub<\/strong><\/p>\n<\/blockquote>\n

5. Open the Coded UI Properties.<\/p>\n

You do this by opening the Test View window (Text > Windows > Test
\nView) and choosing properties.<\/p>\n

\"image\"<\/p>\n

6. Data bind the Coded UI Test.\u00a0 Under properties choose connection string. (See image above)<\/p>\n

\"image\"\"image\"<\/p>\n

This decorates the Coded UI method definition with a data source attribute you can access from the test context object.<\/p>\n

\n

Public Class CodedUITest1<\/strong><\/p>\n

<DataSource(“Microsoft.VisualStudio.TestTools.DataSource.CSV”, “|DataDirectory|addnumber.csv”, “addnumber#csv”, DataAccessMethod.Sequential)> <DeploymentItem(“TestProject1addnumber.csv”)> <TestMethod()>
\n Public Sub CodedUITestMethod1()<\/strong><\/p>\n<\/blockquote>\n

7.\u00a0 In the Coded UI Test use the built in \u201cParams\u201d object to set the input value from the datasource.\u00a0<\/p>\n

For this test case it looks like:<\/p>\n

\n

Me.UIMap.EnterfirstnumberParams.UITextBox1EditText = TestContext.DataRow(“firstnumber”)<\/strong><\/p>\n<\/blockquote>\n

NOTE: For your specific Test case the param object will take its name from the Test Case.<\/p>\n

8.\u00a0 Now when you run your test you will see it sequentially runs through every row in the data source.\u00a0<\/p>\n

You can change this from sequentially to random in the same properties list you set the data connection string.<\/p>\n

\"image\"<\/p>\n

*<\/p>\n","protected":false},"excerpt":{"rendered":"

A while back I was sitting in a class by Rod Claar and he introduced the concept of using Fit tables for improving collaboration in software development. The way Fit tables do this is by enabling stakeholders and business analysts to enter expected input and the proper output in a tool they are comfortable with […]<\/p>\n","protected":false},"author":81,"featured_media":45953,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1,252],"tags":[],"class_list":["post-5173","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-devops","category-testing"],"acf":[],"blog_post_summary":"

A while back I was sitting in a class by Rod Claar and he introduced the concept of using Fit tables for improving collaboration in software development. The way Fit tables do this is by enabling stakeholders and business analysts to enter expected input and the proper output in a tool they are comfortable with […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/posts\/5173","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/users\/81"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/comments?post=5173"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/posts\/5173\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/media\/45953"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/media?parent=5173"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/categories?post=5173"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/tags?post=5173"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}