i have to write a program that will calulcate the percentage growth of four catagrogies of products a company sells that sells fruit.
Grape $565.000 $600.000
banana $600.000 $520.000
strawberry $150.000 $325.000
pineapple $75.000 $82.000
the result has the be a percentage.heres is my code so far.[code].......
I'm using VB 2008 express edition.I have to show the growth of savings in a bank account using input from two text boxes that will be deposit amount and interest rate. I have attached a picture of my form.I have declared my variables and now I'm working on my processing.When the compute button is hit, based on the deposit amount and the interest rate, the amount of years it takes to double the money and the amount of years it takes to become a millionaire with that amount will be displayed in the lower text boxes.
Here's some of my math reasoning...
Doubling time formula : 2P = P(1+ i)^n I tried solving for ^n and got: n = logP(1 + i)/log2P
Is this correct? How do I express logarithms in VB?As for the amount of years that it takes to become a millionaire, can I simply take the deposit amount for example $500 dollars and divide 1,000,000 by 500 to get 2000 so it takes 2000 deposits of 500 dollars each to reach 1 million. Is my arithmetic correct?
I want to copy datatable to dbo.Products
View 9 Replies[URL]...From this link, it explains the formula of how getting the critical level of the products, but I can't imagine how to automatic-compute it because every month and every year there's a computation to be done
View 3 RepliesI have build a program until now with an MySql database. The programs add records for the customers and the products of the company(Its works perfect).. I am trying to build now the Orders the last part of my project but I have a little problem.. First of all I need 4 different type of database:
Cash
Credit Card
Check
Debit
Price Offer
This is the the type of the payment. The user must add the order by the payment of customer so we need to seperate each one.. Unitl here I am fine::
Now, my serious problem is with the order table:: If i used the code that I use for my other adding records (like product and customers ), for each order it's add only one product!! BasicallyI need to be able to add multi products and the user have the ability to change the price of one product:: for example "to make an offer for some special customers" without change data into the database of products..Thats has a lot of typing code but I need a base to start since I have a little bit of confused. At the end am trying to load data from database customers into text boxes:: for example the user select one name that loaded into a combobox and then appears the city and the mobile into a text boxes I build a code below but it's works only One type, actually fill the text boxes but after I clear all the boxes and try for a new customer or the same isn't fill anything.
Dim ServerString As String = "Server=localhost;User Id=root;Password=root;Database=test" ''Sting Server
Dim SQLConnection As MySqlConnection = New MySqlConnection ''SQL Connection
Dim Sql3 As MySqlCommand = New MySqlCommand("SELECT * FROM customers", SQLConnection)
[code]....
I was trying to do a 'Latest Products' page for an eShop project I'm working on. asically, I want to show a number of products, say 10, from a table in my db that where added in my database in the last 30 days or less.irst I tried to use the GridView function in VB.NET, where it auto-populates the table but can't be limited and then I tried this SQL statement, which isn't working, giving me an error.
SELECT *
FROM Product
WHERE DateAdded > (SELECT DATEADD(d,-30,(SELCT MAX(DateAdded) FROM Product)) AS "Last 30
[code].....
I got database with products of restaurant. What i want: I Want to create cocktails with multiple products (products are registered in database). When i put cocktail in the sales list, i want when sales complete, automatically to change stock of included products in the cocktail. I attached a screenshot to be more clarity. If u help me, i apreciate this.
View 2 RepliesI want to grab Top 10 most Ordered product by customer... Im counting how many lines that this product have been ordered .
Sample data:
ProdName
A
B
C
[Code]....
Ive done this in other database using LIMIT 10.. but here in SQL server the result of that query is the bottom record's
I can't seem to figure out how to write this query properly. I've tried various combinations but nothing's worked yet.Below is the relevant portion of my database model:
I need to select the products that match a given Category and Group, and that match a given Year, Make, Model, submodel. This I've done below: ItemList = From P In gDataContext.Products.Include("Groups").Include("Groups.Category1").Include("LookupYearMakeModels") From G In P.Groups Where G.Category = Cat And G.Grp = Group From Y In P.LookupYearMakeModels Where Y.Year = YMM.Year And Y.Make = YMM.Make And Y.Model = YMM.Model And Y.Submodel = YMM.Submodel Select P
[Code]...
IN one application, I need do the following: When user press one button, show a combo box with ptoducts kinds, and the application create a new record in the database. Next, and automatically, I wanna another form to be opened, with all the complementary values of this products, for the operator complete the values.My problem is: The form cant be the same, cause each kind of product show one different form Open the detail form, how can I know what record ID was created??
In later use, the products will show in DGV and double click works. But at the product open, I wanna this form apeear automatically.
I'm trying to make the following snippet work in VB6 but it's one error after the other. can anyone make heads or tails of this?
Basically i'm after a little proggy which will store the names of a couple of products, calculate product code (first three and last three characters of product name) produce a list of products stcked with their initial stock levels, allow info on products be search for, allow the products to be purchased.
CODE:
I'm currently trying to create an Information System of customers who does have different prices for one generic set of products. For example, there's a list of customers, then once you choose one, the system will show a generic product list but a set of price list specifically encoded for that specific customer. I'm sorry but i'm not that good with databases, and I'm using ms access as the database and VB.Net as the programming language.
View 1 RepliesI'm trying to generate a report that shows the products ordered for a given customer.
I'm getting an error on the line that states:
lblList.Text &= rowInvoices(
"ProductCode")
& " "
& rowInvoices("Quantity")
The error message states: Column 'ProductCode' does not belong to table Customers.
I have three tables: The Customer Table, which points to the Invoice Invoice table via the CustomerID.
Also, the Invoice table, which contains the product code, points to the Invoice table via the InvoiceID.
If possible I'd like to bring in the Products table to get the Product description.
[Code]...
Here is a link to a FREE whitepaper relating to;"From Hack to Counterattack: A Guide to Protecting Software Products Against the Top 8 Piracy Threats"in case any of you want to get it? url...If you do not want to enter your details on the above page then go here: url...Try the World's Strongest Software Protection Today.You can download the Sentinel HASP software DK Version 5.10 right now or request the full Sentinel HASP DK at no charge. The standard Sentinel HASP DK enables you to test Sentinel HASP with both HASP SL (software) and HASP HL (USB dongle) protection keys. The software DK enables you to test Sentinel HASP with HASP SL protection keys only following a simple software download.[code]
View 6 RepliesI have a datatable which contains a column (ProductName) and it has 10 rows (products). This number of rows in this table varies.The database table (Products) contains 2 columns (ProductID and ProductName). Is there a way to retrieve the ProductID and ProductName from the database table Products by using the datatable instead of creating a one big SQL statement using WHERE clause using?
View 14 RepliesI have a datatable which has rows of product names. I have a table in SQL Server which has product details, with ProductID.I need to retrieve the ProductID for each product name. I can do this using a for each loop but this is way to slow. Is there a way to retrieve the relevant ProductIDs for the products with one transaction rather then using the for each loop?
View 3 RepliesI am having trouble opening 2007 office products with in a webbrowser control. 2003 office products did open, but for some reason 2007 won't. I have read about rolling my own activex document container, but I don't know where to start. [URL]
View 9 RepliesI'm trying to make the following snippet work in VB6 but it's one error after the other. can anyone make heads or tails of this?
Basically i'm after a little proggy which will store the names of a couple of products, calculate product code (first three and last three characters of product name) produce a list of products stcked with their initial stock levels, allow info on products be search for, allow the products to be purchased.
[code]...
We receive an HTML document in an email which has some special pricing and products. I want to be able to parse the data, perform some lookup operations on it, assign some pricing markups, save it to a data source for future referance and do it with VB.net and a web browser. I'd really like to use MSHTML.HTMLDocument, but all the documentation I have is based on HTTP URL's, but since these HTML pages will be opened from an eMail or saved to a fileshare, they won't have the HTTP. I've also tried to read it as a text file and parse with RegEx, but it's not very effecient and to be honest, RegEx is still a fog to me.
Would anyone be kind enough to suggest a way to do this? Is MSHTML able to do it and if so; how do I set up a reference to a non-HTTP URL?
I've got 2 seperated programs.
One is a program where you can select a product and select how many of them you want. Then the total price wil be displayedin a label. And the list of selected products will be saved in a .txt file.
The second program is an Edit program. The user can edit his selected products. Here he can change the total of a product.So if he had selected 1, he can change it to three or something. When the user clicks the button Save. The changes will besaved in the same .txt file and the total price will also be changed and displayed in program one.
Program one is compleet.Program two has problems and here i need your help:- the user can't make a change in the numbers, seems that the textbox is read-only or something. How to solve?- Then when i click save, the changed must be saved in the .txt ( i can't test this yet because no changes can't be made)- the total new price must be showed in program 1 (i think i programmed this well, but can you take a look)
Here is a part of my code of program 1:
CODE:
I am making a minor basket system which the user selects a number of products from a datagrid and it adds them to a basket using an array list (arrItemID).However on the ViewBasket form I want another datagrid however a query is formed listing the selected products. Though the datagrid seems to be empty (though the query when outputted to a text box is ideal. [code]
View 3 RepliesTrying to build a project that lets users click an item from a list of products (tabbed form). Once an item is selected (check box) find a way to store that item.Then when the user has finished selecting items they can click a button showing what they have selected in a new form that will open.Whats the best way to store what items they select? An Array?
View 2 RepliesI am trying to get a percentage that just does not seem to work.I am using WMI to get the Total Physical memory of my system and then the Free Physical Memory. Then get the percentage.
2147483648 - Total Memory
838028 - Free memory
According to Task Manager my physical memory is 59%. This is the code I am using but I can not get 59% or 41% that is free.
temp = FM/TM
temp = temp * 100
percent = FM * temp
How can I round a percentage off to the nearest whole number? [code]
View 5 RepliesIs there a better way to parse percentage to double like this?
Dim Buffer As String = "50.00%"
Dim Value As Double = Double.Parse(Buffer.Replace("%",""), NumberStyles.Any, CultureInfo.InvariantCulture) / 100
I have a program that is calculating the cost of a certain number of plane tickets, the validation and basic calculations are fine the only problem i've got this: There is a discount text box field called "txtDiscount" where IF a user enters a number it will discount this as a percentage off the total cost of all the tickets, but I cannot get it to work [Code]
View 2 RepliesI have a fixed percentage 0.3% I need to multiply this by a number of months which varies 1 to 12
Having done this I need to add the percentage to a pre-determined number
so as an example
£300 + (0.3 * 10)
I can get the 3% (0.3 * 10)
But when I add this to the existing number (£300) it equals £303 not £309 which is what it should equal.
Can anyone advise the way of adding a percentage as appose to just another number? This also need to allow for -percentages i.e. -3%
The equation I am using is below and I appreciate there is nothing to set decTotalPercentage as an actual percentage but that's because I am stumped...
decTotalPercentage = decPercentage * intMonths
decFinalPercentage = decMoney + decTotalPercentage
I have a problem regarding an access file I attached to this post.I have a table which contains the costs(VVGK) for each month in 2008, 2009 and 2010. For each month we have planned costs(Plan) and the real costs (Ist). And what I want to realize is that in the report in the top right it automatically displays the percentage difference between the plan and real costs of the last month. And this should then be automatic every time I give new input(new month, new VVGK Ist).
View 2 RepliesI'm developing a data logging application using VB for the actual logging to a MySQL database. I'm reading a value from a device and then running an insert query every minute. This is great but if the value doesnt change all day then my records are going to all be the same. I'd like to try and calculate the percentage of change on the value and only run the insert query if the percentage of change is greater than, say 5%.
View 2 RepliesI need to compute the percentage of games won and games lost. I keep getting errors and it's driving me up a wall. I've changed my code so many times that I don't really remember what it was like when I started.
Private Sub btnPercentage_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnPercentage.Click
Dim team As String
[Code].....