I am using the Mysql .NET connect and can connect to my database using my program. i want to be able to get a Users Password from the database using there user name
This is the query i want to use: "SELECT Password FROM staff WHERE Username = " & textbox1.text & " '". But i don't know how to run that query and to get it to store the Password as a variable
How connect Vb.Net to MYSQL..? How to add info to database user informations using mysql database. How to call login infos using mysql.
View 8 RepliesI'm a newbie in visual basic. I'm doing a login system. I'm done with the GUI. but for the programming part, I want to know where to store new user's information along with the username and password. I've done research. seems like it has something to do with database. p/s: I'm looking for high security in storing data to prevent hacking.
View 1 RepliesI need application with login form which gets username and password from mysql database and validate it, if it's correct show form 2...
Currently I made only this version
Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Login.Click
[Code].....
I'm presently creating an application which uses Access2007 as the database. No problem there. But Since most use Excel for data-entry, i've created two tables in access linked to excel source file. Any change in excel will reflect in Access database and subsequently in my Application . Until now my application only reads the database and displays records in DataGridView. These records, i then export to excel along with other formatting for direct printing as a report as I have no idea how to make report. Now i want to add data-entry capability to my app using password-protection user-access. So i can directly add new record to source file. Also need to know if There's any way of eliminating Access from the picture entirely....
View 1 Repliesi want to connect to sql server database in the web thru vb6.0. If connect there is chance of user name and password been hacked. Is there any way to encrypt the password and connect to sql server database in the web or any other solution where in i will be not be exposing user name and password to hackers on tranisition to web.
View 1 RepliesScenero: Users inputs the barcode numbers into a textbox, hits the search button and is returned the description of that barcode.
Database:
Two fields: Barcode - barcodes in this field
Description - Description revalant to that barcode
Form:
Consists: Textbox(Input) - txtBarcode
Button(Process) -btnClick
Listbox(Outut) - lstDetails
Code:
Dim con As New OleDb.OleDbConnection
Dim ds As New DataSet
Dim da As OleDb.OleDbDataAdapter
[CODE]...
This is the code i got to connect to the database itself. Then i got this code for the search part
Code:
SQL = "SELECT Description FROM Table1 where Barcode = '" & txtBarcode.text & "'"
What i need to know is:
1) Is the code for the search right.
2) How to get it so the description for that barcode is displayed in a listbox.
I can connect/login to my database, view a formatted table in the current window, however I want to click a button and see a new table set in a new window. Theoretically I should be still logged in/connection information saved but however I get 'unable to connect to database'.
View 2 RepliesI m creating a Log In form at VB.NET and i have some problems The connection between the application and the web server opens fine and i can login if i use the MD5 encrypted text of the database.
View 15 Replieshow do i retrieve password in database using secret answer and email address and put the answer on label1.text? this is my code Private Sub btnRet_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnRet.Click
Dim con As New OleDb.OleDbConnection
Dim dbprovider As String
Dim dbsource As String
Dim ds As New DataSet
Dim da As OleDb.OleDbDataAdapter
Dim sql As String
[Code]...
I have a project where I added visually and successfully a datasource of MySql. I binded a datagridview with a table.
But, how do I change programatically the password, ip or user to connect with the MySql server? Because it can change at any time, so I can let the user change these values.
I have a MySQL database online. What do I need to connect to it and exchange data?
View 2 Repliesi am trying to save image into MySQL database ...is there any easier way to do that ?
View 1 Repliesi am semester 2 in the "system information", as usual just like in semester 1, this hardcore lecturer just has some way to make us difficult he is giving us a one semester long assignment, and as you probably can see.i got mysql as my database to making a hotel system application.
1.now i am stuck with how to connect "crystal report" with mysql database table??
2.after connected, how shoud i display it?.
I have a chat server / client system running, but I want users to authenticate with my vBulletin forum database.I don't want the client to do it, because it is possible to fake the 'successful login' and connect with a fake username. I want to send the username and password details to the server, and make the server check it with the local vBulletin MySQL database for the username and password.Is there a way to do this? To my knowledge vBulletin has a username and a password entries in the database which is salted, and the salt varies from user to user.
View 7 RepliesI have a problem here I did make database program for a friend the database is online Mysql I use Visual Studio and put this into setup.exe when he install the program and try to log on he get this error This is my connection to the database
[Code]...
In vb.net I am using password protected database with following connection stringconnetionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:vaivaiDB.mdb;JetOLEDB:Database Password=secret;"Database access works fine on the development machine.
View 2 RepliesI have developed a task Using VB.net (windows Application). I want to create a Login window for the Current user only allowed to use my application.So In my Login window UserNAme textbox I have showed the curent Login UserNAme like,
txtUserName.Text=Environment.UserDomainName & "" & Environment.UserName
And I have set txtUserName.Readonly =True.
Now the User to type the Password in my application password textbox.
[code]......
I am asked to write a front end program in VB 2005 (that will run in client computers which running on Win XP) to access an existing MySQL database running in Linux. It is not my preferred choice, but the user have the database and server working just as he wants it, and do not wish to change, at the same time I do not wish to change programming language. Is that even possible? Can we actually write VB 2005 programs that will run in client computers complete with NET framework 2.0 to access a Linux operating database?
View 4 RepliesI need to define sql command to retieve user name, password and balance from database.. I've added two forms and it works proberly but suddenly after entering the username and the password, this error occurs "Vshost-clr2.exe has stop working" and gives me two options whether to debug or to close program.
[Code]...
I'm trying to write vb code to verify a password input by a user to known table passwords in access database. The form has a drop down combo box that has userID's that are selectable. I'm trying to get the index number out of the combo box selection and use that to look up what the password should be. With that information i can then compare the stored password with the password typed into the text box below the combo box. All of the examples i've found that direct me show the code in regular Visual Basic. I'm using Visual Basic 2010 with the .net architecture.
View 3 Repliesworking on a March Madness Program and need help searching the database. I have the database all linked and all the cells connect, but now I need to make it so when people login it will search the database for their username and password to verify the user. My database is in access is called MarchMadness, with the table being tblUser and the column's are "username" and "password"
View 2 RepliesI am using VB.net 2003. I am working on a stand alone windows program that stores data in an Access database via ADO.net via MS jet 4.0 OLEDb. I have progressed to the point that I would now like to provide the end user the oportunity to back-up the data they have stored and re-install if they choose. I am envisioning a menu item for "maintenance" with sub-items for "back-up" and "restore"
View 1 RepliesI created an executable file of an application done in VB Express 2010 which connects to a Access 2010 database. When installling the executable file at one of the user's computer, the file is installed correctly, but it fail's when trying to connect to the database. It says that Microsoft Dataengine cannot open the database. The user's computer doesn't have Access installed, does it need to be installed? or can I install a framework or application to avoid installing Access at the user's computer?
View 8 Repliesi just want some opinnion or suggestions regarding database softwares. we are going to develop a system for 20 or less users, i am planning to use MYSQL community server as our database to lessen the budget for that system, i just want to know if it is ok to use that version.is there a big differece between mysql community server, enterprise server and MS SQL Server in terms of handling data i.e security, speed, etc...
View 2 RepliesAlright, let's try this again. I have an mdb file as a database in my program, I need this mdb file to be what my published program reads off of. Is there any way to have Visual Basic (2008 Express) not encode my mdb file to Example.mdb.deploy?
View 1 RepliesIm building an app to manage PSP contents, and it should connect to my MySQL server on my domain to refresh game info and ratings and so on, but I cant make it connect with MySQL Connector 6.1.
[Code]...
My program connects to a Mysql Database. It allow registration and login. I Need this to update the "BankACCid" column(?) in Mysql for the current logged in user.This is the code that doesn't work
MySql Connection
Dim conn As MySqlConnection
conn = New MySqlConnection()
[code]....
Here's what I'm attempting: The user browses for and opens a dbf file. The user is presented with a checkedlistbox which shows the column headers. The user then selects the columns they wish to run a report on. ex. total # of cells not empty, longest cell length, etc.
I'm to the point of populating the checkedlistbox with all of the columns shown but I'm unsure if the users selections are actually linked to my data and if they are how I go about isolating said selections for the reports. I have a feeling that my approach to populating the checkedlistbox is not the proper way for what I'm trying to accomplish.
Here is the code
Public Sub btnGetFile_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnGetFile.Click
Dim fileLookUp As New OpenFileDialog
[CODE]......................
I've got a code using SQLClient that loops though all users in a Users table inside each loop i want to preform another search in the UserOrders table, thus doing a count of all orders.
I get this error
HTML
There is already an open DataReader associated with this Command which must be closed first.
Here is my code
vb.net UserLists.Items.Clear()
Dim connection As New SqlClient.SqlConnection(My.Settings.ConnectString)
Dim command As New SqlClient.SqlCommand("SELECT * FROM Users ORDER BY PersonName",
[CODE]...