How to Compare the Values of consecutive Cells of HTML Table

Question

1.00/5 (1 vote)

See more:

I have Created Dynamically a HTML
table by Using String Bulider.
and Filled the Table with Database Values.
My requirement is to Compare the consecutive Cells Values .
How can I do this .please assist.

------

VB

here is what i have Done
Dim s As New StringBuilder

sSql = "SP_GetValFrmDB '" & param1 & "','" & param2 & "'"
Dim sdt As New SqlDataAdapter(sSql, connects)
sdt.Fill(dtt)

s.Append("<html>")
s.Append("<head>")
s.Append("</head>")
s.Append("<body>")
s.Append("<table>")
s.Append("<tr>")
s.Append("<td>")
s.Append("UID NO")
s.Append("</td>")

s.Append("<td>")
s.Append("Item")
s.Append("</td>")

s.Append("</tr>")

For Each drowt As Data.DataRow In dtt.Rows

Dim uID As String = drowt("uIDNo")
Dim item As String = drowt("itemNm")

s.Append("<tr>")
s.Append("<td>")

s.Append("" & uID & "")
s.Append("</td>")
s.Append("<td>")
s.Append("" & item & "")
s.Append("</td>")
s.Append("</tr>")
Next

s.Append("</table>")


s.Append("</body>")
s.Append("</html>")

Response.Write(s)

for ex the Data OutPut is
UID NO --- Item
123 --- A
123-1 --- B
222 --- C
222-1 --- D
333 --- Z

and I need to Compare UID NOs
like in this Case consecutive cells 123 and Then next 123-1
then i need to Put "---" mark in the Second Cell

the Otput i want is
UID NO --- Item
123 --- A
--- --- B
222 --- C
--- --- D
333 --- Z

May you understand my Question Now.

Posted 29-Aug-13 3:24am

Karwa_Vivek

Updated 29-Aug-13 21:04pm

v5

Add a Solution

Comments

Jameel VM 29-Aug-13 9:41am

Please post the code what you have tried

vinay.tatipamula 29-Aug-13 9:44am

Please elaborate your question.

enhzflep 29-Aug-13 9:44am

First, get a reference to your table. Next, you can just compare the innerHTML value for the two cells you want to check. The table has an array called rows and each element of this array has an array called cells.

So, say you want to compare row0,cell0 with row0,cell1:

var tbl = document.getElementById('insert_id_of_your_table_here');
var row0 = tbl.rows[0];
var cell_0 = row0.cells[0];
var cell_1 = row0.cells[1];
if (cell_0.innerHTML == cell_1.innerHTML)
doSomething();
else
doSomethingElse();

Jameel VM 29-Aug-13 9:52am

Please post the html table mark up also by improving the question.Please don't put codes in comment box

enhzflep 29-Aug-13 11:06am

Out of curiosity Jameel, what advantage do you think posting the 'html table markup' would provide?

Jameel VM 29-Aug-13 11:11am

in order to loop through the table cells i need to know the table structure he made.

Jameel VM 29-Aug-13 11:12am

he can take the dynamically created table structure from the browser view source.right?

enhzflep 29-Aug-13 11:19am

Yes indeed. I guess the point I'm making is that you appear to be coming from a position that assumes the cells will contain something other than plain text.

Given that:
(a) this was not stated explicitly in the question
&
(b) the question states that the values in the table have been pulled from a database, I made the assumption that the content would be plain text.

You just need to iterate over the rows and cells collections, UNLESS the cells contain text data inside controls like <input> or <textarea>. In this instance, naturally enough, the containing elements will be important just as you've said.

We'll have to see what Karwa_Vivek has to say, I guess. :)

Sergey Alexandrovich Kryukov 29-Aug-13 12:21pm

And how is this related to HTML? You can compare whatever you want, but better compare data from database directly.
—SA

enhzflep 30-Aug-13 3:47am

You've been given a strategy to solve the problem, yet you make no comment on it, instead merely dumping some code. Unless you an convince me otherwise, I think it may be about time that I forget about this question. I've assumed you want to check the values of a html table (which implies doing it client-side, or at least somewhere that you dont have access to the data used to create the table) If you're wanting to do it in the same program that created the table - i.e a VB.NET program - then you're doing it wrong!

Karwa_Vivek 30-Aug-13 5:49am

thanks for your valuable comments.this Really helped me a lot.
trying to find the solution my way.
Just "dumped" my code so that someone could understand my Question .
thanks Again enhzflep

enhzflep 30-Aug-13 12:53pm

You're welcome Karwa_Vivek. :) Hope you've a suitable answer to your problem.

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)