Restict The Input Of A User Based On What The System Needs?
Oct 6, 2011how to restict the input of a user if im going to accept account e.g.,
View 7 Replieshow to restict the input of a user if im going to accept account e.g.,
View 7 RepliesWhat i am trying to achieve is that there are 7 columns in my db table. one is primary key and rest 6 are integer columns. Now my application will allow user to input 6 values. I want to compare 6 values entered by user to those 6 integer columns and if in any row 3 or more columns match user's input Primary key of that table is returned..I have tried using queries, cursor, nested loops and i am still unable to achieve my results..
UPDATED :DB Table Structure.. I am inputting 2,3,7,11,45,65. Number of returned rows should be 5. eg..
UID A1 A2 A3 A4 A5 A6
-----------------------
1 2 3 4 5 6 7
2 2 3 4 55 56 57
3 65 11 45 66 67 68
[code]....
IDs returned should be 1,3,4,9,10
I have 10 constant arrays of data that can be used throughout the program.[code]I also have an array that needs to be populated randomly depending on user input.array_user(8)If the user selects 3 for instance...I need the data in array_user to be populated by the data in array03.I know I can do that with if/then statements...but I'm sure there is a much simpler way to do it.
View 1 RepliesI have a SQL db that holds the records for my page. On my page I have a details view I want to populate with records from my db. I can populate the records just fine, I need to be able to populate in records based on a user selection from a drop box?To clarify, on my main page I have a drop down list with years (ie. 2011, 2010, 2009), and a drop down containing account codes (ie. six-digit numbers). Based on what the user chooses for the year (for example 2010) and the what they choose for the account code (for example 123456) I want to populate the details view (which is on a seperate page) with only those records from 2010 and with the account code 123456??
View 1 RepliesI am working on a project using Visual Studio .NET 2003.I am trying to open a second form based on user response to Yes/No Message Box. I have tried two different code variations. The first variation is:
Dim MsgAnswer As Boolean
MsgAnswer = True
Dim MsgRes As DialogResult
Dim CustomerInfo1 As New Form
[code]....
With this code I get an exception error: An unhandled exception of type 'System.NullReferenceException' occurred in OrpheyOnOpen.exe Additional information: Object reference not set to an instance of an object.
I have a form with 12 text boxes that a user must fill. I need then by pressing a button to promt for the save directory and save the input as ".".txt file. Moreover i need each line of the txt to correspond to each one of the txtboxes. So the input to the first box will be the first line of the txt file,...the input of the ninth box the ninth line of the txt file.
View 15 RepliesI'm trying to do the following.I want to use a gridview to load a set of associated records dynamically based upon the input of the user.I want the gridview to have a checkbox to the left of the records and allow the user to use this to select records to remove. The gridview will have pages and will be sortable using the columns.I had this working using a delete button, but when I went to using the checkbox it stopped sorting.
[Code]...
Is there a way to make one list box dependent on the other based on user input. Here's my situation: A teacher has the ability to enter the name of the student into a listbox via a textbox. The teacher may then select the student from the first student list box and input grades that would go into a grade listbox. If the teacher selects another student from the student list box, the grade listbox would either go empty or show the grades inputed for the other student; all the while retaining all previously recorded grades for other students.
View 1 RepliesI'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.
I am attempting to set up a datagridview that is dynamic based on user input. The user input is a start and end date. The start date defines the first column the next column is the next date... until the end date (x-axis). The y-axis is technicians and the fields will show the assignment for the technician on that date.
All the advise I am seeing on datagridviews is to create a property methods to provide the information for each column. for example:
Dim 12-Oct-2009 as string
Dim 13-Oct-2009 as string
[Code]...
How do I create a object data source that allows me to populate the data grid? I want the column headers to be included as a string in row 0 of the multidimensional array. The amount of columns will be dynamic with a minimum of 1 and maximum viewing of 100 days based on what dates are selected in the start date and end date fields.The input dates will be used to generate a query to a database that will populate the multidimensional array.One solution I see is pick a start date and have a set number of dates and code for set number of columns (100) in a row and then set the names of the columns dynamically...ahhhh code repetition!
I am not sure how else to do this but looking for a more suttle way.I am using this to create a simple scheduling tool to see resource schedules by date. There is an unmoveable end date so initially I will need to look ahead 100 days but as the end date gets closer, I will have fewer and fewer dates. So eventually the end date will be that start date.
Private Sub TrackBar1_ValueChanged(ByVal sender As System.Object, _
ByVal e As System.EventArgs) _
Handles Trackbar.ValueChanged
txtYears.Text = Trackbar.Value
End Sub
This is the code for the trackbar. At the moment as the user moves the trackbar it inserts the value into the textbox. I want this to work in reverse also. user inputs value into text box, trackbar moves.
I know it is possible as my professors program does this.
I was looking for quick assistance with disabling the write button based on wrong user input. Program works great just feel like it needs a little more.
[Code]...
I don't like validating through the TextChanged event either as I believe that to be the cause of some issues. Doesn't the Textchanged event validate on each time a letter is typed?
How to make a combobox only list based on user's input via autocomplete?For example, if user input "A" the combobox only lists all names start letter "A".If user input "AM" the combobox only lists all names start first two letter as "AM" and so on.
View 6 RepliesIn this application I need to allow users to enter a month as integer (1-12) then use integer tryparse to validate that input, that seems to be the easy part. I need two create two functions, one that returns the name of the month and the other returns the number of days in that month. The arrays are supposed to be defined and initialized within the function so that the main program can take the user input and call the two functions, then return the appropriate values as output to labels. I am not sure how to declare the arrays in their appropriate functions and then how to call those functions to retrieve the right value from the function.
View 1 Repliesim currently designing a system that enables the user to input a customer record. the customer record is broken down into 11 fields: customer id, title, forename, surname, house no, town, city, county, postal code, contact number, date of registration. Problems - i need to be able to insert the new record into a file and for them to be organized into surname order (for a binary search to work) at this moment it will only sort by first field (which is unnecessary as the customer id number is generated automatically and is all ready created in order). Also, im having trouble with sorting the array that contains all the variables from the text file.
[Code]...
I have a procedure at the end of my console application that ask the user to either hit enter to end the program, or type s to perform another search. The issue I'm having is no matter what the user types in the program end. What I would like to happen is if the user types s, then the program starts over and lets the user perform another search. The program is procedural and I need to find a way to start back off at the top of the program which ask the user to type a name to search.
[Code]....
iam currently working on my uni project and i have encountered a problem with valadation section.My system displays a message telling the user to input any fields that they have missed out on, listing the name of the field. However as these IF functions are in order the user must input the data in the order of how it is in the code. for example if the "consweight" is inputed and the calculate button is pressed, it thinks that all valadation above it has occured, when those fields are still empty.
[code]...
I need some help with the input validation of my application. Attached is the code that I have written as well as a screenshot of the front end. I specifically need input validation to verify that the user selected input for cbLengthOfStay is a number between 1-10 as well as input validation to verify the user input for txtMedication, txtSurgicalCharges, txtLabFees and txtRehabilitation is a positive numerical number. Please feel free to critique my attached code. [Code]
View 2 RepliesIf my Category and Forum selection is incorrect I am sorry and feel free to move it. I'd like to have the users input in the message box that will show. For example: There is a textbox and the user puts in their name as Bob. Then the message box would be: What my main goal is, is being able to include the users input they type inside the textbox inside the message box.
View 6 RepliesI have had several occasions recently to access a specific class several times over a relatively small time frame.So I've been storing the value of the class in Session and trying to access it on page load, if it's not available creating a new instance and storing that in session.
So instead of constantly replicating the same code for different classes on different pages I'm trying to create an extension method to do this for me.
[Code]...
I'm stuck on what to do when I make my new instance of my class (it would have to have a New() sub)
I'm not sure where to go from here... or even if this is the best way to do it.
Option Strict On Public Class Form1 Private Sub btnDistance_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnDistance.Click 'The btnEnterSpeed click event accepts and displays up to ten speeds from the user'and then calculates and displays average speed
[Code]...
I cannot figure out how to incorporate the number of days into the input box then get it to loop and count the number of times the User inputs in the number of days. Then I have to incorporate it into the equation to get the total distance D = MPH * Hours. What I have right now wil not count up the number of days and locks up after I input one number and will not add anything to the listbox. Because I also have to make sure that they cant add nonnumaric values and the number of hours per day cannot exceed 20. I have put things in and taken them out but it has been 2 days and I am lost now
I'm trying to save what the user types in the vb code Dim user as Inputbox("") for example in a .txt file i can save the textbox and listbox but i cnt figure out how to save the inputbox i really need this to be saved the most.
View 7 RepliesI am creating a form for work where managers can report when they find a customer's personal information laying around on a desk (we work at a call center where agents answer calls for a wireless cell phone provider, so we take personal information security very seriously). Anyway, I am wondering if there is a way to have a text box autofill with that manager's windows username (since they will need to be logged into their own profile to use the form).
View 2 RepliesI need something tje user can type in data to such a parts QTY cost etc. There are no predefined parts list so the user can enter any part name/Number and there is no limit to amount of parts that can be entered.
Does anyone have any idea what might be useful. It was thinks of a listview bu i can't see that you can type into that. I cant use comboboxs because there are no predefined list and i know there is some way to generate text at runtime (i think) but i don't know how to do it and i would prefer a clearer approach.
I currently have a subroutine that generates a file with specific parameters, and it relies on user input in 2 fields. Now I also have a numericupdown control. What I'm looking for is a way that if Numericupdown.Value = 3 then it will generate 6 textboxes and once the parameters are filled out completely it will generate subroutine times(numericupdown.value) and output it to a single file.
View 3 RepliesI have a form with a few text boxes, one of which has it's contents stored to a integer variable.
The value stored will end up being one of a few numbers ranging from 12 to 98, and I need to the same number of new variables as the number in the textbox.
Can I automate the creation of new variables based on the value stored, or do I need to define the max number required and just ignore the rest when using less?
Say I've got the following variables:
Public Shared x As String = "100"
Public Shared y As String = "text"
Public Shared z As String = "something"
[Code]....
But this doesn't do what I want, naturally. What I want is that my function giveVar returns the value of the variable that holds giveVar. For example I call giveVar("x") I want my function to return "100".
Of course this can be done by a Select Case but thats not what I like to do. Is it even possible to call a value based on a string?
[edit:]
Namespace i18n
public NotInheritable Class Settings
Public Shared LanguageCode As String
[Code]....
I think this works so far, BUT I get the following error on the CallByName(Me, varName, vbGet) at the Me : "me is only valid within an instance method"
I want to listen to events in my windows forms .NET application for the following system wide events :
[Code]...
I'm writing an application which has user authentication system, basically, when the user open the software, he has to enter his/hers username and password which are retrieved form a access data base, and if the user is set as admin then it enable some features, I couldn't figure out how to read the column lets say, IsAdmin table, which will store an value of 1 or 0 for example. I need a concept of how build a login system with levels or whatever you guys call it...
View 2 Repliesi want to set the system date of my a client pc based on the system date where the sql server reside.In short i want to sysncronize the date between the client and server.I have a working code in vb6 but i dont know how to do it in vb 2008.
dim RstDate As ADODB.Recordset
Set RstDate = New ADODB.Recordset
RstDate.Open "SELECT GETDATE() as ServerDate ", CnAP
[code]....