User Credential Lookup In VB To Access Database
Mar 11, 2011
I have a program which I am securing with a Username and Password box, in which the user enters their credentials. In the database, the username is a number field (VB would not accept this as a string and was looking for it as Int32). And the password is a text field. I have the form linked to the database by an OleDbConnection with a DataAdapter (DaUser) and DataSet (DsUser). I am using a datarow which I have declared at the top of my code i.e. Public drUser As DataRow. The problem arises when the user enters their username and password.
The following code searches the primary key row of the database (Username)
drUser = DsUser.Tables("User").Rows.Find(txtUsername.Text)
When the Username entered does not exist, I'm getting this error when trying to display on the form the users email:
NullReferenceException was unhandled - Object reference not set to an instance of an object.
I've tried both if statements and try/catch to basically say if the Username doesn't exist... display an error message etc.
View 2 Replies
ADVERTISEMENT
Apr 27, 2010
I have a table called MEMBER with fields for mem_id, mem_name, mem_addr, mem_city,mem_state, mem_zip and another table called STATE with state_id, state_addr, state_name in Access 2007.On the Visual Studio 2008 form, there is a combo box for the state. The goal here is to display the state abbreviations, but use the state_id value for the mem_state (there is a foreign key between those two fields).The mem_state is defined as number, the state_id is autonumber. Under the mem_state definition in Access, I used the lookup wizard (on the database that is in the bin/debug folder) to set the following properties:
Display Control - combo box,
Row Source Type - Table/Query,
Row Source - SELECT [State].[state_id], [State].[state_abbr] FROM State ORDER BY
[code].....
View 1 Replies
May 29, 2009
I have created an access database which i want to search with vb.net, I tried a few thing but it didnt work as desired.
Firstly the program is suppose to display items in the database base on the criteria selected by the user. what i've succefssfully done so far is I've added a datagrid 2 combobox, 1 (searchcbo) with the columns in the database and the other (searchcbo1) will autoload the items under the column selected in and a button (searchbtn) but i have no clue of the code to put in the button. i also tried the fill method but that didnt work as i wanted to. ultimately i want a combobox with the list of columns and a textbox to enter criteria and of course a search button.
The searchbtn should act as the "WHERE" sql command, e.g. SELECT EmployeeNumber, Firstname, LastName, Phone, Location....etc FROM CallLog WHERE searchcbo.text = searchcbo1.text And display the results in the datagrid.
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'TODO: This line of code loads data into the 'CallLogDataSet.CallLog' table. You can move, or remove it, as needed.
Me.CallLogTableAdapter.Fill(Me.CallLogDataSet.CallLog)
[CODE]....................
Attached image(s)
View 3 Replies
Aug 22, 2009
I have a form with labels that have databindings on them from an access database .. im using vb 2008 .. and i have a search query and a next button on the form displays when the currency manager count is greater than 1, to be able to display the next set of data.. now the problem i am having is that when i click the next button, its not changing any of the data in the labels on the form .. i have no clue why it isnt working, im for sure the code i am using is correct, i've tried for hours and cannot figure out where the problem is..
here is the code that i am using
Dim currManager As CurrencyManager
Private Sub frmLookupChild_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[Code]....
View 3 Replies
Mar 1, 2011
I started a forms solution in VB 2008, created a datasource to an access database (2010) and used the datagrid view to display the data. 3 fields in the access database are lookup fields with 2-8 values each, typed in by me, since the linking to other fields did not work. This is not working either. When I change the column to combo-box or not, those values, typed into access, are NOT showing up in the datagrid. the combo box has its drop down arrow but the value fields are empty.
View 10 Replies
Jan 9, 2012
I have a lookup table that contains a label that describes the data to be written back to my database. For example:Label = Manufacturing Repair Issue (This is what the user see's in my front-end windows app)Data = Mfg_Repair (What I want to save to the database when the user choses the label)
View 13 Replies
Mar 6, 2009
I am new in programming and I am using VB2005 and I can user either SQL2005 or MS access database.Here my scenario:I have created a project where the user can add a new record, (Support Desk) there are times when a new record is added, it may need a backup (Pictures, Document)to be included in regards the problem.
I need to know if anyone has some sample code on how to attached any type pf file (jpeg, BMP, doc, txt, PDF, excel) and be able to save it to the database.
View 4 Replies
May 21, 2010
how can i look up for a specific computer given ip or computer name ...retrieve the user logged on..
View 2 Replies
Dec 21, 2011
add user to access database but it's doesn't work the problem here
SavInto.ExecuteNonQuery()
View 16 Replies
Apr 4, 2011
i want to allow user to select or find access database file when the software is executed/opened for the first time. after user selects the file and as he clicks open the software shows the full path of the file and then stores it with the provider and datasource in a txt file for future use.
View 3 Replies
Jul 10, 2009
My aim is to try to add a new user to a access database. Im doing this using from a form named frmRegister. It seems like the code is working perfectly, and I get no expectations that indicate if any errors occurred. However, the user doesn't get added to the database.
The code I'm using is:
Public Class Register
Dim connectionString As String
Dim connection As OleDbConnection
Dim OLEDBAdapter As New OleDbDataAdapter
Dim OLE As String
[Code] .....
(Files too large for attaching here)
Rar format - [URL]
Zip format - [URL]
View 6 Replies
Sep 29, 2009
I have decided to quit using Access and trying my hand a VB.I am wanting to create a database with Forms for entering Address's.
View 1 Replies
Mar 20, 2011
I need help with the code to make it so when a form loads it will check the Access database for the user and if that user is present, then it will load their selections. Otherwise, if no user is present it will add a new row to the database and display nothing.
View 2 Replies
May 29, 2010
cn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:Documents and SettingsKashifDesktopDesktop itemsvalid.mdb;")
View 2 Replies
Apr 27, 2012
I have been using access for my applications from over 4 years now. I realize its time to move on now and i need suggestions for a new database. Here are my requirements :should be able to connect it with Vb.net windows form frontend GUI - all database functions such as add/delete/edit/update will be done through the vb.net front-end only.Should be able to place the db on LAN and each client on the LAN can then access the centrally stored db through their individual front-ends.At the most 5-6 users will be reading/writing to the database at the same time , so the database should not crash or slow down Since i come from MS access background, i would like something thats similar to it so that i can learn and adapt to it quickly.Not very important, but i think its worth mentioning. This db will be the main central db for my .net application.My .net application will also be interacting with quickbooks and magento via some apis but ultimately all this data will go to the central db. So just curious, will there be any compataibility issues with the database that you suggest Should handle about 10 tables and around 10k records in each table Should be secure - just that i should be able to lock it up or anyhow prevent it being accessed from anywhere else other than the vb.net front-end.
Lastly, I would prefer it to be free to use if possible but not essential. I realize there are some topics like mysql vs sqllite and on databases, but pls understand i need suggestions for one that will be apt for the purposes i have listed above.
Edit : Just curious - Would i pushing the limits if i still stick to access - i understand access won't be good for multi-user access but i guess 5 users is not much ?
View 3 Replies
Sep 3, 2008
I'm writing a form that get some informations from a database to manage the User Access Level.The way i do that is to Fill a Dataset by using a DataAdapter and the Bind some controls to the Dataset.The controls i binding are a ListBox, a Textbox, and five Checkboxes.All are fine with this controls. I can delete values and update values, i can choose a record from my ListBox and the values of this record to be desplayed on the othrer binded controls and so on.
[Code]...
View 1 Replies
May 8, 2009
Not sure if this is the right Forum to post this question. If not guide me where to post... I have an Access database that I would like to be able to share with Multiple user cuncurently... I have seen it is being done but I am not sure how? Or may be I should be using SQL Express.
View 1 Replies
Dec 3, 2009
I've been working on an application for awhile that, basically, allows the viewing and printing of a maintenance database. It allows the user to view basic information for the object and then view the maintenance history. My approach for the maintenance history is simply to have unique tables per object since a history has to be kept for each, however, I'm running into a problem in the application that allows the user to view the general information from one DB and the Maintenance history from the other DB.
Say you have Object ID BG1. I can enter the object ID into a search field, pull the data from the general DB and display the data, but I also need it to pull the information from the maintenance history and display. If maintenance history for this object is not found, then create a new table within the DB, fill the columns with the required fields and allow for the user to edit the history.
View 6 Replies
Apr 17, 2011
I have a form with 5 fields(inputs). When I entered data in the form and click submit, the data is entered into an Access 2007 Database(Table). All the set up (connection) is working because the data table is getting populated with the user info. However, I also need to search the database by entering a name in the name text box and clicking a button.
This is suppose to populated all the fields with information from the data base if the user exist. The search part is not working. I have no more hair to pull. :) Here is the code:
[Code]...
View 1 Replies
Oct 28, 2009
I want to take my access database which i used in my project on visual studio2008 backup by selecting the local drive of my computer at the time of backup i choose the drive & there were i taken the backup i restore my database. Is is possible to take backup atomatically when i close my application.
View 1 Replies
Sep 26, 2011
Is it possible to create a credential for RDP using VB 2010?For example, to do this using win7 GUI:
I go to credential manager and choose add a credential. I then enter TERMSRV/myserver and enter user name and password.
View 3 Replies
Jul 9, 2009
I've been trying to develop a VB application which retrieves a lot of information from an XML file on our secure intranet. So far I've been using...
Dim request As WebRequest = WebRequest.Create(xmlUrl)
request.Credentials = New NetworkCredential(username, password)
Dim response As WebResponse = request.GetResponse()
Dim str As Stream = response.GetResponseStream()
Where username and password are predefined. What I need is a way of utilising the Windows credential manager to handle this. Ideally, I like it to pop up a credential prompt at application start, and then store the credentials for later use. So far so easy, but I want to be able to use the tick box to save the credentials back to the store, so taht next time the application is used, they are already filled in.
So far I've been investigating the CredentialsDemo from MSDN, but have been unable to adapt the routines to a web request from the given example of a SQL request. In fact I've not even been able to get the demo working adapting it to my own SQL server!It utilises the CredUIPromptForCredentials function. Is this the right way to go? Or am I barking up the wrong tree?
View 8 Replies
Jul 13, 2009
I registered a domain and created a (Windows) web site via [URL].I created a simple Hello World web service using VWD 2008 Express. I have no idea why it put the web service into the stats folder, but that is a different issue.If I type [URL] into the address bar of my IE 6, I am prompted for user name and password, which I enter. I get a page listing my web services (Only one: HelloWorld) and other information. If I click the HelloWorld link, I get the appropriate response.Bottom line: the web service uses SOAP and it works.
However, if I create a Windows application (vb) in Visual Studio 2005 to use the web service and try to connect to that same address (Add Web Reference), I get asked:"The server needs to authenticate your request. Your credentials will be sent to the server in clear text. Do you want to continue?" I click yes, and I see a Discovery Credential dialog box. It asks for 4 things.
1)Url: (The same address as above already filled in)
2)User name: (I enter my user name)
3)Password: (I enter the password)
4)Domain: (I enter mydomain)
Of course "mydomain" is a standin for the real domain name I typed in.I click Ok. The information apparently is rejected and the dialog appears again.What can I do to make this work. The web site has IIS 6 with front page extensions. This is shared hosting and I do not have access to change anything about the IIS settings.
View 7 Replies
Jan 27, 2011
Is it possible to create a credential for RDP using VB 2010?For example, to do this using win7 GUI:I go to credential manager and choose add a credential. I then enter TERMSRV/myserver and enter user name and password.
View 2 Replies
May 4, 2009
Turns out this impersonation with .NET's security only allows application-level access. Since the COM object is at the system level, the impersonated user still cannot instantiate it. I figured this out by right-clicking the executable and selecting "Run As...", the program functioned fine. I found out that launches the program with system access (assuming the user you are running it with has those credentials).Now I am in the process of creating an external program that will launch this application using this method.
[Code]...
View 4 Replies
Jun 29, 2010
I'm struggling to find a way of prompting the user for network credentials within a VB.net application. I appreciate I could use the login form, but I'd really like to be able to use the standard Windows UI prompt.I want to use the same credential prompt as you get when you try to access a server using UNC e.g.\servernamec.This is easily possible in Powershell using the get-credential cmdlet. The closest I can find is using the Powershell assembly PSHostUserInterface.PromptForCredential method, but I cant get this to work in VB.netIs there any way to invoke the standard network credential prompt at all?
View 2 Replies
Feb 15, 2011
I am building a simple intranet site and want to get the employees user name, but when i use Request.LogonUserIdentity.Name , i keep getting the servers credentials and not the users. what am i doing wrong and is there a better way to do this.
View 1 Replies
Jun 4, 2011
I can save my data to access database and in the access database field I set it to date/time.But problem is when I get the value out from the database.. the format is always month/day/year hour:minutes:seconds example today: 5/2/2011 12:00:00..How to get the value into listview becoming May/2/2011 without the hour..Here's my code to get it from database ListView1.Items(i).SubItems.Add(dt.Rows(i)(14).ToString).The second problem is.When I would like to edit, how can the datetimepicker get the listview value ? [code] info: using access 2003 (.mdb) the Date of Birth field has been set into Date/Time.
View 2 Replies
Sep 17, 2011
I programmed an app with an Access 2010 database, I installed the app and the database on a computer with office 2007. The app can't open the database. Do I need to copy some extra file on the user's PC?
View 15 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