Setup A Customer Collection Class That Has One Function?

Jan 15, 2012

I am having trouble setting up these classes.I need to set up a customer collection class that has one function GetCustomer(ByVal customerNumber As Integer) As Customer..The customer class reads a file and returns 5 fields and x number of records.My question is do I set up the 5 properties (fields) in the Customer class and if there are 10 records that match how do I return the customer object to the customer collection class. I don't care about exact syntax but could someone show me how these 2 classes should look?

View 2 Replies


ADVERTISEMENT

Customer Class - Return Array In Function?

Apr 12, 2009

I have a class called Customer. It has some property like custID,custName..etc. Inside Customer class I have a function which returns an array of customer.

I wrote a function like this :
Public Function InitLoadCustomerDetails() As Customer()
sql = "SELECT* FROM tblCust"
ds = classDC.queryHandler(sql, "InitCustomerDetails")
Dim customerArray(classDC.maxrow - 1) As Customer
Dim currentCustomer As New Customer
[Code] .....

But it is not returning an array. Just a customer variable??
Public Function InitLoadCustomerDetails() As Customer()
Return customerArray
End Function
Fix this to return an array of customer!!

View 10 Replies

Datatable Object Within Class Function + Garbage Collection?

Oct 6, 2009

Datatable object within class function + garbage collection?

View 3 Replies

Procedure Or Function 'Get Customer Data' Expects Parameter

Jun 10, 2011

This is the error when i try to execute my code "Procedure or function 'Get Customer data' expects parameter '@Name', which was not supplied."

objCommand.CommandType = CommandType.StoredProcedure
objCommand.CommandText = "GetCustomerData"
Dim ObjParam1 As New SqlParameter("@Name", SqlDbType.VarChar, 2000)

[Code].....

In debugging, i c the value in ObjParam1.value that I'm passing.

View 2 Replies

LINQ To SQL Query - Select Customer From Dropdownlist And Then Gridview - Load All Items Of All Orders Of That Customer

Oct 4, 2011

I have the following problem: I select a customer from a dropdownlist and then the gridview should load all items of all orders of that customer. I have the following query:

Dim allorders = From ord In db.Orders

Where ord.CustomerID = Convert.ToInt32(CustomerDropDownList.SelectedValue)

[CODE]..............

I also tried to modify the query as follows:

Dim orderitems = From oi In db.OrderItems

