Click here to Skip to main content
15,921,577 members
Home / Discussions / C#
   

C#

 
AnswerRe: Smooth scrolling scrollbars Pin
Gaurav Dudeja India8-Apr-10 20:13
Gaurav Dudeja India8-Apr-10 20:13 
GeneralRe: Smooth scrolling scrollbars Pin
N a v a n e e t h8-Apr-10 20:59
N a v a n e e t h8-Apr-10 20:59 
AnswerRe: Smooth scrolling scrollbars Pin
Ravi Bhavnani8-Apr-10 21:43
professionalRavi Bhavnani8-Apr-10 21:43 
Questioncreate public variables at run time Pin
Jassim Rahma8-Apr-10 13:36
Jassim Rahma8-Apr-10 13:36 
AnswerRe: create public variables at run time Pin
PIEBALDconsult8-Apr-10 14:01
mvePIEBALDconsult8-Apr-10 14:01 
GeneralRe: create public variables at run time Pin
Jassim Rahma8-Apr-10 14:15
Jassim Rahma8-Apr-10 14:15 
AnswerRe: create public variables at run time Pin
Not Active8-Apr-10 14:39
mentorNot Active8-Apr-10 14:39 
GeneralRe: create public variables at run time Pin
Jassim Rahma9-Apr-10 11:52
Jassim Rahma9-Apr-10 11:52 
GeneralRe: create public variables at run time Pin
Not Active9-Apr-10 14:04
mentorNot Active9-Apr-10 14:04 
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 

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.