Click here to Skip to main content
15,905,233 members
Home / Discussions / C#
   

C#

 
AnswerRe: create public variables at run time Pin
NavnathKale10-Apr-10 0:56
NavnathKale10-Apr-10 0:56 
GeneralRe: create public variables at run time Pin
Jassim Rahma10-Apr-10 12:02
Jassim Rahma10-Apr-10 12:02 
GeneralRe: create public variables at run time Pin
NavnathKale10-Apr-10 21:49
NavnathKale10-Apr-10 21:49 
Questionkeep one sqlconnection alive Pin
Jassim Rahma8-Apr-10 13:31
Jassim Rahma8-Apr-10 13:31 
AnswerRe: keep one sqlconnection alive Pin
PIEBALDconsult8-Apr-10 13:59
mvePIEBALDconsult8-Apr-10 13:59 
GeneralRe: keep one sqlconnection alive Pin
Jassim Rahma8-Apr-10 14:14
Jassim Rahma8-Apr-10 14:14 
GeneralRe: keep one sqlconnection alive Pin
PIEBALDconsult8-Apr-10 17:11
mvePIEBALDconsult8-Apr-10 17:11 
GeneralRe: keep one sqlconnection alive Pin
Dave Kreskowiak8-Apr-10 17:48
mveDave Kreskowiak8-Apr-10 17:48 
Usually, you open and close the connection on every operation. You don't keep a connection open for the life of a form or for an entire applications lifetime. SQL Server (or other) licenses are expensive and connections consume resources on both the client and server side. You grab a connection, use it, then release it when your operation is complete.

Again, you UI code should have nothing to do with the database connection at all. That is up to your business and data layers.

A guide to posting questions on CodeProject[^]



Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
     2006, 2007, 2008
But no longer in 2009...




AnswerRe: keep one sqlconnection alive Pin
Not Active8-Apr-10 14:13
mentorNot Active8-Apr-10 14:13 
AnswerRe: keep one sqlconnection alive Pin
N a v a n e e t h8-Apr-10 16:21
N a v a n e e t h8-Apr-10 16:21 
Questionmake a default printer Pin
Jassim Rahma8-Apr-10 13:30
Jassim Rahma8-Apr-10 13:30 
AnswerRe: make a default printer Pin
loyal ginger9-Apr-10 7:02
loyal ginger9-Apr-10 7:02 
QuestionText overlay on webcam streaming videos PinPopular
bdb388658-Apr-10 12:46
bdb388658-Apr-10 12:46 
QuestionInput type ="image" in c# Pin
tedyboy98-Apr-10 11:15
tedyboy98-Apr-10 11:15 
AnswerRe: Input type ="image" in c# Pin
Arun Jacob8-Apr-10 19:07
Arun Jacob8-Apr-10 19:07 
GeneralRe: Input type ="image" in c# Pin
tedyboy98-Apr-10 21:07
tedyboy98-Apr-10 21:07 
QuestionManualResetEvent set()/waitOne() Pin
igalep1328-Apr-10 9:17
igalep1328-Apr-10 9:17 
AnswerRe: ManualResetEvent set()/waitOne() Pin
Luc Pattyn8-Apr-10 9:26
sitebuilderLuc Pattyn8-Apr-10 9:26 
AnswerRe: ManualResetEvent set()/waitOne() Pin
supercat98-Apr-10 9:44
supercat98-Apr-10 9:44 
GeneralRe: ManualResetEvent set()/waitOne() Pin
igalep1328-Apr-10 10:09
igalep1328-Apr-10 10:09 
AnswerRe: ManualResetEvent set()/waitOne() Pin
igalep1328-Apr-10 10:52
igalep1328-Apr-10 10:52 
GeneralRe: ManualResetEvent set()/waitOne() Pin
igalep1329-Apr-10 0:37
igalep1329-Apr-10 0:37 
GeneralRe: ManualResetEvent set()/waitOne() Pin
supercat910-Apr-10 13:21
supercat910-Apr-10 13:21 
QuestionLegal issue - Using controls from Code Project in commercial applications Pin
ekareem8-Apr-10 8:11
ekareem8-Apr-10 8:11 
AnswerRe: Legal issue - Using controls from Code Project in commercial applications Pin
EliottA8-Apr-10 8:45
EliottA8-Apr-10 8:45 

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.