i have problem multiplying total minutes of user login with price. for example, my price for 10 minutes is 100. if user A start login at 9.00 am and logout at 10.00 am, that means he spends 60 minutes using the computer. how to multiply 60 minutes with 100 (my price) so that i could get the correct price and update the data to my database?
[Code]...
CODE:
Right now i have the following code. it is 4 radio buttons that if selected will display the price of a ticket.
There is a button called "repeat offender" that should take the price and double it. so me, being new to visual basic, were thinking of trying an if statement such as If it is selected decTicketTotal * 2
But this did not work. any help would be appreciated.. just trying to get the repeat offender selection working so when it calculates the price will double.
I have in Sql a money filed named value, and the data looks like this: 234.0000 .
I use this data trough a vb application, and so I store it in a double variable named dfValue, but I only get 234.0, even if I use: select round(value,2,1) and then Format (dfValue,"#.00").
I usually have a check to see if a certain database column is DBNull and if it is convert it. Current with a datatype of money in SQL 2008 with the row column containing
Null, i declare the equivalent value as Decimal (in .Net) then get the error "'DBNull' to type 'Decimal' is not valid".... How could i check this column for null and convert it?
How can input number to database where my field in database data type money.[code]...
View 5 RepliesI am linking to an SQL table with 'Money' field. When i try to update this field in VB.NET I get an error message that "Can not convert a character value to money. The char value has incorrect syntax".
[Code]...
I am new to vb and I am having so much trouble with this. What I need to do is this: I have a form application for winter sports equipment rental.I have a listbox filled with the equipment for the user to choose from then I have a combobox for the user to select the duration they would like to rent it. The book that I am using has no examples I can refrence and i have had no luck online either. I am posting what I have so far. However, i think I am going in the wrong direction. I have been working on this for so long that I think I have over thought it and made a mess of it. I am thinking that I need to add a new class for rentalRates then use enum of durationType and equipmentType but I am unsure how to move that way. That is using a enum, a 2d array and a parallel array? [code]
View 1 RepliesPHP
Public Class GasPump
Private name As String
Private quan As Double
[Code].....
I get problem in the code when you going to pick y/n. how i going to get the price of the premium or Regular in Price per unite?
I have a form as follows "Price changer" The user is allowed to select a product and enter price . So when the change price button is clicked...the price is stored in a array which is later called
So what i am stuck is when the user selects a product from the drop down menu...the user can enter price . But i need to display a error message when the user enters text instead of numbers for prices. I tried try parse method but it displayed the error message but did not transfer the entered price to the array.
My code is as follows
The bolded intMediaprice() are arrays....
Private Sub btnPrice_Click(sender As System.Object, e As System.EventArgs) Handles btnPrice.Click
If cbMedia.Text = "8-Track" Then
[CODE]...
I have to create a form that I enter the price of gas each month over a year. I enter the price in a text box and click the enter button to send the price to a list box immediatley and use an array. I have the following code but I don't think it's working with the array correctly as it will let me enter the information but doesn't stop letting me enter after the 12 prices. I am really having a hard time trying to figure out how to set up this input for an array and make it all work.
[Code]...
As a continuation of my eCommerce app, im trying to display the name of DVD's + their price into a ListBox All the data is being read from a text file which stores the dvdname and the price e.g
[Code]...
For each column in data table i want to add parameter with same data type as column data type. But looks it's not that simple.
Dim cmd As New SqlCommand
Dim dType As New System.Data.SqlDbType
For Each cl As DataColumn In DataTable1.Columns
[CODE]...
How can I do this?
my exce'sl file has some data.i can open file from vb
how can i refresh data all 30 minutes from vb
I would like the client app being able to refresh the data every 30 minutes.
View 2 RepliesI am looking for formula that is accurate in converting Minutes to Decimal Minutes i.e 30 minutes is 50 Minutes in Decimals so 1.3 hours is 1.50 and not 1.5 i have used Minutes/60 but it is not accurate as some times i have to Multiply the result by 100 and some time 1000 to get correct results based on single digit Try 1/60, 10/60 99/60 or 100/60.What would be the most efficient and correct way to Convert the time into Minutes ?
View 10 RepliesI need to create a function which have either 1 parameter with a string as data type or 2 parameters with double as data type.Something like the substring method.
View 2 RepliesI'v designed a ms access database table with one field having Datetime datatype. I can Insert data into it from vb.net front end by trns_dt DateTime.Now.DateBut when I fetch records from the tableand assign the dataset datasource as da, it shows datatype mismatch error.
daleDbDataAdapter("SelectDaily_Transactiondtp_from_dt.value dtp_To.value con)
dsDataSet
[code].....
I have a program that calculates commission, but if the commission is nothing then I do not want it to show a zero commission. I want a message box to show a message that there is no commission earned.
View 1 RepliesMy colleague gave me a DLL that manage all database business. I wanted to invoke a function that uses Stored Procedure and return the search result. In the function receive a parameter type in ystem.Data.IDataParameter[]. Below is my codes.
[Code]...
I have a function (on vb.net) to get a data from a XMLWebService:
[Code]...
I added this lines in the form load of DataGridPrinter by Merrion in the codebank..[code]Unable to cast object of type 'System.Data.DataViewManager' to type 'System.Data.DataTable'.
View 2 Repliesevery time i run this code i get the same error
Unable to cast object of type 'System.Data.DataTable' to type 'System.Data.DataView'.
the code is
Dim plmExcelCon As New System.Data.OleDb.OleDbConnection
Dim cmdLoadExcel As System.Data.OleDb.OleDbDataAdapter
Dim PrmPathExcelFile As String
[Code]......
in my project i am using this code to multiply to textboxes value
(
Dim tot As Integer
[code].....
how would i go by multiplying two variables..
ListBox1.SelectedItem.ToString() * Label1.Text.ToString() = Label2.Text
is what i have but it seems to not want to do it... [URL]
I'm new to vb and I am currently trying to code a Program for counting cash from a till. I know how to multiply and add if I were to use a button to execute it but what I want is for the totals to be automatically populated as soon as the user inputs the data.
Example:User inputs 23 into the txt1cent textbox
So the program should multiply 23 by 0.01 and output the answer (0.23) into txtsum1cent textbox.
(All of this is in a datagridview) i would like to know if it would be possible to say, take Columns 1 and Column 2 and multiply the value of each row and post it to a Column 3 with each row in Column 3 reflecting the multiplied values of the previous 2 columns..
View 6 RepliesI've got an array of type double with about 30 entries(numbers) in it.I need to multiply them all together. Sort of like "=product(A1:A30)" in Excel (formula).
View 1 RepliesI have two list boxes created. One is Quantity and other is Price. When i enter price and quantity i want it to multiply and add one by one and give me the total in a label below...The problem is when I have two or more items in each list box I'm unable to come up with the total. I figured out that it will need a loop. So my question is that how should i use the loop. I haven't learn't how to make loops..
View 6 Replies[code] "The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.The statement has been terminated." [code]
View 6 RepliesI have an application that provides a countdown for 60 minutes and I'm currently using the win form timer and it updates some labels and a progressbar. Now I have to change this to be a countdown for 360 minutes. Will the win form timer be sufficient or should I implement a Timers.Timer instead?
View 6 Replies