If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > MySQL > Baby Steps, Visual Studio 2008 connect to MySQL

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 11-06-09, 20:15
jdostie jdostie is offline
Registered User
 
Join Date: Oct 2003
Posts: 100
Baby Steps, Visual Studio 2008 connect to MySQL

OK, I am sorry for the stupid question, but I need a little spoon feeding to get started.

I have visual studio 2008. I also have downloaded and installed mysql and setup an instance as well as connected and viewed the default tables - and seen where to add tables, and have a basic notion of how to do that. I have downloaded libMYSQL.dll, but have not idea how to add it to the project, nor am I sure if it matters where in the webconfig I add the connection strings.

Until now everything I have done has been in Access or SQL Server - but for my new project I want to publish on the web, so MYSQL seems like the right choice as does visual studio, but I can't seem to get started. Any info would be appreciated - I don't expect anyone to write the app for me, but enough to get me started would be much appreciated.

Thanks
Reply With Quote
  #2 (permalink)  
Old 11-07-09, 15:42
Fakin Fakin is offline
Registered User
 
Join Date: Sep 2009
Posts: 35
first you must downloaded a connector for .net.
MySQL :: Connector/Net 6.1

then install this.
then you must added dll in VS as reference.

and here is documentation with exampels
MySQL :: MySQL 5.1 Reference Manual :: 21.2.5.4 Using Connector/NET with Connection Pooling

and here is one example what's you need.
MySQL :: MySQL 5.1 Reference Manual :: 21.2.5.5 Using the Connector/NET with Prepared Statements
Reply With Quote
  #3 (permalink)  
Old 11-10-09, 13:48
jdostie jdostie is offline
Registered User
 
Join Date: Oct 2003
Posts: 100
Thanks very much.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On