VS 2008 - Querying Array Of Invoice Objects (LINQ)

Sep 20, 2009

Use the Invoice Class provided to create an array of Invoice Objects. Class Invoice includes four properties- a PartNumber (type integer), a PartDescription (type String), a Quantity of the item being purchased (type Integer), and a Price (type Decimal). Write a Console Application that performs the following queries on the array of Invoice objects and displays the results:

a. Use LINQ to sort the Invoice Objects by PartNumber
b. Use LINQ to sort the Invoice objects by Price
c. Use LINQ to select the PartDescription and Quantity and sort the results by Quantity
d. Use LINQ to select from each Invoice the PartDescrition and the value of the Invoice (i.e. Quantity * Price). Name the calculated column InvoiceTotal. Order the results by InvoiceTotal.
e. Using the results of the LINQ query in Pard d, select the InvoiceTotals in the range of $200 to $500

I am pretty sure I have parts a, b, & c completed correctly. Or at least the provide the desired results. Part d I figured out how to multiply the 2 fields but can't create a new column for the result or figure out how to show the PartDescription with the multiplied result. Part c I think I can figure out when I get part d. I already coded what I think will work for part c.

Below are the 2 Objects the Invoice was given and not to be changed & the LINQ is the one I have been working on.
Module LINQ
Sub Main()
' array of invoices
Dim invoices As Invoice() = { _
New Invoice("83", "Electric Sander", "7", 59.98), _
[Code] .....

View 3 Replies


ADVERTISEMENT

Querying An Array Of Invoice Objects (LINQ)?

Sep 19, 2009

I am having a little problem with some homework. Here is the problem:Use the Invoice Class provided to create an array of Invoice Objects. Class Invoice includes four properties- a PartNumber (type integer), a PartDescription (type String), a Quantity of the item being purchased (type Integer), and a Price (type Decimal). Write a Console Application that performs the following queries on the array of Invoice objects and displays the results:

[Code]...

View 3 Replies

.net - Querying Twice-separated-or-more Objects In A Relation Chain?

Apr 20, 2010

Not sure if I am using the correct term, but it's not child/parent since they aren't nested objects. In my application I've got a User, UserUserGroup, and UserGroup objects which are pretty standard, UserUserGroup is a linking object with corresponding IDs. I am using Linq-to-SQL so unforunately it doesn't used nested objects, but it still knows the relation.

[Code]...

View 1 Replies

Querying XML With LINQ By Attribute?

Mar 2, 2012

Given the following XML file:

<users>
<user name="admin" password="foobar" roles="Admin,Guest" />
<user name="guest" password="foobar" roles="Guest" />
</users>

How do I find a specific node? In this case I want to find the node that has its name attribute to be "admin"

Dim authGroup As XElement = XElement.Parse(myXMLDoc.OuterXml)
Dim foundUser As IEnumerable(Of XElement) = From i In authGroup.Elements Where i.Attributes("name") = "admin" Select i

[Code].....

View 2 Replies

(Linq To Datasets) Dynamic Querying In .net?

Jan 24, 2010

I have been looking into dynamic querying of datasets and the use of copytodatatable() for a project. I have seen in alot of forums that the copytodatatable functionality is unusable as it was removed. have an example of a dynamic Linq query being loaded into a datatable.

View 1 Replies

LINQ - Querying Top 5 With Rank Number?

Jun 29, 2010

How do I return a top 5 with rank number using linq?

Dim Top5 = From A In DAO.Cache.Select(Of VO.Empresa).Take(5) Select A.Nome

I would like this result:

Rank Name
1 "Example Name"
2 "Example Name"
3 "Example Name"
4 "Example Name"
5 "Example Name"

View 3 Replies

Wpf - Linq Querying For User Search?

Mar 10, 2012

I am trying to query from search box using list of data and the linq I used is:data = (From k As BSPLib.ContactLib.Contact In data_org.Values Where k.stringdata Like "%" & Searchtxtbox.Text & "%" Select k.prime).ToListBut this is not working, I am getting no data at all. Data_org is a dictionary so I used the values; k.stringdata contains all the data that need to be searched. Searchtxtbox.text contains the user defined search item.I Tried with sqlmethods through linq, but sqlmethods does not exist for me, I tried with with Imported namespace yet the code is not showing sql methods, could you please provide a workable query or just tell me where I have gone wron

View 2 Replies

Querying An Entity That Has A Varbinary Field With LINQ?

Jun 5, 2012

When I try to query an entity that has a varbinary field in it I am getting error:"The LINQ expression node type 'ArrayIndex' is not supported in LINQ to Entities."

Here is my query:

Dim query = From entity In db.Entity
Where entity.Id= Id
Select entity.VarBinaryField

[code]....

The error gets generated when I check that the query isNot nothing.

View 1 Replies

Error - Create A Class Called Invoice - Hardware Store Use To Represent An Invoice For An Item Sold At Store

Apr 15, 2012

"Create a class called Invoice that a hardware store might use to represent an invoice for an item sold at the store. An Invoice should include four pieces of information as instance variables--a part number (type String), a part description (type String), a quantity of the item being purchased (type Integer) and a price per item (Type Integer). Your class should have a constructor that initialize for each of the four instance variables. Provide a property for each instance variable. If the quantity is not positive it should be set to zero. If the price per item is not positive it should be set to zero."

I attached the code I have. obj is underlined and says "Argument not specified for parameter 'Invoice4' of the 'Public Sub New (Invoice1 As Object, Invoice2 As Object, Invoice3 As Object, Invoice4 As Object)' and so the program won't run. What am I doing wrong?

Public Class Form1

Private Sub TextBox1_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs)
Dim obj1 As New Invoice(Val(TextBox1.Text))
TextBox1.Text &= obj1.Invoice1 & vbNewLine
TextBox1.Text &= obj1.Invoice2 & vbNewLine
TextBox1.Text &= obj1.Invoice3 & vbNewLine
TextBox1.Text &= obj1.Invoice4 & vbNewLine

