NUnit -Data Driven Using Excel

[Vidya]

I am using ‘Telerik Test Framework’(NUnit Template) with VSTS 2012.

Please help me how to do parameterization using Excel in ‘NUnit’ template. If you provide me step by step guide or Video will be great help.

My Sample Code look like this:

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using ArtOfTest.WebAii.Controls.HtmlControls;

using ArtOfTest.WebAii.Controls.HtmlControls.HtmlAsserts;

using ArtOfTest.WebAii.Core;

using ArtOfTest.WebAii.ObjectModel;

using ArtOfTest.WebAii.TestAttributes;

using ArtOfTest.WebAii.TestTemplates;

using NUnit.Framework;

using Core = NUnit.Core;

namespace UnitTestProject1{

[TestFixture]

Public class TelerikNUnitTest1 : BaseTest

{

[Test]

Public void testmethod1()

{

Manager.LaunchNewBrowser(BrowserType.InternetExplorer);

 ActiveBrowser.NavigateTo("http://www.Anaqal.com");

 Find.ByXPath<HtmlInputText>("//input[@type='text' and contains(@name, 'EmailAddressTextBox')]").Text = "[e-mail]";

Find.ById<HtmlInputPassword>("ctl00_ctl00_PageContentPlaceHolder_PageContentPlaceHolder_PasswordTextBox").Text = "Admin1";

}

}

}

I wants to parameterized ‘Email Address’ and ‘Password’ field with multiple data

My Excel sheet contains data like this

EmailAddress	Password
[e-mail]	Pwd123
[e-mail]	pwd456

[Boyan Boev]

Hi Vidya,

If you are using the free Telerik Testing Framework and Visual Studio, you will need to follow their directions for creating a data driven test.

If you are using Test Studio you need first to Bind the test to an external data source and then write the code in a coded step:

// You can reference the column by index

Pages.Google.QText.Text = (string)Data[0];



// Or by name

Pages.Google.QText.Text = (string)Data["Numbers"];

Hope this helps.

Regards,
Boyan Boev
Telerik