How do I communicate with my mysql database using VB.Net. I am trying to create an application for my employees to use. They will enter calls made, support requests, replies to those requests, and client data for our clients.

How do I communicate with my mysql database using VB.Net. I am trying to create an application for my employees to use. They will enter calls made, support requests, replies to those requests, and client data for our clients.

hi,
There is a COM component for connect the mysql db using .net languages.You cann get it from internet.i think its free

Hi,

Dim Con As New OleDb.OleDbConnection("Provider=MySQLProv;Data Source=DATABASE;User Id=YOURSQLUSERNAME;Password=YOURSQLPASSWORD;")
Dim Com As New OleDb.OleDbCommand("SELECT * FROM TABLENAME ORDER BY DESIREDFIELD ASC", Con)

Com.Connection.Open()

regards
bhar
http://www.vkinfotek.com

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.