Database And Report Methods - Recording Orders?
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
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
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
Nov 15, 2011
I am developing a Windows Forms Based Application using dbo.database and Visual Basic: I populate some Orders in DataGridView1 using LINQ 2 SQL from "tbl_Orders" where OrderStatus is "Pending". I change OrderStatus Column Type to "CheckBox" in DataGridView, Now I want that when I select some records (Orders) by checking respective checkboxes and click on "btn_UpdateStatus" Button, program pick OrderID's of only selected orders and update OrderStatus of Only selected Records (Orders) from "Pending" to "Completed" in Database Table "tbl_Orders" and DataGridView1 should be Refreshed. [code]
View 1 Replies
Sep 5, 2009
I have this problem for some days now and i did not figure it out yet.When i use 2 buttons one for recording and one to stop recording is just fine, but when i use a timer to stop recording does not stop.
Here`s my First i have a button named start recording which calls the Public Sub record and enables timerRecordStop to TRUE.
[Code]...
View 9 Replies
Apr 26, 2010
I created a button instead of the print button in crystal report because i need to record the report printed report serial number, date and time to the database. when i click on the button, dialog box appear. if i click on the ok button , system record the printed report details to the database and report printed successfully. but when i click on the cancel button , system again recording the printed report record.
[Code]...
View 8 Replies
Apr 13, 2011
I've read jmcilhinney's code bank submission on retrieving and saving database data and have been using this a lot.
What i would like to know now is how/if i should be using the built in VS method of databinding with bindingsource, bindingnavigator and dataset controls etc for anything?
What can i do better with this method and what are the limitations?
Also, i'm using a function that reads an ini file to set the path in the connection string, can i still do this using the data binding method?
I've read a fair bit on using databases with VB but the above is still a bit confusing to me.
View 2 Replies
Aug 29, 2011
This is the original code in c#
public class CategoryRepository: RepositoryBase<Category>, ICategoryRepository
{
public CategoryRepository(IDatabaseFactory databaseFactory)
: base(databaseFactory)
[Code]...
Does anyone has an idea what i should change to let it work and let my UserRepository use the methods in RepositoryBase while implementing the IUserRepository?
View 1 Replies
Feb 26, 2011
I'm using Visual Studio 2010 Express running on Windows 7 64-bit. I get the same error as detailled in this link [URL] .I need to work with some data to develop the system. I think I can only do this by changing the Copy to Output Directory file property to "Copy if newer" to prevent the debugger from losing it.However this causes TableAdapter.Fill to exit from the sub immediately after executing leaving behind the other code in the form "Add_Load" routine.
View 1 Replies
Jun 24, 2011
I am working with a vb program, but there is something strange on one of my .vb code pagewhen i put the "dot" afther the object name its dont show the methods availables for this objectbut on other vb code pages i can see it. but in this one no.for exmaplethis is a piece of code: Dim sb As New StringBuilder()
View 3 Replies
Mar 29, 2010
I am not sure how clear my question is by the title, but I am trying to make Class methods instead of Instance methods in Visual Basic that way I don't have to waste memory and code creating temporary objects to execute methods that don't need instance variables.
I am not sure if you can do that in VB but I know you can in Objective-C by using either a "+" or "-" sign in front of the method declaration. And in C++ (at least I think, I can't remember) you put the static keyword or const keyword in front of the function.How would I do this in VB if it is possible? Or should I just make a separate set of functions that are not members of a class?
View 2 Replies
Apr 19, 2011
how I can reference a report variable in the Report Properties Code Window of a local report? I have tried Variables!Claimant.Value (for a variable called Claimant) but I get an error "Reference to a non-shared member requires an object reference." I have tried qualifying it with Report. and also with the report name in front of it but I get errors with this also.I have the variable CLaimant defined in the Variables section of the Report Properties.
View 3 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 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
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
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
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
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
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
Aug 12, 2011
i am new beginner of visual basic, could you give me step by step to generate report using visual studio 2005 and my database is sql 2005.currently i am using a windows aplication..
View 1 Replies
Jan 2, 2011
i am in need of a little help. Is there a possibility to create a layout or report without connecting or using a database. Here is what i mean, i am building a very simple app with 2 textbox and a button. Winforms. i want to connect the text i type in the textbox to the template i created and when i click the button it print the template. vs2010 vb.net.
View 2 Replies
Feb 7, 2012
Anyone who give me a reference how to query the sql to SAP crystal report?
View 2 Replies
