How to display SQL data in gridview to repeatable row as one! ..

Question

0.00/5 (No votes)

See more:

Hi guys,

I am working on asp.net with c# and I am new at this.

I want to create gridview to retrieve from sql server but I want to list equals cells as one.

For example;
We have data like below in sql
123 123 123
456 456 456
123 123 789
123 321 456
456 456 789
but I want to display
123 123
456 456
123 321
just this columns I have interested to list.

Is there any possibility to make this codes?

What I have tried:

I tried to google to find some example but there is no one made it something like I want.

Posted 7-May-21 3:27am

Nazım Elverdi

Updated 7-May-21 6:05am

Add a Solution

2 solutions

Add a Solution

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)

Richard MacCutchan · Answer 1 · 2021-05-07T03:56:00

Solution 1

Probably something like:

SQL

SELECT col1, col2 from table WHERE col1 = col2;

Posted 7-May-21 3:56am

Richard MacCutchan

CHill60 · Answer 2 · 2021-05-07T06:05:00

Solution 1 will give you the results

I.e. it will not return the value set 123 321. Assuming you just have reversed values and are not wanting all combinations then you could do something like (assumes SQL 2016 or better)

SQL

select col1,col2
from @demo
where col1 = col2 
or  REVERSE(col1) = col2
or REVERSE(col2) = col1;

which returns

To get just the three rows you list as your expected results you will need to use the DISTINCT keyword.
It gets more complex if you want to include col3 as well, but the principle is the same.