Click here to Skip to main content
15,923,689 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: How To Insert Bulk datas in a DataSet Into Table... Pin
shamsubava28-Dec-09 20:12
shamsubava28-Dec-09 20:12 
QuestionChanging System Short Date Format Pin
εїзεїзεїз28-Dec-09 19:23
εїзεїзεїз28-Dec-09 19:23 
AnswerRe: Changing System Short Date Format Pin
dan!sh 28-Dec-09 19:39
professional dan!sh 28-Dec-09 19:39 
GeneralRe: Changing System Short Date Format Pin
εїзεїзεїз28-Dec-09 20:20
εїзεїзεїз28-Dec-09 20:20 
GeneralRe: Changing System Short Date Format Pin
dan!sh 28-Dec-09 20:47
professional dan!sh 28-Dec-09 20:47 
AnswerRe: Changing System Short Date Format Pin
Abhinav S28-Dec-09 20:02
Abhinav S28-Dec-09 20:02 
GeneralRe: Changing System Short Date Format Pin
εїзεїзεїз28-Dec-09 20:06
εїзεїзεїз28-Dec-09 20:06 
Questionhaving a login in a windows form that uses a remote MySql database Pin
malcomhfc28-Dec-09 7:00
malcomhfc28-Dec-09 7:00 
I am learning visual basic, i have asked questions before and got great answers and oping for a little bit of help again if no one is busy Smile | :)

I am a trainee web designer/developer and have my own website, which i am currently designing. Now i have planned it all out and wish to create a Visual Basic.NET program.

I wish for both the website and the program to have the same logins, both using a MySql database. The website is using a simple script by me for the login at the moment. I didn't want to over complicate it, till i have the Vb program connecting to the database too.

Heres a simple breakdown:

1. Both website and program use same login credentials and same MySql database.
2. Visual Basic program connect remotely to the Mysql database. ( with a shared host )

The program would go about it by basicly starting with a mysql connection then, accessing both username and password tables and checking is Username.TEXT & Password.TEXT match with the database. Once matches, then load up Mainfrm

Sorry for the big message. I have did research on how i would go around doing this. Nothing i can find suggests how i could connect to a remote database on a shared host with (cPanel)

Some of the code im using just now to open the connection, but not sure how to connect to my databse :

Dim connect As New MySqlConnection
Dim sqlcommands As New MySqlCommand

Dim myConnString As String
Dim UserID As Integer

myConnString = "server=" & My.Settings.HostIP & ";" _


My.Settings.HostIP - code i have put in settings file all it contains is my website which doesn't work, of course hehe XD



I have the import mysql client.

Any help would be great thanks. Ofc im not asking someone to do all the work, just asking for some help or ways to improve what i have.
AnswerRe: having a login in a windows form that uses a remote MySql database Pin
Dimitri Witkowski28-Dec-09 10:40
Dimitri Witkowski28-Dec-09 10:40 
GeneralRe: having a login in a windows form that uses a remote MySql database Pin
malcomhfc29-Dec-09 12:12
malcomhfc29-Dec-09 12:12 
QuestionHow can I transfer all the records in the dataset to a sql database? Pin
JUNEYT28-Dec-09 3:53
JUNEYT28-Dec-09 3:53 
AnswerRe: How can I transfer all the records in the dataset to a sql database? Pin
Eddy Vluggen28-Dec-09 4:09
professionalEddy Vluggen28-Dec-09 4:09 
QuestionExceptions throw in try block Pin
cstrader23228-Dec-09 3:02
cstrader23228-Dec-09 3:02 
AnswerRe: Exceptions throw in try block Pin
Abhinav S28-Dec-09 3:08
Abhinav S28-Dec-09 3:08 
GeneralRe: Exceptions throw in try block Pin
cstrader23228-Dec-09 3:18
cstrader23228-Dec-09 3:18 
Generalrepost Pin
Luc Pattyn28-Dec-09 3:33
sitebuilderLuc Pattyn28-Dec-09 3:33 
GeneralRe: repost Pin
cstrader23228-Dec-09 3:40
cstrader23228-Dec-09 3:40 
GeneralRe: repost Pin
Luc Pattyn28-Dec-09 3:44
sitebuilderLuc Pattyn28-Dec-09 3:44 
GeneralRe: repost Pin
cstrader23228-Dec-09 3:51
cstrader23228-Dec-09 3:51 
GeneralRe: repost Pin
Luc Pattyn28-Dec-09 4:05
sitebuilderLuc Pattyn28-Dec-09 4:05 
GeneralRe: repost Pin
Rick Shaub31-Dec-09 8:27
Rick Shaub31-Dec-09 8:27 
GeneralRe: Exceptions throw in try block Pin
nlarson1128-Dec-09 4:51
nlarson1128-Dec-09 4:51 
GeneralRe: Exceptions throw in try block Pin
cstrader23228-Dec-09 5:49
cstrader23228-Dec-09 5:49 
GeneralRe: Exceptions throw in try block Pin
nlarson1128-Dec-09 8:12
nlarson1128-Dec-09 8:12 
GeneralRe: Exceptions throw in try block Pin
Alan N28-Dec-09 8:14
Alan N28-Dec-09 8:14 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.