Produce A List Of Products Stcked With Their Initial Stock Levels?
Jun 19, 2011
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]...
View 1 Replies
ADVERTISEMENT
Sep 21, 2010
I think (?) this is about object design, and perhaps about structural and/or creational patterns. But a bit hard to say when I only know a couple of patterns yet.[code]But... what if we INSTEAD want each Product instance only to (in some way) refer to one instance of a specific list of Components. So we wan't to save the products list to one file, and the components list to another file. Then would I build the objects the same way, or different? So let's then say we have now Class B as below. [code]
1. Will not need to update each component variable of the products list when the components list changes.
2. If the Product object shall be shown in a DataGridView, for editing properties, it seems easier to implement the selection of the component property.
Is this wrong approach? Is it suitable in some cases, and if so, when? Are there other solutions I perhaps am not aware of that would be appropriate? Is this about structural design patterns? and if so, can the alternatives above be catagorized to some pattern type? I don't really know exactly what I'm looking for.. But I think probably I'm looking to understand whether the object design will be determined by the way the objects are saved.. And if i shall save the objects by serializing to file, vs saving to a database, would I create the business objects differently?
View 4 Replies
Jun 30, 2009
I'm basically brand new to LINQ. I've seen some examples that allow me to strong type objects using LINQ but I don't really understand them because they're in C#, which I guess lets you do different things with LINQ(I think?). [Code] I just want to get a list of all the products from the XML doc and put them into a Generics list.
View 3 Replies
Feb 15, 2010
What is the simplest/best practices way to get a comma separated list of the integers in the Integer array levels?
Dim levels(5) As Integer
Dim levelsStr As String
'put values in levels'
[code].....
View 2 Replies
Jul 31, 2008
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:
View 3 Replies
Jun 8, 2012
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 Replies
Feb 10, 2010
Trying 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 Replies
Jan 4, 2012
I'm trying to create a VBasic executable to read a SQL server database and produce a mailing list.I have the SQL routine working fine and had set it up as a stored procedure, but I've just discovered the manager I've written this for is an Access-type and does not have SQL Server installed on her machine. So, I figured I'd make a front end in VBasic.
Dim con As New SqlClient.SqlConnection
con.ConnectionString = "Data Source=mySQLServer;User ID=Username;Password=myPass;"
con.Open()
View 3 Replies
Jun 15, 2010
I'm trying to make a game in Visual Basic, but I can't figure out how to add in different levels.
Essentially, what I'm looking for is the Tab Control, minus the tabs. On a different note, is there a way to make a group of controls? Like instead of
TextBox1.Text = "Hello"
TextBox2.Text = "Hello"
I could have something along the lines of TextBoxGroup.Text = "Hello"
View 5 Replies
Dec 15, 2009
whats the difference with high and low level of programming
View 1 Replies
Jan 10, 2010
i have a login form and it has 3 user levels - admin, manager & accountant - which have limited privileges using the system. For ex., if admin logged in, this user can access the whole system; if manager logged in, this user can only access the employee records; & accountant user can only access the payroll.
i actually have the idea but because i lack knowledge about vb.net, i don't know how to code it.
[code..]
At the main menu, buttons are enabled & disabled depending on the user level that was entered.
View 2 Replies
Jun 12, 2009
hello everyone, i m using treeview control in vb .net . How do we usee a recursive function to add data at different levels from different tables in a database.
View 2 Replies
Jan 12, 2010
I'm looking for a recursive subroutine.I have the dataset from sql-server with in the datasource-table a parent- and a child-column.
I made a routine to put the parent-nodes in the tree.The problem starts with the childs over so many levels.I can write it out but it is to much code, I'm sure it can be done more efficient with a recursive subroutine.
.tv_Ana.Nodes(A).Nodes(B).Nodes(C).Nodes(D).Nodes(E).Nodes(F).Nodes(G).Nodes(H).Nodes.Add(Trim(sLev_nI + "-" + row_nI("MidCod").ToString()))
The tree will be about 25 levels deep.A few days ago I saw a recursive subroutine to fill the childnodes without the above difficulty to write alle the levels in code.That example I cannot find it any more, but it had a line of code more or less like this here below:
Dim
Nodes As TreeNodeCollection = tv.Nodes(A).Nodes
but it doesn't work yet!
View 5 Replies
Mar 20, 2012
I have a requirement to create a multi level treeview in ASP.Net (with VB) but I am completely stuck on how to start this. Currently my treeview is a fixed 2 level approach but now I need to rewrite this to be more dynamic and support extra levels being added into our database tables.So this treeview needs to support as many levels as needed without having to rewrite any code each time we want to add new level, Ideally we will just insert the data at the database level.I think I have the database part designed correctly, I created 2 tables Menu and MenuItemsMenu has 2 columns ItemID and ChildIDMenuItems has 2 columns ItemID and Description Doing this query:
SELECT
menu.Item_ID,
menu.Child_ID ,
[code].....
View 1 Replies
Jan 30, 2010
Let's say I have three lists: Departments, Divisions, and Groups. A Department is made up of Divisions, which in turn is made up of Groups.The Divisions have the Department ID as a foreign key. The Groups have the Division ID as a foreign key.I'd like to produce a report that looks like this:
[code]...
But since I can't include a subreport within a subreport, I'll need to go about it some other way. Is there a way to do this?
View 1 Replies
May 20, 2010
I want to copy datatable to dbo.Products
View 9 Replies
Feb 2, 2012
[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 Replies
Mar 15, 2012
I 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]....
View 1 Replies
Jun 21, 2010
i'm developing an application with vb.net and mysql. I want to add additional users to the application but with different access levels. this is my original code [code]If i add a third parameter named level to the sql statement, how do i determine which form shows???
View 3 Replies
May 15, 2008
I need to create an application that allows staff members to login and see different things.I need to be able to have different user levels for this so that certain staff can see some things and other staff can't.I would like the login system powered by the MS SQL Database that the rest of the programs data is stored in.
View 4 Replies
May 22, 2012
I want to use a DataGridView to show parent-records that are expandable to show children records. Basically, the top-level data shows class names, and expanding each class name shows the students enrolled in that class... that kind of thing.
View 2 Replies
Apr 2, 2012
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].....
View 1 Replies
Oct 4, 2008
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 Replies
Feb 20, 2012
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
View 1 Replies
Feb 4, 2011
With a steady tone feeding my audio input jack, the VU meters jump and bounce about 30%. I can also see the problem in the byte array of the capture buffer. I am running 8 bit mono so there isn't a chance that I'm getting a byte swap in a 16 bit word. My on board sound card is "Realtek HD Audio Input", direct sound 1.0.2902.0 and XP. Here is the real kick in the head, if I run anything that captures sound using the winmm library or if I use the winmm library in my application along with direct sound, the meters become stable. No errors are reported. Although I have written this in vb.net, I download another persons application that was written in C++ that uses direct sound with the same bouncing meters. I used the VU meters in Audacity to look at my audio levels and they are stable.
View 2 Replies
Nov 22, 2011
I am working on a multiple choice quiz, admin screen, student login screen where they choose their level of difficulty. I have been able to start the quiz, have the questions and answers filled, user answers question, check if correct or not, if correct then the score is incremented.I am able to set up a variable for 'level' and want to write some code so that whatever is selected then that table / questions will be selected and displayed to the user.
The way I'm thinking at the moment seems very long winded. I think I'll have to write an IF ELSE statement/case statement for each of the 'navigaterecords' and the sql statment for beginners, intermediate and advanced.Assume there is a variable 'LEVEL' - have not actually done this yet. Where the code refers to 'advanced' is where I have been trying it out to select questions from the advanced table.
Imports System.Data
Imports System.Random
Imports System.Data.OleDb
[code]....
View 8 Replies
Sep 2, 2011
I want to make different levels of access for a vb.net program i'm writing.I have a database called "stratocast". I want to show a specific form for entries in this table with "IsManager" checked and another specific form for those with "IsAdmin" checked.Im using MySql server and visual basic 2010 express
EDIT:To clear up any misconceptions about my post, ill explain further: In my vb.net application i have a login form with two textboxes; One for the username and one for password. I also have three other forms, one is called "frmAdmin", another called "frmManager" and another one called "frmEmployee".
On my database i have a table called "employee" with columns called "name", "title", "IsManager", "IsAdmin", "Username" and "Password".
IsManager and IsAdmin are both Boolean columns
This means that their values can only be 0 or 1 and the result is displayed as a checkbox.When the employee logs into this applcation i want it to check whether or not the employee is a manager, an administrator, or just a regular employee with no additional rights. If the employee is a manager, i want to show "frmManager". If the employee is an Administrator i want to show "frmAdmin". And if the employee has no additional rights then i want to show "frmEmployee".
I'd like to keep the configuration for access level checking confined to the one table but if it's better to have separate tables for each level of access (ie: tables called Admin,Manager, and Employee) then ill consider that too.
View 2 Replies
Feb 21, 2010
I am using Cursor.Draw to draw the default cursor on an image however this does not draw the alpha levels - they just draw the alpha pixels with a black backing how can i draw a cursor to an image and KEEP THE ALPHA channel?
View 1 Replies
Apr 8, 2010
I have my forms all set up, I want a button on my main form that says Volume. When clicked it either opens a window above the current form with a volume control. Or opens another form that has the volume control in the center. When the slider is moved up to 100% windows is at 100% volume, when moved down windows volume moves down also.
View 3 Replies
Oct 8, 2011
Producttable : PId, Openingstockdate , openingstock , Closingstockdate , Closingstock
Despatchtable : PId, Qty , date
Receipttable:PId, Qty , date
[code].....
View 3 Replies