i am trying to make a login screen that is connect to a database(NOT MS ACCESS).i keep geting an error when i try geting it to conect to the database
"Value of type MySqlData.mySqlClient.MySqlDataReader cannot be converted to System.data.OleDb.OleDbDataReader
At rdr = MyCommand.ExecuteReader()
dose anyone know whats going on
[Code]...
In this code block, the datarow gets the row number of the username that was used to log into the system with, right? And in this code, if there is a username/password that was matched with in the database, it'd place it on the dbUsername/dbPassword variables and compare it with the ones that were inputted by the user.What if I wanted to know if there is none of that username (like, username doesn't exist from the database)? I tried inputting login info that doesn't exist in the database and it resulted into the following error:An unhandled exception of type 'System.IndexOutOfRangeException' occurred in system.data.dll
[Code]...
I 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 RepliesI got the above error when i deploy my web application into windows server 2003. How do i resolve it? [code]
View 3 RepliesI'm making a database app. I've finish the search, add new, and add function. What I'm trying to do is to expand the functionality of the add new item function.
View 2 Repliesso I've started using the Webbrowser control, and I've got it doing most of what I want (a button takes them straight to the correct page on the correct site, it's filling in text boxes, will fill out more once I get to that step).However when I go to the particular secure site my users are supposed to login to, it brings up what I assume is a windows domain login prompt with a check box to save the userid/password.
Saving the password is not allowed for this secure site, and when I use system.webclient to get the first page so I can use my own windows for getting the login info, it doesn't carry over the authentication info to the webbrowser if I let it go back to using the web browser's default navigation methods, nor does it load the images or the page properly.I was thinking I needed to set the webbrowser's credentials, but I can't find anything exposed to make changes to or override if I try to inherit.
i'm behind a webproxy, and the site itself requires login. I've figured out in code how to pull back secure pages that require you to be logged in, but when I pass that html up to the webbrowser it doesn't know how to access or load the images or other things that the html instructs it to do.
I wrote this code to the load event of the form which contain the report viewer , i connected it to the dataset but it is asking for login info whenever i am opening the report..
View 2 RepliesI have a form in my application, and when I logIn, I make a query to SELECT the username, the password and the level of username.
"SELECT username, password, level FROM TLogin WHERE [username] = @username and [password] = @password and [level] = @level"
So, when I logIn, I go to a form called "Options", I would like to know how to only show the information about the user that I've loggedIn ?
In my vb.net windows app, which runs on windows server 2003, i will like to return all the users who are logged into the server. How to do that?
View 3 RepliesI have just added a login form to my main form which just has a username textbox and a password textbox. What i basically want a user to be able to do is enter their username and password into these fields and then for the form to store the values there.
So if they enter their username and password, and then click OK on the login form, if they were to open up the login form their details would still be there?I want to be able to call on these values else where? How do i store the info in the username and password fields? And if they then closed the form and opened it up again would it still remember what username and password had been entered?
Hi, I've created a login screen for my application and defined the username and password using the following code
If UsenameBox.Text = "username" and PasswordBox.Text = "password" Then
Me.Hide()
Main.Show()
It works great however, I need the user to be able to set their own password using a registration form with the details being stored in a xml file. There are no security concerns with the password being stored in a text file as it's a mock login screen.
I am trying to have my application use our email servers to send out an email when a certain action is taken. What I want it to do is use the username and login that the user is logged into the domain as for their email username and login. How can I get access to the users domain login and password? For instance, if I log into the computer, I want the application to use my windows login and password as the email username and password, since they are the same. This way I don't have to ask for it. I tried importing System.DirectoryServices and it once I type in Imports System. it does not have directoryservices as an option.
View 4 RepliesI need to convert a large VB6 app to vb.net which does a lot of database work and produces a Crystal Report. The initial form is simple a login form which validates the user. I am trying to use a datareader to retrieve the user's login info but it won't compile on the statement where I'm trying to get the Connection String from the app.config file. It complains that the ConfigurationManager is not declared on the dim statement. Where and how do I declare the ConfigurationManager? I thought it was just pointing to the app.config file but apparently that is not correct. [Code]
View 3 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]...
How 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 created a SQL DB named MainDB.mdf and a small VB 2010 application with some forms and datasets.Everything was working OK until i got a new computer and re-installed Visual Studio 2010 and SQL server 2010 on it. I copied my DB from the old to the new computer and also copied by VB 2010 project to it. I used Windows Authentication to connect to the DB in the old computer and also in the new one, i am using different Windows user account names though.
I was able to connect to the DB in the new computer in the Server Explorer section, i created a new connection string to the DB and i can seed there is data in the tables. When i run my VB 2010 application created in the old computer get error:
"Cannot open database "MainDB" requested by the login. The login failed. Login failed for user 'D630Admin'."
I need to get rid of that error and be able to add/mod/del data from my DB using my VB application as i used to.
I have the lines above to login by database. However, I really don't know why always give me the error: "Incorrect fields". I am 120% sure that all the fields of the table are right, including the text that I put into my textboxs. I have already add a user into the database. I can make login in PHP but in VB.NET I just can't.
Try
Dim MySQLConnection As New MySqlConnection("server=localhost; user id=root; password=; database=DB")
Dim MySQLQuery As String = "SELECT * FROM TableLogin WHERE Username = @username AND Password = @password"
[CODE]...
I already tried to show the data of the database into a Datagridview and it works fine, it displays to me all the rows that I had add in the database.
I have been trying to solve this for 2 days now, every text book I own and google have been well and truely exhausted and I am still no closer to solving my problems.I have a login facility reading in user info from a main user file. This takes all info into a temp array and then splits usernames into a username file, passwords into a password file and a current score in a score file.
I have the login working fine and everything else in my program works as intended but touching up cosmetic aspects I want to add a Message box after login to say hello and display current score. This works great for the first name in the user file i.e - after login User1 welcome to the game. Your current score is 45 As intended.But the problem arises with any other users, my message comes out as
User2 welcome to the game. Your current score is 55 I do not understand where the random new lines are coming from. I have tried assigning the message as a variable and removing new line using
[Code]...
I followed below attached tutorial but I got this error: Cannot open database "mydb" requested by the login. The login failed. Login failed for user 'NAME OF COMPUTER FOR THE NETWORKUsername'. Second question: When I deploy my application which communicates with SQL server, should I put in the installation file SQL server? If I need to deploy and SQL server, I have to configure server, right? P.S.I use SQL 2005. I changed Authentication Mode of the SQL server to: SQL Server and Windows Authentication mode.
View 12 RepliesI have code on log in form but it only get the latest data on username and password column on my database
Here is my code
Public Class Users
Dim MyLogIn As New myRecords
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles
[CODE]...
This is my connection:
Imports MySql.Data
Imports MySql.Data.MySqlClient
Module myconnect
[CODE]...
This is my record:
Imports System
Imports System.Data
Imports MySql.Data
Imports MySql.Data.MySqlClient
[CODE]...
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 RepliesI created a database in access 2007, linked it to my project in visual studio 2008 (vb). When I enter some data using the UI, it does not save it in the database, and it's gone as soon as I run the program again. I dragged the textboxes from the datasource panel, onto the UI..
this is the code that was automatically generated by vs for the save button:
[code]Private Sub StaffBindingNavigatorSaveItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles StaffBindingNavigatorSaveItem.Click
[Code].....
I have 3 labels I want to populate with info from my database. I have a SELECT statement that works for only one piece of info but I need it to include the other 2 as well.
I have 3 labels: Current, YTD, and MTD My select statement is working for YTD but I don't know how to write the SELECT statement to include the others.
[Code]...
This code is correct...
Do While rdr.Read
issuebook.cbmember.Items.Add(rdr.Item("FName"))
Loop
Suppose i want to add both last and first name..I tried this but getting a error
Do While rdr.Read
issuebook.cbmember.Items.Add(rdr.Item("FName" & " " & "LName"))
Loop
I have selected the info that i want from my database but im unaware of the syntax need to be used to add them to the datagrid.The datagrid has the column...BookName, DateRetun and DateIssued.
cn.ConnectionString = "data source = RayonRayon; initial catalog = library; uid=sa; password=minnie"
cn.Open()
cmd.Connection = cn[codee]....
got a new problem while trying to add a new user into the database. After i've submitted all the data i get an error message saying "Conversion failed when converting the varchar value "Aron" to data type int" to be honest, im totally stumped as to what this could meen, does it meen its trying to convert string type data to an integer? Anyway heres the code im using
[Code]....
im trying to add a new user login to my database through my program, and i've got the procedure worked out, i just dont know how to retrieve the inputted data.
Basically i've got three text boxes that ask for "Name" "Password" "Phone Extension" but how would i work them into his statement?
CreateLogin.CommandText = ("INSERT INTO Users (UserID, Password, Phone) Values How would i follow up after "Values"??
I have a gridview with four template fields that I need to be able to put info into to save to the database. When I hit the edit button and my columns change into edit mode I can enter information just fine. But when I try to loop through the control to get the information it doesn't pick anything up?
Private Sub gvOLIAdj_RowEditing(sender As Object, e As System.Web.UI.WebControls.GridViewEditEventArgs) Handles gvOLIAdjst.RowEditing
gvOLIAdjst.EditIndex = e.NewEditIndex
BindData()
End Sub
Here is the update event that I have so far... any ideas? Am I just not doing this right?
Private Sub gvOLIAdj_RowUpdating(sender As Object, e As System.Web.UI.WebControls.GridViewUpdateEventArgs) Handles gvOLIAdjst.RowUpdating
Dim dts As DataTable = DirectCast(Session("BudgetsTable"), DataTable)
Dim row As GridViewRow = gvOLIAdjst.Rows(e.RowIndex)
[Code]...
how do i get info from 2 different columns in an Access database and put them together in a drop down menu. (i know how to get data so that i can see it in just a textbox but i dont know how to put 2 data together and then display in a drop down.
another question is how do i save info that has been changed back into the access database i got it from
last question- how do i make a textbox only take numbers
I am working on a project for my final in vb.net and I have a weird error when I try to insert info into my database. When I run the application it errors out on command.ExecuteNonQuery()and the error is Syntax error in INSERT INTO statement. I have the fields in my database are set as text at 255 chars. I have both inmports statments at the top, and as far as I can tell my statement is right.
Here is my code.
Dim con As New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source =../../Base/LogTextCopy.accdb;Persist Security Info=False;")
Dim StrSQL As String = "INSERT INTO TIMEANDDATE(DATE, TIME) values(@date, @time)"
Dim command As New OleDbCommand()
command.CommandText = StrSQL
[Code] .....