Connecting Tech Pros Worldwide Forums | Help | Site Map

VB read from MYSQL

Newbie
 
Join Date: Feb 2007
Posts: 4
#1: Nov 12 '08
I want to read from my table in mysql so that data is displayed in a listbox and a text box on my form.

I have a mailing system and want the subject to be displayed in the list box and then the message to be displayed in the text box. The field names on the DB are:

message_ID, user_from, user_to, subject, message, read

I want to be able to read the user to for the current username logged in and then display the subject and message as said above!

Any help appreciated :D!

Cheers

Dököll's Avatar
Moderator
 
Join Date: Nov 2006
Location: Upstate NY - US
Posts: 2,268
#2: Jan 1 '09

re: VB read from MYSQL


Hey there skynetplus!

It is achievable; be sure you can first establish a connection to MYSQL with a simple textbox, the n go from there.

As for the message, you may need it to come through a textarea rather than a textbox.

Do stay tuned, as I am just apssing through, our experts will likely see yourpost and come to aid:-)

Good luck with project!

Dököll
debasisdas's Avatar
Moderator
 
Join Date: Dec 2006
Location: Bangalore ,India
Posts: 7,508
#3: Jan 1 '09

re: VB read from MYSQL


you can find the connection string for mysql here.
Reply


Similar Visual Basic 4 / 5 / 6 bytes