Better Data access components for windows desktop application

Posted by KoolKabin on Stack Overflow See other posts from Stack Overflow or by KoolKabin
Published on 2010-06-01T08:34:58Z Indexed on 2010/06/01 8:53 UTC
Read the original article Hit count: 181

Filed under:

winforms

|

ms-access

|

dataaccesslayer

|

mssql

Which one can be the better one data access component for desktop application and why?

1.) For MS Access 2007: ADO, OLEDB, DAO

2.) For MSSQL 2005: ADO, OLEDB, DAO

© Stack Overflow or respective owner

Related posts about winforms

Redirect WinForms web browser Control pop ups to another WinForms web browser control with form data

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a c# web browser and one of the pages it displays has a form. When the form is submitted it posts data to a new window in IE. I want to catch that data and forward it to another C# web browser that I have in my application. So I don't want it to open an IE browser when the javascript function… >>> More
Responding to MS Wireless Notebook Presenter Mouse 8000 presenter buttons in WPF/WinForms

as seen on Stack Overflow - Search for 'Stack Overflow'
Does anyone know how to respond to the presentation buttons of the Microsoft Wireless Notebook Presenter Mouse 8000 in WPF or WinForms? >>> More
WinForms Web Browser control forcing refocus?

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm trying to automate a web process where I need to click a button repeatedly. When my code "clicks" that button (an HtmlElement obtained from the WebBrowser control I have on my form) then it brings focus back to my application, more specifically the WebBrowser control. I wish to better automate… >>> More
Creating a Persistent Panel Web Control

as seen on Code Project - Search for 'Code Project'
Extending ASP.NET's Built in Panel Control to create Sticky control values between page visits. >>> More
Moving from Winforms to WPF

as seen on Programmers - Search for 'Programmers'
I am a long time experienced Windows Forms developer, but now it's time to move to WPF because a new WPF project is comming soon to me and I have only a short lead time to prepare myself to learn WPF. What is the best way for a experienced Winforms devleoper? Can you give me some hints and recommendations… >>> More

Related posts about ms-access

SQLAuthority News – MS Access Database is the Way to Go – April 1st Humor

as seen on SQL Authority - Search for 'SQL Authority'
First of all, today is April 1- April Fool’s Day, so I have written this post for some light entertainment. My friend has just sent me an email about why a person should go for Access Database. For a short background, I used to be an MS Access user once (I will not call myself MS Access DBA), and… >>> More
LINKED TABLES BETWEEN MS ACCESS 2003 AND MS ACCESS 2007-WRITE PERMISSIONS DENIED

as seen on Super User - Search for 'Super User'
We are in the process of switching over to ACCESS 2007. We have numerous data tables in ACCESS 2003 files. In one case, the user has 2007 on his PC and opend the front end in 2007. No problems. When the the user is done, he clicks a button that executes a macro full of update queries. The macro… >>> More
Working with Compressed (zipped) folders in MS Access

as seen on Internet.com - Search for 'Internet.com'
Doug Steele presents a simple technique to add zip files from within your application. >>> More
Extending the InputBox function for MS Access Forms

as seen on Internet.com - Search for 'Internet.com'
While it's not possible to change the behavior of the InputBox function, this article illustrates how to create your own Access form that includes a text box with its InputMask property set to Password, and then use that form instead of the one generated by the VBA InputBox function. >>> More
Uses for Cartesian Products in MS Access

as seen on Internet.com - Search for 'Internet.com'
Less well known than inner and outer joins is the Cartesian product, which produces every possible combination of records between the two tables. Doug Steele offers four examples to demonstrate some legitimate uses for Cartesian products. >>> More