i wanna design a login form in vb.net with sql server of two user's how is it possible i.e everytime i click on OK button in windows forms it should check the database and allowed only those users else error mesg?
View 1 RepliesI try to make one application that will first show login form (with textbox for username and password) and when I press login client application send request to server side application that make SQL query (local) and return some values and that values will be listed in main form. I try something with TCP chat source codes but I don't manage what I want.
View 3 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.
The configuration is as follows
Remote SQLserver 2005 back-end
Windows Forms Front end (Visual studio 2008)
Is there a way to provide the username and password for the data connection from a Login form and not have it stored in a Connection string? Even better, is there a way to invoke the SQL login window each time the app starts? I need each user to be able to use his own (sqlserver) login everytime the application is started.
The configuration is as follows
Remote SQLserver 2005 back-end
Windows Forms Front end (Visual studio 2008)
Is there a way to provide the username and password for the data connection from a Login form and not have it stored in a Connection string?Even better, is there a way to invoke the SQL login window each time the app starts?I need each user to be able to use his own (sqlserver) login everytime the application is started.
I had a problem with WebBrowser component. Basically, it works improperly when try to log in on one web-site (Forex Trading Social Network | Online Forex Trading Forum and Social Networking Site). I am working with Visual Studio 2010 Professional. I created a simple WebBrowser trying to access the indicated web-site. The problem begins. Well, the website loads, but when you go to the login page (Forex Trading Social Network | Online Forex Trading Forum and Social Networking Site) and try to log in, it doesn't work. I mean, when I enter the login details the login page just refreshes itself and the login wasn't proceed. The same login page appear with every login attempt. The is the current problem!I check with Google, it works. But, it doesn't work with Forex Trading Social Network | Online Forex Trading Forum and Social Networking Site! Why?
View 14 Replieshow to create form login with sql server 2005 in vb.net 2005..
View 2 Repliesi'm trying to make a login form connected to an sql server database. my data base has records like this:
fname - lname - minit
each name in a separate column, and i wanted to use the name as the login username, so in the dataset designer i made a new column and concatenated the names together like this: lname+fname+minitbut at "Dim dr As SqlDataReader = cmd.ExecuteReader" i get this error:
"Invalid column name 'username'. Invalid column name 'username'."
i'm asuming that's because username doesn't actually exists in the database, only in the dataset.is there a way to get that to work with out the username column actually existing in the database?
Imports System.Data.SqlClient
Public Class LoginForm
Private Sub OK_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles OK.Click
Dim cmd As SqlCommand
[code]....
In VB.Net 2005 I have a login form where the user enters his username and password on beginning to run the VB app. The login form is called from the Shown event of the form called at StartUp. frmLogin.ShowDialog() frmLogin is set as Fixed3D, and TopMost = True, and the first textbox is TabIndex = 0 and TabStop = True. The cursor evens flashes in the textbox.
However, when another program is running eg. AVG Anti Virus, Word etc., the focus is lost but the frmLogin 'looks' live. When the user types something into the user name box, what they type appears somewhere in the other program not in the frmLogin.
Is there a way of forcing focus back to frmLogin? I tried a timer and Me.BringToFront every 1/10th of a second, but no success.
Otherwise, the user has to find the mouse and click on the frmLogin before trying again.
how can i connect my login form to my sql server 2008, only members of my project is able to sign-in, i want my project to have authentication. can i do it with a stored proc?
View 1 Repliesthis is used to add upon details of username and encrypted password in database
Imports System.Data.SqlClient
Imports System.Security.Cryptography
Imports System.Text
Public Class Form1
[code].....
I have made a windows forms application with a user login which queries a sql server database located on a central server. It currently has one sql server login which it connects to using a connection string in the app.config file. The user login is validated by querying a username table in sql server. I would like to make this a multi user application where after the user logs in, their credentials are stored and used by the the application to access the database with a sql server login. There will be 5-10 users.
View 3 RepliesI've created a windows form application in vb 2010. I've got all my forms complete and now want to add a Login screen. One the login screen, after the username/password is entered and OK is pressed, I try to open the a connection string. Obviously if the connection fails, the user has entered the incorrect credentials. If the credentials are ok, True is returned and I then open up the Main form that shows the correct items for the logged in user.
[Code]...
ok well eh i have a interface where i can login, but i must set the status to tell whether i am student or staff login.
View 1 RepliesMy background is mostly Access VBA and I am having to learn VB.NET. I am trying to recreate an Access 2007 application I wrote into VB.Net. We are looking at using a hosted SQL Server so we do not have to worry about remote offices or replication. I am using VS 2008 and SS2008.My issue is that I need to create a login form in VB that with look at SQL Server DB and return a dataset record matching the username and password. There are many tutorials on here but do not match what I am looking for.I have a stored procedure with 2 parameters (@prmUser and @prmPassword) named spLogin.I need to call the sp and pass the parameters to SQL Server DB and return the complete row of data that is matched from the button_click event on my form.
In Access, I would have a form that would have the returned data and I would reference that information throughout the application by using the 'forms!frmName!txtValue' to populate forms, reports, and fields that would capture the user that created the record. What is the best practice for this?Next when the login credentials are correct then I need another form to open, which is my MDI form, if not correct then msgbox to try again.
I've made a basic loginform in VS 2005 for anyone to use (Continued from the VS 2003 version), here's the zip file containing the form, feel free to use & modify it freely ... you dont even need to tell me about it How it works:Make an instance of it then you can set the properties UserId, Password, UserIdMaxLength and PasswordMaxLength then just call the the ShowDialog method.I've provided some other ShowDialog signatures that allows those properties to be set with only 1 ShowDialog call..When the Login button is clicked on the window you can retrieve the UserID and Password from their respective properties..This works with the DialogResult object as well so you can easily check to see if the cancel button was clicked or not.[code]
View 3 RepliesI am having trouble in creating a login form in my windows application.If i create a login form with its database local to the system ,it works fine .But my requirement is that the database is placed on a remote server so that the login is secured.When the user tries to use the application he first needs to login.When he puts the username and password in the login form it should send the data to a remote server for authentication.
View 12 RepliesPrivate Sub OK_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles OK.Click
Dim con As New SqlConnection("Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirector y|Database1.mdf;Integrated Security=True;User Instance=True")
[code]....
i'm trying to make a login form connected to an sql server database. my data base has records like this:
fname - lname - minit
each name in a separate column, and i wanted to use the name as the login username, so in the dataset designer i made a new column and concatenated the names together like this: lname+fname+minit but at Dim dr As SqlDataReader = cmd.ExecuteReader i get this error:
"Invalid column name 'username'. Invalid column name 'username'."
i'm asuming that's because username doesn't actually exists in the database, only in the dataset.is there a way to get that to work with out the username column actually existing in the database?
Imports System.Data.SqlClient
Public Class LoginForm
Private Sub OK_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles OK.Click
[code]....
wen i open mdi through the login form, the forms inside the mdi child forms dont seem to execute.
View 2 RepliesHow To on a database driven login form. I'll include the Administration Backend to go along with it soon. Dial-Up users should not use this thread, it is image heavy
[Code]...
I have an ASP application with Sql Server 2000 database. The application has a login page. It was working fine. But from past few days, some times login fails and some time it works. I looked into the procedure and ASP page but could not find any issue.
View 2 RepliesI am currently working with VB.net 2005. I am trying to create a login form and use a text file as a database to login. The part login form is fine but i can't connected to the text file. When i use my coding with a database such as access or mysql is work fine.
[Code]...
For the past couple of days I have been using Visual basic 2008 and learning it.Anyway, I am trying to make a login form that will login to a website with WebBrowser control.and I am noticing that the webbrowser is extremly slow, it takes him about 20 seconds to load a page while mozilla opens it in a moment, why is that?
View 6 RepliesHow do I create a Login Verification routine (Login Form) and make the password case sensitive?Please remember to mark the replies as answers if they help and unmark them if they provide no help.
View 3 RepliesI have a situation where I need to create a session in a Windows server using a specific Username and Password.
View 1 RepliesI have a login form with username and password authentication . It works fine. But I want to give option to remember login info option in the form.
View 7 RepliesIs that possible to done this? If yes, how to done it?
Client: [Client is made in VB.NET]
Add new form: "Login Form"
Add new form: "Form2"
[Code]...
if it is "LOGIN" then check is the username and password correct, after that send back to the client that the information is true so the client will show up Form2
if it is "REGISTER" then add new username and password to the server *NOTE: The username and password will be saved in a file
What I'm doing to making something that is /like/ the MSWPI(microsoft web platform installer), but not quite. When you open it up, a dialog will pop up, and ask for a username, and password to the site(I might be able to do that with "SendKeys"), is it is correct, it will load up a list of files and directories. From there the use3r can download anything. I want to make this for my website, where i will sometimes post a tutorial, and post the programs I make, but most programs that are not done yet go in to the private server...
[Code]...
I have the login codes.. Private Sub OK_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles OK.Click
mysqlconnection = New MySqlConnection
mysqlconnection.ConnectionString = "server=xxxxxx; port=3306; user id = root ; password = 123456 ; database = alogin;"
mysqlconnection.Open()
[Code]...
my server is a IP address xx.xx.xx.xx...which other server in other place but why i got the error which is
'unable to connect to any of the specified mysql host'