[CODE]...

View 14 Replies

VS 2008 Querying SQL With VB?

Aug 7, 2010

My form has a DateTimePicker and a DataGridView on it. I need to have it query a SQL Server DB and return the table to the DGV. The query is to search the Date_Joined field for date less than the date that the user input with the DTP. With the code below, my DGV is populated with all data and not the filtered data I need. I also have added a Go button for the purpose of execution instead of using the ValueChanged sub for the DTP.

Private Sub btnGo_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnGo.Click
Dim query As String
'dtpDateJoined is a DateTimePicker on the form

[code].....

View 6 Replies

An Array Of Objects - An Entry Will Be Stored In Serialports(4), All Other Array Elements Will Be Blank?

Jun 1, 2009

I've come up with the following and it's partly working.

Public serial1, serial2, serial3, serial4, serial5 As SerialPort
Public serialports() As Object = New Object() {serial1, serial2, serial3, serial4, serial5}
dComPort = "COM4"[code]....

The above code works fine! But im having trouble trying to now retreive whats stored in the array.In the above example, an entry will be stored in serialports(4), all other array elements will be blank.If I do this it works.

MsgBox(serialports(4).PortName) ' this retuns the value COM4

But I'd like to loop though all array elements and print out ALL the PortNames, The below code doesnt work, I get an error Object variable or With block variable not set.

For i = 0 To serialports.Length - 1
MsgBox(serialports(i).portname)
Next

View 3 Replies

C# - Where And When To Use LINQ To Objects

Feb 21, 2009

In which situations I should use LINQ to Objects?

Obviously I can do everything without LINQ. So in which operations LINQ to code shorter and/or more readable?

View 7 Replies

VS 2008 Print To A Pre-formatted Invoice Form

Dec 11, 2009

I'm trying to figure out the best and or easiest way to print to a pre-formatted invoice form so that my data lines up with the appropriate fields on the invoice. I've looked at PrintForm from the Power Packs, but it doesn't print a full 8 1/2 x 11 page that I can tell. I was thinking about storing the data to a text file and printing the text file, but I know there are going to be problems if I use hard spaces inbetween the text. Is there a way to use some kind of absolute positioning to line up my data? If so, how would I go about doing that?

View 7 Replies

VS 2008 Printing Invoice - Print Out The Whole Form

Apr 17, 2009

