Checkif Admin Or User Hard Code Mysql
Jan 20, 2009
I'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]
View 2 Replies
ADVERTISEMENT
Dec 1, 2011
i'm having problems in register admin. Before it didn't insert, but now i have other problem, it doesn't open the registering form.
Here is the login.form:
Imports MySql.Data.MySqlClient
Public Class Login
Dim server As String = "Server=localhost;Database=escola_musica;Uid=root;Pwd=;"
'Dim server As String = "Server=localhost;Database=esola_musica;Uid=root;Pwd=;"
[code]....
View 5 Replies
Nov 9, 2011
i'm having some problem over here. When user enter their id,it will show up the main page and its for user but when admin enter their id,it will enter the user's main page and i have to click admin site on the top hyperlink and it automatically logout and once i enter back admin passwrd and then only it redirect to admin page.how to make it like once user enter their passwrd it redirect to user page and once admin enter admin password in the login it redirect to admin ?I have 3 roles over here which are admin,staff and user. Hereby i'll provide you my aspx code and also my vb code which is running behind the program.p
ASPX
<asp:Login ID="Login1" runat="server" BackColor="#009933" BorderColor="Red"
BorderPadding="4" BorderStyle="Ridge" BorderWidth="1px" Font-Names="Verdana"
[Code].....
View 2 Replies
Feb 12, 2011
i m using admin levels for a program it uses a Mysql database i now if u use a local db that u can use a dataset but how to do it when u have to Connect to a Mysql and check if the colum admin = 1 ?[code]......
View 3 Replies
Jan 29, 2011
how to add user level's like admin and normal user
i have this table login with the gebruikersnaam paswoord admin (admin is a int and if its 1 then your a admin)
this is my login script
Dim cnn As New SqlClient.SqlConnection
Dim comand As New SqlClient.SqlCommand
Dim adapt As New SqlClient.SqlDataAdapter
[Code]....
View 4 Replies
Nov 16, 2009
I think this has to do with a third party OCX control. Below is the output when the application starts. When I install my application on a stand-alone PC or most PCs in a networked environment it runs fine. When I go to some offices that have very tightly controlled networks I have problems.
The set up won't run under the user name so someone from IT must log in as administrator. They run the set up and the application installs and runs fine. The IT person logs off and the user tries to run it and the application won't even start. An error box appears and below is the report. SCANNERLib.DLL is the third party control. Maybe there is something I'm missing when I compile. Maybe the DLL registering funny under the Admin rights. [Code]
View 2 Replies
Jan 31, 2010
I found that snippet, edited it a little bit and now im trying to use it...the problem that ocurres, is that its never going into the first IF... so already there seems to be an error.Im working on XP SP3 with admin privileges..
Private Shared Function GetCurrentPrivileges() As Privileges
If My.User.IsAuthenticated() Then
If My.User.IsInRole(ApplicationServices.BuiltInRole.Administrator) Then
[code]......
View 7 Replies
May 23, 2012
Error: The database has been placed in a state by user 'UserName' on machine 'ComputerName' that prevents it from being opened or locked.
View 5 Replies
Oct 10, 2010
i have a script with a login form that creates a folder per user with username.txt, password.txt, firstname.txt, and lastname.txt. - auto creates when creating new user.after i log in and change form i want an label showing the first and last name of the person logged in,how am i supposed to do that? is there any way to make like an "admin" form where new account applies will pop-up when "admin" log in and then either accept or reject new users?
View 8 Replies
May 2, 2012
Just a pretty question that seem to me a bit difficult to do it. Well, I have a form called customers. Login form and mainform. So my clients want to have an option that explains this: If a user enters information in the customer form, then that information has to be confirmed by admins panel.
[Code]...
View 3 Replies
Sep 10, 2008
I recently just started working somewhere which will involve me coding VB in MS Visual Studio .NET 2003. I've been trying to refresh myself in VB by reading things online, but I just discovered an error while trying to run some practice programs (attached as error.png). Basically it says that I need administrator access.I'm waiting on an IT guy to grant it to me, but in the meantime I'm trying to figure out if there's a way that I can test my code without being an administrator.
View 1 Replies
Feb 26, 2012
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]....
View 5 Replies
Jun 9, 2009
on XP Pro, IsUserRole(eUserType.Administrator) returns true, if the class is administrator, and false if it's limited...
On Vista, it returns true, if it's the first administrator account, and false for anything else... I created a second administrator account on Vista, and it shows in code as "Standard" (or limited) user, the same as if I made a "Managed Account" on Vista...
My
#Region " [IsUserRole] "
Public Enum eUserType
Administrator = 0
[Code].....
View 7 Replies
Jan 6, 2009
i m using wmi to get connected with remote pc with admin privilege code works fine on around half of machines in my domain but in case of other machines just throw rpc server not available error i google to solve this problem but all in vain
i tried with
1. disabling firewall application
2. allow dcom 135 port for exception
3. checked wmi services are running
but i m in dark side and i really give up to this problem of "RPC unavailble" i hv wasted few days in this,
View 8 Replies
Apr 3, 2011
How can one obtain his/her database password with code while the admin privileges are proved to be sufficient by windows authentication?
View 1 Replies
Apr 9, 2011
i have a login page link above the page /// i want if user already loggedin then anybody click on loginlink then the user will automatically redirect to default.aspx ..
View 3 Replies
Mar 11, 2010
I'm designing a system, whereby am unable to use 2 different login authorities, which are Admin and Non-Admin. I am using VB.NET and Ms. Access and need help for the codes.I want something like, if i click on admin/non admin (with different passwords) a dialog box pops onto the screen and asks for the password. If the password is correct it should take me to the form i want. Something of this sort please.
View 9 Replies
Dec 8, 2010
Below is the part of code which I was working right now. Here what i am doing is checking whether the string is from header or div using [code] but i dont need this hard code.Can u provide me any alternative to this code. [code]
View 1 Replies
May 14, 2010
I'm using vb.net and have a small project that displays data from a SQL Server database. I used the Data Source Configuration Wizard to create a dataset. I've noticed web sites and code samples that show coding to connect to a database and I've tried that with success. But I'm wondering what the difference is between the two and which is better to use. The only difference I can tell so far is that by using the wizard, the textboxes on my form are bound and I have a lot less coding to do. By hard-coding the connection, I have to bind the textboxes in code. Is that the only difference?
View 3 Replies
May 18, 2010
I am attempting to hard code a richtextbox that has multiline characters upon the Load_Event. However, whenever I use the "&controlchars.newline _ " I get a syntax error and end of statement expected error.
[Code]...
View 3 Replies
Nov 6, 2011
What used to be C:Documents and SettingsAll UsersApplication Data is now Win7 as C:UsersPublicPublic Documents or similar..This folder is not part of the Environment.SpecialFolders list. Is there another way to expose the above Public folder?I'm hoping you can programatically use that location for non virtualized read/write/alluser files.
View 1 Replies
Jun 22, 2011
This is my first attempt at creating a Winforms application, and I have been developing in the .Net Framework (Silverlight, ASP.Net, WPF) for about 6 months. So, my appologies if this is a newbie question.
Basically what I am doing right now is taking the drawings of a stylus-based input, and storing them into an image field in a SQL Server database. Then, in another form, I go and get that image out of the database, and load it into a picture box. It works, but it is rather "sloppy" how it got there.When the user clicks save, it stores that image into a temporary folder, then converts it to a byte array and throws it into the database that way. Then, it deletes the file from the temporary folder. When retrieving it, it pulls it out of the database in a byte array, then converts it to an image in a temporary folder, thus displaying it on the form.
Is there a way that I can just bypass the storing of the file onto the user's harddrive both times, and go from byte array to picturebox?
View 2 Replies
May 1, 2011
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 Replies
Dec 18, 2010
The drive is connected via USB and the problem I'm having is that, periodically, while my code is executing, the usb drive seems to disconnect and reconnect. (Nothing to do with the program, but the drive itself).I want to find a way to prevent these temporary drive reconnects from interrupting my code. IE, i want to insure that whatever read or write that is requested is actually executed even in the case of a temporary drive interruption.
View 1 Replies
Oct 2, 2009
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 Replies
Jun 23, 2009
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
View 3 Replies
Jan 2, 2008
need to connect to a MySQL 5 DB from VB.NET [2008] 3.5 Framework from code.Help ..need the connection code
View 11 Replies
Jul 14, 2009
I'm trying to save what the user types in the vb code Dim user as Inputbox("") for example in a .txt file i can save the textbox and listbox but i cnt figure out how to save the inputbox i really need this to be saved the most.
View 7 Replies
May 17, 2011
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]....
View 1 Replies
Sep 8, 2011
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].....
View 2 Replies
