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

VS 2008 Will Not Need To Update Each Component Variable Of Products List When Components List Changes

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

XML To LINQ - Get List Of All Products From XML Doc And Put Them Into A Generics List

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

Get A Comma Separated List Of The Integers In The Integer Array Levels?

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

Shop Code - List Of Selected Products Will Be Saved In A .text File

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

User Selects Number Of Products From Datagrid / Adds Them To A Basket Using Array List

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

Build A Project That Lets Users Click An Item From A List Of Products (tabbed Form)?

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

Read A SQL Server Database And Produce A Mailing List?

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

Different Levels For A BASIC Game?

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

VS 2008 High And Low Levels

Dec 15, 2009

whats the difference with high and low level of programming

View 1 Replies

VS 2008 Log-in User Levels

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

Add Data At Different Levels From Different Tables In A Database?

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

Fill A TreeView, 25 Levels Deep?

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

Sql - Creating Treeview With Multiple Levels?

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

Two Levels Of Linking In Crystal Reports?

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

Copy Datatable To Dbo.Products?

May 20, 2010

I want to copy datatable to dbo.Products

View 9 Replies

Getting The Critical Level Of The Products?

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

MySql And Order Products?

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

Add Additional Users To Application But With Different Access Levels

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

DB/Reporting :: VB Login System With User Levels?

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

VS 2010 Can DataGridView Show Multi-levels

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

Building An EShop 'Latest Products'?

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

DB/Reporting :: Get Database With Products Of Restaurant?

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

Select Most Ordered Products In SQL Server?

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

Direct Sound, Vu Project, Levels Bounce Or Change?

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

Multiple Choice Quiz With Access, Get 3 Levels Of Answers?

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

Set Up Different Levels Of Access In An Application Based On An SQL Table Of Usernames?

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

VS 2008 Drawing A Cursor On An Image WITH Alpha Levels?

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

VS 2008 Form That Will Control Audio Levels In Windows 7?

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

How To Calculate The Stock

Oct 8, 2011

Producttable : PId, Openingstockdate , openingstock , Closingstockdate , Closingstock
Despatchtable : PId, Qty , date
Receipttable:PId, Qty , date

[code].....

View 3 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved