Use Data Source Columns in Code

Test Studio allows you to insert any custom code in the tests - that includes the option to convert an already recorded step to code and use it that way.

Given that, you may need to use the values from the data source in coded steps and this article describes how to access the data columns through code.

• C#
• VB

//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() 

• C#
• VB

//Reference a column by name
Pages.Bing.SbFormQText.Text = Data["Col1"].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("Col1").ToString()

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

This method can also be applied to a Verification:

• C#
• VB

//Reference a column by name
Assert.IsTrue(ActiveBrowser.ContainsText(Data["Col1"].ToString()));

//Reference a column by index (zero based)
Assert.IsTrue(ActiveBrowser.ContainsText(Data[0].ToString()));

'Reference a column by name
Assert.IsTrue(ActiveBrowser.ContainsText(Data("Col1").ToString()))

'Reference a column by index (zero based)
Assert.IsTrue(ActiveBrowser.ContainsText(Data(0).ToString()))