Click here to Skip to main content
16,004,977 members
Home / Discussions / C#
   

C#

 
GeneralRe: help for opengl in c# Pin
Pete O'Hanlon10-Feb-08 22:03
mvePete O'Hanlon10-Feb-08 22:03 
GeneralConnection string problem Pin
D i x y10-Feb-08 20:06
D i x y10-Feb-08 20:06 
GeneralRe: Connection string problem Pin
N a v a n e e t h10-Feb-08 20:16
N a v a n e e t h10-Feb-08 20:16 
GeneralRe: Connection string problem Pin
Rupesh Kumar Swami10-Feb-08 20:33
Rupesh Kumar Swami10-Feb-08 20:33 
GeneralRe: Connection string problem Pin
Mircea Puiu10-Feb-08 23:17
Mircea Puiu10-Feb-08 23:17 
GeneralRe: Connection string problem [modified] Pin
Harvey Saayman11-Feb-08 0:28
Harvey Saayman11-Feb-08 0:28 
GeneralRe: Connection string problem Pin
Pete O'Hanlon11-Feb-08 2:37
mvePete O'Hanlon11-Feb-08 2:37 
GeneralRe: Connection string problem Pin
Harvey Saayman11-Feb-08 22:57
Harvey Saayman11-Feb-08 22:57 
hi peepZ

after doing some more research on this topic ive stumbled upon something... i use DataAdapters all through my app.

so let me quote a paragraph in "PRO C# 2008 and the .NET 3.5 platform" page 784 Chapter 23 (incase anyone has this book)

"The data adapter object of your data provider handles the database connections automaticly. In an atempt to increase scalability, data adapters keep the connection open for the shortest amount of time posible.
once the caller receives the DataSet object, the calling tier is compleatly disconected from the database and left with a local copy of the remote data. The caller is free to insert, delete or update rows from a given DataTable, but the physical database is not updated until the caller explicitly passes the DataSet to the dataAdapter for updating. in a nutshell, the datasets allow the clients to pretend they are indeed always connected, when infact the are operating on an in memory database"

having read this there is nothing wrong with passing a SqlConnection between forms because i never actualy do SqlConnection.Open() i just pass the closed connection to the dataAdapter which then manages the connections for me

therefore i dont see a problem? i might be wrong, like i said im just a rookie!
i did how ever use the app.Config file to save my connection string but i only use this once in Main().

the problem i hav with making a new connection every time u need data from the db is LAG. its takes a noticeable amount of time to open forms and all the forms in my app query the database before frmWhatEver.Show() is called.

thanx

Harvey Saayman - South Africa
Junior Developer
.Net, C#, SQL
think BIG and kick ASS

GeneralRe: Connection string problem Pin
Dave Kreskowiak11-Feb-08 3:49
mveDave Kreskowiak11-Feb-08 3:49 
GeneralRe: Connection string problem Pin
Pete O'Hanlon11-Feb-08 2:41
mvePete O'Hanlon11-Feb-08 2:41 
GeneralRe: Connection string problem Pin
D i x y11-Feb-08 17:06
D i x y11-Feb-08 17:06 
GeneralRe: Connection string problem Pin
Harvey Saayman11-Feb-08 20:35
Harvey Saayman11-Feb-08 20:35 
GeneralRe: Connection string problem Pin
Ravenet11-Feb-08 3:10
Ravenet11-Feb-08 3:10 
QuestionHow to Add a Font in Setup Project Pin
Bajrang Singh10-Feb-08 20:04
Bajrang Singh10-Feb-08 20:04 
AnswerRe: How to Add a Font in Setup Project Pin
Rupesh Kumar Swami10-Feb-08 20:18
Rupesh Kumar Swami10-Feb-08 20:18 
AnswerRe: How to Add a Font in Setup Project Pin
Giorgi Dalakishvili10-Feb-08 20:25
mentorGiorgi Dalakishvili10-Feb-08 20:25 
GeneralRe: How to Add a Font in Setup Project Pin
Rupesh Kumar Swami10-Feb-08 20:39
Rupesh Kumar Swami10-Feb-08 20:39 
GeneralAn unhandled exception of type 'System.StackOverflowException' occurred in mscorlib.dll in c# Pin
ramyanaidu10-Feb-08 18:36
ramyanaidu10-Feb-08 18:36 
GeneralRe: An unhandled exception of type 'System.StackOverflowException' occurred in mscorlib.dll in c# Pin
Martin#10-Feb-08 20:24
Martin#10-Feb-08 20:24 
GeneralPrinting 128-bit integer in decimal Pin
Skippums10-Feb-08 15:59
Skippums10-Feb-08 15:59 
GeneralRe: Printing 128-bit integer in decimal Pin
Luc Pattyn11-Feb-08 1:41
sitebuilderLuc Pattyn11-Feb-08 1:41 
GeneralRe: Printing 128-bit integer in decimal Pin
Skippums11-Feb-08 5:20
Skippums11-Feb-08 5:20 
GeneralRe: Printing 128-bit integer in decimal Pin
Luc Pattyn11-Feb-08 6:06
sitebuilderLuc Pattyn11-Feb-08 6:06 
AnswerRe: Printing 128-bit integer in decimal Pin
Skippums11-Feb-08 5:50
Skippums11-Feb-08 5:50 
QuestionBackground image refreshing on Form resizing? Pin
Jacob Dixon10-Feb-08 13:19
Jacob Dixon10-Feb-08 13:19 

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.