Click here to Skip to main content
15,893,266 members
Home / Discussions / C#
   

C#

 
AnswerRe: How do I Prevent addition to collections returned by properties Pin
leppie29-Aug-03 7:43
leppie29-Aug-03 7:43 
GeneralRe: How do I Prevent addition to collections returned by properties Pin
Daniel Turini29-Aug-03 8:38
Daniel Turini29-Aug-03 8:38 
GeneralRe: How do I Prevent addition to collections returned by properties Pin
Rahul Singh29-Aug-03 9:00
Rahul Singh29-Aug-03 9:00 
GeneralRe: How do I Prevent addition to collections returned by properties Pin
Rahul Singh29-Aug-03 9:02
Rahul Singh29-Aug-03 9:02 
GeneralRe: How do I Prevent addition to collections returned by properties Pin
Daniel Turini29-Aug-03 9:13
Daniel Turini29-Aug-03 9:13 
GeneralRe: How do I Prevent addition to collections returned by properties Pin
leppie29-Aug-03 13:23
leppie29-Aug-03 13:23 
GeneralComponentServices Pin
0siris29-Aug-03 5:52
0siris29-Aug-03 5:52 
GeneralUsing Paint or something to create pseudo columns with a tree view Pin
Ista29-Aug-03 5:20
Ista29-Aug-03 5:20 
QuestionBest Practices? Pin
econner29-Aug-03 5:05
econner29-Aug-03 5:05 
GeneralClass parser in C# Pin
thedex29-Aug-03 4:22
thedex29-Aug-03 4:22 
GeneralRe: Class parser in C# Pin
Frank Olorin Rizzi29-Aug-03 7:37
Frank Olorin Rizzi29-Aug-03 7:37 
GeneralRe: Class parser in C# Pin
leppie29-Aug-03 7:49
leppie29-Aug-03 7:49 
GeneralRe: Class parser in C# Pin
Frank Olorin Rizzi29-Aug-03 8:20
Frank Olorin Rizzi29-Aug-03 8:20 
GeneralRe: Class parser in C# Pin
leppie29-Aug-03 9:05
leppie29-Aug-03 9:05 
GeneralRe: Class parser in C# Pin
Frank Olorin Rizzi29-Aug-03 11:28
Frank Olorin Rizzi29-Aug-03 11:28 
GeneralRe: Class parser in C# Pin
leppie29-Aug-03 13:40
leppie29-Aug-03 13:40 
Generaldatagrid Pin
Member 52474029-Aug-03 1:26
Member 52474029-Aug-03 1:26 
GeneralFind the greatest and the smallest Pin
laphijia28-Aug-03 22:34
laphijia28-Aug-03 22:34 
GeneralRe: Find the greatest and the smallest Pin
Paul Ingles29-Aug-03 0:14
Paul Ingles29-Aug-03 0:14 
Well, firstly you can use the SQL Aggregation functions MIN and MAX on the columns... i.e. SELECT MAX(xCord) FROM Coords.

If you want to tie it into one query you'll probably have to start using sub-queries.

Performance wise, I'm not sure how you'll optimise it. The only other alternative would be to re-visit the design so that if it's read-intensive that the majority of the calculations etc. are done during an insert or update, whether that's possible (and how it might be so) is dependent upon the application and design, sorry to be so vague Smile | :)

--
Paul
"Put the key of despair into the lock of apathy. Turn the knob of mediocrity slowly and open the gates of despondency - welcome to a day in the average office."
- David Brent, from "The Office"

MS Messenger: paul@oobaloo.co.uk
Download my PGP public key

GeneralSimple question: StreamWriter Pin
devvvy28-Aug-03 21:52
devvvy28-Aug-03 21:52 
GeneralRe: Simple question: StreamWriter Pin
Daniel Turini29-Aug-03 8:00
Daniel Turini29-Aug-03 8:00 
GeneralRe: Simple question: StreamWriter Pin
Tatham30-Aug-03 19:03
Tatham30-Aug-03 19:03 
QuestionInt* into IntPtr? Pin
novachen28-Aug-03 19:18
novachen28-Aug-03 19:18 
AnswerRe: Int* into IntPtr? Pin
MaxVC29-Aug-03 4:40
MaxVC29-Aug-03 4:40 
AnswerRe: Int* into IntPtr? Pin
leppie29-Aug-03 7:19
leppie29-Aug-03 7:19 

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.