I work for a Non-Profit Organization... And I'm trying to make a program for all of us to use as stand alone to just check minimum things like volunteers, events, requests... etc. I have some experience with Visual Basic, but not a lot.
Imports System.Data.SqlClient
Imports MySql.Data.MySqlClient
Public Class Login
[code].....
i try to do a login using asp.net 3.5 and sql server 2005 i create a dataset and do this code but something is missing in the code here the code. [code] it say that there is something missed after the password=' " & txtpass.Text in line 5 but i cant get what missed.
View 3 RepliesI get this error, while I'm testing the code below:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[student](ID, LASTNAME, FIRSTNAME, SCHOOL) VALUES ('333', 'aaa', 'aaa', 'aaa')' at line 1I just recycled the code that I used in manipulating ms sql database. So the syntax must be wrong. What might be the correct syntax for adding records into mysql database?Here is my current code:
idnum = TextBox1.Text
lname = TextBox2.Text
fname = TextBox3.Text
[code].....
I have the lines above to login by database. However, I really don't know why always give me the error: "Incorrect fields". I am 120% sure that all the fields of the table are right, including the text that I put into my textboxs. I have already add a user into the database. I can make login in PHP but in VB.NET I just can't.
Try
Dim MySQLConnection As New MySqlConnection("server=localhost; user id=root; password=; database=DB")
Dim MySQLQuery As String = "SELECT * FROM TableLogin WHERE Username = @username AND Password = @password"
[CODE]...
I already tried to show the data of the database into a Datagridview and it works fine, it displays to me all the rows that I had add in the database.
I am getting a syntax error for the code below.I am trying to create a user in the mysql database and add their information to a datagrid control all in one button click using two statements; one to create the actual user, and one to add the user and their additional information to a table on the database and then refresh the datasource which will display the new user's information in the datagrid control.
If anyone knows where i went wrong please feel free to critique my code and let me know; or simply offer more efficient alternatives to what im hoping to achieve.
For those of you that must know, i am running the latest version of MySql server, MySql Workbench, and Visual Basic 2010 Express on a windows 7 based laptop. I'm writing this program in VB.net.
[Code]...
Error: MySql.Data.MySqlClient.MySqlException: #42000 You have an error in your SQL syntax
[Code]....
I am trying to make a login system mysql try to connect to a mysql database.
Here is my code:
Imports MySql.Data.MySqlClient
Public Class LoginForm1
Dim MySqlConnection As MySqlConnection
Private Sub OK_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles OK.Click
MySqlConnection = New MySqlConnection()
[code]....
i Built A MySQL Login System Using MySQL Connector But If Other People Want To Use The Program Thay Get An Error, I Think This Is Due To Thay Do Not Have The Connector So What Should I Do, Btw Dont Say 'Tell Them To Connector'!
View 5 RepliesI'm connecting to my mysql server using ODBC in vb.net, the database is shared throughout the company because it is used in an accounting program (simply accounting), each user has their own account user/pass to login to the database. I have developped a program that uses the accounting database and combines it with other information, my problem is that at least once a day I get this error when I run my program: "(10061) ERROR [HY000] [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on"and the error persists for at least 4 hours, for some reason it starts to work again later on in the day.
View 1 RepliesI want to select some rows from a sql express 2005 table. I am using this expression: "Starttime >= " & dtpStart.Value dtpStart is a DateTimePicker But I am getting this error: Syntax error: Missing operand after '14' operator.
View 18 RepliesI have a datagridview on my form which displays records from Mysql table on form load.i want to delete the selected row in datagrid from table on 'row header mouse click' event.
The 2 different codes that i tried --- deletes the record from the datagrid for a moment but does not delete from mysql table & re-appears when closed & debugged again.[code]...
I am creating a custom log in page using VB in Visual Studio. Every time I try logging in, however, I get the following error:"Incorrect syntax near '.'".When I put in the wrong username/password combo it recognizes this, but when it is right it will get this error and fail to log in.
View 1 RepliesIs there a syntax on how I can get the value of the date/time a user logged on their PCs?
View 1 Repliesi am working on an application which uses login form, search and registration in VB.NET but let this topic focus on login first i am using MySQL database via MySQL.NET connector
here is what i have so far Private Sub btnLogIn_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnLogIn.Click
[Code]...
I have login form, and it works. but only if passwords are not MD5. I would like to ask how to improve my code, so my application can use MD5 instead of normal text password stored in my MYSQL database.
This is the code I;m using now.
Dim mMySQLConnectionString As String = E3MCEncrypter.Decrypt(My.Settings.MySetting)
Dim MyADOConnection As New MySqlConnection
MyADOConnection.ConnectionString = mMySQLConnectionString
[Code]...
I have the login codes.. Private Sub OK_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles OK.Click
mysqlconnection = New MySqlConnection
mysqlconnection.ConnectionString = "server=xxxxxx; port=3306; user id = root ; password = 123456 ; database = alogin;"
mysqlconnection.Open()
[Code]...
my server is a IP address xx.xx.xx.xx...which other server in other place but why i got the error which is
'unable to connect to any of the specified mysql host'
Simple question (I think)Is it possible to create a login system interact with a MySQL database through a PHP script? the only tutorial I have found on the web is this, but its not a login and I dont understand it very well.[URL]..basicly I have created the login to directly connect to the MySQL, and since this project will be going live, my host does not allow me to connect remotely to the database, so I have only got a php script to do that with.
I already have a simple function on the php side, all I need the script to do is return a value to vb.net to tell it that its correct or its incorrect.And I need the vb.net application to get the value and login with the provided username and password and if its incorrect to show a message box and if its correct show a different form.
im trying to let users login to an application i created in vb.net using the user table of the application's database in mysql i heard that The usual way to do this is to have just one MySQL user called "[my_app_name]" with the relevant permissions. Then my application uses it's own user table to control access to the application, and the one MySQL user to access the database.
View 2 Replieshow to create login system using VB.NET .. (usernames and passwords are stored in mysql database)
View 12 RepliesI am making a login with the database stored in MYSQL and for some reson when i press login i get a error on this line
CODE:
Im my SQL server I have 2 columns one for user inputed username(user enters in HelloWorld123, HelloWorld123 is entered in the table) and the other is a clean version(user enters in HelloWorld123, helloworld123 is entered in on the table.) this is really similer to a regular forums login. what would the sql query to check column 1 and 2 (clean, user input) and see if they match. this is the spot im stuck at right now.
View 1 Replieshow to Use MYSQL as a Login System Im Tryna Make a System Where My Users Have To Login Or Be Part Of My Forum Too Login
View 2 Replieshow can i create login form with mysql database?
View 15 Repliesi recently added a login that uses mysql database now it use to pull data from text file but as i said i made it use mysql now..it works great locally but when i sent it to a friend to test the login he got this error. unhandled exception has occurred in the your application. if you click continue, the application will ignore this error and attempt to conttinue. if the click quit, the application will close immediately could not load file and assembly 'MySql.Data. version=5.1.7.0 Culture=neutral, public key token=c5687fc88969c44d' or one of its dependencies. this system cannot find the file specified.not sure what to do i was thinking about having him install the MySQL Connector net but i thought i would come here first and ask..and can someone also help me on how can i retreive data from the login part? i can get it to keep the username but for some reason i can pull the rest of the data here is the login script.[code]
View 11 RepliesIm trying to make a program and i have everything done but i need to make a login bar that if the user logs in, it takes them to form10 but if they log in and they are in a special user group on the forum (VIP) they go to form11.
View 39 RepliesI am trying to make a login screen that is connected to a mysql database. I cant seem to get it to work it keeps giving me an error that says ("there is already an open datareader associated with this connection which must be closed first")
Imports System.Data.OleDb
Imports MySql.Data.MySqlClient
Public Class SalePersonLogIn
Dim con As MySqlConnection = New MySqlConnection("Data Source=localhost;Database=testdatabase;User ID=fvfvxcv;Password=cxxvx;")
[Code] .....
I am trying to make a login for vbulletin through a windows application using mysql but whatever i tried has failed, i can connect with the database but i cannot find the password table, since vbulletin has md5 on their passwords.
View 3 RepliesI created a SQL DB named MainDB.mdf and a small VB 2010 application with some forms and datasets.Everything was working OK until i got a new computer and re-installed Visual Studio 2010 and SQL server 2010 on it. I copied my DB from the old to the new computer and also copied by VB 2010 project to it. I used Windows Authentication to connect to the DB in the old computer and also in the new one, i am using different Windows user account names though.
I was able to connect to the DB in the new computer in the Server Explorer section, i created a new connection string to the DB and i can seed there is data in the tables. When i run my VB 2010 application created in the old computer get error:
"Cannot open database "MainDB" requested by the login. The login failed. Login failed for user 'D630Admin'."
I need to get rid of that error and be able to add/mod/del data from my DB using my VB application as i used to.
I am using Visual Studio 2010. I can connect to my MySQL datababse no problem by clicking my login button.Now I can't figure out how to query the database and check if username and password are correct, and switch to a different form, to display the data loaded from the database.This is Login.vb Form
Imports MySql.Data.MySqlClient
Public Class Login
Dim conn As MySqlConnection
[code]....
When the login is completed, and username and password are correct, I want it to load Main.vb.
So here is the thing: This code is form my hash computing function module
[Code]...