Set Up Different Levels Of Access In An Application Based On An SQL Table Of Usernames?
Sep 2, 2011
I want to make different levels of access for a vb.net program i'm writing.I have a database called "stratocast". I want to show a specific form for entries in this table with "IsManager" checked and another specific form for those with "IsAdmin" checked.Im using MySql server and visual basic 2010 express
EDIT:To clear up any misconceptions about my post, ill explain further: In my vb.net application i have a login form with two textboxes; One for the username and one for password. I also have three other forms, one is called "frmAdmin", another called "frmManager" and another one called "frmEmployee".
On my database i have a table called "employee" with columns called "name", "title", "IsManager", "IsAdmin", "Username" and "Password".
IsManager and IsAdmin are both Boolean columns
This means that their values can only be 0 or 1 and the result is displayed as a checkbox.When the employee logs into this applcation i want it to check whether or not the employee is a manager, an administrator, or just a regular employee with no additional rights. If the employee is a manager, i want to show "frmManager". If the employee is an Administrator i want to show "frmAdmin". And if the employee has no additional rights then i want to show "frmEmployee".
I'd like to keep the configuration for access level checking confined to the one table but if it's better to have separate tables for each level of access (ie: tables called Admin,Manager, and Employee) then ill consider that too.
View 2 Replies
ADVERTISEMENT
Jun 21, 2010
i'm developing an application with vb.net and mysql. I want to add additional users to the application but with different access levels. this is my original code [code]If i add a third parameter named level to the sql statement, how do i determine which form shows???
View 3 Replies
Sep 1, 2011
Basically i am trying to create a programme, which needs to have some authorisation.
When the application starts up, it starts straight into the login screen.
I want the Username and Password textboxes to read the database and if they match then progress to the next form but if they dont match then a message box will appear.
I also want to create groups of people so if a certain group of people log in they go to a certain form and if the another group of people log in i want them to go to a different form.
Also i want the password box to be * instead of visable text.
dbProvider = "PROVIDER=Microsoft.Jet.OLEDB.4.0;"
dbSource = "Data Source = D:/Users.mdb"
con.ConnectionString = dbProvider & dbSource
[Code]....
View 3 Replies
Jan 23, 2011
I have made an Access database complete with a report/form UI, however I am now looking to take this further to Visual Basic. In my Access database I have a log-in form to access some secure reports. I am now trying to do the same thing in Visual Basic, with no luck. I have created the UI elements i.e. buttons and text boxes, but am now stuck at how to implement the code.What I want to do is make the login button check what's in the username/password boxes with a table in my Access database.
View 1 Replies
Nov 22, 2011
I am working on a multiple choice quiz, admin screen, student login screen where they choose their level of difficulty. I have been able to start the quiz, have the questions and answers filled, user answers question, check if correct or not, if correct then the score is incremented.I am able to set up a variable for 'level' and want to write some code so that whatever is selected then that table / questions will be selected and displayed to the user.
The way I'm thinking at the moment seems very long winded. I think I'll have to write an IF ELSE statement/case statement for each of the 'navigaterecords' and the sql statment for beginners, intermediate and advanced.Assume there is a variable 'LEVEL' - have not actually done this yet. Where the code refers to 'advanced' is where I have been trying it out to select questions from the advanced table.
Imports System.Data
Imports System.Random
Imports System.Data.OleDb
[code]....
View 8 Replies
Jul 19, 2011
There's a table Category with a pk idCategory and a self-referencing foreign-key fiCategory.That means categories are "main-categories" when fiCategory is null. If fiCategory links to another category, it is a sub-category of it. But it's also valid that this sub-category also has 1-n sub-categories(with fiCategory linking to it's idCategory).Q: How can i get a list of main-categories,sub-categories,"sub-sub-categories", ...etc. with LINQ?I'm using typed DataSets to compare data from Server1/MySQL with data from Server2/MS SQL-Server.After normalizing and cleaning(there are several inconsistencies) i want to import the new data into SQL-Server. First of all i have to import the main-categories, then the sub-categories and so on. Otherwise SQL-Server would throw a constraint exception when i would try to insert a row with a foreign-key to a category that is yet not inserted.
View 1 Replies
Feb 23, 2011
I have a query that I have to run that requires me to get rows from a table based on the value of a field in another table (which I have gotten earlier). I currently have it done like this (simplified).
[Code]...
View 1 Replies
Aug 23, 2010
I have two tables Employees and CafeLogs. Some employees can be cashiers and also customers at the Cafe shop.
Table structures:
Employees: EmployeeId(PK) , FirstName, LastName
CafeLogs: LogId (PK), CashierId, EmployeeId, Value, => CashierId and EmployeeId are the data from column EmployeeId of Empoyee table
Table relationship:
Employees 1:N CafeLogs (CashierId (FK))
[code]....
Right now I know how to select only LogId, Employee's name, and , Value, not with Cashier name yet.
Dim query = From log In db.CafeLogs _
Join emp In db.Employees On emp.EmployeeId Equals log.EmployeeId _
Select log.LogId, emp.FirsName, emp.LastName, log.Value
View 1 Replies
Apr 6, 2011
I am creating a project in VB.NET in which one of the reports require that the name of employees should be displayed as column names and whatever work they have done for a stated period should appear in rows below that particular column.Now as it is clear, the columns will have to be added at runtime. Am using an ODBC Data source to populate the grid. Also since a loop will have to be done to find out the work done by employees individually, so the number of rows under one column might be less or more than the rows in the next column.Is there a way to create an empty data table and then update its contents based on columns and not add data based on addition of new rows.
View 1 Replies
Aug 30, 2009
I want to add a new table in my accdb and copy the content tfrom an existing table into the new one.
Is there an easy way to do this?
View 8 Replies
Jul 9, 2010
I have a table (Projects) which is linked to projectVersions on projectID..projectVersions contains several columns on which I'd like to filter a returned project (and associated projectVersions) list. For example there is a "capacity" column and a "country" column. I am doing a filtered list of projects on one page and I'd like to include all projects where any one of the associated projectVersions has a capacity of 750ml and a country of "France" for example.It may be that a particular parameter is not set and so I pass a zero to indicate not to filter on that.I guess this needs some kind of subquery as when I try and do something like this: [code] it doesn't work as the "xxx" bit, being one-to-many, expects me to specify an item to get at the entities within and yet I want to query where ANY of the associated versions match one of the criteria.
View 1 Replies
May 27, 2009
how to create a uninstall command for a Windows-based application in the Application Folder when creating a new setup project in visual studio 2008.
View 4 Replies
Oct 12, 2009
I have been working on a project in which I need to get all usernames.
Add to form
Public Function GetUserId() As String
Dim lUserName As String
Dim lSuccess As Boolean
[Code].....
Unfortunately, this only gets the username of the user logged on. I was wondering if there is a way to modify this to get all user names.
View 2 Replies
Jan 25, 2009
Is it possible to get a list of usernames (as shown in Control Panel->Users) on the PC that my app is running on? If so, is it then possible to determine the type of account (i.e. Admin, Standard AND if the account is the Built-in Guest or Built-in Administrator account)?
View 1 Replies
Jun 16, 2011
Here is my code that I wrote its very simple.
Normal Code
If TextBox1.Text = "PleaseHelp" Then
Button1.Enabled = Enabled
End If
BUT I need like multiple correct logins I don't know how I forgot! EXAMPLE: If TextBox1.text = "PleaseHelp, HELP, Thanks" <--- gives me a error I know it isnt the correct way! I just cant figure it out and its basic code....
View 3 Replies
Sep 27, 2009
I am trying to get use to this....I need to know how to type in a database for my usernames and passwords??? I am using visual basic 2008, which I think is visual.net? anyway...heres my code:
Code:
Public Class login
Private Sub login_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Hello.Hide()
[code]....
View 2 Replies
Jan 28, 2012
I need a Function that I can read all the Users that exist on the Windows System. I dont know how to realize that.
View 7 Replies
Feb 27, 2009
I'm trying to connect to an Access table who's name includes spaces ('look Material Type').How do I identify this table in an OleDB string
View 2 Replies
Oct 23, 2009
I get a Syntax Error with the following code"ALTER TABLE receipts RENAME COLUMN payees TO payee"what I am doing wrong
View 18 Replies
Apr 28, 2009
I am trying to update a table based on row selected in a grid (C1TrueDBGrid1.Columns(1).Value), but I am getting the following error:
Update unable to find TableMapping['Table'] or Data Table 'Table'
Dim ConnectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|AOPT2002org.mdb;Persist Security Info=True;Jet OLEDBatabase Password=testaopupdate"
[Code]....
View 3 Replies
Dec 18, 2009
I have a Link Table containing the ID field of several tables, how do I load the grid from the Link_Table based on the ID field of several tables loaded to the grid? [code]...
View 9 Replies
Mar 17, 2011
I would like to know if it is possible for a Table Adapter to reference a query as opposed to a table. Currently my Table Adapter references a table in my SQL database, but I wanted to know if it was possible to have it reference a query, which selects a table from another database?
View 5 Replies
Oct 15, 2011
I have an application that has an Ms Access 2007 DataBase which runns great if access is installed. Is there any code that I can use in vb that I would be able to run access with out installing it.
View 5 Replies
Oct 22, 2010
First off, I am a total VB noob. I want to create a program so that I can store usernames and passwords. I want to be able to search by username and pull up their password. What VB program do I need to write this? Can I just use the VB in excel?
View 9 Replies
Feb 6, 2012
storing usernames and password after the program closes. I do not want them to be stored in a .txt file, as this is insecure. How do I store it?
View 2 Replies
Jun 12, 2011
I'm having a problem with the error in verifying the usernames that are already existing in the record/database.
When you inputted a username that already existing it will throw an exception, and when you change the username, it still throws the exception.
View 7 Replies
Mar 2, 2011
I have 2 Tables , OrderDetails and Requests In my LINQ to SQL dbml file. OrderDetailsID is a foreign key in Requests Table.
I want to write the query to get the sum of UnitCost from OrderDetails based on OrderId. And If there is a row in Requests Table for each OrderDetailsID, and the Requests.Last.RequestType="Refund" I want to reduce the total refund amount from the main sum otherwise If there is no row based on OrderDetailsID, add to sum.
Here is the way I implement that. I am looking to prevent using "For each".
iRefund = (From od1 In dc.OrderDetails _
Where od1.OrderID =1 _
Select od1.UnitCost).Sum
[Code]....
View 1 Replies
May 18, 2012
I am having a loading problem, the problem is my formating code takes way to long to load.
What I have is a datagridview that is loaded by one table and I want to format the cells based on data from another table, the following code works, but it gets slower and slower as I add more records to the data.[code]...
View 4 Replies
May 8, 2008
I am working on a 1-page report, that basically consists to select 1 record from table and bind values to proper fields (eg. =Fields!name.Value).However, I have one field in the table that will be just "Y" or "N".When this field will be "Y" I would like to show in the report "Yes, I do."; otherwise I would like to show "No, I dont."
View 1 Replies
Mar 4, 2009
I have 2 Tables , OrderDetails and Requests In my LINQ to SQL dbml file.OrderDetailsID is a foreign key in Requests Table.I want to write the query to get the sum of UnitCost from OrderDetails based on OrderId.And If there is a row in Requests Table for each rderDetailsID, and the Requests.Last.RequestType="Refund" I want to reduce the total refund amount from the main sum otherwise If there is no row based on OrderDetailsID, add to sum
View 3 Replies
