Solved

CONNECTING TO MYSQL FROM C#

Posted on 2009-05-11
14
283 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

 

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
 

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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Suggested Solutions

Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

739 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