Click here to Skip to main content
11,575,635 members (60,297 online)
   

Database

 
QuestionProblem with MySQL stored procedure Pin
jrahma7-Oct-12 7:27
memberjrahma7-Oct-12 7:27 
AnswerRe: Problem with MySQL stored procedure Pin
Jörgen Andersson7-Oct-12 10:43
memberJörgen Andersson7-Oct-12 10:43 
GeneralRe: Problem with MySQL stored procedure Pin
jrahma7-Oct-12 10:52
memberjrahma7-Oct-12 10:52 
AnswerRe: Problem with MySQL stored procedure Pin
Eddy Vluggen8-Oct-12 0:51
memberEddy Vluggen8-Oct-12 0:51 
AnswerRe: Problem with MySQL stored procedure Pin
Bernhard Hiller7-Oct-12 22:26
memberBernhard Hiller7-Oct-12 22:26 
GeneralRe: Problem with MySQL stored procedure Pin
jrahma7-Oct-12 23:31
memberjrahma7-Oct-12 23:31 
AnswerRe: Problem with MySQL stored procedure Pin
Shameel8-Oct-12 1:56
memberShameel8-Oct-12 1:56 
GeneralRe: Problem with MySQL stored procedure Pin
jrahma8-Oct-12 6:54
memberjrahma8-Oct-12 6:54 
GeneralRe: Problem with MySQL stored procedure Pin
jrahma8-Oct-12 7:11
memberjrahma8-Oct-12 7:11 
Questionterminating SqlConnection.Open() call while connecting Pin
Dan_K4-Oct-12 7:43
memberDan_K4-Oct-12 7:43 
AnswerRe: terminating SqlConnection.Open() call while connecting Pin
Shameel4-Oct-12 8:46
memberShameel4-Oct-12 8:46 
AnswerRe: terminating SqlConnection.Open() call while connecting Pin
Eddy Vluggen4-Oct-12 9:10
memberEddy Vluggen4-Oct-12 9:10 
GeneralRe: terminating SqlConnection.Open() call while connecting Pin
Dan_K5-Oct-12 4:37
memberDan_K5-Oct-12 4:37 
GeneralRe: terminating SqlConnection.Open() call while connecting Pin
Eddy Vluggen5-Oct-12 4:57
memberEddy Vluggen5-Oct-12 4:57 
Dan_K wrote:
I tried in my own way which works fine now. My BackgroundWorker thread creates a new thread and the created thread rather calls SqlConnection.Open(). When the cancel button is clicked, the BackgroundWorker thread aborts the thread opening the connection.

That's what the OpenAsync in 4.5 will do; open the query on a backgroundthread, polling it's status.

Dan_K wrote:
It works fine although I don't know if there could be any related problems.

Opening a connection can fail for multiple reasons, and exceptions aren't casted across the thread. You might want to make sure you have a good exception-handler in there; if you have the time, then it'd be mighty cool to have a "try connecting again" function - that way people won't have to relaunch the app after they found out that the database-server wasn't powered on.
Bastard Programmer from Hell Suspicious | :suss:
if you can't read my code, try converting it here[^]

