|
Just store the different connection strings, and create a connection every time you need it. .NET connection pooling will find out if there's already another "closed" open connection (when you close it, it's not actually closed until some time later) and reuse it. The connection string must be identical for a connection to be reused, but if you have 5 different databases, you'll have 5 pools.
-- LuisR
Luis Alonso Ramos
Intelectix - Chihuahua, Mexico
Not much here: My CP Blog!
|
|
|
|
|
"connection string must be identical for a connection to be reused"
Eaven the db names should be the same?
The thing is that I have a app with a TreeView and the treeview is populated with all db names and then in each db node with some info from the db, and when i click a node the app will use to get info from the selected db...
Until now this is the method I have used changein the string but when I create a new DB and try to insert it in the tre view i do the .clear() thing from the tree and the try to rebuild it again... and some errors apear i will be back with code and error text...
Sorry for my BAD BAD english...
Thx
|
|
|
|
|
Well, then just make sure that everytime the same node is selected, the same connection string is built. You'll have connection pooling working for each different connection string, but in you scenario, I think that's the best you can do.
-- LuisR
Luis Alonso Ramos
Intelectix - Chihuahua, Mexico
Not much here: My CP Blog!
|
|
|
|
|
Hi,
I have to create an attendentee-list in Crystal Reports.
Vertically I summarize the student-data (name etc). This is OK, but know I have to summarize horizontally all the dates for the classes and every cell of the grid you get needs a code.
I was thinking cross-tabs or subreports, but I still can't figure out how to do that.
Can anyone help me?
tnx!
(example: )
session1 session2 ... sessionn
student1 code code code code
student2 code code code code
student3 code code code code
...
studentn etc...
No hurries, no worries.
|
|
|
|
|
I need a C# project for final year of gradution
I'm doing B.Sc(IT)
|
|
|
|
|
without more info and without letting us know you're trying yourself you won't get much response here.
What do you have to do and what did you do to try to solve the issue yourself?
eg.
We need a project in the line of this, this and that, it is subject to bla bla bla and I was thinking this and that, but it isn't ok because...
does anyone know something to help me?
good luck !
No hurries, no worries.
|
|
|
|
|
Wow!!! 
May I nominate this for the question of the year? 
-- LuisR
Luis Alonso Ramos
Intelectix - Chihuahua, Mexico
Not much here: My CP Blog!
|
|
|
|
|
I need U$ 100,000.00 to buy a Ferrari.
Why not? If we can ask anything here... ;P
Rui A. Rebelo
Caminante no hay camino.
El camino se hace nel caminar.
Frederico Garcia-Lorca
|
|
|
|
|
Rui A. Rebelo wrote:
I need U$ 100,000.00 to buy a Ferrari.
A used Ferrari? Here in México the cheapest (a 360 Modena with a standard transmission) is about $217K
-- LuisR
Luis Alonso Ramos
Intelectix - Chihuahua, Mexico
Not much here: My CP Blog!
|
|
|
|
|
|
"I need suggestions for a C# project for my final year".
/ravi
My new year's resolution: 2048 x 1536
Home | Articles | Freeware | Music
ravib@ravib.com
|
|
|
|
|
Taking the Ferrari example from above, it's very different "Give $100K USD" to "Give ideas on how to earn $100K USD"!! 
He could have meant that, but how are we supposed to know?
-- LuisR
Luis Alonso Ramos
Intelectix - Chihuahua, Mexico
Not much here: My CP Blog!
|
|
|
|
|
I think that an application using C# to output a message that says "Hello World" on both the CRT and a printer would be an impressive final project. Give it a go, and if you get stuck, feel free to post any questions here. Good luck!
"...putting all your eggs in one basket along with your bowling ball and gym clothes only gets you scrambled eggs and an extra laundry day... " - Jeffry J. Brickley
|
|
|
|
|
What I did for my final projects was go to different departments through out the campus to discover what they needed written and then selected from that list. In the end I wrote a complete point of sale system for the bookstore. I had 9 months to work on this though so you may need to scale back based upon your skill set and time available.
Hope this helps
|
|
|
|
|
Hello All,
I fill arraylist with some elements and i need to remove the duplicate elements for the arraylist. How Can i do that?
Thanks
hay
|
|
|
|
|
Wouldn't it be easier to check for duplicates on insertion?
You can do so by using the Contains method of the ArrayList.
/cadi
24 hours is not enough
|
|
|
|
|
Whats the "best" (most widley accepted) way to store user preferences in a way they can be read and written to?
I though of using .config and coding a way to write back to it .... but have since been told its bad programming practice to write to a .config.
May be the registry? but im using this program as a peice of portfolio work to show potential employers and im not sure they would want a slew of candidates code writing to somthing as volotile and not-so easily cleaned as the reg' .... or is this somthing they will expect?
|
|
|
|
|
IMO, the best way is whatever suits the requirements of the application. Do you want your users editing the config file themselves? Do you want the config information human-readable? Does your install program handle creating a registry entries? Are you installing your app as an "all-users" app and relying on Windows login to differentiate users, or does your app have a separate login? Is it a client-server app, where the user config might be on the server so the user gets his/her setting regardless of what client tmachine they are using?
It's more a question of requirements than the current fad. Hope that helps.
Marc
My website
Latest Articles:
Object Comparer
String Helpers
|
|
|
|
|
On the other hand, you don't want to analyse the problem to death and paralyze the whole project, so just use an ini file. The important thing is to abstract your option loading and saving, so that you can plug in the popular method of the day. Then, of course, you'll discover that the ini file format is just fine 99.9% of the time and there's no need for the overkill of registry, SQL, XML, etc.
Matt Gerrans
|
|
|
|
|
try using a Database. Hopefully thats the widely used approach (if not file IO)
Hope this helps!!!
Regards,
Sidhu
IF YOU DON'T HAVE ANYTHING TO SAY, WELCOME TO THE CLUB
Dotnet @ Work Where Dotnet works...
My Blog
|
|
|
|
|
I think you can use XML to store user's pref...
The man with nothing to lose
|
|
|
|
|
Take a look at the Configuration Application Block[^]. It's part of Microsoft's Enterprise Library. I used the Configuration Application Block in my last app. and it worked very well. Easy to implement, very flexible and a snap to set up and configure.
Cheers,
Drew.
|
|
|
|
|
Does anyone know how to do this conversion from pdf format to a tif format.
Thanks
|
|
|
|
|
Sure, there are three ways:
1) Use Photoshop to load the PDF and simply export it as a TIFF.
2) Use Ghostgum[^] in conjunction with Ghostscript and choose Convert from the file menu.
3) Use a third party PDF library (some of which are advertised here) or one of the free ones on SourceForge to render the PDF file to a bitmap and dump it to a file using .NET or other graphics library, several of which can be found here for free at the Code Project.
Cheers,
Drew.
|
|
|
|
|
here a prob..in the treeview control, when i right click on a node and say add,then i should be able to add a node immediately after that node ...
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
