Click here to Skip to main content
15,867,568 members
Home / Discussions / C#
   

C#

 
GeneralRe: Convincing web service migration Pin
Daniel Turini1-Aug-03 5:00
Daniel Turini1-Aug-03 5:00 
GeneralRe: Convincing web service migration Pin
Ista1-Aug-03 6:03
Ista1-Aug-03 6:03 
GeneralExcel in C# Pin
don7cry1-Aug-03 0:50
don7cry1-Aug-03 0:50 
GeneralRe: Excel in C# Pin
Philip Fitzsimons1-Aug-03 2:28
Philip Fitzsimons1-Aug-03 2:28 
GeneralRe: Excel in C# Pin
Jesse Squire1-Aug-03 3:07
Jesse Squire1-Aug-03 3:07 
GeneralRe: Excel in C# Pin
Ista1-Aug-03 6:20
Ista1-Aug-03 6:20 
GeneralRe: Excel in C# Pin
sburton@amersham1-Aug-03 7:57
sburton@amersham1-Aug-03 7:57 
Questionsql connection best practise? Pin
isarfraz1-Aug-03 0:34
isarfraz1-Aug-03 0:34 
Dear all,

I am developing a desktop application in c# with sqlserver2000, presently my application is doing following steps to communicate with database.

1. Open the connection
2. Create a command
3. Define the input parameter
3. ExecuteNonQuery
4. Assign new values to input parameters
5. ExecuteNonQuery
6 Close Connection

I need help in this regard, is this best practise regarding desktop applications or not.

what about below option?
that i build sql connection and put it in some public object in some class and next time use this global connection object.

Smile | :) infact i would like to imporve my application speed.

Thanks and regards

Muhammad Sarfraz
AnswerRe: sql connection best practise? Pin
Rampas Tomas1-Aug-03 1:51
Rampas Tomas1-Aug-03 1:51 
GeneralRe: sql connection best practise? Pin
isarfraz1-Aug-03 2:20
isarfraz1-Aug-03 2:20 
GeneralRe: sql connection best practise? Pin
Khang Nguyen1-Aug-03 6:19
Khang Nguyen1-Aug-03 6:19 
QuestionNetwork Access? Pin
Rocky Moore1-Aug-03 0:10
Rocky Moore1-Aug-03 0:10 
AnswerRe: Network Access? Pin
Rampas Tomas1-Aug-03 1:25
Rampas Tomas1-Aug-03 1:25 
GeneralRe: Network Access? Pin
Rocky Moore1-Aug-03 21:17
Rocky Moore1-Aug-03 21:17 
GeneralRe: Network Access? Pin
J. Dunlap1-Aug-03 21:21
J. Dunlap1-Aug-03 21:21 
GeneralRe: Network Access? Pin
Rocky Moore1-Aug-03 22:01
Rocky Moore1-Aug-03 22:01 
GeneralRe: Network Access? Pin
J. Dunlap1-Aug-03 22:19
J. Dunlap1-Aug-03 22:19 
GeneralRe: Network Access? Pin
Rocky Moore2-Aug-03 2:56
Rocky Moore2-Aug-03 2:56 
GeneralInvestigating assemblies Pin
Profox Jase31-Jul-03 22:27
Profox Jase31-Jul-03 22:27 
GeneralRe: Investigating assemblies Pin
Profox Jase31-Jul-03 22:29
Profox Jase31-Jul-03 22:29 
GeneralRe: Investigating assemblies Pin
J. Dunlap31-Jul-03 22:49
J. Dunlap31-Jul-03 22:49 
GeneralRe: Investigating assemblies Pin
James T. Johnson1-Aug-03 0:02
James T. Johnson1-Aug-03 0:02 
GeneralRe: Investigating assemblies Pin
Profox Jase1-Aug-03 0:18
Profox Jase1-Aug-03 0:18 
GeneralRe: Investigating assemblies Pin
leppie1-Aug-03 2:49
leppie1-Aug-03 2:49 
GeneralRe: Investigating assemblies Pin
Nick Parker1-Aug-03 4:12
protectorNick Parker1-Aug-03 4:12 

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.