Click here to Skip to main content
15,891,423 members
Home / Discussions / C#
   

C#

 
AnswerRe: Read Records then Count Pin
Pete O'Hanlon14-Oct-15 5:09
mvePete O'Hanlon14-Oct-15 5:09 
SuggestionRe: Read Records then Count Pin
Richard Deeming14-Oct-15 5:24
mveRichard Deeming14-Oct-15 5:24 
GeneralRe: Read Records then Count Pin
Eddy Vluggen14-Oct-15 6:35
professionalEddy Vluggen14-Oct-15 6:35 
GeneralRe: Read Records then Count Pin
Pete O'Hanlon14-Oct-15 7:43
mvePete O'Hanlon14-Oct-15 7:43 
AnswerRe: Read Records then Count Pin
OriginalGriff14-Oct-15 5:16
mveOriginalGriff14-Oct-15 5:16 
SuggestionRe: Read Records then Count Pin
Matt T Heffron14-Oct-15 7:52
professionalMatt T Heffron14-Oct-15 7:52 
GeneralRe: Read Records then Count Pin
OriginalGriff14-Oct-15 8:02
mveOriginalGriff14-Oct-15 8:02 
GeneralRe: Read Records then Count Pin
macca2414-Oct-15 22:18
macca2414-Oct-15 22:18 
I should have said I am trying to do this using LINQ:

I have a 20 records in a database table. Each record has and ID. I want to read a field in each record fieldA. I only want to read the records that have an ID '1'. For each record that has an ID '1' and fieldA Is Not Null I want to return a count of those records.
So if 10 records have data in fieldA and have ID '1' then my count for fieldA will be 10.

Anyone know how to do this in Linq?
GeneralRe: Read Records then Count Pin
Agent__00714-Oct-15 22:56
professionalAgent__00714-Oct-15 22:56 
GeneralRe: Read Records then Count Pin
Richard Deeming15-Oct-15 2:43
mveRichard Deeming15-Oct-15 2:43 
GeneralRe: Read Records then Count Pin
Agent__00715-Oct-15 4:05
professionalAgent__00715-Oct-15 4:05 
GeneralRe: Read Records then Count Pin
Richard Deeming15-Oct-15 4:10
mveRichard Deeming15-Oct-15 4:10 
GeneralRe: Read Records then Count Pin
Agent__00715-Oct-15 4:17
professionalAgent__00715-Oct-15 4:17 
GeneralRe: Read Records then Count Pin
macca2415-Oct-15 4:16
macca2415-Oct-15 4:16 
GeneralRe: Read Records then Count Pin
Agent__00715-Oct-15 17:58
professionalAgent__00715-Oct-15 17:58 
GeneralRe: Read Records then Count Pin
macca2427-Oct-15 5:49
macca2427-Oct-15 5:49 
GeneralRe: Read Records then Count Pin
Agent__00727-Oct-15 16:41
professionalAgent__00727-Oct-15 16:41 
QuestionWhy does Navigation throw null exception when returning to a page 2nd time Pin
Sultan Uz Zaman13-Oct-15 19:30
Sultan Uz Zaman13-Oct-15 19:30 
SuggestionRe: Why does Navigation throw null exception when returning to a page 2nd time Pin
Richard MacCutchan13-Oct-15 21:41
mveRichard MacCutchan13-Oct-15 21:41 
GeneralRe: Why does Navigation throw null exception when returning to a page 2nd time Pin
Sultan Uz Zaman13-Oct-15 22:42
Sultan Uz Zaman13-Oct-15 22:42 
GeneralRe: Why does Navigation throw null exception when returning to a page 2nd time Pin
Richard MacCutchan13-Oct-15 22:45
mveRichard MacCutchan13-Oct-15 22:45 
GeneralRe: Why does Navigation throw null exception when returning to a page 2nd time Pin
Sultan Uz Zaman13-Oct-15 22:57
Sultan Uz Zaman13-Oct-15 22:57 
GeneralRe: Why does Navigation throw null exception when returning to a page 2nd time Pin
Richard MacCutchan13-Oct-15 23:22
mveRichard MacCutchan13-Oct-15 23:22 
AnswerRe: Why does Navigation throw null exception when returning to a page 2nd time Pin
NeillJam14-Oct-15 0:24
NeillJam14-Oct-15 0:24 
GeneralRe: Why does Navigation throw null exception when returning to a page 2nd time Pin
Sultan Uz Zaman14-Oct-15 1:42
Sultan Uz Zaman14-Oct-15 1:42 

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.