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

C#

 
AnswerRe: Regarding Notify Icon Pin
AB77718-Mar-06 20:22
AB77718-Mar-06 20:22 
AnswerRe: Regarding Notify Icon Pin
sathish s8-Mar-06 20:41
sathish s8-Mar-06 20:41 
QuestionDetecting Keypresses in the keyboard buffer Pin
Phil (Strategy Map)8-Mar-06 17:10
Phil (Strategy Map)8-Mar-06 17:10 
QuestionMDI parent & Child Pin
RonBou8-Mar-06 16:31
RonBou8-Mar-06 16:31 
Questiondatabase handling in C# Pin
Jaymahinda8-Mar-06 14:47
Jaymahinda8-Mar-06 14:47 
AnswerRe: database handling in C# Pin
Le centriste8-Mar-06 15:10
Le centriste8-Mar-06 15:10 
AnswerRe: database handling in C# Pin
Sendilkumar.M8-Mar-06 16:11
Sendilkumar.M8-Mar-06 16:11 
AnswerRe: database handling in C# Pin
mcljava12-Mar-06 14:58
mcljava12-Mar-06 14:58 
Jay,

The preferred MS access method is to connect, retrieve multiple rows if possible, and then close the connection. As noted ADO Connection pooling is great for this. If you prefer working with embedded SQL you can definitely use ODBC in this manner: basically create an adapter and fill your dataset. Fundamentally you have to choose the direction you want to go with that makes the most sense to you. Bear in mind the more layers we add to "simplify" our logic isn't always the most straightfoward solution at the end of the day.

Now having a database proxy is another approach. Like the other cases I'd say you definitely need to ditch the one connection approach and support some "configurable" number of connections to allow for tuning. Ideally a proxy would have a multi-threaded or async architecture as the core einfrastructure. You can also build in security as needed. There are plenty of TCP/IP examples on Code Project that do this type of thing. All you would need to do is provide the Glue to make it ft within your world.

I personally use ODBC with MySQL and have found the development to be pretty easy. One of the hassles is the DSN, i.e. do you want to provision it in odbcad32 on each system or... provide some automated form of registry loading? Again here's a cat that has been skinned many times on Code Project.

I'll briefly mention OLE DB which is Micosoft's supplement to ODBC. Basically yet another access method but this one is not aimed at relational databases per se, but if you have to retrive from other data stores such as ISAM files, MS Office Files, then it' worth investigating.

Good luck

Mike Luster

CTI/IVR/Telephony SME
AnswerRe: database handling in C# Pin
Brian Aihab9-Mar-10 22:42
Brian Aihab9-Mar-10 22:42 
Questionhyperlink to open/save image Pin
missy48-Mar-06 14:10
missy48-Mar-06 14:10 
AnswerRe: hyperlink to open/save image Pin
Guffa8-Mar-06 18:27
Guffa8-Mar-06 18:27 
GeneralRe: hyperlink to open/save image Pin
missy48-Mar-06 18:30
missy48-Mar-06 18:30 
GeneralRe: hyperlink to open/save image Pin
missy48-Mar-06 19:40
missy48-Mar-06 19:40 
AnswerRe: hyperlink to open/save image Pin
Guffa9-Mar-06 6:41
Guffa9-Mar-06 6:41 
Questionserver error in crystal report Pin
angelagke8-Mar-06 13:47
angelagke8-Mar-06 13:47 
QuestionOverloading a class? Pin
eggsovereasy8-Mar-06 10:30
eggsovereasy8-Mar-06 10:30 
AnswerRe: Overloading a class? Pin
Le centriste8-Mar-06 16:00
Le centriste8-Mar-06 16:00 
AnswerRe: Overloading a class? Pin
Le centriste8-Mar-06 16:22
Le centriste8-Mar-06 16:22 
QuestionOLE in-place activation server Pin
Nikhil Dabas8-Mar-06 10:25
Nikhil Dabas8-Mar-06 10:25 
QuestionWindows Service like application for Windows CE? Pin
spAAwn8-Mar-06 10:11
spAAwn8-Mar-06 10:11 
QuestionIterating throu files Pin
Mr Marchepane8-Mar-06 8:48
Mr Marchepane8-Mar-06 8:48 
AnswerRe: Iterating throu files Pin
Kevin McFarlane8-Mar-06 10:17
Kevin McFarlane8-Mar-06 10:17 
QuestionAdd a checkbox to a openfiledialog ??? Pin
Ralf Hägenläuer8-Mar-06 8:27
Ralf Hägenläuer8-Mar-06 8:27 
AnswerRe: Add a checkbox to a openfiledialog ??? Pin
CWIZO8-Mar-06 10:36
CWIZO8-Mar-06 10:36 
GeneralRe: Add a checkbox to a openfiledialog ??? Pin
Steve Hansen9-Mar-06 3:22
Steve Hansen9-Mar-06 3:22 

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.