how to get this login to work if i add a field in to my database called UserTypes "Admin" "Normal" if they are admin if will display cmdAdmin and if they are Normal if will hide cmdAdmin this is the code i have currently?.[code]
View 12 RepliesFor a school program, I was assigned to use a .dat file to store and edit information while using VB to be it's front end( to appear in a listbox). I was also given what field length to use per field. I never worked with .dat files, so I have a few questions (all the google-ing Ive done say the same thing: every .dat file is different so you can't play around with them):
[Code]...
I have an application which connects to a database, retrieves a username from a user's table and matches it against the username retrieved with System.Security.Principal.WindowsIdentity.GetCurrent.Name.On my localhost, everything works fine. The database exists on the development server but the application lies on my localhost. All of my authorization and authentication techniques are running smoothly.However, when I publish my application to the development server, I'm faced with the following error.Cannot open database requested in login 'databaseName'. Login fails.Login failed for user 'DevelopmentServerNameASPNET'.
[Code]...
I created a local Database in VB2008 with 4 tables, the problem is that I have a textbox in one table and a combobox in other table and I want that the information that I put in textbox appear after in combobox from the other table... that's possible?
Table: Filmes ... Field: NomeTextBox
Table: Tempo de Aluguer ... Field: Nome_FilmeComboBox
I got the above error when i deploy my web application into windows server 2003. How do i resolve it? [code]
View 3 RepliesThe table has an AppID column which just increments 1 every time a new appointment is added. That works fine. It also has an ID column that gets a unique doctor ID assigned to it so the program knows which doctor has which patient.Now, when I try to add a new row, no matter what I try, the ID field gets a -1. I've tried assigning it the doctor's ID that I'm currently browsing as well as hard coding it to be a "3" and it still shows as -1. So this means that while it does save and update the new row, it adds that -1 in the ID column and thus the program can't tell which doctor has it so it won't show in my program.[code]I'm only trying to get the ID column populated, the rest should be fine as they're all from textboxes.
View 8 RepliesHow can I display column contents of a MS SQL Database on Text Box using VB 2008
View 2 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]....
There are lots of questions about this but I've not been able to solve my problem using the answers to any of them (after many, many attempts..)
I'm working in vb.net creating an asp.net web application. I have an SqlDataSource and a GridView on my page.
I want to change the DoNotMail boolean value represented by a Gridview checkbox and automatically update in the database if the checkbox is checked from 0 (False, Will Mail) to 1 (True, Won't Mail) here is the code I used. [code]...
is it possible to do a two way sync on the entire gridview when the user hits a button so you don't have to do an update every time a row is changed? because the user might check the box and then check another box then uncheck a box and it would be a lot of updates...
I 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 want to add a blank value to a field in access database with vb 2008 command.
Problem 1: Here is my code, it shows conversion to string not possible errors
Private Sub btnRedThrow_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnRedThrow.Click
Dim dbCnct As New DBUtills
[Code]....
notice the fifth and last value is empty. But it is not being added into the database, how do I do that?
Problem 2: Why does an additional field from my access database disappear even after I manually created the field?? (access database 2003 version, extension is .mdb) I'm using visual studio 2008
I have a combobox that displays saved names from the fullname column of my database. This works fine, all the items under the fullname column are added to the combobox. However, I also have several textboxes on the same form that also need to display data from the database, from the same record. So I was wondering if this was possible:
[Code]...
I am new with VB. I got now the Visual Studio 2008. I newer used it before.I need the following:I need a login form, which is using an MS Access 2003 database, in which I stored usernames and passwords.
The DB name is users.mdb and is stored on the C drive. It contains just 1 table, the name of the table is UserList. In the table I have 3 colums, first is ID, second is Username, the third is Password. It contains
just 4 datas, in the username the first entry is John, the second is Mary, in the password column the passwords are john and mary.
[Code]...
i recently added a login that uses mysql database now it use to pull data from text file but as i said i made it use mysql now..it works great locally but when i sent it to a friend to test the login he got this error. unhandled exception has occurred in the your application. if you click continue, the application will ignore this error and attempt to conttinue. if the click quit, the application will close immediately could not load file and assembly 'MySql.Data. version=5.1.7.0 Culture=neutral, public key token=c5687fc88969c44d' or one of its dependencies. this system cannot find the file specified.not sure what to do i was thinking about having him install the MySQL Connector net but i thought i would come here first and ask..and can someone also help me on how can i retreive data from the login part? i can get it to keep the username but for some reason i can pull the rest of the data here is the login script.[code]
View 11 RepliesIm trying to make a program and i have everything done but i need to make a login bar that if the user logs in, it takes them to form10 but if they log in and they are in a special user group on the forum (VIP) they go to form11.
View 39 RepliesDim query as String = "Select * from openquery (devbook, 'SELECT wb.arrival_time FROM web_bookings wb ')"All I need is to convert my arrival_time into a datetime field in the query
View 1 Repliesi am developing a vb.net 2008 application. I use oledb to connect to oracle is there any way to insert a clob field in oracle from vb.net 2008 ?
View 1 RepliesHow can i declare a simple variable in a form that is the count of the amount of times a field appears in a database.Basically i want to count the amount of times the word "Saloon" appears in a column in my database (access 2007) and then assign that value to a variable.
View 22 RepliesI am trying to update a SQL Server database Date field.When the user enters the date they enter 02 Oct 2010.When I pick up the DateTimePicker.Value it is 10/02/2010 00:00:00. I need to get the value to read 02/10/2010 00:00:00 How do I get the value to be in this format?
View 7 RepliesI have data entries in my database that have a common field. For example:
account_id type user_id
1 new 1
2 old 3
3 new 1
4 old 1
I am using a query like this(mysql): SELECT account_id, type, user_id FROM table WHERE user_id = 1
This is just all theoretical. The problem that I am having with this is it is only returning the first result in this case account_id 1. How can I get it to find all the results with the user_id 1 because in the way I am thinking that it is failing is that it is finding only the first result and then ending?
I've created a log in system using a database and query builder to return the correct values, however, once the users signed in I need to bring up the rest of their data from the same table in the database. How'd be the best way of going about this? I'm not sure whether the log in should be changed to use the primary key as well.
View 2 Replieslogin function but with 3 required field, let say username, password1, and password2
View 4 RepliesI have a database and I wanna select a field ..I usually do this with access:
dim chosen as string
chosen = textbox1.text
Dim querysql = "select * from table where field = " & chosen & ""
But with SQL it doesnt work =S I really need to make this work .
I'm trying to query LDAP using a field that contain's 's in VBScript, but I can't get it to work. Here is my code (basically). What am I doing wrong?objCommand.CommandText = _
"SELECT cn FROM 'LDAP://" & x & "' WHERE extensionAttribute1 = '1500 0FFEA14C439' "This string will never match any record even if use wild cards or copy in the exact data from the AD record.
I am investigating an issue with regards to a textbox rejecting user input. In this case the error message is: 'The note was found to contain a possible credit card PAN.'Now obviously this is a custom validator but I am enable to find where it tells me what characters ARE allowed? In debug I entered a note containing no numbers and when the validators are initialized, these variables have the value below:
valNoteContainsPAN.Expression = Me.PANRegEx value = (d*)45367{13,15}(?!d)
I'm assuming this is blocking numbers of certain lengths? How can I find out how to actually read and understand the above? Google is proving fruitless
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.
Iam developing a Windows application using Visual Basic 2008 with a SQL Server database. Throughout the program I give the user as many options as possible and have no problem with either the database or the windows forms. The program does not initially require a Login and I want toprovide the User with the opportunity to add a Login to the system. The default Login form is perfectly satisfactory.
The problem is that I can't figure out how to program the change sothat the Login from isopens the program rather then th form designated as the StartUp form. this forum I am able to prgrammatically change the form but I can't figure out how to make the requirement a permanent factor. I tried using a Constant, but if the User wants to change, you can't change the constant. Its an apparantly simple yes/no situation but if I set a varable to yes and then change it to no the next time the program runs, the change will be lost.
I am creating a database in VB.NET for a movie rental place. I currently have three forms;
Member Information
DVD Information
Borrow DVDs
What I would like to do is when I am viewing a member's details, if I click a button 'Borrow DVD for Member', the member's ID number transfers over to the Borrow DVDs table in the Member ID which also would hold some information from the DVD Information table, but I'm sure if i can figure out how to do this firstly, I will be able to apply the same rule and work it out myself.I have been trying to use a query statement like;
INSERT INTO [Borrow DVDs].[Member ID] [IN goodstuffvideos.mdb]
SELECT [Member Information].[Member ID]
FROM [Member Information]
but that has been coming up with error codes and completely not working.
Borrow DVDs table fields are: Borrow ID, Member ID, DVD ID Number, Hiring Fee, Borrowing Limit?
DVD Information table fields are: DVD ID Number, Title, Rating, Hiring Fee, Borrowing Limit Member?
Information table fields are: Member ID, Family Name, Given Name, Address, Town/Suburb, Postcode?
The error coming up is; Error in INSERT statement. Unable to parse query text.And under that it says The query cannot be represented graphically in the Diagram and Criteria Pane.
this is my first time making an application so I would like to make a Login form in VB. I haven't gotten into any problems so far but my question to you are the following1) Is it possible for me to make an event/action that will allow it to work with the script that is php? IE: Application has a button that will scan all files in /public_html for viruses, when the button is clicked, it will send the event to cPanel and make it scan all files.2) Once the user has connected and all information has been verified make another window show and the new application will be the new window.Another question I have isRight now I'm using WHMCS(url..) for my billing system they have an intergtation code that I use for my web page and it goes like this
<form method="post" action="http://www.orionconn.com/clients/dologin.php?goto=clientarea"> Email Address: <input type="text" name="username" size="50"><br> Password: <input type="password" name="password" size="20"><br> <input type="submit" value="Login"> </form>