Click here to Skip to main content
15,848,157 members
Home / Discussions / C#
   

C#

 
QuestionSuggesstions on saving 100s of rowsto the database Pin
Giridhar Aruri1-Sep-16 16:27
Giridhar Aruri1-Sep-16 16:27 
AnswerRe: Suggesstions on saving 100s of rowsto the database Pin
OriginalGriff1-Sep-16 21:22
mveOriginalGriff1-Sep-16 21:22 
AnswerRe: Suggesstions on saving 100s of rowsto the database Pin
Eddy Vluggen2-Sep-16 0:10
professionalEddy Vluggen2-Sep-16 0:10 
QuestionNeed to cancel BackgroundWorker Pin
David_411-Sep-16 14:01
David_411-Sep-16 14:01 
AnswerRe: Need to cancel BackgroundWorker Pin
Pete O'Hanlon1-Sep-16 22:01
subeditorPete O'Hanlon1-Sep-16 22:01 
GeneralRe: Need to cancel BackgroundWorker Pin
David_416-Sep-16 9:12
David_416-Sep-16 9:12 
GeneralRe: Need to cancel BackgroundWorker Pin
Pete O'Hanlon6-Sep-16 10:39
subeditorPete O'Hanlon6-Sep-16 10:39 
AnswerRe: Need to cancel BackgroundWorker Pin
Gerry Schmitz3-Sep-16 7:53
mveGerry Schmitz3-Sep-16 7:53 
Yes; the usual reaction is to figure out how to "cancel the query".

Perhaps one should first look at "tuning" the query.

The "query" is being confused with the "what it is that is submitting the query" (existentially speaking). The "query" is the "database server engine"; not some thread that submitted the query.

Is the query returning a scalar or a "set"?

If a set, is it required to be viewed and paged? Reported on?

Is virtualization an option for "paged" results.

Can the execution plan be estimated and presented before kicking off the query?

What is the nature of query? Would a data reader suffice? Can intermediate results be used to confirm kicking of further queries instead of resorting to a single "large" (poorly optimized) query (e.g. when "drilling" down).

etc....

GeneralRe: Need to cancel BackgroundWorker Pin
David_416-Sep-16 9:20
David_416-Sep-16 9:20 
GeneralRe: Need to cancel BackgroundWorker Pin
Gerry Schmitz6-Sep-16 10:08
mveGerry Schmitz6-Sep-16 10:08 
GeneralRe: Need to cancel BackgroundWorker Pin
David_416-Sep-16 10:14
David_416-Sep-16 10:14 
GeneralRe: Need to cancel BackgroundWorker Pin
David_416-Sep-16 10:18
David_416-Sep-16 10:18 
GeneralRe: Need to cancel BackgroundWorker Pin
Gerry Schmitz6-Sep-16 10:48
mveGerry Schmitz6-Sep-16 10:48 
GeneralRe: Need to cancel BackgroundWorker Pin
David_416-Sep-16 11:05
David_416-Sep-16 11:05 
GeneralRe: Need to cancel BackgroundWorker Pin
Gerry Schmitz6-Sep-16 11:25
mveGerry Schmitz6-Sep-16 11:25 
QuestionFacebook login form Pin
Launchar31-Aug-16 19:14
Launchar31-Aug-16 19:14 
AnswerRe: Facebook login form Pin
Mycroft Holmes31-Aug-16 20:38
professionalMycroft Holmes31-Aug-16 20:38 
AnswerRe: Facebook login form Pin
Nathan Minier1-Sep-16 1:59
professionalNathan Minier1-Sep-16 1:59 
QuestionPRINT DATE TIME & TEXT ON PICTUREBOX Pin
Member 1271206730-Aug-16 19:11
Member 1271206730-Aug-16 19:11 
AnswerRe: PRINT DATE TIME & TEXT ON PICTUREBOX Pin
Mycroft Holmes30-Aug-16 21:17
professionalMycroft Holmes30-Aug-16 21:17 
QuestionGet value from string and pass it to another field Pin
Member 1105143930-Aug-16 12:50
Member 1105143930-Aug-16 12:50 
AnswerRe: Get value from string and pass it to another field Pin
Simon_Whale30-Aug-16 14:11
Simon_Whale30-Aug-16 14:11 
AnswerRe: Get value from string and pass it to another field Pin
Dave Kreskowiak30-Aug-16 14:17
mveDave Kreskowiak30-Aug-16 14:17 
Questionobject reference not set to an instance of an object Pin
mmiklauz29-Aug-16 7:38
mmiklauz29-Aug-16 7:38 
AnswerRe: object reference not set to an instance of an object Pin
Pete O'Hanlon29-Aug-16 8:23
subeditorPete O'Hanlon29-Aug-16 8:23 

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.