Creating A List Of Orders
Jun 5, 2011
So I have a program that is supposed to support a small business. I have the work completed and the professor said it was correct but I wanted to go do a little extra. Basically, on the Order screen, you begin to type the name of a customer/supplier/employee into a text box and a list of names that fit the criteria pops up in a list box (lbMatchingAccounts). When you select it, you can hit enter new order and be transported to the Order Details screen to enter the new order.
[Code]...
View 2 Replies
ADVERTISEMENT
Mar 9, 2009
I have a scenario at hand which has some design discussion going on. To break it down in simple words, think about a hierarchy as such Company -----> Customer ------> Orders (ignore the details of how the orders have products etc) if I was to expose an API to work with this, what would be a better design.
a)
Dim comp As New Company
comp.GetInfo(123)
Dim cust As New Customer
cust.Name= "CustomerName"
comp.Add( cust)
b)
Dim custhand As Customerhandler
Dim cust As New Customer
cust.Name= "CustomerName"
custhand.AddCustomer(cust,123) ''123 is CompanyID
View 5 Replies
Sep 12, 2011
I have the following code for Customers and their orders. I want to list all the customerID and the corresponding count of orders. How do I achieve it using LINQ? [code]
View 3 Replies
Feb 29, 2012
I am working on an invoicing program that based on the Northwind database.I am pulling information from a 'view' for the orders form.How do i program the customer ID field to populate with the corresponding invoiceID (already done through the view) AND when i drop down the customerID box to list all possible customers from the customers table.I have the SQL for the operation I believe the problem is that the field is bound to the orders Orders Qry 'View'.How can i accomplish both of these tasks within the same dropdown?
View 1 Replies
Mar 7, 2010
I am wanting to create a VB.Net app that checks a database and then prints out the latest orders, the database is mysql and i need it to periodatically check and only print new orders i.e. not print ones it has already printed out.
View 3 Replies
Jun 28, 2009
It's a basic Access database driven e-commerce site. I have a home page, a products page, an orders page, an order confirm page, a shopping cart page and a view current orders page. The site uses an Access database with three tables. A Customer table, with all of the customer details, (FirstName, LastName, EmailAdd, CardNo, CardEx, SortCode, DeliveryAdd, Postcode)A Products table, with all the product information, (ProductID, ProductName, Price, ProductType, Images, ProductDescription). And an Orders table which contains CustomerID and ProductID.I've managed to get the orders page to work, this leads to the order confirmation page which displays the details the customer just placed.Here is what I have in the order confirmation page load event so far. Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs)
[code]...
This returns this error "Syntax error in FROM clause." I'm guessing my SQL code is wrong. I noticed when I placed the order in the order page it added an entry in the Access database where the generated CustomerID was 12 on the customers table and 4 in the orders table. Shouldn't these numbers be the same when they are generated?
View 2 Replies
Jun 8, 2011
I need to make an application that can calculate the items the user chooses from. There is 7 different items the user can choose from.
Small Coffee ..... $4.95
Medium Coffee .... $6.87
Large Coffee ..... $8.52
Bagel ............ $2.99
Cream ............ $0.71
Sugar ............ $0.50
Lid .............. $0.99
Total the coffee order (subtotal + tax at 6% = grand total). Allow the user to delete items from the customer order and to allow the user to start the order for a new customer (clear all). Create a button that gives a 10% discount for coffee only and adjusts the subtotal, tax, and total. Make certain the user can not click the button more than once per customer and if an item is removed from the customer order, make sure the discounted price is removed rather than the list price of the coffee. The button can only be clicked after the coffee is ordered, not before the coffee is selected.
This is what I got so far
Public Class Form1
Private myCoolCheckBoxPrices() As Double = {4.95, 6.87, 8.52, 2.99, 0.71, 0.5, 0.99}
Private myTax As Double = 0.06 'Tax used to add to Total Price
Private Sub lstItems_DoubleClick(ByVal sender As Object, ByVal e As System.EventArgs) Handles lstItems.DoubleClick
[Code] .....
View 13 Replies
May 4, 2012
I have a home page, a products page, an orders page, an order confirm page, a shopping cart page and a view current orders page. The site uses an Access database with three tables. A Customer table, with all of the customer details, (FirstName, LastName, EmailAdd, CardNo, CardEx, SortCode, DeliveryAdd, Postcode)A Products table, with all the product information, (ProductID, ProductName, Price, ProductType, Images, ProductDescription).And an Orders table which contains CustomerID and ProductID.I've managed to get the orders page to work, this leads to the order confirmation page which displays the details the customer just placed.[code]This returns this error "Syntax error in FROM clause." I'm guessing my SQL code is wrong.I noticed when I placed the order in the order page it added an entry in the Access database where the generated CustomerID was 12 on the customers table and 4 in the orders table.
View 2 Replies
Mar 11, 2009
My table holds the following information:- ID- custID- ordered- amount- dateAddedFrom my ASP (VBScript) page I am trying to show all the rows where someone has not ordered, say in the last 30 days, 2 months, 1 year, etc. I am struggling to put the SQL statement together.
View 1 Replies
Jul 20, 2011
I want to create a big list box that has lots of default values in many lines so they can then be edited later.Right now I have in my initializer:
Dim counter As Integer = 0
For counter = 0 To counter = totalNumber
listBoxThingy.Items(counter) = ("DEFAULT DETAILS TO BE COMPLETED")
Next
with my list box called listBoxThingy and totalNumber a previously defined constant of how many items I want in my list box.yet when I try to run the code I always just end up with the first list value containing the text.Even if I put a counter=counter+1 it still only gives me the one completed value of my list box?
View 4 Replies
Aug 15, 2011
I have a table called Ordersthe table has many rows but im only interested in two in particular.I want to query the table so it returns the average ordered count of each producti want to know what is the average count of the ordered products, but now in total but per productID instead.
View 1 Replies
May 8, 2012
I am using the northwind database, My goal is to create an application that has a main form area for the orders and a details section (I guess a data grid view)How can I Utilize the data grid view for inputting values such as Product, Quantity, Unit Price, Extended price.... Specifically how to program the date grid view to multiply unit price by Quantity to get the extended price, then add up all the extended prices and shove that to another txtBox outside the dataGridView (txtSubtotal)Saving the header (to the Orders table) and using the InvoiceID to also save the details section in the OrdersDetail table.
View 1 Replies
Nov 18, 2011
I would like to know how I can get the list of possible choices to Intellisense for my class object, like it does with MsgBox.For example, when creating a message box you type MsgBox "Test Message Text", vbYesNo, "Test Message Title".In typing that, when you type the comma just before the vbYesNo, it gives you the possible selections for button types in a drop down list: i.e., vbYesNo, vbOKOnly, etc.I have a class called clsKeyState. what it does is turn on/off/toggle key states, such as CAPS LOCK, SCROLL LOCK, NUM LOCK, etc... I have set my property for it as Get/Let "State". When I call it to set a key to on/off I will be doing it like this: KeyState.State WhichKey, On/Off/Toggle.I would like the WhichKey part to automatically display all the possible selections that I define, such as CapsLock, NumLock, Scroll Lock; and I want the On/Off/Toggle to display those specific items also (On, Off, Toggle). I will be using the ability to create these displayable options for many more things in my project than just this one simple class.
View 3 Replies
Apr 24, 2010
I want to create a sorted list, where I enter a name in two separate text boxes(Jones, Brown) and their values in two other textboxes(200,500), then in a fifth text box I enter one of the names and it gives me a messagebox with its corresponding value. Here is my code below.
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim saleslist As New SortedList(Of String, Decimal)
[code]....
View 5 Replies
Oct 25, 2011
I'm trying to create a small program where someone would select one of five items from a list box (Hot, Medium, Mild, Sweet, Zesty). When they select this, they then enter in a qtyTextBox the quantity they want, ie.e, 1, 2, 3, 5,... Then they the Calculate Button, which then the total would go into the preDiscountLabel box, where it would calculate the amount they want * the sale price. Here is the Price Listing:
Hot - 3.19
Medium - 3.09
Mild - 2.98
[Code].....
View 1 Replies
Jun 5, 2011
This program I am writing is basically a way to record orders. So I got a bunch of possible components required, which got their textfield(1 for product info, 1 for product price). Those are controlled with a checkbox, disabled on default. Enabled when checked.
Something like this:
Label, Checkbox, Product info textbox, Product price textbox.
This for a bunch of products, and at the bottom you got the total costs textbox.
Which updates as entries are made.
1. Would a access database be a good thing to use for this? To save the completed forms to, for later viewing through the program. Or are the better options for this kind of thing.
2. Would crystal reports be a good choice to make the reports after the form has being completed. So you got a decent sheet which shows you the entire order, and give a print ability.
View 6 Replies
May 4, 2012
I've got 6 hours left to finish a uni project. It's a basic database driven e-commerce site. I have a home page, a products page, an orders page, an order confirm page, a shopping cart page and a view current orders page. The site uses an Access database with three tables. A Customer table, with all of the customer details, (FirstName, LastName, EmailAdd, CardNo, CardEx, SortCode, DeliveryAdd, Postcode) A Products table, with all the product information, (ProductID, ProductName, Price, ProductType, Images, ProductDescription). And an Orders table which contains CustomerID and ProductID. I'm trying to create an INSERT statement on the orders page so that when the customer inserts their details and presses the submit button the customers table will have a new record inserted. I also want this to create an entry in the orders table and redirect the client to the order confirm page which will display the details of the order. Here is my code which runs when the submit button is clicked on the order form. EDIT I've fixed the error with the missing apostrophe. Attempting to insert using two sql commands as I've been told that access databases can't handle two at once. Still getting an error though.
Protected Sub btnAddRecord_Click(ByVal sender As Object, ByVal e As System.EventArgs)
Dim strFirstName As String
[Code].....
View 2 Replies
Dec 1, 2010
I got a pizza shop and the assingment is to create a application which allows the user to take a customer's order... I have a combo box filled with all of the items you can order (data from an access file)... and I need to have it so that when you select an item, it shows up in a text box below... I keep getting an error message saying you can't convert datarowview to string..
Here is some
Private Sub TakeOrders_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'TODO: This line of code loads data into the 'PROJECT4DataSet.Items' table. You can move, or remove it, as needed.
Me.ItemsTableAdapter.Fill(Me.PROJECT4DataSet.Items)
[Code] .....
View 2 Replies
Aug 21, 2010
I've tried to write a code which will count the orders for each person in my users table. This is what I have but it's not working. What is wrong?
vb.net
Dim command As New SqlClient.SqlCommand("SELECT *, COUNT(Orders.Username) FROM Users LEFT OUTER JOIN Orders ON Users.Username = Orders.IssuedBy ORDER BY Users.PersonName")
View 3 Replies
May 26, 2010
I want to create a generic list - but I want to specify the type at runtime - is there a way I can do this? using reflection perhaps?Something like this...
Public Shared Sub create(ByVal t As Type)
Dim myList As New Generic.List(Of t)
End Sub
View 2 Replies
Jun 23, 2009
I'd like to create a list of an anonymous type, for example:
Dim dsResource = New With {.Name = dsResourcesEnd(index).Last_Name & ", " & dsResourcesEnd(index).First_Name _
, .StartDate = dsResourcesStart(index).Day _
, .EndDate = dsResourcesEnd(index).Day}
I have created that anonymous type. Now I'd like to add it to a list of that type. How do I declare a list of that type?
View 4 Replies
Nov 2, 2009
I am using MS Visual Studio 2005 and SQL Server 2000 to develop an application. I wish to make a list of radio buttons when I fetch a particular column from a table. for example, I fire a query that returns to me 10 types of candies, (yummy!). I want to show these candies as options on the form. I want to use Radio Buttons. Now the number of candies are not fixed, it can be any number (less than 15-20). So I wish to dynamically create this 'Array of Radio Buttons' on the form.
View 5 Replies
Sep 7, 2009
Im working with VB 2008 express
I have several pictures on my form designer and a large textbox to the right of them. When the user clicks the pictures I want a list to be created in the textbox. I was able to get a single button posted into the textbox but when a second picture is clicked it over rides it and replaces it. I wasn't sure if i should be use some kind of loop or not.
View 3 Replies
Aug 4, 2010
I am creating a List(Of String), always of size 9.This list contains True/False values. I need to go through this list and find the 3 values that are True (will never be more than 3, but could be less) and then set 3 string values in my code to the 3 index's of those values + 1.
Here is my current code:
Private Sub SetDenialReasons(ByVal LoanData As DataRow)
Dim reasons As New List(Of String)
With reasons
[code]...
I had 3 True's next to each other in the array and the code failed with an exception saying count must be positive or something.Now if there are less than 3 True's, it should set the remaining DenialReason's that haven't been set yet as blank (however they are set as blank in the constructor already to account for this).
View 1 Replies
Mar 2, 2010
I've been coding in VB.net for a while now, but still have never used the printing features. I've created a program which stores and creates customers and orders etc. I now require to print invoices related to these quotes.Is the following possible within VB.net when printing a document. Images i.e. Logo of company (which i've made already)Table of items orderedTotalshorizontal lines to split-up the design of the invoice/document.
View 2 Replies
Jun 8, 2012
I have written a small program to allow our employees to submit work orders. I want to have each computer on our network to be able to open the program, run it, and have the files (which are actually jpeg's of the form) saved on the server. This part works fine.
I have it loaded on the server and have tried to run it from several computers. While the program does run ok, it does not load the My.Settings items that are on the server. On each computer the program has, or appears to have its own set of my.settings.
If I go to the form in the program that allows me to add items to my.settings, and make changes they are saved, but when I go to the next computer they are not there. It only reflects the my.settings that were put directly in during program construction. (opened my.setting, clicked on the setting and added them there)
My question is,, how to get the program to stay on the server when running it so that the settings are there no matter which pc is running it? This is a windows forms program, I am using Visual Basic 2010 Express.
View 12 Replies
May 6, 2009
Look at the code. all i need to do is take all notes from orders table.
The connection is openned
Private Sub Load_History()
Dim myCnt As Integer
Dim myStr As String
Dim totalrows As Integer
Dim myDataset As New DataSet
[CODE]...
View 3 Replies
Mar 21, 2010
I have been trying to figure out how to get my code to work. (It was a homework assignment which has already been turned in but I am determined to get this code to work.)I have a text box titled txtSearch and btnClick.I need to search a list box for a city name and then have it displayed in a message box. If there is not a match then I need to display an alternative message box stating there is no match. City is in the list box starting at 16.The text needs to be case insensitive.I am only getting the message "That is not a valid city." for any entry that I type into my txtSearch even though I know it should be a match.
Here is what I have for code
Private Sub btnFind_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnFind.Click
' Declare variables to find text on txtSearch when button clicked
Dim length As Integer = txtSearch.TextLength
Dim value As String = txtSearch.Text.ToUpper
[code].....
View 1 Replies
Nov 7, 2010
I have an array of 26 strings from A to Z. Then, I am creating a random list of 7 alphabets from this array. Now I want the user to pick first 2 alphabets manually and then on a click it will display the rest 5 randomly generated after subtracting first 2 picked ones from the whole 26 alphabets array. how this can be achieved in lists.
View 3 Replies
Aug 24, 2010
I'm having trouble creating a global array that i can use in other functions.
I have this code right under "Public Class myClass":
Dim LoadedPlugins As Array
Then in a function I have this:
Dim PluginList As String() = Directory.GetFiles(appDir, "*.dll")
For Each Plugin As String In PluginList
Dim Asm As Assembly
[Code]....
Now obviously that doesn't work, how can I add the tmpPlugin to an array or list so I can use it in other functions?
The main thing I need to be able to do is loop through all the loaded plugins and execute the CustomFunction in a separate function than the one that loads the plugins listed above.
View 1 Replies
