select the distinct values from the datatable

Question

2.54/5 (3 votes)

See more:

i have the read the some value from the database in data Table in C#.NET.
in this datatable the following value contains

batch  tag     pcdatelogged
1      11   12-12-2012 11:35
1      12   12-12-2012 11:36
1      13   12-12-2012 11:37
1      14   12-12-2012 11:38
2      15   12-12-2012 11:39
2      16   12-12-2012 11:40
2      17   12-12-2012 11:41
2      18   12-12-2012 11:42

i want to select the distinct values from the datatable & display into the grid

batch  tag(last value)   pcdatelogged(min)   pcdatelogged(max)
1           14           12-12-2012 11:35    12-12-2012 11:38
2           18           12-12-2012 11:39    12-12-2012 11:42

i want the above output in the grid

Thanks in advance

Posted 30-Dec-11 18:25pm

vrushali katkade

Updated 23-Sep-19 3:25am

v2

Add a Solution

3 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)

bluesathish · Answer 1 · 2011-12-30T18:46:00

Solution 1

Hi vrushali,
Try this code, i think it'll be helpful for you.

SQL

ds.Tables["datatablename"].DefaultView.ToTable(true, "batch"); 
dt.DefaultView.ToTable(true, "batch");

Quote:
where ds is a Dataset object.

Regards,
Bluesathish

Posted 30-Dec-11 18:46pm

bluesathish

Comments

vrushali katkade 31-Dec-11 1:08am

thanks for the replay ,what about another columns, its only distinct the batch column

bluesathish 31-Dec-11 1:12am

Then try this one,
DataView view = new DataView(table);
DataTable distinctValues = view.ToTable(true, "Column1", "Column2" ...);

ref: http://stackoverflow.com/questions/1199176/how-to-select-distinct-values-from-datatable

Amir Mahfoozi · Answer 2 · 2011-12-30T20:25:00

Here is one solution :

SQL

if OBJECT_ID('tempdb..#t') is not null
  drop table #t
select  * , ROW_NUMBER() over ( partition by batch order by batch, tag) no  into #t from  events

select s.batch, tag, min , max from 
(select max(no) no, MIN(pcdatelogged) min , MAX(pcdatelogged) max , batch from #t group by batch) s
join #t on #t.no = s.no and #t.batch = s.batch

Convert it to a stored procedure and retrieve data with a suitable datasource.

Hope it helps.

Member 8983639 · Answer 3 · 2012-06-10T20:50:00

Solution 3

select distinct * from datatablename

Posted 10-Jun-12 20:50pm

Member 8983639