Solved

CONNECTING TO MYSQL FROM C#

Posted on 2009-05-11
14
278 Views
Last Modified: 2012-08-13
Hi experts,
I want to connect to Mysql through c# using .net enviroinment,
I have downloaded mysql-connecter-net-6.0.3
should i need to download   mysql -odbc driver.

can anybody tell how to access sata from mysql

many thanks
0
Comment
Question by:APPIREDDY
  • 6
  • 6
  • 2
14 Comments
 
LVL 7

Expert Comment

by:zwei
ID: 24352982
You don't have to use the odbc driver. You have to add a reference to the MySQL connector assembly to be able to use it. If you are in visual studio, go to Project -> add refrence and locate MySql.Data and add it. You'll also have to add the proper usings after you've added the reference to your project of course:
using MySql.Data.MySqlClient;

Open in new window

0
 
LVL 26

Expert Comment

by:Anurag Thakur
ID: 24353234
the following link shows how to connect to MySql using OleDb
http://www.aspfree.com/c/a/Database/Database-Programming-in-C-Sharp-with-MySQL-Using-OleDB/
0
 
LVL 26

Expert Comment

by:Anurag Thakur
ID: 24353240
and another link for mySql Connector 5.2
http://www.codeproject.com/KB/cs/CsharpAndMysql.aspx
0
 

Author Comment

by:APPIREDDY
ID: 24353364
I am trying to add the reference MySql.Data, I am able to go to the package mysql-connecter-net-6.0.3\MySql.Data, but i couldn't add the package.
should i need to do anything?
many thanks
0
 
LVL 7

Expert Comment

by:zwei
ID: 24353798
You should be able to add by adding it to the reference folder. If you have installed the connector it will appear in the .NET tab. Otherwise locate the dll using the Browse tab.
addref.jpg
browse.jpg
0
 

Author Comment

by:APPIREDDY
ID: 24354216
I have downloaded the connecter from mysql website  and installed it but i could not find the dll files
i will try  downloading the connecter once again
0
 
LVL 7

Expert Comment

by:zwei
ID: 24354298
If you installed it, it will appear in the first tab of the add reference dialog (after all the Microsoft assemblies):
NET.jpg
0
Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

 

Author Comment

by:APPIREDDY
ID: 24354361
I am using visualstudio express edition , even i couldn't find System.Data.OleDB
0
 
LVL 7

Expert Comment

by:zwei
ID: 24354445
I'm also using express edition.
0
 
LVL 7

Expert Comment

by:zwei
ID: 24354460
0
 

Author Comment

by:APPIREDDY
ID: 24354487
yes i have installed the source one
0
 

Author Comment

by:APPIREDDY
ID: 24354532
why  even i couldn't locate  System.Data.OleDB
0
 
LVL 7

Accepted Solution

by:
zwei earned 500 total points
ID: 24354645
Install the
"Windows Binaries (ZIP)" package instead of the sources.
0
 

Author Comment

by:APPIREDDY
ID: 24354786
I have againe installed mysql connecter
now i can referece MySql.Data
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
C# Offline Apllication 5 56
Error when loading the database 16 58
scanning dentists xray (the small ones) 3 45
PHP: Insert Data into MySQL 5 19
Introduction Hi all and welcome to my first article on Experts Exchange. A while ago, someone asked me if i could do some tutorials on object oriented programming. I decided to do them on C#. Now you may ask me, why's that? Well, one of the re…
This article is for Object-Oriented Programming (OOP) beginners. An Interface contains declarations of events, indexers, methods and/or properties. Any class which implements the Interface should provide the concrete implementation for each Inter…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now