Connecting to SQL Server and a Windows Form Application

Question

2.50/5 (2 votes)

See more:

Hi Friends,

I am stuck in a problem and I need a little help. I am creating an application wherein I need to connect to a Database (MSSQL or Access or MySQL). Kindly suggest me to create a front end from where a user (client) can setup this information like: which server?, username?, password? and connection engine? etc.
Also, if I am not wrong, there is a difference between the SQL queries for Access, MSSQL and MySql so I need to create multiple classes to manage those also. Kindly guide me a little.
Thank you very much.

Tushar Srivastava

Posted 9-Jun-14 4:42am

Er. Tushar Srivastava

Add a Solution

Comments

DamithSL 9-Jun-14 10:47am

Are you using all these databases?

Er. Tushar Srivastava 9-Jun-14 10:50am

Actually I am making a software (like Data Entry etc) where a client can use my software as an interface to do CRUD on database. He/She might have any of the following Database Server: MS-SQL, MS Access or MySQL Server. So, I might need to provide my users with an option to select his own database server and other credentials as I have mentioned.

ZurdoDev 9-Jun-14 10:48am

You can look at connectionstrings.com to see what different connection strings will need. And yes, the syntax does differ for each product. This sounds like a massive undertaking for you.

Er. Tushar Srivastava 9-Jun-14 10:51am

Yes It is... I have been stuck for around 1 night and Finally I thought of asking for help.

[no name] 9-Jun-14 11:06am

There is really nothing here to "help" with. You need to do some research and figure out what each of those databases need for their connection strings and design your UI to accommodate those items. And yes you will have to come up with some system to deal with the differences in your queries.

Er. Tushar Srivastava 9-Jun-14 11:08am

Thank You very much :) I guess that is the my only hope.... :) :) :)

Pikoh 9-Jun-14 11:09am

As you've been told,first look at connectionstrings.com. Then you just have to code different classes in your DAL depending in the database selected. It's not as difficult as it seems.

Er. Tushar Srivastava 9-Jun-14 11:13am

:) :) :) Thank you very much I will look at that website but just let me know, if I need some connection engine (like MySQL uses with .Net) then is there a way to embbed it in my program as a dll?

Pikoh 9-Jun-14 11:20am

Of course you'll have to embbed all the connectors you need. That will depend on which method you use to deploy your application, e.g with click once is an easy task, refer this http://stackoverflow.com/questions/12042024/how-can-i-package-mysql-data-with-my-clickonce-application

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sherkhan3451 · Accepted Answer · 2014-06-09T11:43:00

Its very easy, you will have to use entity framework, which translates sql queries according to the database server automatically. You will have to
1: Copy DAL classes and paste them in DAL, just do some miner changes like
(i) write OracleConnection insteated of SqlConnection, and OleDbConnection.
its a Complete Tutorial which can solve your problem

http://www.youtube.com/watch?v=aoFDyt8oG0k

http://www.youtube.com/playlist?list=PL6n9fhu94yhX5dzHunAI2t4kE0kOuv4D7
http://csharp-video-tutorials.blogspot.com/2012/10/what-is-adonet-part-1.html