QuestionSQL 2000 to 2008R2 Query Performance Pin
cjb1104-Oct-12 5:13
membercjb1104-Oct-12 5:13 
AnswerRe: SQL 2000 to 2008R2 Query Performance Pin
Shameel4-Oct-12 9:01
memberShameel4-Oct-12 9:01 
GeneralRe: SQL 2000 to 2008R2 Query Performance Pin
cjb1104-Oct-12 22:30
membercjb1104-Oct-12 22:30 
AnswerExecution plan Pin
David Mujica4-Oct-12 10:25
memberDavid Mujica4-Oct-12 10:25 
GeneralRe: Execution plan Pin
cjb1104-Oct-12 20:58
membercjb1104-Oct-12 20:58 
GeneralRe: Execution plan Pin
David Mujica8-Oct-12 8:54
memberDavid Mujica8-Oct-12 8:54 
GeneralRe: Execution plan Pin
cjb1108-Oct-12 23:41
membercjb1108-Oct-12 23:41 
GeneralRe: Execution plan Pin
David Mujica9-Oct-12 3:12
memberDavid Mujica9-Oct-12 3:12 
GeneralRe: Execution plan Pin
cjb1109-Oct-12 4:34
membercjb1109-Oct-12 4:34 
GeneralHigh CPU Pin
David Mujica9-Oct-12 9:13
memberDavid Mujica9-Oct-12 9:13 
GeneralRe: High CPU Pin
cjb11010-Oct-12 21:30
membercjb11010-Oct-12 21:30 
GeneralRe: High CPU Pin
cjb11010-Oct-12 23:15
membercjb11010-Oct-12 23:15 
QuestionMySQL Server timestamp changed! Pin
jrahma2-Oct-12 21:53
memberjrahma2-Oct-12 21:53 
AnswerRe: MySQL Server timestamp changed! Pin
Shameel3-Oct-12 4:05
memberShameel3-Oct-12 4:05 
QuestionConnection String for Ms access 2010 to Windows 7 64 Bit Pin
Satyam Tripathi2-Oct-12 21:33
memberSatyam Tripathi2-Oct-12 21:33 
AnswerRe: Connection String for Ms access 2010 to Windows 7 64 Bit Pin
Richard MacCutchan2-Oct-12 22:00
mvpRichard MacCutchan2-Oct-12 22:00 
QuestionBackup/Recover of row data in a multi-Company database Pin
DeDawg2-Oct-12 10:35
memberDeDawg2-Oct-12 10:35 
AnswerRe: Backup/Recover of row data in a multi-Company database Pin
Mika Wendelius2-Oct-12 11:17
mvpMika Wendelius2-Oct-12 11:17 
GeneralRe: Backup/Recover of row data in a multi-Company database Pin
DeDawg2-Oct-12 11:22
memberDeDawg2-Oct-12 11:22 
GeneralRe: Backup/Recover of row data in a multi-Company database Pin
Mika Wendelius2-Oct-12 18:22
mvpMika Wendelius2-Oct-12 18:22 
AnswerRe: Backup/Recover of row data in a multi-Company database Pin
Mycroft Holmes3-Oct-12 7:39
memberMycroft Holmes3-Oct-12 7:39 
GeneralRe: Backup/Recover of row data in a multi-Company database Pin
DeDawg3-Oct-12 7:43
memberDeDawg3-Oct-12 7:43 
GeneralRe: Backup/Recover of row data in a multi-Company database Pin
Mycroft Holmes3-Oct-12 8:02
memberMycroft Holmes3-Oct-12 8:02 
Questioncannot find column Pin
sindhuan1-Oct-12 0:19
membersindhuan1-Oct-12 0:19 
AnswerRe: cannot find column Pin
Eddy Vluggen1-Oct-12 1:00
memberEddy Vluggen1-Oct-12 1:00 
QuestionHow to Recover Deleted rows from sql 2000 Database Pin
Robymon30-Sep-12 20:38
memberRobymon30-Sep-12 20:38 
AnswerRe: How to Recover Deleted rows from sql 2000 Database Pin
Eddy Vluggen1-Oct-12 0:57
memberEddy Vluggen1-Oct-12 0:57 
AnswerRe: How to Recover Deleted rows from sql 2000 Database Pin
Shameel3-Oct-12 5:46
memberShameel3-Oct-12 5:46 
QuestionWindows Run Command Pin
jojoba201128-Sep-12 23:08
memberjojoba201128-Sep-12 23:08 
AnswerRe: Windows Run Command Pin
Eddy Vluggen29-Sep-12 2:41
memberEddy Vluggen29-Sep-12 2:41 
AnswerRe: Windows Run Command Pin
Richard MacCutchan29-Sep-12 2:58
mvpRichard MacCutchan29-Sep-12 2:58 
AnswerRe: Windows Run Command Pin
jojoba201129-Sep-12 5:12
memberjojoba201129-Sep-12 5:12 
GeneralRe: Windows Run Command Pin
Richard MacCutchan29-Sep-12 6:09
mvpRichard MacCutchan29-Sep-12 6:09 
QuestionRe: Windows Run Command Pin
jojoba201129-Sep-12 9:26
memberjojoba201129-Sep-12 9:26 
AnswerRe: Windows Run Command Pin
Richard MacCutchan29-Sep-12 21:29
mvpRichard MacCutchan29-Sep-12 21:29 
GeneralRe: Windows Run Command Pin
jojoba201129-Sep-12 22:40
memberjojoba201129-Sep-12 22:40 

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

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


Advertise | Privacy | Mobile
Web04 | 2.8.150624.2 | Last Updated 3 Jul 2015
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid