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 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'm looking at creating something similar to a POS system for a restaurant with a floorplan editor, just a pet project to try something new and exciting. Anyway, what I want to do is make a form that the user can create a floor plan of their restaurant on. This will include them creating simple walling layouts so they can map out the size of the room and adding tables. This would be similar to those house design software packages where you create your house, but only the flat 2D design. Would it be as easy as instantiating new image controls and dropping them on the form etc?
View 3 RepliesA restaurant wants an application that calculates a table's bill. The application should display all the menu items ( shown below) in four ComboBoxes. Each ComboBox should contain a category of food offered by the restaurant (Beverage, Appetizer, Main Course and Dessert). The user can choose from one of these ComboBoxes to add an item to a table's bill. As each item is selected in the ComboBoxes, add the price of that item to the bill. The user can click the Clear Button to restore the Subtotal:, Tax:, and Total: fields to $0.00?
View 5 RepliesTrying to create a restaurant bill, i found a program that does something similar but when i tried to adapt it, it doesnt do what it is supposed to.Let me go over what it's supposed to do first.If there are three items on a menu, lets say; pizza, fries and drinks. the pizza costs $1.75 a slice, the fries are $2.00, and the drinks are $1.25. the user selects how many of each are purchased, then presses a 'compute' button and displays a bill in a listbox. here is the code i wrote for such a program, obviously wrong or it'd be working.
Public Class RestaurantBill
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnCompute.Click
[code]....
I'm making this POS software for a restaurant and I was wondering what the best way to create the button interface for the items since it's going to use a touch screen monitor.
I was thinking of adding the buttons at runtime to solve the excess space problem, and also add the code at runtime, but that seems like too much work, so I thought I should ask if there are any other ways to approach the problem?
[Code]...
and Send me some codings for a restaurant management system project using any programming language preferably VB6,VB.NET,PHP&MYSQL,HTML with Javascripts[i][color=#000099][size=3][font=Times New Roman]
View 2 RepliesIm doin my school project on taking order system(POS) in a restaurant using VISUAL BASIC?the word visual basic is very new for me...i already do some of the coding,this system not using database,just a simple POS system..When i insert y(for yes),msgbox for order_code and order_quantity apear.but when i insert n(no),msgbox for order_code and order_quantity apear again for one time then stop.then msgbox for calc2 pop out but the value isnt right..calc2 also calculate the order_code and order_quantity,the one that apear after i strike no.
[Code]...
For i = 1 To 60
Me.Controls("picturebox" & i).BackColor = Color.White
Next
i want to change backcolor of picturebox but when i run program,i get this error :
An exception of type 'System.NullReferenceException' occurred in EZEE Restaurant.exe but was not handled in user code
Additional information: Object reference not set to an instance of an object.i go to Project->Add reference and then look for "System.NullReferenceException" but i don't find it.
I want to move my programs and the database to another computer and hard-disks. It looks to me as though I nearly have to re-create the controls and rewrite some of the code to make it so the programs still work after the move. At least with ODBC all I would change was the DSN definitions external to the programs. Is there an easy way to move or rename a database without loads of work?
View 3 RepliesI am trying to copy a table from a network database to a local database. I used DAO and could check if the network table existed using a function that tried to assign a TableDef object to the table in question. If there was no error then I assumed that the table existed and the function returned true...Or it would error out and return false.I could then proceed with the copy or not as the case may be.I am converting the code to ADO.net and need to know how to check for a table. [code]
View 1 RepliesRecently working in vb 2010 express. I'm using service-based database which is based on SQL Server. This database will be deployed at the server. Is it possible that multiple vb.net programs, which are installed in remote computers or client computers in the same network, connect to this database simultaneously? Does the service-based database support multiple connections?
View 1 RepliesI 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 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 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 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 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 need to programmatically add a row to a MS Database.How is this done?
View 2 RepliesI don't actually know if I can use any XML file as a database that I can edit and make some changes to it using vb.net 2008 and save them. Because I'm working aboard a war ship and we have a central automatic system to control all the internal communication using standard telephones. to reprogram the extinctions we used to have a MS DOS program and it's so old and now it's totally lost and not found and after a long searching I have found a file that could maintain the extensions and reprogram the system but it's an XML file.
[Code]...
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]...
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?