im having problem creating an invoice. on my form ive layed out text boxs,listboxs etc in the correct order. i do not want to print out the whole form, but just how the layout is and containing the information in the labels etc.

my program is working perfectly fine the only problem is i just cant print it!! i managed to print the subheadings, eg price,name,quantity etc . i want to be able to print the contents of the listboxs under the correct heading. does anyone know a way to go about this?

View 3 Replies

VS 2008 Querying A Database?

Mar 23, 2010

vb
Dim conn As New OleDb.OleDbConnection(ConnStr)
conn.Open()

[code].....

View 3 Replies

VS 2008 Querying A DataTable?

Oct 2, 2009

I have a DataTable filled with employee names and hours. I want to query that data to make a list of all the unique employees and the total hours for each, but I don't know how to do that. If I were to query the database directly I would do something like this

View 6 Replies

Make The Invoice Number Increase As Make Each New Invoice?

Jan 31, 2012

how do i make the invoice number increase as i make each new invoice. i want to save each invoice then as i make the next one i want the number to increase,then be able to save that one and so on...

View 1 Replies

.net - String Where In LINQ To Objects

Jun 5, 2012

I have a linq query like that:

Elementos = From b In Elementos Where b.Value.IdGrupo = 0 Select b

"Elementos" is a dictionary(of long, MyObject). MyObject has approximately 50 properties.

The problem I have is that I have a new requirement to accept string parameter with a "where" condition. Something like "property1>10 and property2 like 'anystring' or property3<=25". (That means any property could have a condition. I have string and numeric properties.)

I'd like to keep using linq, adding the condition as it comes. I'm aware that it could produce an exception if the condition is misspelled or something, but that's acceptable (by try catchs). I wouldn't want to parse the string to build parameters or anything.

View 2 Replies

LINQ To XML And Child Objects?

Nov 20, 2009

I am creating a tool that interfaces with an API for a CD/DVD burner. I have created several custom classes that will hold the information for the disk sets (which consist of a data path and a label file among other information. The DiskSet class has a list of Include objects. My proposed XML output would be something similar to the following:

<DiskSets>
<DiskSet>
<Name>MySet 1</Name>

[code].....

I am attempting to traverse the Includes collection (I have tried List and Binding List as I am also using this in a pair of datagridview controls) and it keeps returning Expression of type 'Object is not queryable. Make sure you are not missing an assembly reference and/or namespace import for the LINQ provider." How can I use LINQ to pull a list of the Include objects under each DiskSet object for transformation into XML? I am hoping to keep this restricted to this one block of code if possible.

View 7 Replies

Array Of Child Objects In Nested Classes And Accessing Child Objects In .Net

Jan 3, 2012

I have a nested class, let's call it class1 and it has class2 inside it; VB.Net eg:[code]

1) How can I define X number of Class2 objects[let's call it: Node(x) array]** with NEW() subroutine called?' this raises error: dim cls2(n) as new class2 end sub.

2) How can I return actual number of Node() array? [code]Outside my class in main project I define cls1 object:[code]Now an array of class2 is created inside cls1.

3) Now,How can I access All of them[node(x) array which is created inside cls1] with all properties and methods available?

I remember I wrote a ProcessManager class with this functionality in .net 2003, nearly 4 years age, I don't have the code now.

View 1 Replies

VS 2008 Querying Data Out Of Datagrid In Win App?

Nov 10, 2010

i would like to check the possibilities to draw out data from a data grid, which is currently showing out some data in it.the datagrid contains 2 columns in it,but will display only one column at run time. The result is assumed to get changed according to some parameter values.

So i need to query the value of first column and i need to use it as parameter for a report in report viewer.i am trying it in VB.NET.Kindly let me know whether the above is possible? if so please do let me know how to start.

View 7 Replies

Asp.net - Serialize Linq Objects Not Working?

Apr 14, 2010

Using the following code:

Private Sub MakeMeSomeXmlBeforeRyanGetsAngry()
Dim db As New MyDBDataContext
Dim customer = From c In db.Customers Select c

[code]....

I am attempting to serialize my linq collection of customers. But it keeps throwing

