Member Avatar for David Super

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.

  • 4 Contributors
  • 3 Replies
  • 289 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by Bharati Krishna
Member Avatar for pixcode

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

Member Avatar for Bharati Krishna

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.