DB / Reporting - Using A Datareader To Retrieve The User Login Info
Jun 4, 2008
I 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 Replies
ADVERTISEMENT
Nov 9, 2011
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]...
View 9 Replies
Feb 15, 2012
what i want is when the user inputs the username and password, his/her information will be showed in the textbox located at the mainform which shows the users information like where he live and his occupation. how to show users data in the textbox of another form when he/she logged in. im using vb.net and mssql
View 1 Replies
Apr 4, 2010
I 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 ?
View 4 Replies
Oct 20, 2009
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 Replies
Apr 10, 2011
I am trying to learn VB.NET and I've written a user entry screen to store and retrieve information. I keep getting this error. I understand that I have to either change the ref value from the calling code, but my problem is where is the calling code? Here is the error I'm getting (the program is underscoring udtTrans in the FileGet line in this segment).
Private Sub viewRecords()
'open the file and read fields of the first record into the textboxes
Try
FileOpen(1, strFilename, OpenMode.Random, OpenAccess.ReadWrite, OpenShare.Shared, Len(udtTrans))
FileGet(1, udtTrans, intCurrentRecord) 'gets first record
[Code] .....
View 2 Replies
Jul 17, 2008
i am trying to log a user in using a login form. i have my connection to my database and there and it connects just fine but it will only read the first row. here is my code.
Code:
Dim ConnString As String = "Driver={MySQL ODBC 3.51 Driver};Server=dansoft.selfip.com;Option=131072;Stmt=;Database=elemental_battle; User=****;Password=*****;"
Dim objConn As New OdbcConnection(ConnString)
[code]....
there are two entries in the database. the first username and password are bagstoper and 1a2b3c4 the second is bagstoper2 and 1a2b3c4d. when i test it with the first username and password it works but when i try the second it doesnt work.
View 2 Replies
May 16, 2011
I'm creating an app like a CRM ( Costumer Relationship Managment ) for a school but I have some questions I'd like to be answered.
It will have a main user ( Administrator ) and that user can create another users to access the app. The app will work locally and I would like to know a method to save that information @ localhost without being acessible to edit or view by other users.
Im thinking in a Access DB with all info and then make all information needed. But how to secure it without anyone else could access it or modify id? An encryption method would be the best way?
View 1 Replies
May 15, 2008
I need to create an application that allows staff members to login and see different things.I need to be able to have different user levels for this so that certain staff can see some things and other staff can't.I would like the login system powered by the MS SQL Database that the rest of the programs data is stored in.
View 4 Replies
Apr 7, 2011
I have a data reader pulling in some data from an access database and im trying to get it to add some values to an existing textbox when an item is select, and when another item is selected changing the value.
here is my code
Private Sub FlipsMainItemComboBox_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles FlipsMainItemComboBox.SelectedIndexChanged, FlipsMainItemComboBox.SelectedIndexChanged
burgerinfoconnection = New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0; Data Source=" & Application.StartupPath & "ProjectDatabase.accdb")
[code]....
View 3 Replies
Jul 7, 2008
im converting my classic vb class into vb.net class and im having some problems with my object.Query function
here is my obj.Query Function
Code:
Public Function Query(ByVal sqlStatement As String, Optional ByRef e As String = "") As SqlDataReader
Try
[Code].....
View 5 Replies
Jun 10, 2011
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 Replies
Mar 1, 2011
I got the above error when i deploy my web application into windows server 2003. How do i resolve it? [code]
View 3 Replies
May 8, 2012
I'm using Visual Basic Express 2010 and SQL Express 2008 in Windows XP. At first I couldn't add a datasource (the .mdf file for the database) because of a "Operating system error 32" which I seemed to have resolved by giving myself full permissions for .mdf file (by right clicking on the file and going into properties and then Security) and restarting the SQL SERVER (SQLEXPRESS) service. The dataset for the database is in my solution explorer but when I right click on a table adapter to add a query and attempt to open up the query builder, I get the error in the title above.
View 1 Replies
May 8, 2012
I'm using Visual Basic Express 2010 and SQL Express 2008 in Windows XP.I created a database on my local PC HDD. At first I couldn't add a datasource (the .mdf file for the database) because of a "Operating system error 32" which I seemed to have resolved by giving myself full permissions for .mdf file (by right clicking on the file and going into properties and then Security) and restarting the SQL SERVER (SQLEXPRESS) service.The dataset for the database is in my solution explorer but when I right click on a table adapter to add a query and attempt to open up the query builder, I get the error in the title above.
View 10 Replies
Apr 9, 2011
I have a login control in my asp.net webform i uses the roles manager...i have two roles admin and vendors i want when user enter username and password in login control then on login button click event it validates either the user is admin or vendors if vendor is admin then it will redirect to default.aspx other wise stay on login page with error. ...how to do this using vb.net ?
View 1 Replies
May 29, 2009
how can i login when user type password and they press enter that login code can be activiate. What event can be using for this, i m using button_click event. need textbox typed value and press enter it should be login to that next form.
View 1 Replies
Aug 25, 2010
Alright, So with this game I am Making with VB I am Confused on how to make the login system to make the registered user to login to his character automatically other then having to make a new character? Here is my login System code not much[code].....
View 3 Replies
Oct 16, 2009
I'am trying to make a login system with the dll. I want the .dll file to have the password inside of it and make another interface window that the user can login in.
View 10 Replies
Jun 7, 2012
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]...
View 2 Replies
Oct 3, 2008
so 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.
View 5 Replies
Jun 10, 2011
How can I retrieve info from a HTML table like this :
[Code]...
View 4 Replies
Dec 9, 2011
I am attempting to write/read data to/from a device that is connected to my laptop via a USB-to-serial connection.The device getsa picked up in my device manager on com port 8.What do I need to be able retreive and send info. across to the device?
View 18 Replies
Jan 22, 2011
I am trying to retrieve the data from EXCEL 2003 spreadsheet from row 8 onwards because from Row 1 to Row 7 the row is merged columns from A1 to K1, A2 to K2, A3 to K3, A4 to K4, A5 to K5, A6 to K6, A7 to K7.
View 28 Replies
Apr 16, 2011
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 Replies
May 13, 2009
I 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?
View 7 Replies
May 10, 2012
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.
View 23 Replies
Aug 12, 2009
I am working on making a program that will log into my internet banking site (this will most likely have to be done in IE) grab my current available balance and store this to a string, before I do any research I was wondering if anybody had anything like this already completed.I also need it to do this silently (as in no open IE windows) no visibility of program running to the user.
View 7 Replies
May 11, 2009
I am using the following SQL statement to retrieve information from an access 2003 database but this command keeps stripping out the proceeding 0 from the number of the month. The variable is called TBookingsDateFulldate
Dim sqlQuery As String = String.Format("SELECT [ID], [Date], [Zone], [Year], [Subject], [Teacher], [LessionID]" & _
" FROM tblBookings" & _
" WHERE (((tblBookings.[Date])={0})" & _
" AND ((tblBookings.[Zone])='{1}')" & _
" AND ((tblBookings.[Active])=0)" & _
" AND ((tblBookings.[LessionID])='{2}'));", TBookingsDateFull, TBookingZone, TBookingsTimes(B, 0))
View 1 Replies
Aug 11, 2010
Basically I'm adding a registration feature into my program, or a similar thing to that. So, when you purchase you can install up to 3 copies (for example), but not more.To do this, I need to know some kind of information that is unique to each computer (to store in my database online), I thought of the name of the computer, but that isn't unique, obviously.
View 9 Replies