Type 'System.Data.Linq.DataQuery`1[MyDB.Customer]' cannot be serialized. Consider marking it with the DataContractAttribute attribute, and marking all of its members you want serialized with the DataMemberAttribute attribute. See the Microsoft .NET Framework documentation for other supported types. My issue is that I have already marked the dbml Serialization Mode to UniDirectional and when I check the dbml codebehind all of the DataContract()> and DataMember()> elements are there. I have tried adding various dataloadoptions and setting deferredloading to false, but no luck.

View 2 Replies

C# - Join The Objects In A LINQ Expression?

Dec 15, 2011

How to Join the objects in a LINQ select in this sample (C# variants accepted as well):

Class Room
Public Area As Integer
End Class
Class RoomPair

[code]....

View 4 Replies

C# - Linq To Objects Outer Join?

Mar 10, 2010

Im trying to use LINQ to query Objets. I'm doing the following:

Dim myList As Generic.List(Of MyItem) = (From ThisItem In LinqToSqlObject.Items _
Join Folder In LinqToSqlObject.Folders _
On Folder.Id Equals Item.Id _

[Code]....

This however will not return any item that has a ParentItemId of null. I am trying to do a left join so as to return all "Item" regardless of whether it has a parent or not. I am aware that this is feasible in C# by adding an "into X" on the join, and selecting from X.DefaultIfEmpty(), this however does not appear to work in VB.Net.

View 2 Replies

LINQ Filtering List Objects?

Mar 1, 2011

I have list object and I need to check id in a comma separated string using LINQ in VB.NET, something like this:

dim strId as String = "1,2,3,5,"
dim myList = from objmylist where objmylist.id in (strId)

View 4 Replies

LINQ To XML Syntax And Class Objects In .net?

Dec 10, 2010

I have the following XML file

<Test>
<Modules>
<Module Name= "Test1">
<QueueName Name="Test1Active1" Active="True"></QueueName>
<QueueName Name="Test1Active2" Active="True"></QueueName>

[Code]...

View 1 Replies

Linq-to-XML: Adding Enumerations To Objects?

Oct 2, 2010

I'm trying to figure out how to add an enumeration to an object with Linq. For example:

Dim thingBlock = <Things>
<Thing Name="Ish">
<SmallThing>Jibber</SmallThing>

[code].....

View 1 Replies

[2008] - DataSet/Grid And MSAccess07 Querying?

Aug 9, 2009

Microsoft Access 07
Visual Basic/Studio - 08
Windows XP / Vista

im currently working on a program which must connect to a microsoft access 07 database file and do various operations on the data and then resave the data.Currently i can get the information displayed in a table using a DataGrid and browse through the data by scrolling or using a combo box which i linked to the data.

I am making a query for a quick search function using a text box and a button. I have the sql already however i need some help implementing the variable QSearch into the sql. QSearch is the variable which stores the infomation in the quick search text box. The query is currently in the TableAdapter section of DataSet.xsd ?

SELECT *
FROM Members
WHERE (any row is like QSearch)

View 3 Replies

.net - LINQ Union Objects With Same Base Class?

Apr 5, 2011

I'm trying to create a list of all my objects from several lists of objects using Union.

Return Chart.AnnotativeNodes.Union( _
Chart.DecisionNodes.Union( _
Chart.EndNodes.Union( _
Chart.StartNodes.Union(Chart.WorkCenterNodes))))

The above line gets an error because I can't union List(of AnnotativeNode) with List(of DecisionNode). Each list defined like List(of EndNode) or List(of StartNode), but each class inherits from the base type Node.Is there a possible way to union these to get a result of IEnumerable(of Node)?

View 1 Replies

Asp.net - LINQ To Objects Auto-increment Number?

Feb 25, 2009

This feels like a completely basic question, but, for the life of me, I can't seem to work out an elegant solution.

Basically, I am doing a LINQ query creating a new object from the query. In the new object, I want to generate a auto-incremented number to allow me to keep a selection order for later use (named Iter in my example).

Here is my current solution that does what I need:

Dim query2 = From x As DictionaryEntry In MasterCalendarInstance _
Order By x.Key _
Select New With {.CalendarId = x.Key, .Iter = 0}

[Code]....

Is there a way to do this within the context of the LINQ query (so that I don't have to loop the collection after the query)?

View 3 Replies







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