What i am trying to do is get my system to look into the database and recognize if the user is a admin or a user, based on that they have certain rights below is my code
Imports MySql.Data.MySqlClient
Imports System.Data.SqlClient
Public Class Form3
[code]....
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 have determined thanks to the last q & a that there is something wrong with my "save to db" code as well as my "retrieve to picture" code. Even If I manually save the pic in the db it stil wont retreive. This is code i patched together from 3 or 4 examples around the net.
Dim filename As String = txtName.Text + ".jpg"
Dim FileSize As UInt32
Dim ImageStream As System.IO.MemoryStream[code]......
MySQL databases exists for saving values as strings (text only). Is there any way that i could store files with the same speed as a mysql command ? I know that it depends on the file size but lets say that the file is "Avatar.jpg" 50KB... I ve tried FTP but this is not what im looking for. e.g. You want your users been able to upload a file like the [Add This Attachment] button does in dreamincode.net and you dont have any background on PHP/HTML/Javascript/ASP.NET just VB.NET and the basics of MySQL plus you dont want to use it for a website. How do you accomplish this? Something silly that ive tried was opening an image as text then update the mysql server with that text but it didnt work backwards after i wrote the text on the file and oppened it ...it said that the image was corrupted.
View 7 RepliesWhat i have going on, is i have a MySQL connector as a resource on my application, and im basically trying to connect to my MySQL server, to either a) register a new account, or b) check that the account exists and they are premium, and login, Now what i have run into problems with is: My MySQL Database Name has a _ in it which VB is not allowing for some strange reason.
The code i am using is below
Imports MySql.Data.MySqlClient
Public Class Form1
Function UpdateRecord(ByVal query As String) As Integer
[CODE]...
How i can allow the _ into the application, because the only databases that don't have a _ in the user or dbname are a) Paid ones which i DO NOT have the money for or self hosted ones, i cannot leave my computer on 24/7
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 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]...
I can have mysql database. but i have not mysql. how to connect this database vb.net 2005. but i have mysql-connector-net . I want to mysql-connector-net use to connect this database. database path(C:Documents and SettingsAdminMy DocumentsVB.NETStock delnaSTC.sql)
View 3 RepliesI have a query from within my vb.net code which searchs for a record by date. The date being entered via the code is in format dd/mm/yyyy, i need to search in the database using yyyy/mm/dd? Ideally i thought there may just be a function within MySQL which will convert this. If not in vb.net to convert the string 01/01/2011 to 2011/01/01?
View 1 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 Replieserror " Unable to cast object of type 'MySql.Data.MySqlClient.MySqlException' to type 'MySql.Data.MySqlClient.MySqlDataReader'. " ?
THIS IS THE CODE Ssql = "SELECT ItemID, Prodname, qty, Desc, Cost * FROM items ORDER BY ItemID ASC"
[Code]...
I want to create 1000 MySQL database on a hosting server & add 1 single user in all of them with all privileges enabled,Now I know how to create a database from MySQL query, But what I can not find is "how to add a user in the database",For example: create database 1a;This will create the database, but with the creation of the database I also want to add a user in that database from the same MySQL query, or another query to run with it, but I want both operation to run at the same time.
View 1 RepliesI'm creating a program that users will login to and I'm trying to make different user levels. I have the login and registration part done. But i need the user levels part. I know i can use a billion if then statements for each admin i have but that will be thousands lines of code afterwards. So I thought up maybe i can check the column name admin and see if its set to true. Or even check another table to see if the user is in that table then load a different form.
Dim conn As MySqlConnection
'connect to DB
conn = New MySqlConnection()
[CODE].................
Also I'm using Visual Studio 2008 express and was wondering if this would work also even though its for 2005 Do to I see the flaw in hard coding it into the program. Any hacker who de .exe it can get a hold of my information and use it against me. And if not how would i go about in 2008 and use it. [URL]
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
I have successfully create a user name = 'root' and host = '127 .0.0.1 ', use the mysql command (client mode) as follow: sql = String.Format("CREATE USER '{0}'@'{1}' IDENTIFIED BY '{2}'; GRANT ALL PRIVILEGES ON *.* TO '{0}'@'{1}' IDENTIFIED BY '{2}' WITH GRANT OPTION;", userName, serverHost, userPassword) When the script above I change it to store procedure (server mode) as below, I found the error as follows: (Error 1064 - You have an error in your SQL syntax; check the manual That corresponds to Yout MySQL server version for the right syntax to use near 'pass' at line 1)
[Code]....
I have a datagrid control with a list of names that it retrieves from a MySql database. I can search through them until i have one result. I want to be able to Display a groupbox control when the number of results is equal to 1. Also, in the groupbox i have a button that when clicked will delete this user from the server and their information from the mysql table called "employee". when the user is deleted i'll display a confirmation message in a messagebox, and reload the table with the updated list. so far the only two problems i have are showing the groupbox when the results are equal to 1 and deleting the user from the sql server based on the name of the search result
Private Sub TextBox1_KeyUp(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles TextBox1.KeyUp
'Search Function.
[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]....
I'm bulding a program that willl work with a database the database is made with mysql.I would like to know if there is a way to install the DB automatically with the application without requiring the user to create a mysql server...the db have more than 5 million records.
View 3 RepliesI have this MySQL Query glitch in my VB.NET program. Here is the query in VB.NET:
"SELECT Points FROM user WHERE Username = '" & UsernameText.Text & "';"
It will select the points column from the user table from the Username they entered. When I deploy this it will set the value for points to 0 on their account. I'm not even inserting anything in.
Now I have my databases in .sdf-files. These files are located on a server and loaded into several listviews. It has worked fine for a while, but I found out that last week one of the computers didn't close the connection with the database, which resulted in (a bunch of) errors on the other computers.
I have a mySQL server (external) where I can add the data into, but I think that it would slow down the loading severely, but it's very important that people can import the data at the same time.
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 my program working beautifully when localhost, I can login to a specified user from my "Mysql" database.However when I try connecting from another computer I can't connect.Here is my code so you know what I am working with.
Imports MySql.Data.MySqlClient
Imports System.Data
Module mdlDataConn
Public conn As New MySqlConnection
[code].....
I am working in VB.Net 2010 framework 2.0. In my application I want to run a Setup.exe with Process.start. I want to know that whether the user who has started the my application is having the rights to run the setup.exe
View 2 RepliesWhile testing my software a friend of mine got the following Error: "Access to the database file is not allowed. [File name = ...etc..." I found out that this has to do with the user rights in Vista (perhaps also XP). How can I solve this?
View 3 Repliesi've created toolstripmenuitems in design time.I named it to mnuUser,mnuKaryawan and form menu based on it too..I create a table that holds the data like this
position menu
admin mnuUser
admin mnuKaryawan
I'm wondering how to achieve suppose the admin logged in,then the menus will be shown?
I've been looking around for a way to check if the current user has Administrator rights but the information seems to be quite disperse and not exactly
View 3 RepliesCan someone tell me what's wrong:Imports MySql.Data.MySqlClient
[Code]...
i am having a problem converting MySQL entries to xml format while using visual.net.so far, i have succeeded in creating a plain xml format based on the entries of my database using basic commands.here's what i've done so far:
Dim query As String = "SELECT * FROM " & table
Dim connection As New MySqlConnection(Form10.connStr)
Dim path As String = ""
[code]....
the problem is, i want to generate an xml report which also contains several extra comments and items that are NOT inside the table.
how to connect and manipulate database tables using MySQL 5.x and Visual Basic 2010?
View 1 Replies