how to connect to mysql database

[joefox]

i just installed mysql, and i am tryign to make a asp.net c# app.

how do i connect to the database?

I wanted to do a simple search, and have it spit out the results...

[vbdotnetboy]

did you download the mysql provider from www.mysql.com

[joefox]

did you download the mysql provider from www.mysql.com

i dont know what to download on there.

[vbdotnetboy]

http://dev.mysql.com/downloads/connector/net/5.0.html

[joefox]

it says i have to install framework 2.0 first, how do i do that?

[vbdotnetboy]

what version of .net are you using?

[joefox]

i know this is dumb. but how do i find out what version? it's 2003 .NET if that helps

[vbdotnetboy]

ok if i remember correctly i believe the 1.0 driver works for this... which can be downloaded here

http://dev.mysql.com/downloads/connector/net/1.0.html

[joefox]

ok i downloaded that...

now how do i use it?

i wanted to make a winapp and make it connect to my database, and get values from it.

[vbdotnetboy]

install the provider
add a reference
use it like any other ado.net provider

[joefox]

ok geeze im lost lol

ok so i opened up a winapp in .net and went to server explorer on the left hand side, and didnt see it.

[vbdotnetboy]

if you're trying to view the mysql db from within the server explorer this won't work with the provider from mysql... you have to look at buying something like the 3rd party provider that supports this. the only way to be able to view the database from server explorer is to download and install the ODBC driver from mysql's website and make a odbc connection to the database

[joefox]

ok ill pass on buying anything lol

how do i connect to it, making a simple vb.net win app?

[vbdotnetboy]

here's a nice tutorial
http://www.15seconds.com/issue/050210.htm

[gep13]

Hello there,

You might also want to take a look here.

A very good series of tutorials.

Gary

[mendhak]

Traitors.

http://www.vbforums.com/showthread.p...o.net+tutorial

[gep13]

Can i just say for the record that I don't use MySQL, but I have looked into it in the past and know where to get some good tutorials for it!

[vbdotnetboy]

Traitors.

http://www.vbforums.com/showthread.p...o.net+tutorial

i'm sorry mendhak i didn't even know you had a tutorial for ado... as you can see i've added it to my links now in hopes that you'll forgive me

[mendhak]

I shall think upon it while you fetch my cigar for me.

[joefox]

Ok i am way confused....
What is ADO.net is it some program that i can use in .NET?
I just want to connect to either an access DB, or MySql DB, and pull some data from it, and put it in a datagrid, thats all.

[gep13]

Hello,

ADO.Net stands for ActiveX Data Objects for .Net, and it is part of the .Net framework. It is basic a set of data access technogies that let you access and manipulate data. You have probably been using these tools without actually knowing it. For instance, the System.Data.SqlClient Namespace within the framework, gives you access to things such as SqlConnection, and SqlCommand.

What you are trying to do is mix two things that do not come as standard within the .Net Framework. Within the .Net Framework you will find classes and objects to access "Access DB" without any problems and you will literally find dozens of tutorials to do this on the web, however, these objects and classes for accessing a MySQL database do not come as standard within the .Net Framework. However, you can download the MySQL Connector, which once you reference this within your project, you will be able to access a MySQL database in the same way that you would a Access DB, using for instance the MySQLConnection, and MySQLCommand.

I hope that clears things up for you a bit, and I also hope that I am 100% correct in what I am saying! Mend, can you maybe check and make sure? Still learning myself!

Thanks

Gary