Very Simple Database Interaction - Using Textbox To Pull User ID From The Table
Jun 25, 2010
I have one table here with a list of UserIDs, Users, and ClientCodes. Each user can be assigned a client code to view that client's data elsewhere. Right now I have to change it for everyone via SQL Server and actually going into the table manually, but I'm trying to make a simple little program that will let the user change it themselves. All I need is a textbox that pulls the user based on a certain UserID from the table, and a drop down list that will not only show the current ClientCode they're set to, but allow me to change it and save that change to the table in the database.
What's the best way to go about this? I tried using the wizards but I guess that's not the best way to go about it. I have it displaying the correct user and their current ClientCode but that's about it.
I'm currently pulling HTML data from a database and displaying it in a WebBrowser control in my VB.Net application so that it's correctly rendered. The next step is to print it, but I need to be able to send it to a specific printer rather than the default printer. How can I accomplish this?
I'm currently pulling HTML data from a database and displaying it in a WebBrowser control in my VB.Net application so that it's correctly rendered. The next step is to print it, but I need to be able to send it to a specific printer rather than the default printer.
I open a form from the datagridview on a selected record in the database. When saving I have my code saving to (0) I need to somehow pull the text form the account textbox in order to save to that row in the database. here is a copy of my save button...
Private Sub btnSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSave.Click 'save updates to database
could anyone please help me with this1.Create a simple Times Table program which will allow the user to enter an integer value n (between 1 and 20) into a textbox. On the click of a button output to a label the n times tables. Use a For Next loop to perform the repetition.i can output them to a list box but only last one to a label ive been stuck for 3 days.
I've created a user control with a simple text box and a corresponding label and added a few custom control properties. When added to a form, I'm trying to loop through all control of this type and evaluate the custom property. In the below, the cntl.MyCustomProperty is not recognized. I can evaluate the property when I check each user control on the form by name, but not by using the loop below. I would much rather use the loop as it is much cleaner.
For Each cntl As Control In Me.Controls If (TypeOf cntl Is MyUserControl) And cntl.MyCustomProperty = "ABC" Then ''Do some stuff End If Next
I am trying to develop a simple math calculator that will allow the user to input the right-hand-side (RHS) of an equation into a textbox on the application and have the application evaluate the expression for a given value of x, which is also input into the application by the user via another textbox.For example, if the user wants to evaluate the following expression,
y = 3 + 4*x + 5*x^2
then they would input into the textbox the RHS of the equation
3 + 4*x + 5*x^2
and then enter a value of x into the another textbox and click on the calculate button.I tried this:
In the application I'm actually building, I'm dealing with two dynamically-added controls that need to interact with each other, but I've reduced the problem to an as-simple-as-I-can-make-it example with the controls being statically loaded, and it still presents the same problem: a NullReferenceException when invoking the delegate. Here's the gist:
Control 1 Partial Class Control1 Inherits System.Web.UI.UserContr
I am trying to create a form which will be fed by an underlying database to create multiple form fields for each entry in an underlying database table. This is for a program to monitor patients under anesthesia, and prior to surgery, the doctor will choose which monitors they will be using. Then, on the actual monitor screen which will pop up every X minutes, there will be a text box and a check box for each chosen monitor. I am relatively new to VB, so I have tried to illustrate what I am needing but using the logic that I know from my previous life in PHP.
I am using DevExpress's layout control to place the form fields, so that is the code in the middle of the first loop (on_load), and I know that part works, I just need to know how to name the fields and then recover those fields and commit the values to the database. (the text boxes are added to the database, the check boxes are used to determine if an entry is made for that monitor- i.e. at the end of surgery if a monitor is turned off). I know that my syntax for naming the fields is no where close to correct, and it probably would not work in PHP, but I remember doing something like this in a PHP application I built long ago. [Code]
I am designing a fairly small application to manage a waiting area for a clinical department. There will be a receptionist who books appointments and updates exisiting appointments to say that a patient has "Arrived". In seperate rooms will be nurses who call patients who have "Arrived" and update the appointment as "In Session" and finally as "Discharged". The appointments are viewed in a flexgrid with nurses across the top and time down the left, patient names are displayed at the relevant times and the cells are shaded a colour to represent the current appointment status ("Booked", "Arrived", "In Session" and "Discharged").
I am using SQL Server as the back-end and Visual Basic 6 (I know) as my front-end.I have been told that there will be 2 or 3 nurses plus the receptionist logged in to the system but I would like to cater for growth.My question is what is the best mechanism to use in order to reflect the status change made by one user on the screens of the other users currently logged in?
I have been thinking about using a timer to refresh the data at a set interval but I do not want to keep hitting the server excessively (although what is considered excessive? we would be talking about a call for data every 60 secs per user). Plus the server could be serving data for many other applications so this is another consideration.Alternatively I have been thinking about sending some kind of message via Winsock to the other users notifying them of data changes as they happen. I don't have a lot of experience with this and am concerned about clients not receiving messages and users seeing old data. It also seems strange to me that once the days appointments have been retrieved from the database that "in theory" a client could go the whole day without having to query the database again to pick up changes - kind of scary.Some information on the data:We would probably be looking at around 100 appointments per day We capture patient name, date of birth, date and time of appointment and appointment status.What is the standard approach / best practice for this kind of scenario?
Using VB.Net 2003, how do you code to send an email with no user interaction? I do not want any windows to open or require any sort of input from the user. The idea is for the user to be able to request technical assistance by simply pressing a button.
I've written a program using Visual Studio 2008 Standard Edition in Visual Basic. It's a Windows Forms Application. The program is very simple, it just reads a directory of text files, parses the text and outputs another text file as .CSV file for import into Excel. There's no user interaction required but it never displays the form and therefore the progress bar. If I put a GO button on the form and modify the program so that the subroutine that does the processing isn't called until the user clicks GO it shows the form and the progress bar etc. How can I make the program run at startup, show the form, show the progress bar and then pause for 10 seconds or so and then exit?
This IS a project for the class. HOWEVER, this class is *NOT* a programming class, but is called "Usability Engineering", which aims its goals at creating a better user interaction. I'm not sure of what the "homework" policy is here, but what I am asking isn't for getting a grade, as the grade isn't based on my ability to program here. But nonetheless I am a C++ programmer at heart and VB makes me groan a little bit.
^ The program: Our goal with this project is to make a program with only five buttons (Aiming to be a cellphone type system, I know, the resolution is huge.), The buttons are the arrow keys, and enter. When the user selects a textbox, it changes the focus to the keyboard and then allows input via moving around and hitting enter.
My first problem right now, is that when I use my arrow keys, if I press RIGHT or DOWN, it will only go right, and if i press left or up, it only goes left.
The second problem, is that the buttons are out of order... when I am on "P", and press right, it actually hops down to the space bar button instead. I'm sure this is just some sort of container that can be modified, but I'm unsure of where it is.
Not so much a VB question more of a Net question.Does anyone have a logical explanation as to why the Maximum value of a Scrollbar is impossible to reach by user interaction?The documentation explains clearly the how, it just gives no reason for the why.
Back again... getting into the next issue. My question is regarding a simple way to pull the table in without headaches. Right now I open the website, navigate to the page and am ready to pull in the needed info. It's Paypal, I'm trying to automate getting new sales customer addresses/orders downloaded into a spreadsheet.
I am using VB within the Visual Studio 2010 platform.I have created a simple Database with Access.I have connected my database to my VB 2010 project using the Visual Basic BindingNavigator object.I now need to navigate my Database with code from within VB 2010.
1) More specifically I need VB routines that allow me to:
· GoTo first record · GoTo a specific record · MoveDown one record at the time and sense the EOF.
2)I need to add new records at the end of my database as data become available through a change in four text boxes.
3)I need any other VB 2010 statement or routine that might apply to Database navigation and communication from within VB 2010.
My Database consists of four columns: Date, Time, Bid (Double Integer), and Ask (Double Integer), and was created with Access.Is Access the best solution for creating a Database today?
I've been studying design patterns off-and-on now for a project I've recently been working on. I've been fortunate with this last one not to have to work with databases, but will soon have an opportunity.
I have one table here with a list of UserIDs, Users, and ClientCodes.Each user can be assigned a client code to view that client's data else where.Right now I have to change it for everyone via SQL Server and actually going into the table manually, but I'm trying to make a simple little program that will let the user change it themselves.All I need is a textbox that pulls the user based on a certain UserID from the table, and a drop down list that will not only show the current ClientCode they're set to, but allow me to change it and save that change to the table in the database.What's the best way to go about this? I tried using the wizards but I guess that's not the best way to go about it.I have it displaying the correct user and their current ClientCode but that's about it.
I have VS 2005 installed in my sytem fyi.We have two databases, say source database and destination database. The databases is in Oracle. Now we need to pull data from Source database, manipulate it and push it into the destination database on daily basis.We are planning to use VB .Net for this and would like to know if this is feasible. Using windows forms through VB .NET, is it possible to create a exe and schedule the exe on nightly basis to pull the data from source to destination.how to do this as for manipulation of data, there is no intermediate database for us?
Using Visual Basic 2008 express, I would like to access a database with 2 tables, one table (useraccounts) which has Users and Password and ID, and the other table which has information (linktable). Basically I would like to do a login form which reads from the table useraccounts and be able to create new users which will write into the database.
Another is that I have a form with a number of links which I would like to store in the table 'linktable' and it basically just gets the links from the table and straight to the form where it is used. I have tried using access or the .mdf files that visual basic has but I have been unable to find an answer for either.
I wouldn't mind using either access or the .mdf file for the database, I would just like it to work. Overall I am trying to get: Login form which reads from database table 'useraccounts' and has a new user feature Just a form that can read / write to the database once the save button is clicked.
I am quite new to programming and I want to be able to check whether the user logged on to the system is in a table or not. I am not quite sure how to iterate through a table.
I am new to Vb script or any scripting at all. I have made a script for reflections that run vb 6.3 macros I have modified the original script to use msgbox and input boxes as below:
I need your guide regarding to pull data form other database to other database. I'm already pull the data into Dataset using this command oracmd = New odbccommand ("Select id,name,dept from staff order by id",oracn) da = ds.fill then i need to insert to other database but it have different name of column that is Staff_Id,Staff_name,Department.
I currently have a drop down box that selects a customers id, when selected it populates the neccesary fields. I now want to populate these fileds by entering a customers name in a textbox. The customers names are in a table in sql server.
I need to pull a random word from a text file in my resource folder (visual Studio 2010) and then have a user enter a letter to see if it is in the word. Yes, Hangman game. There is more, but right now I need to pull from that text file for a start. I know what I have is not even close to right under "Get Word Button", but I'm kind of confused about the process.
Public Class hangMan Private Sub Form1_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load Dim word As New Random End Sub
I have to use the word list supplied and cannot use "streamreader" so, I need to pull a random word from text file in my resource folder (Visual Studio 2010) so user can guess letters for hangman game). I don't know if the code under "get word" button is right or not as far as pulling from the file. I would like to get that far!
