| 11 | 4 | 14 | TWELTH LEGISLATIVE ASSEMBLY | ??????? ???????? | 1 | New Session 01 | Local Name01 | 2014-02-26 00:00:00.000 | NULL | 11:00:00 | NULL | 1 | 1 | 1 | New Session 3rd | New Session 3rd | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | False | e7e83032-1cb0-41ea-bca8-ffdedd859cef | 2014-02-10 17:33:11.000 | e7e83032-1cb0-41ea-bca8-ffdedd859124 | 2014-04-19 23:27:31.000 | NULL | NULL | NULL | False | True | NULL | 2014-04-19 23:27:31.000 | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| 13 | 5 | 14 | TWELTH LEGISLATIVE ASSEMBLY | ??????? ???????? | 1 | New Session 01 | Local Name01 | 2014-02-26 00:00:00.000 | NULL | 11:00:00 | NULL | 1 | 1 | 1 | New Session 3rd | New Session 3rd | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | False | e7e83032-1cb0-41ea-bca8-ffdedd859cef | 2014-02-10 17:33:11.000 | e7e83032-1cb0-41ea-bca8-ffdedd859124 | 2014-04-19 23:27:31.000 | NULL | NULL | NULL | False | True | NULL | 2014-04-19 23:27:31.000 | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| 14 | 6 | 14 | TWELTH LEGISLATIVE ASSEMBLY | ????? ???????? | 1 | New Session 01 | Local Name01 | 2014-02-26 00:00:00.000 | NULL | 11:00:00 | NULL | 1 | 1 | 1 | New Session 3rd | New Session 3rd | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | False | e7e83032-1cb0-41ea-bca8-ffdedd859cef | 2014-02-10 17:33:11.000 | e7e83032-1cb0-41ea-bca8-ffdedd859124 | 2014-04-19 23:27:31.000 | NULL | NULL | NULL | False | True | NULL | 2014-04-19 23:27:31.000 | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| 16 | 3 | 14 | TWELTH LEGISLATIVE ASSEMBLY | ??????? ???????? | 1 | New Session 01 | Local Name01 | 2014-02-26 00:00:00.000 | NULL | 11:00:00 | NULL | 1 | 1 | 1 | New Session 3rd | New Session 3rd | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | False | e7e83032-1cb0-41ea-bca8-ffdedd859cef | 2014-02-10 17:33:11.000 | e7e83032-1cb0-41ea-bca8-ffdedd859124 | 2014-04-19 23:27:31.000 | NULL | NULL | NULL | False | True | NULL | 2014-04-19 23:27:31.000 | True | NULL | 4/20/2014 1:09:53 AM | NULL | NULL | NULL | NULL |
| 17 | 7 | 14 | TWELTH LEGISLATIVE ASSEMBLY | ??????? ???????? | 1 | New Session 01 | Local Name01 | 2014-02-26 00:00:00.000 | NULL | 11:00:00 | NULL | 1 | 1 | 1 | New Session 3rd | New Session 3rd | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | False | e7e83032-1cb0-41ea-bca8-ffdedd859cef | 2014-02-10 17:33:11.000 | e7e83032-1cb0-41ea-bca8-ffdedd859124 | 2014-04-19 23:27:31.000 | NULL | NULL | NULL | False | True | NULL | 2014-04-19 23:27:31.000 | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| 18 | 3 | 14 | TWELTH LEGISLATIVE ASSEMBLY | ??????? ???????? | 1 | New Session 01 | Local Name01 | 2014-02-26 00:00:00.000 | NULL | 11:00:00 | NULL | 1 | 1 | 1 | New Session 3rd | New Session 3rd | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | False | e7e83032-1cb0-41ea-bca8-ffdedd859cef | 2014-02-10 17:33:11.000 | e7e83032-1cb0-41ea-bca8-ffdedd859124 | 2014-04-19 23:27:31.000 | NULL | NULL | NULL | False | True | NULL | 2014-04-19 23:27:31.000 | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| 19 | 3 | 14 | TWELTH LEGISLATIVE ASSEMBLY | ??????? ???????? | 1 | New Session 01 | Local Name01 | 2014-02-26 00:00:00.000 | NULL | 11:00:00 | NULL | 1 | 1 | 1 | New Session 3rd | New Session 3rd | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | False | e7e83032-1cb0-41ea-bca8-ffdedd859cef | 2014-02-10 17:33:11.000 | e7e83032-1cb0-41ea-bca8-ffdedd859124 | 2014-04-19 23:27:31.000 | NULL | NULL | NULL | False | True | NULL | 2014-04-19 23:27:31.000 | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| 20 | 7 | 14 | TWELTH LEGISLATIVE ASSEMBLY | ??????? ???????? | 1 | New Session 01 | Local Name01 | 2014-02-26 00:00:00.000 | NULL | 11:00:00 | NULL | 1 | 1 | 1 | New Session 3rd | New Session 3rd | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | False | e7e83032-1cb0-41ea-bca8-ffdedd859cef | 2014-02-10 17:33:11.000 | e7e83032-1cb0-41ea-bca8-ffdedd859124 | 2014-04-19 23:27:31.000 | NULL | NULL | NULL | False | True | NULL | 2014-04-19 23:27:31.000 | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| 21 | 7 | 14 | TWELTH LEGISLATIVE ASSEMBLY | ??????? ???????? | 1 | New Session 01 | Local Name01 | 2014-02-26 00:00:00.000 | NULL | 11:00:00 | NULL | 1 | 1 | 1 | New Session 3rd | New Session 3rd | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | False | e7e83032-1cb0-41ea-bca8-ffdedd859cef | 2014-02-10 17:33:11.000 | e7e83032-1cb0-41ea-bca8-ffdedd859124 | 2014-04-19 23:27:31.000 | NULL | NULL | NULL | False | True | NULL | 2014-04-19 23:27:31.000 | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
Loading
Mukesh Kumar TiwariPosted Apr 29, 2014, 1:00 AM
select new
{
stud.name,
stud.roll,
stud.marks
}).Distinct();
Jignesh TrivediPosted Apr 22, 2014, 3:39 AM
Yes distinct may help but for the distinct value you have to remove first column ( values 11 to 21)....
can please share you linq query so that we can change it.
also refer
http://www.codeproject.com/Articles/535374/DistinctBy-in-Linq-Find-Distinct-object-by-Propert
http://abundantcode.com/how-to-remove-duplicates-and-get-distinct-records-from-list-using-linq/
hope this will help you.
AshishPosted Apr 22, 2014, 2:16 AM