This is a migrated thread and some comments may be shown as answers.

How to search an item in a htmltable?

23 Answers 1051 Views

General Discussions

This is a migrated thread and some comments may be shown as answers.

23 Answers, 1 is accepted

answered on 12 Mar 2013, 08:39 AM

Hello Sudarshan,

You can achieve this via simple find expressions. Read more about them here.

See below for complete sample code against an html table:

HTML:

<!DOCTYPE html>

<html>

<head>

</head>

<body>

<table border="1" id="myTable">

<tr>

<th>Header 1</th>

<th>Header 2</th>

</tr>

<tr>

<td>row 1, cell 1</td>

<td><a href="http://www.google.com">Google</a></td>

</tr>

<tr>

<td>row 2, cell 1</td>

<td>row 2, cell 2</td>

</tr>

</table>

</body>

</html>

Find expressions (C#):

HtmlTable table = 

Manager.ActiveBrowser.Find.ByAttributes<HtmlTable>(

"id=myTable");

HtmlAnchor googleLink = table.Find.ByAttributes<HtmlAnchor("href=http://www.google.com");

googleLink.Click();

This will locate the table with ID="myTable" then it will find and click on a link with href="http://www.google.com".

I recorded a short video as a demonstration.

Hope this helps.

Greetings,
Boyan Boev
the Telerik team

Quickly become an expert in Test Studio, check out our new training sessions!
Test Studio Trainings

answered on 11 Oct 2013, 06:39 AM

I have a simple HTML table in my application, where I'm searching a particular row by using the expression "innertext=mytext" which is working fine. I just want to make this search as parameter search from data sheet. Please let me know how to pass the data from binded data sheet to ("innertext=xxxxxxx")
Example:
HtmlTableRow myRow = table.Find.ByExpression<HtmlTableRow>("Innertext=abc01");
HtmlTableRow myRow = table.Find.ByExpression<HtmlTableRow>("Innertext=abc02");
HtmlTableRow myRow = table.Find.ByExpression<HtmlTableRow>("Innertext=abc03");

Please let me know if you want any other details

Regards,
- Suresh

answered on 11 Nov 2013, 05:23 AM

SampleHTML-Table.png

Hi Velin,
I have attached a screenshot of sample HTML table which is same as my HTML table.
In the table the data under first column (Column name = CustomerID) is unique and it's hyperlinked.

My Issue:
I want to search a particular CustomerId from first column by it's name & click on it.

Example: I want to search the CustomerID = "KASHM" by name = "KASHM" & click on it.

Please help me in getting this resolved.

Regards,
Suresh

answered on 13 Nov 2013, 11:41 AM

Hello Suresh,

Thank you for the clarifications.

Here is a sample code that executes the same test scenario:

//Find the table on the site.

HtmlTable table = ActiveBrowser.Find.ById<HtmlTable>("myTable");

//Get all rows of the table.

IList<HtmlTableRow> list = table.Find.AllByTagName<HtmlTableRow>("tr");

string name = "KASHM";

//Get the values of the first column.

foreach (HtmlTableRow item in list)

{

//locate the cell from the current row that is in the first column

HtmlTableCell currentCell = item.Cells[0];

//get the link that is inside this cell

HtmlAnchor customerID = currentCell.Find.ByTagIndex<HtmlAnchor>("a", 0);

//if the text content of this link is the same as the name, click on the hyperlink

if (name == customerID.TextContent)

{

customerID.Click();

break;

}

Let me know if this helps.

Regards,
Velin Koychev
Telerik

Quickly become an expert in Test Studio, check out our new training sessions!
Test Studio Trainings

answered on 21 Sep 2014, 03:12 AM

Hi,

I have slightly different scenario. I am evaluating Telerik Test Studio for test automation.
I have Html Table something like:

01.<div class="tab-content">

02. <div id="divIDname" class="tab-pane active" >

03.

04. <table>

05. <tr>

06. <th>Head1</th>

07. <th>Head2</th>

08. <th>Head3</th>

09. </tr>

10.

11. <tr>

12. <td><a href="link">111111</a></td>

13. <td><a href="link">1111</a><br/>22222</td>

14. <td>$434343</td>

15. </tr>

16. </div>

17.</div>

I need to click on the first cell of the table data row. I can't use the text because it may change in future. I need to find "111111" (line no.12) element by path. Could you please tell me how can I use XPath or any other Html find expression to find that element in coded step?

answered on 24 Sep 2014, 01:38 PM

Hi Viral,

Here is how you can locate directly the first table cell (td) in the given div:

HtmlTableCell cell = ActiveBrowser.Find.ByExpression<HtmlTableCell>("id=divIDname", "|", "tagIndex=td:0");

Here is another approach. It firstly locates the second row of the table and then the first cell:

//Find the div with id "divIDname"

HtmlDiv myDiv = ActiveBrowser.Find.ById<HtmlDiv>("divIDname");

//Find the table in the div

HtmlTable myTable = myDiv.Find.ByExpression<HtmlTable>("tagname=table");

//Find the second row

HtmlTableRow row = myTable.Rows[1];

//Find the first cell of the second row

HtmlTableCell cell = row.Cells[0];

Let me know if this helps.

Regards,
Boyan Boev
Telerik

Quickly become an expert in Test Studio, check out our new training sessions!
Test Studio Trainings

answered on 19 Oct 2015, 05:50 PM

code1.jpg

code2.jpg

Hi,

I am trying to automate the similar type of scenario. Application do have a page with HTML table. Each row displays the customer information. First three columns in the table represent Last Name, First Name and Middle Name. Name field in allof these three columns is a hyperlink and on clicking the link user is navigated to another page.

Currently, I am facing issues with the code which performs the task of - Searching the page with the Customer name provided via local data (attached for reference)

When I run the test, below error is displayed even though I have added proper assembly references.

"The type or namespace name 'UI' does not exist in the namespace 'System.Web' (are you missing an assembly reference?)"

Thanks!