Click here to Skip to main content
14,602,124 members
   

C#

 
AnswerRe: Is it at all possible to get the REAL amount of memory installed on the computer? Pin
Dave Kreskowiak9-Jun-09 7:05
mveDave Kreskowiak9-Jun-09 7:05 
GeneralRe: Is it at all possible to get the REAL amount of memory installed on the computer? Pin
Luc Pattyn9-Jun-09 7:24
sitebuilderLuc Pattyn9-Jun-09 7:24 
GeneralRe: Is it at all possible to get the REAL amount of memory installed on the computer? [modified] Pin
taralex9-Jun-09 7:38
Membertaralex9-Jun-09 7:38 
QuestionTaking screenshots from games Pin
SimpleData9-Jun-09 4:13
MemberSimpleData9-Jun-09 4:13 
GeneralRe: Taking screenshots from games Pin
harold aptroot9-Jun-09 5:30
Memberharold aptroot9-Jun-09 5:30 
AnswerRe: Taking screenshots from games Pin
Baeltazor9-Jun-09 6:14
MemberBaeltazor9-Jun-09 6:14 
GeneralRe: Taking screenshots from games Pin
Anthony Mushrow9-Jun-09 13:54
professionalAnthony Mushrow9-Jun-09 13:54 
QuestionHow I can filter out Child Entities Pin
Qasim19849-Jun-09 3:21
professionalQasim19849-Jun-09 3:21 
Dear Sir/madom

I have three tables

1. Categorys (ID, Name)
2. Definitions (ID, Name, CategoryID)
3. Versions( ID, Name, DefinitionID)

I have generated three objects using EDM
1 Cagegorys
Navigation (Definition)
2. Definitions
Navigation (Category, Version)
3. Versions
Navigation (Definition)


I want to get latest versions against each category

My Code is as follow It return all version against the categoryId but I want to get only latest version of each definition against a category.


DataEntities data = new DataEntities();

Category cat = (from c in data.Categorys where c.ID == CategoryID select c).First();

IList<definition> defintions = (from d in data.Definitions.Include("Versions") where d.Category.ID == cat.ID select d).ToList();

IList<dynamicforms.data.version> versions;

if (defintions.Count>0)

{

versions = defintions.SelectMany(d=>d.Versions).ToList();


Grid.DataSource = versions;

Grid.DataBind();

}

If I need sub query How I have construct and use subquery in this code

Your early reply will be highly appriciated please.
QuestionHow to copy the selected tree node along with its children and paste the same Pin
Rafone9-Jun-09 3:20
MemberRafone9-Jun-09 3:20 
AnswerRe: How to copy the selected tree node along with its children and paste the same Pin
Mycroft Holmes9-Jun-09 4:21
professionalMycroft Holmes9-Jun-09 4:21 
GeneralRe: How to copy the selected tree node along with its children and paste the same Pin
Rafone9-Jun-09 7:53
MemberRafone9-Jun-09 7:53 
GeneralRe: How to copy the selected tree node along with its children and paste the same Pin
Mycroft Holmes9-Jun-09 14:19
professionalMycroft Holmes9-Jun-09 14:19 
GeneralRe: How to copy the selected tree node along with its children and paste the same Pin
Rafone9-Jun-09 16:28
MemberRafone9-Jun-09 16:28 
QuestionSQL Connection problem Pin
KIDYA9-Jun-09 2:57
MemberKIDYA9-Jun-09 2:57 
AnswerRe: SQL Connection problem Pin
Colin Angus Mackay9-Jun-09 3:02
MemberColin Angus Mackay9-Jun-09 3:02 
GeneralRe: SQL Connection problem Pin
KIDYA9-Jun-09 3:04
MemberKIDYA9-Jun-09 3:04 
GeneralRe: SQL Connection problem Pin
Colin Angus Mackay9-Jun-09 3:06
MemberColin Angus Mackay9-Jun-09 3:06 
GeneralRe: SQL Connection problem Pin
KIDYA9-Jun-09 3:09
MemberKIDYA9-Jun-09 3:09 
GeneralRe: SQL Connection problem Pin
Eddy Vluggen9-Jun-09 3:11
professionalEddy Vluggen9-Jun-09 3:11 
JokeRe: SQL Connection problem Pin
Luc Pattyn9-Jun-09 3:24
sitebuilderLuc Pattyn9-Jun-09 3:24 
GeneralRe: SQL Connection problem Pin
Mycroft Holmes9-Jun-09 4:17
professionalMycroft Holmes9-Jun-09 4:17 
GeneralTelepathetic Software is already here Pin
Ennis Ray Lynch, Jr.9-Jun-09 5:38
MemberEnnis Ray Lynch, Jr.9-Jun-09 5:38 
GeneralRe: SQL Connection problem Pin
SilimSayo9-Jun-09 6:30
MemberSilimSayo9-Jun-09 6:30 
AnswerRe: SQL Connection problem Pin
saanj9-Jun-09 3:13
Membersaanj9-Jun-09 3:13 
AnswerRe: SQL Connection problem Pin
Simon P Stevens9-Jun-09 5:01
MemberSimon P Stevens9-Jun-09 5:01 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.