Where oi.OrderNumber = (From From ord In db.Orders

[CODE]...........

But this does not work. I just started using LINQ.

View 5 Replies

Using Microsoft Acres Database - Table Named Customer Info To Store Customer Details When Registering

Oct 5, 2011

A registeration sys using a Microsoft acres database I have a table named customer info to store customer details when registering and I need coding that will add the following to my table customer I'd , firstname, lastname , phonenumber and user also has to make selection between radio buttons male or female.

View 2 Replies

Creating A Class That Searches A Binary File For A Specific Customer Number

Jan 4, 2012

I am creating a class that searches a binary file for a specific customer number. I am using a binary search that keeps on slicing the file in half until I find the customer number while is sorted. Once it finds it I am positioning it at the first instance of that Customer number as there can be multiple records with the same Cus Number.

Now here is my question. I now need to loop through this Customers records and do some data base searches. Since I want to make my class as generic as possible what should I pass back to the calling class? An Array with all their records. If I do this I have to loop twice, once in the class and once when it passes the array bac to the original calling class?

[Code]....

View 20 Replies

Autocomplete Customer Surnames Direct From The Customer Datatable?

Jan 5, 2010

I am trying to autocomplete customer surnames direct from the Customer Datatable, using the code below which I got from another thread, but nothing is happening.

[Code]...

View 6 Replies

Adding A List (of Class) Or Collection As Another Class's Property

Apr 2, 2010

I'm looking for a tutorial on how to Adding a list(of Class) or Collection as another Class's Property.What I am after is something like the Columns Collection for the DatagridView control.I would like to add Items in the graphics screen. Where the item list is displayed in the left panel and the selected Item properties are displayed in the right panel.

View 4 Replies

Base Class Collection With Sub Class Objects

Jul 19, 2010

[code]The reason that this is a problem is that this is a collection of EventBase objects, but I'm trying to populate it with child classes instead. For example, I might have a JumpEvent class that inherits EventBase, and this is being put into the EventBaseCollection. That means that value.GetType() returns the type of JumpEvent, which as you might guess does not equal the type of EventBase.The goal of course is to simply loop through all of the various events without having to know anything about the sub-classes. Is there a way to determine the type of the base class so that the OnValidate call will work? Or is this just the wrong way to go about it altogether?

View 2 Replies

Passing List / Collection From Class To Class

Apr 28, 2009

I seem to have problem with passing a collection/sorted list/ list of strings from one class to another.I am using property procedure to pass it, however nothing is sent to another class. There isn't any error messages either.[code]

View 3 Replies

DB/Reporting :: How To Setup A 'Library' Function

Dec 23, 2008

I'm working on a Free, Open Source Multimedia player. I'm hoping if I do it right, I can have it beat out WMP and iTunes. As this is the case, I'm trying to program the whole thing without connecting to either WMP or iTunes through COM or ActiveX, and not use any of the .dlls.One of my current problems is that I can't seem to figure out how to setup a "Library" function. What I'm thinking right now is I want to setup a database, and then connect to it. I was able to create a Local Database, and setup my Table and Fields, but I don't know how to connect to the database; I figured out how to create a new instance of the table, but those get deleted as soon as the program is closed.If anyone has a suggestion on how to do this, or a tutorial they can point me to, that would be fantastic. My only stipulation I have is I'd like to be able to use SQL searches on the database, to make searching for song faster.

View 3 Replies

VS 2008 Best Way To Setup Class?

Nov 29, 2010

I have a Class that will automate processes based on a set of variables. I have a finite number of boolean variables. If True, the process will run, if False, it won't.If a variable is True, I'll add it's corresponding process to a Queue of processes.What I'd like to know, is how should I setup the processes? Should it be in the new class or form class? Should it be at class level or not?

I was thinking I could just setup each process at Class level:

VB.NET Private p1 As New ProcessPrivate p2 As New ProcessPrivate p3 As New Process

Then, before the process is added to the Queue, I'll assign the appropriate properties.

Is there a better way? Or will this work just fine?

View 1 Replies

Bug In Collection Class VB?

Aug 16, 2009

The following code creates a Collection where every Item is assigned a value equal to the last item added. At the end of adding for example seven items all the entries are identical to the last one added, although each has the correct key

The parameter passed to the function - aCOA() - is a comma delimited string of three strings.

The code is as follows
Public Function myCOA(ByVal aCOA() As String)
Dim thisCOA As New Collection
Dim keyCOA As String

[Code]....

Is this a bug in the code or in the Collection Class. I have traced the operation of the code and all seems OK until the second entry is added at which time the first entry Item get the same value as the second entry Item and so on.

View 2 Replies

Collection, Class .. Which Is Best For Example

May 25, 2009

I have worked some with classes and collections in the past but seek some direction before I start on this project as to the best method to use.I will be reading 20,000 or so lines from a text file. partno, desc and loc Each will contain 3 elements to be collected and stored temporarily.There are 2 results that I desire that relates to selling of products

First Result: Sorted list of most used partno, desc
2,234 partno (most sold)
1,345 partno (2nd most popular)
etc.

2nd Result: Sorted list by specific loc., partno, desc
loc. 45 - 234ea partno, desc
loc. 45 - 143ea partno, desc

Maybe end up with the top 500 selling products in the list. This data will then be added to a dataviewgrid for printing and then deleted.So, to temporary store and sort should I use some type of collection or classes? I know how to fight my way to either but which would be the best method?

View 3 Replies

Setup USB Function At Visual Basic 2008?

Mar 8, 2010

i want to create a GUI which content a button and when the button is clicked, a signal B'0000 0001' send out through USB port.

my pc already can detect my hardware through USB port.

So, i just want to know how visual basic 2008 setup USB port function.

View 1 Replies

Composite Key With Class Collection?

Jun 17, 2011

I want to be able to get an instance of a class based on two fields in that class. I was hoping to use something like a dictionary, because I thought indexing would be the best for performance. Should I just use LINQ or go back to a strongly typed dataset? Here's an example of what I'm trying to do[code]...

View 2 Replies

Create A Function To Return One Database Row In A Collection

Mar 4, 2011

How would I create a function to return one database row in a collection, such that the rows column name & value are stored as key/value pairs in the collection?

View 5 Replies

.net - Set An Incrementing ID Property To A Class' Collection?

Nov 15, 2011

I have some nested objects arranged like this:

Process
Persons
Workflows
Tasks

So you have one Process. Then multiple Persons can be added to and multiple WorkFlows can be added Process as well. Multiple Tasks can be added to each WorkFlow but I need a way to tie which Person is doing each task. I basically need a way that for each Person added to the Process it, in it's constructor, assigns a Person.ID property that can then be assigned into each Task's PersonID property...

Dim myProcess as New Process()
Dim myPerson as New Process.Person()
myProcess.AddPerson(myPerson)

[code]....

View 2 Replies

2010 Collection Class Oddity

Sep 28, 2010

I converted a project from 2008 to 2010 to be able to use the TPL.I've updated the compile target to .NET 4. Everything seems good, including the .NET 4 specific TPL stuff...except that:[code]

View 7 Replies

A Property In A Class Is A Collection Of Objects

Jan 29, 2009

Thought I had got this sorted earlier but unfortunately not. A property in a class is a collection of objects.

[Code]...

View 4 Replies

Getting An Error With  A For....Each Loop For A Collection Class?

Sep 1, 2010

I decided to go back to the VB6 book, "Learn to Program Visual Basic Objects", so I can code it in VB2010. This has been a great learning experience. However I've run into a problem. I'm getting an error with a For....Each loop for a collection class. The error message states, Expression is of type 'China.Order', which is not a collection type." From what I've deduced the problem deals with an enumerator. I could be wrong.

View 2 Replies

Retrieve A Property Of A Class As A Collection?

May 26, 2012

I'm working on a small project and got into some troubles trying to keep it OOP.I have a global variable:

Public Stations As New Microsoft.VisualBasic.Collection()
And 2 classess: Station & Unit:
Public Class Station

[code].....

View 1 Replies

Sort Of A Collection Of Class Objects?

Feb 28, 2012

I'm having problems doing a sort of a custom collection. The collection is Device Classes which is a collection of Device Class. My sort does not produce an error but the treeview control shows nothing. I am not sure what I am missing. I'm guessing just a simple sort won't work here but I don't know what I'm missing in my code. Here's the code that creates the collection

[Code]...

Simply sorting the treeview will not work because it throws off the display of related info for a given device in listview controls. The collection itself needs to be sorted before the data is added to the treeview.

View 6 Replies

XmlSerializer To Serialze A Class With A Collection?

May 26, 2010

I have a custom class that has one property as a collection.For some reason XmlSerializer doesnt like the class having a collection property and the Serialize Fails!If I remove the collection property it works! Is there a special way of getting the collection in the class to work?

View 1 Replies

Saving Items In A Collection To A Database Using A Loop Function?

May 12, 2011

I would like to be able to save to a db and send task to email or as text msg for instance nevermind that.. I have two variables of type ArrayList they are "_mList1" , "_mList2" and "_mList3"

_mList1 stores the list of Telephonenumbers , _mList2 stores the list of StaffIDs and _mList3 Some concatenated string.

theses variable lists will hold some data in runtime as explained and i would like to use them to populate a DB table again mentioned

tblTask (TaskID(PK), Action, StaffID(FK), AssignedBy, TelephoneContacted, NotesCotent)
tblStaff (StaffID(PK), FirstName, Surname, Telephone, Address etc..)

[Code]....

View 1 Replies

Why Use A Public Property Instead Of A Function To Expose A Custom Collection<T>

Jul 6, 2009

During a code review I looked at set of repository classes (in vb.net). I am used to seeing these repository classes full of functions that return collections (among other things) of your domain objects. However, this repository had 1 public property and 1 private variable that looked something like this:

Private _item as Collection (of Customer)
Public Item as Collection (of Customer)
Get...
Set...

In the "Get", there is code that gets a the Customers from the DAL and loads it in the private _item. What would the benefits be in using a property (customerRepository.Item) instead of plain old function (customerRepository.GetAllCustomers)? The "Property" way looks odd to me but odd doesn't always mean wrong.

View 3 Replies

Determine Directory Setup Msi Is Launched From Within Installer Class?

Jan 24, 2010

In my installer class, I want to check the existince of a file in the same directory that the setup msi is launched from.How do I determine the directory the MSI is launched from, from within the Installer Class?My installer class is launching succesfully and is able to process a file if I hard code the name and location. My goal is to remove that hard coded reference.

View 5 Replies

C# - Create A Collection Of Variable Binding In A Class?

Apr 15, 2010

I'm trying to create a collection of variable binding in a class.It is intended to look something like this:

Dim x as integer, s as string
Dim c as new VBindClass
x = 1
s = "Hello"

[code]....

Is there some function that allow us to retrieve a unique ID for a given variable and also get/set based on variable?

Update:At last, I've managed to found the answer. Here's the code:

Dim gh As Runtime.InteropServices.GCHandle = Runtime.InteropServices.GCHandle.Alloc(obj)
Return Runtime.InteropServices.GCHandle.ToIntPtr(gh).ToInt64

View 2 Replies

C# - Find And Insert Into List Class Collection?

Mar 10, 2011

I have class called GroupSelect and made a collection List(Of GroupSelect)().[code]...

View 1 Replies







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