Set The Value Of The 1st Record To Be Equal To The Exchange Rate For Dollars?
Apr 14, 2009
I am currently working on an ATM prototype in VB.Net and have encountered difficulties when trying to return values from two different recordsets in the same table. I wanted to set the value of the 1st record to be equal to the exchange rate for dollars and the 2nd record to be the exchange rate for euros. When I run the code below I get the error:Current provider does not support returning multiple recordsets from a single execution.
[code]...
View 18 Replies
ADVERTISEMENT
Apr 27, 2011
I am using a not equal operator <> in my sql statement but it doesn't retrieve any record which is not equal to the selected date.
CODE:
Command = New SqlCommand("SELECT * FROM [Products] WHERE [ParkingStartDate] <> @StartDate", myConn)
Command.Parameters.AddWithValue("@StartDate", StartDate1)
View 4 Replies
Aug 19, 2009
how to calculate rate for 3 days in different rate like public holiday,weekend and normal for 1 room
View 2 Replies
Mar 25, 2012
How can I speed up a process? I see I should use timegettime, gettickcount, and queryperformance counter, but I have no clue where to start.
I guess you can call it Frame Rate or Refresh Rate of a process?
View 1 Replies
May 7, 2009
i am trying to indicate if the tax is at single rate (18%) or the family rate of (15%)This is what i got so far i could do the rest but just cant do the Mstatus part.
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim Name As String 'Name of employee
Dim hrWage As Double 'Hourly wage
Dim hrsWorked As Double'Hours worked this week
[code]....
View 1 Replies
May 19, 2012
In the following LINQ query, i would like when the Loc=Locale.Gr all the records with GrID=100 returned and when the Loc is anything else all the other records with GrID <> 100 returned.How can i achieve this one? I tried something like the following, but it is totally wrong.
PrivateSub Test(Byval Loc as Locale)
Private Const GrID as integer = 100
Dim Query = From c In Mob Where c.CountryID = IIf(Loc = Locale.Gr, GrID, <> GrID) select c
End Sub
[Code]...
View 1 Replies
Mar 9, 2011
The output I am getting is is not what I am suppose to be getting when you type in 50 dollars i should get 58 bars and 2 coupons but when i run it i am getting 57 with 7 coupons left
Module Module1
Sub Main()
' declare variable
[code].....
View 1 Replies
Mar 8, 2012
How does one check to see if the system time is equal or not equal to a specific time? So, say I want to perform an action if your system time is between 6pm and 6am. Or something similar?
View 1 Replies
Sep 17, 2009
i am supposed to calculate change. well this works fine but i need to know how to make it show how to breakdown the money in dollars quarters nickels dimes and pennies. [Code]
View 5 Replies
Sep 24, 2009
I am having trouble with the pennies calculator. I need to create an application which should calculate the number of dollars, quarters, dimes, nickels and pennies a person will receive when they cash in the pennies at a bank.Eveything seems to be working fine except the nickles...
Option Explicit On
Option Strict Off
Option Infer Off
Public Class frmMain
[code]....
View 3 Replies
Jan 20, 2011
say pounds to dollars is £1 = $3
how would i write a program that allows the user to enter the amount of pounds then it converts to dollars??
View 8 Replies
Mar 22, 2009
Public Class MainForm
Private remainder As Integer
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles xCalcBtn.Click
Dim xChangeTxt As Double
[code]....
it says 0 for all dollars, quarters, dimes, nickels and pennies.no errors.
View 9 Replies
Sep 16, 2011
I am trying to learn how to use the modulus operator.this excersise is a change calculator and is supposed to calculate the number of dollars , qtrs, dimes, nickels and pennies from the change that is calculated.
in the form if i put a value in for owed = 30.00 and paid 34.25 my dollars returned = 4 and that is correct but the number of qtrs = 0 and should be 1. I am not sure how to correctly use this - any assistance you can provide is great - this is purely educational
Private Sub btnCalc_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnCalc.Click
Dim owed As Decimal
Dim paid As Decimal
Dim change As Decimal
[Code]...
View 8 Replies
Oct 13, 2010
Im trying to create a program that takes an amount entered by the user and then convert it into Half Dollars, quarters, dimes, nickles, and pennies when the calculate button is clicked. Each coin has its own function and is shown in separate text boxes... right now i cant get it to work correctly. When i try to get half dollars to work it rounds up and then the rest of the coins say 0. How should i do this?
View 5 Replies
Apr 9, 2009
I'm trying to add a bargraph to one of my forms which will show a trend in dollars spent for certain projects (vs. the forecasted amounts). I wanted to know if there is a control or a function in VB.NET 2008 that I can use to build this graph in.... My only other thought is to use pictureboxes as bars (with background filled colors) and adjust their heights based on a ration or height to dollar amt... I don't mind doing this, but I wanted to know if there is a more intelligent way of building this... maybe some graph wizzard like in excel.
View 1 Replies
Apr 18, 2009
I hav a web service which pull records from a database and I am hosting these services in IIS which works fine but I am trying to retrieve the record and display the record in a listbox displaying the time field as the text for that record.I have created the following function
public sub get_data()
dim dt as new data.dataTable
dim service as ws webservice.webservice
[code]...
View 1 Replies
Aug 9, 2010
I am trying to check a record in database before inerting a new record here is my code but problem is when i enter a names first alphabet it imediatly populate massage. i want to check it after entering whole name
Private Sub TextBox1_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles TextBox1.KeyPress
Try
Dim cnString As String = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" &
[CODE]...
View 2 Replies
Feb 8, 2010
I was trying to use the web service for currency rate to get the rate, although I have already add web reference to [url] but I still do not know how to retrieve it from there. I'm using asp.net vb.
View 1 Replies
May 18, 2009
Each Taste Tester rates the two drinks on a scale of 1 to 10, with 10 being the best.I need to display the summary of results that contains the current results of the taste test.It should display the winner, the total number of taste tester and the average rating for each drink.My program has three forms.The main form, the input form and the summary form.For some reason, I can not get my results to display in the form. Plus it is not calculating my results correctly.[code].....
View 6 Replies
Oct 25, 2011
I need to get shipping rates from USPS. I have signed up with them, got myself a user id and trying to use the sample request XML as shown on page
<Error>
<Number>80040b1a</Number>
<Description>API Authorization failure. RateV4 is not a valid API name for this protocol.
[code].....
View 1 Replies
Jul 31, 2009
I'm coding a program, which supposed to give the discount rate of the entered price, so there is as what I got on my code. [Code]
View 6 Replies
Mar 11, 2011
Im creating an interest rate calculator that will make sure the principal is a positive amount, retrieve the interest rate from the interest rate:numericupDown function and will leave a message in the resulttextbox.This is what i have so far:
Public Class InterestCalculatorForm
' handles Calculate Button's Click event
Private Sub calculateButton_Click(ByVal sender As System.Object, _
[code].....
View 3 Replies
Mar 3, 2010
I just started with VB.NET using Murach VB.net 2008 book and i want to make this program for my work, please tell me what knowledge needed to make this program beside VB.NET: want to make a program for my supervisor which Lists the name of every employee in our division. the program should be accessed by any computer in our division using LAN. each employee will have user and pass to enter this program they only can view their data with charts showing their attendance, productivity , etc, supervisor will have master account where can edit the info.the supervisor can send private message like e-mail to each employee. all the info should be saved in database so it can be used to compare the employee activity for each year.
View 3 Replies
Mar 9, 2010
duplicating a visual basic assignment. I have know idea where to start.......
Public Class Form1
Private Sub NumberofChildrenNumericBox_ValueChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles NumberofChildrenNumericBox.ValueChanged
[Code]...
View 4 Replies
Jul 8, 2009
Track open rate of hyperlinks
View 3 Replies
Feb 14, 2012
I am working on a program that takes a present value, multiplies it by an interest rate (between 1 and 25 percent), multiplies the resultant answer by a specified number of periods and produces a listbox breakdown of value accumulation for each period. I was doing just fine. UNTIL. yeah, until......I don't really know when...... I am trying to specify that the interest rate must be between .01 and .25 (user has to enter it as a decimal on the GUI) or a Message Error box pops up. However, it seems that everywhere I drop my code, it doesn'
vb.net
Private Sub mnuClear_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles mnuClear.Click
[code]....
View 5 Replies
Nov 16, 2009
I have this code that is supposed to calculate the gross pay based on hours and rate, the program debugs without a problem but when I click the calculate button it gives me and answer of "0.00".
Public Class frmMain
Private Sub btnCalc_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnCalc.Click
' calculates and displays a gross pay amount
Dim dblHoursWkd As Double
[Code] .....
View 1 Replies
Jun 25, 2010
I am developing a software for tracking the time and attendance for employees. I am learnt the best way for me to be able to capture this information is through the use of a biometric device. But right now my problem is how do i integrate the biometric device in my project. What do i need in order for my Vb.net to be able to recognize the biometric device so that i can record the details captured into the database.
View 3 Replies
Jun 22, 2010
I am trying to open a cmd window as an admin but it never works. I can open a command window but it does not open as the admin.. Here is my code (VB.NET 2008)..
[Code]...
View 5 Replies
Oct 20, 2009
This is the current incarnation of what I have:
'Program: Ch4E4.6
'Programmer: Jeff Pannell
'Date: October 1, 2009
'Description: This will allow for entry of a worker's name and the number of pieces completed. The program will then calculate a pay rate, but also determine an average and summarize number of pieces made, total pay and an average pay per person.
Public Class PieceworkForm
'Declaration of modular-level constants.
Const PIECE_RATEA_Decimal As Decimal = 0.5D
Const PIECE_RATEB_Decimal As Decimal = 0.55D
Const PIECE_RATEC_Decimal As Decimal = 0.6D
[Code] .....
So, my problem is that whenever the form is executed..a user would type in a worker name, and the amount of pieces made. I get a dollar amount earned and then a total pay, though they seem to be the same. More than likely I've got some sort of bad logic in there mathematically.
View 3 Replies
