How To Create Multi-Level IF Statement
Apr 6, 2010
In my first application I need to create a multi-level "IF" statement and I am a little lost on how to proceed. The idea is to do figure out an estimate on costs based on the quantity of products being sold. I can do this in Excel, but the VB code escapes me.
So I'll show you in psuedo code what I want to do.
IF comboBoxA = 1 and comboBoxB = 1 then
value X
IF comboBoxA = 2 and comboBoxB = 1 then
value X
If comboBoxA > 3 and comboBoxB > 1 then
(comboxBoxA * costA) + (comboBoxB * costB) = Value X
I have another IF statement that will work off the calculations here. Haven't figured this one out yet, but I haven't gotten there yet in my form.
If Value X > Y Amount then
Offer product Z as a better idea
View 6 Replies
ADVERTISEMENT
Jun 18, 2010
Let's say I have 2 interfaces defined like so:
public interface ISkuItem
{
public string SKU { get; set; }
}
[Code]....
VB.NET explicitly requires you to add Implements IInterfaceName.PropertyName after each property that gets implemented whereas C# simply uses regions to indicate which properties and methods belong to the interface.
Interestingly in VB.NET, on the SKU property, I can specify either Implements ISkuItem.SKU or Implements ICartItem.SKU. Although the template built by VS defaults to ISkuItem, I can also specify ICartItem if I want. Oddly, because C# only uses regions to block out inherited properties, it seems that I can't explicitly specify the implementing interface of SKU in C# like I can in VB.NET.
My question is: Is there any importance behind being able to specify one interface or another to implement properites in VB.NET, and if so, is there a way to mimic this functionality in C#? Furthermore, what is the effect of specifying one interface over another when implementing properites?
View 3 Replies
Jun 18, 2010
This question is a follow-up to my last question with a reference to COM Interop. Let's say I have the following 2 interfaces and implementing classes:
[Code]...
Interfaces are important in COM interop for exposing properties and methods to IntelliSense in the VB6 IDE (per this article). However, because ICartItem is inherited from ISkuItem, SKU is not explicitly defined in ICartItem and thus is not visible in IntelliSense in VB6 and even throws a compiler error when trying to write to objCartItem.SKU.
I've tried using Shadows and Overloads on the SKU property in ISkuItem, but then the compiler wants me to explicitly implement SKU for both ISkuItem and ICartItem within the CartItem class. I don't think that's what I want. Is there a way (in either VB.NET or C#) to explicitly declare the SKU property in ICartItem without having to declare SKU twice in the CartItem class?
View 2 Replies
Dec 18, 2009
I want to make multi level side strip with some data as shown in figure below:
The first column could be labels (names) read from an array or a variable and the second column could be a value to that label read from a variable or array. The value of the last column will be assinged to the label or in the first column. for example:
Column1 (level1) Column2 (Level2) Column3 (Level3)
Area1 => Value => 5
8
Importance => 9
[Code].....
View 3 Replies
Aug 13, 2011
I can create a Custom UserControl with simple properties (Integer, String, etc) and have those properties show up in the Property Panel. I can also create a Custom UserControl with properties like Size, Rectangle, etc and the properties will show up as an expandable item in the Property Panel (click on the '+' and the Size expands to Width & Height).
Is it possible to create properties with my own custom structure? e.g. Property 'Message' expands to Text, ForeColor, BackColor, Blink etc. I have tried creating a property that references a simple class or structure with containing the properties representing my custom structure but in the Property Panel the property is greyed out and cannot be expanded or modified.
View 1 Replies
Oct 25, 2010
The first list box contains the project name. Based on whatever is selected in the Projects list box, the 2nd list box is generated with Custodian names associated with that project. I am having problems generating the 3rd list box. This holds the data sources associated with whatever is selected in the 2nd list box (Custodians)
View 1 Replies
Aug 25, 2009
With the following code I only can add until second level node... If wan to add more level in child node?? I want to add child node to "UOM" node??
TreeView1.Nodes.Add("Maintenance", "Maintenance")
TreeView1.Nodes("Maintenance").Nodes.Add("2", "Item Group")
TreeView1.Nodes("Maintenance").Nodes.Add("3", "UOM")
View 4 Replies
Feb 22, 2012
I've got this code
Public Class Form1
Dim m_listener As HttpListener = Nothing
Dim m_asyncCount As Integer = 0
[code].....
View 8 Replies
May 12, 2011
I know you can alias an Imports statement in
Imports xyz = ProjectABC.ClassABC
But if I want to use the Project Properties, Reference tab to select a namespace to allow a project-wide setting, is it possible to alias that namespace?
View 4 Replies
Nov 27, 2008
Define a structure named product, The structure should contain 2 variables one as a string and the other as a decimal. The decimal is used to store the price and the string is used to store the item number.
Declare a module level array that contains 5 product structure variables
Code the main forms load event procedure so that it reads the item number and prices from the itemInfo.txt file The procedure should store the item numbers and prices in the module level array. It also should add the item numbers to the list box.
When the user selects an item in the list box the items price should appear in the xPriceLabel. code the appropriate procedure.
The code I have is as follows
' Project name: Glovers Project
' Project purpose: The project displays the price of an item.
' Created/revised: <your name> on <current date>
[Code].....
Seems the problem I am having is this line is returning a value less than 0.
itemprice = (itemnumber.Substring(productIndex, newLineIndex - productIndex))
View 4 Replies
Dec 14, 2009
May i know how to change my below login code to support for multi access level login? So that i can differentiate between manager and normal employees login so that i can enable or disable certain features for different department? I have the below code that can serve as a basic login.
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
'login code can work
conn.Open()[code]......
View 5 Replies
Mar 25, 2010
I've only dealt with firing a single SQL statement at a SQLServer table and returning a single result... easy....
however....
is there a way to fire a dual sql command and load the results into respective tables within a dataset?.. I'm thinking something along these lines (this code of course does not work)
Dim ds As New DataSet
Dim dt1 As DataTable = ds.Tables(0)
Dim dt2 As DataTable = ds.Tables(1)
[Code]....
View 3 Replies
Sep 18, 2009
Is there a way to create my applicationSettings at the solution level? I have several projects that need the same settings, that someone before me hard coded so was wondering if there was a way to do this via a config file?
View 2 Replies
Aug 16, 2011
I have a program that I would like to create application-level MouseEnter and MouseLeave events for. Basically I have an app that I'd like to leave open that would be very opaque when not in use, and when the user moves the mouse anywhere within the bounds of the application, it becomes solid, and when they move their mouse away from the application, it becomes opaque again.
The obvious problem is that MouseEnter and MouseLeave are control-specific and so they fire every time you move over a button or menu or whatever, so Leave and Enter are constantly firing even though you haven't "left" or "entered" the application.
So, is there any way to create mouse events that only fire at the application level?
View 12 Replies
Apr 10, 2011
i don't want to use the system date and time in my mini project.i want to create my own system date and time to be in sync with standard time i specify?
View 3 Replies
Aug 12, 2009
Does anybody know where to find a toolbox for Visual Basic 2005 or 2008 that allow to create level, button, display or other special box used on a bridge of a ship? I want to simulate a small bridge of a ship and I need something that allow me to display engine power, rotation speed, level of pressure, compass and so on.
View 6 Replies
Nov 30, 2011
To create a program that asks for input then uses an else statement to create a handling fee balance.
Input: sales record - first name, last name, purchase amount, balance before purchase
Output: report - full name, old balance, purchase amount, handling fee, new balance
Definitions: handling fee is 5% of the old balance if the old balance is less than $1000.00 else it is 2% new balance = old balance + purchase + handling fee
Processing:
Ask for and receive sales information
Calculate new balance
Print output report
End the program when a purchase amount of 9999.99 is entered
View 3 Replies
Apr 1, 2012
I am creating an Excel add-in written in VB.NET. I would like to bind KeyDown and KeyUp events to the spreadsheet to record when the user presses and releases the arrow keys while navigating the spreadsheetIdeally, these events would be built into Excel alongside the native SheetActivate and SheetSelectionChange events, for example. Alas, they are not.
View 1 Replies
Oct 7, 2008
I try to create a form that managing the access level of user management system.The model I use is the following :I create a connection to database I create a DataAdapter to transfer the data from the database I create a Dataset to hold my data My form consists of the following :A ListBox that list all the access level namesThree text boxes: the first for the record ID The second for the access level name And the third for the discription of the access level Five check boxes:One for writing rights One for the deleting rights One for the Updating rights One for Printing rights And one for Special area access rightsSo what i do is the following :I create a connection string I create a new connection to my database server I create the DataAdapter I initializing the DataAdapter command such as SelectCommand, DeleteCommand, e.t.c.I fill my DataSet with the data DataAdapter get from DataBase I binding my controls to DataSet I setting the DataSource property of the ListBox to my DataSet I setting the DisplayMember to the ACCL_NAME column of the DataTable inside the DataSet I setting the ValueMember to ACCL_ID column of the DataTable inside the DataSetUntil this time all are fine ! ! !The question is :When i try to add a new row to dataset by using the following code i have a problem :
Dim newRow As DataRow = Dataset.Tables("TableName").NewRow newRow("COLUMN_NAME") = Binded Control Value DataSet.Tables("TableName").Rows.Add(newRow)
View 3 Replies
Aug 12, 2009
Does anybody know where to find a component for Visual Basic 2005 or 2008 that allow me to create level indicator, button, display or other special box used on a bridge of a ship? I want to simulate a small bridge of a ship and I need something that allow me to show engine power, rotation speed, level of pressure, compass and so on.
View 1 Replies
Jan 6, 2010
In Visual Basic 2008, there's two different ways that I know of to accomplish the same thing:The Dim on the member level:
Dim counter1 as integer = 0
Dim counter2 as integer = 180
Public Sub SampleSub1()
[code].....
View 1 Replies
Sep 7, 2010
How do I create a multi dimensional array in visual basic. For example I have a soccer team with players. Each player has an id, first name, last name, address, phone number. How would I represent this using a multi dimensional array?
View 1 Replies
Sep 18, 2009
I am new to programming. I know how to create simple windows app using VB and Sql Server/AccessDB. My question is this: Can my windows app be ran on a LAN or do I have to create a special multi-user app for a LAN? If the answer is yes, can someone please guide me on how to create a LAN/Multi-user app.
View 2 Replies
Jun 26, 2011
I am planning to make a multi-user chatroom client. I have got a web hosting, but I don't have the server. I want to know how to create the chatroom from my webhost and what type of method that I would need to connect it?
View 3 Replies
Feb 19, 2009
I need to create a multi user VB.Net application that connects to Access 2007 and has 2 forms. How do I go about it? Please give me a start up.
View 6 Replies
Mar 30, 2012
who can clearify more about how to link the relationship between a Local database to ComboBoxes as an example below:
1. ComboType: it will show only kind of audio file extension
2.ComboCompany: will show only the music company name we added
3.ComboVolt: will show of album volt
How it work
If we've selected the ComboType Ex: mp3 file then in the ComboCompany After we have selected with any album name.
The last result is in ComboVolt the number of volt will show up base on we have selected the name of any company name in ComboCompany.
[Code]....
View 4 Replies
Nov 24, 2010
Background: ok I have an app that hides in the system tray. During its operations in the background it can try to invoke an outside app several times.. and I need to track when the call errors out.. I was using messagebox's but for some reason if the app hidden the messagebox's dont come up and goto the forefront. So in reading about this I read I should just use a form to do it.. so I did.. works fine.. well works fine for one error.. but if the user tries to do 3 of the same operation.. and lets say first errors.. second works and third fails.. using one error form wont work.. since I diaplay the error one.. then need to display error 2.. I need 2 error forms so they can click OK on both.[code]...
View 2 Replies
Mar 18, 2011
I have created a simple program which uses a two tier structure of SQL Tables.At the top level, one record holds the date of the activities and linked to it using its primary key as a foreign key, three subordinate tables hold time stamped records.The issue I have been unable to solve is that before adding any of the lower level records for a given date, a newly added top level record must be saved to the database.Doing this manually is simple - but can I rely on my users to remember to do this before they start plugging in the lower level data?I thought not, so I am looking to save the top level automatically.I've failed miserably but I refuse to believe that it's not possible.
View 14 Replies
Feb 23, 2009
If i want to create a vb.net windows application in multi-language (EnglishArabic). Is there any steps i need to do?I installed the Arabic at my windows XP and I am able to write the labels and the the textbox for example in arabic but is there a way for the controls to shifts automatically?
View 7 Replies
Feb 27, 2009
i have a function to export data with some loops now the problem is that when he is exporting the data the program stop responding and only respond when the job is done, and i need a option to cancel the job when it is running but the problem simple block all forms that is opened how can i creat some multi task for fix that problem?
View 1 Replies
