I have been requested to implement a login form into a friend's Visual Basic .NET application. He specifically requested that I should do this using LINQ to compare the input to a table in an Access database. I don't really know why he imposed these restrictions, but who am I to judge? However, the problem is I am not overly familiar with VB .NET, or LINQ.
View 1 RepliesI wanted to create a Login System. I am using Visual Basic 2008 Express Edition, Microsoft Access 2007/2010 Beta.Ok this is my current code-the main problem I have is that I dont how to compare what the user puts into the textboxes and then check that against the data in my database. [code]When I run/debug the program and enter the correct username and password into the program it comes up with the MsgBox("Incorrect Login Details - Please try again.").The connection string for where the database is coming from is right, because I checked it..so must be something wrong with the SQL Coding I guess.
View 19 RepliesI am trying to create a login system using 2 tables from MS Access to grant access for opening another form.
View 8 RepliesI took sample code to implement the IReportServerCredentials to send the login information to retrieve a report remotely but for some reason the implementation is error prone.
[Code]...
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 RepliesHow do I create a Login Verification routine (Login Form) in vb.net . i have an windows application with login form contain user name , password , ok button and cancel button .
as this one:
Imports System.Data.OleDb
Public Class LoginForm1
' OK button
[Code].....
but i want to run my application from desktop and will get confirmation if the user name and password correct by checking them in MS Access Database in the server.
so the the application in the desktop and the tabel of user name and password in the server.
I'm working on a project with includes a student login system and Staff control. This has been successful although i am trying to find out how to show specific user information from the student login.The project is based on students getting points for "good behaviour and attendance" which is controlled by staff who teach them and students can redeem the points on set prices e.g. from pens to cinema tickets.Here is my student login code
Private Sub OK_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles OK.Click
' Connects the .NET framework to the OleDb database and selects the file wanted for use
[code].....
I am new to development and I am looking for some pointers. I have a sql 2000 database and a vb.net app. Right now the SQL username and password to connect to the database is stored in the VB application which is not convenient since we must change the password periodically. The user opens the app and enters the username and password for the vb application. Using the credentials stored in the application to connect to the sql server, the app checks the username and password stored in a user table in the database to determine if they are allowed to connect or not. For various reasons, it is not feasible to simply have the application username and password be the same as the database username and password. We must have only one database username and password and it must be changeable. Like I said, it is now stored in the compiled application which is inconvenient.
View 1 RepliesI am using the code shown below to compare two Access databases with two fields each and write the results to a third Access database. I am getting an error at the "Do While DMReader02.Read = True" line: "Invalid attempt to call Read when reader is closed." Why would the reader be closed at this point if I am using different DataReaders in the two loops?
Imports System.Data.OleDb
Partial
Class Form1
[code]....
I am quite new to programming and I want to be able to check whether the user logged on to the system is in a table or not. I am not quite sure how to iterate through a table.
View 2 RepliesI am using VB and have created a Access Table with a few columns. Simple things like....user name, password, etc. I created this table for my login form. I just want a simple login form where the user enters their user name and password. Then it is checked to see if it matches the Access Table. If so they are allowed in if not prompt and error message. For starters: I have the table created (it will only need apx. a dozen user names/passwords) I have the data source linked to the form already. My realy problem is getting the User validation information to compare with the access table accurrately. The Access Table is linked and the first row of the table is arleady in the text boxes. So, I went ahead and replaced them with noting on the form load.
LOAD
ACCESS TABLE ----
Login_NameTextBox.Text = ""
[code]....
That's the code I am using. It is not working. It either lets you in no matter what as long as there is data in each text box or it will not let you in even if your data exactly matches. I am trying to get the first instance to work before I try to get all the login names and passwords to work.
I have to compare an item value in two tables. these two tables are on different database(same server).
I have succesfully generated sql query to return both table values.
the query runs in sql server without any problem and gives the results.
The same query i used in vb.net doesnt gives any result ...
It is resulting with no rows.
Does the connection to multiple databases wont work from vb.net.
The following classes are used to get the result ...
SqlConnection
SqlCommand
SqlDataAdapter
SqlDataAdapter is showing with no records returned. The same query returns the results in sql server query window...
how to connect login system using vb.net to Access 2010?.
View 3 RepliesMy query is i want to save record from an excel sheet to my Database Table.
But i dont want to insert the Excel sheet as a whole rather i want to insert the record in my database table Row wise.Inserting the records is not the only thing but my major issue is i want to check and compare the Primary Key column of my Table with the Column in my Excel.
Suppose Table1 is my Sql Database Table,and RegistrationNo is the Primary Key Column.Similarly there is also a column of Registration Number in my Excel Sheet.
Now before inserting each record the RegistrationNo column should be compared.If the a registrationNo in the excel sheet say RegistrationNo 112 is already present in the table then it should not Insert the record and if its not present then it should insert.
Also the other issue is the number of columns in my Database table are more than the number of columns in my excel Sheet.So the columns that are not present in the excel sheet should be set to NULL while inserting the record in the Table.
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?
[Code]....
This code is for listing all folders including subfolders. but when i run this code i m getting error "Access to Path F:System Volume Information is Denied" How can i ignore this folder and continue scan.? is ther any solution for this error?
I have an interface 'ICRUDable' and a class called ClientAddress which implements the ICRUDable interface.
My understanding of OOP would lead me to believe that if I declare a System.Data.Linq.Table(Of ICRUDable) then I should be able to put ClientAddress's in there.
The code I have tried includes;
Dim dc As New CRMDataContext
Dim items = dc.ClientAddresses
and
[Code]....
i am trying to create a login access for my application. Well, i have 2 account type, that is manager and receptionist. And both account type have their own forms. which mean if i log in as manager, then i will open to the manager forms, and if i log in as receptionist then i will be open to receptionist forms. Can it possible be done?
View 5 Repliesi want to make a login system using an sql database but i don't know how to create an sql database and don't know how to make this program, how to make a login system with a register button too using an sql database,and how to make the program
View 1 RepliesMy login system used a database1.mdf and if the user is new to the program it will have a default login, if signed in with the default login then user will be promoted to a firstrun.vb screen which will allow the them to change username and password or else it will go to the mainmenu.Problem : I am unsure how to stop the firstrun form from appearing if the user as already changed the password or username, either 1. and what code to add to the form firstrun.vb if they would like to change it, meaning updating the database.mdf
Imports System.Data.SqlClient
Public Class Login
Dim cm As SqlConnection
[code]....
I'm working with the project that require save all user personal information in one table when they login the my system. The problem is too many users login my system per day, it's very hard to manage. So, I want to add one more function which can specify one user information. My solution is filter that user and copy to other table, the problem is I don't know how to do that. how can I delete all information in a table in database?
View 3 RepliesI've now properly started implementing OO into my system (which I probably should have done from the start) but I just want to clear some best practices.So let's say I have a class called Job which contains information such as Description, Project Manager (Employee class), Value etc. at the moment, if I initialise the Job class it will initialise all the information held within it, even if I only want the job description. Is it best practice to do this or is it better to implement the class and access the database for values as and when they're needed? Or is it just better in those cases to just access the database directly?
View 1 RepliesBasically Im going to sell software where once the user buys they register on a page, then their credentials gets added to a database, then once they open my program they login and my program checks if there in the database or not so they can advance.
View 3 Repliesi'm trying to link the program i'm designing so that it creates an entry and can refer to the record for the numerous pieces of information that was saved to it. I'm not sure what method would be the best to achieve this but I'm a bit short on time to have this done as it is a school major work and this is one of the final steps but me and my partner are stuck and the teacher refuses to help, probabaly because he doesn't know.
In the register I need to allow the user to input a Username, Password, First & Last Name, Email, Address and a Phone Number On the login it will only require a Username and a Password.
I'm really sorry I have not given any personal coding etc. but we simply don't know where to start.
[code]
Imports System.Data.OleDb
Imports System.Data.SqlClient
Imports System.Configuration
[code]....
I don't know if these can connect with Access, anyway, I got ERROR on the com.Connection.Open()?
i want to compare a column present in the access database BankAccount table with a field present in the form named as account......
[Code]...
How can I convert an object of type System.Data.Linq.DataQuery to System.Linq.IQueryable?I'm working with Visual Basic/Silverlight, and the source code of my query is as follows:
Public Function Get_Cli_Pag() As IQueryable(Of V_Cliente_Pagare)
Dim Qry = From P In Me.Context.Pagares Join C In Me.Context.Codigos On C.Codigo
[code]....
If I have this to read from an access database, how could I translate it to read from an oracle database with the same table/field information? I know nothing about oracle but I assume I cannot use the oledbdataadapter that I am used to when connecting with an oracle DB.
[Code]...
I have two Access database, say database One.mdb and Two.mdb. I want to use VB2005 to export tblCustomer from One.mdb to Two.mdb, and replace the existing tblCustomer in Two.mdb, during run time. I basically want to simulate the export function that is available in MS Access (which can export one table from one Access database to another) with VB2005 during run time. I can think of a way by querying the table to a dataset and then delete everything on the other database before filling the table in that database with the dataset
View 1 RepliesI'm having a problem with loading my MS Access Database. I can get it to load but it won't load in a row. My friend told me to try this but it puts all the information in a column instead of putting all the information spread out accross the row.
Here's my code:
Dim lb_Connection As New OleDb.OleDbConnection
lb_Connection.ConnectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE = pass_database.mdb"
Dim lb_SelectCommand As New OleDb.OleDbCommand
[Code] .....
Also I'll attach an image of what the program does when I load it.