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?
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!!
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.
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.
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.
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?
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.
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.
[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?
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]
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.
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?
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.
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?
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]...
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?
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)
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]
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.
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.
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?
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
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.
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.