List Of Objects Into SQL Query?

Oct 7, 2011

The scenario is this, I have several variables that are set as a list(of objects). The values for these lists are populated during code via a SQL query. I want to be able to take these values and then use them within another SQL query. Each time the program runs the values will be different and there will be more or less within the list.

View 6 Replies


ADVERTISEMENT

.net - LINQ Query Returns List Of Empty Objects?

May 3, 2012

I have a query that 'selects' object of a type:

Dim l as IList(Of Foo) = (From dataRow As DataRow In table.Select()
Where CStr(dataRow("Column1")) = "A"
Select New Foo(CStr(dataRow("Column1")), _
CStr(dataRow("Column2")))).ToList()

What's happening is that if i set a break-point to the constructor of Foo and step, the constructor is hit and the parameters are loaded with the arguments. However, l has empty Foo objects (the members in every object are Nothing). What could be happening here?

View 1 Replies

Create List Of Child Objects From List Of Parent Object?

Jun 2, 2011

I would like to create list of child objects from list of parent object. Like If i have list of bookingroom which has one member room then i would like to create list of room from it.

eg. code:

Dim BookingRoomList As List(Of BookingRoom) = New List(Of BookingRoom)
Dim RoomList As List(Of Room) = New List(Of Room)
BookingRoomList = BookingRooms.FillGrid()

[Code]....

Is there any short cut method instead of iterating over for earch?

View 1 Replies

VS 2005 Sort List Of Objects By Child List Order?

Jul 20, 2011

I'm having a bit of a 'brain doner' moment here

I have a list of Objects. Each of these Objects contains a list of other Objects (pseudo code) :-

Private Structure Object1
dim Name as string
dim ListOfObject2 as List(Of Object2)

[Code]....

I need to sort the list of Object1 by the Value in Object2. I have a comparison class which sorts Object2 by its Value nicely.

View 13 Replies

.net - Searching A List Of Objects In An Object List Using Linq?

Dec 22, 2010

I have 2 classes

Public Class Shipper
Public Property ShipperID As Long
Public Property CreateDate As DateTime

[Code].....

View 1 Replies

Linq - Create A List Of Integers From A List Of Objects?

Nov 23, 2011

I'm trying to create a list of days(integer) from a list of dates(date).

I tryed to do this....

[Code]...

View 4 Replies

Multithreading - Create Custom Objects/list Of Custom Objects In .NET?

Jan 24, 2010

I need two seperate lists, which every item is Integer, String, Bitmap - and one which every item is Integer, String String. However I don't know how to do this, or even where to look - I've googled for custom objects and custom object lists. What I'm trying to do is this.Custom Object1 is Integer, String, Bitmap Custom Object2 is Integer, String, String

In one thread I'll be adding items to List1(Of Object1), and processing them, and adding the results to List2(Of Object2), however I need to be able from other threads to look at the list and say only give me the items where Integer = (my thread ID), is this possible? Any help, or even links to information that would be relevant to this request would be helpful?

View 2 Replies

Running Same Query For Different Objects?

Jun 2, 2010

Running same query for different objects?

View 1 Replies

VS 2008 Running Same Query For Different Objects

Jun 2, 2010

Currently my code looks like this:

[Code]...

Where x would be the numbers 0 to 100, or infinite I don't mind. I want it to check all the numerical values for each number. How would I go about doing this?

View 2 Replies

Linq To Entities Query With Child Objects?

Oct 13, 2011

Basically I have the follwing:Dim ctx As New AdminCoreEntities Dim roles = (From r In ctx.Roles where r.Name.StartsWith("cust") Select r) 'list of System .Linq.IQueryable(Of AdminCoreModel.Role)

[code]...

The error i get when i run this is: Unable to cast object of type System.Data.Objects.ObjectQuery`1[AdminCoreModel.Role] to type AdminCoreModel.Role

Basically I have a many to many situation and I try to get all the Quicklinks objects queried by their roles and not quite sure why EF will cast to a single AdminCoreModel.Role when i.Roles is a collections of objects.

View 1 Replies

LINQ To Objects, Query Arrays In Object?

Sep 15, 2011

I need to query an array. I have tried to use LINQ but with no success.

Here is a simplified structure of Insurance

Public Class Insurance
Public _typ As String
Public _numb As Number()

[Code]....

View 1 Replies

Order By And Group By In A Linq To Objects Query?

Sep 28, 2010

How do I order by and group by in a Linq query?I tried..Dim iPerson = From lqPersons In objPersons Where Len(lqPersons.Person) > 0 Group lqPersons By key = lqPersons.Name Into Group Order By Group descending Select Group, key

For Each i In iPerson
tmp = tmp & vbNewLine & i.key & ", " & i.Group.Count
Next

[code].....

View 5 Replies

SQL Query Two Tables At Once And Loop Result As JSON Objects

Dec 16, 2011

I have a MySQL database with a table called "Locations" which looks a bit like this

id | name | other parameters
1 | shop1 | blah
2 | shop2 | blah

[Code]....

This works, but it is inefficient calling the database through the loop, how do I avoid this?

View 6 Replies

VS 2010 Dynamically Building LINQ Query To Search Objects

Mar 24, 2011

I am creating a mediaplayer / playlist creator tool that basically imports MP3 songs into playlists (grids). I'm looking to add search functionality where the user can search all open playlists (or a subset of the open playlists). A Playlist is basically a collection of AudioFiles, where an AudioFile is a class that holds the filename of the MP3 file and then exposes the tags (Title, Artist, Album, etc) in public properties.

The idea is that the user can search for a certain expression (for example "the"), and that he can then choose whether to search in the title, in the title and artist, in the title or artist, in the title, artist and/or album, etc. However, I'm having a hard time implementing this and also having it kind of dynamic.

At the moment I am simply gathering all the AudioFiles from the open playlists (or from the subset of playlists the user chooses) and then running a simple LINQ query to find those AudioFiles where the Title contains the search text. Then I display the resulting AudioFiles in a new playlist window:

[Code]....

In case the AND / OR distinguishing is too hard, I would be happy to start with just letting it default to 'OR', so that the user can check Title and Album for example. If he would then search for 'a' then all songs that contain 'a' in their title as well as all songs that contain 'a' in their album should be returned. I guess that makes it easier, but I still wouldn't know how to dynamically create the LINQ query.

View 2 Replies

Display A List (Of Object) Which Has Single Objects And Child List (Of Object)?

Sep 6, 2011

Limited to using v2.0 of .Net framework (we use VB.net) due to environmental constraints on our servers.I've got an ASP.net webpage which pulls data from a webservice that performs checks on user accounts in active directory. Operators can check multiple accounts at one time using the web interface. The webservice returns a list(of AccountCheck) objects which themselves contain single properties like username, email address, and List(of AccountError) objects which contain multiple properties.[code]What I want to do is using some kind of repeater, create multiple panels or divs which contain labels showing the username, email etc, and a gridview which has the accounterror list bound to it to show all the errors. The users could be checking 2, 5, 7 accounts at once, and is dynamic.

View 2 Replies

Adding To A List Of Objects

Nov 9, 2011

I have an Object structured as follows:[code]I thought this would work but I keep getting the following error: Object reference not set to an instance of an object.

View 1 Replies

Get List Of String From Objects?

Aug 26, 2011

I was wondering how I could go about getting a list of string from a list of objects, while removing duplicates[code]....

View 2 Replies

Intersecting List Objects?

Dec 18, 2009

just needed to get my head round something. Say I have a class 'myClass' with properties ID and Name. Now say I have 2 lists of objects of this type as follows:

Dim list1 as List(of myClass) = GetList1()
Dim list2 as List(of myClass) = GetList2()

What I want is to 'intersect' (this may not be the right word!) the two sets of data by the Name property, but bring back the ID property from list1. A suitable database analogy would be if list1 and list2 were tables, I'd want to do a left join from list1 to list2 on the Name field.

View 1 Replies

List Of Superclass Objects?

Aug 14, 2009

I have a superclass NetworkTest and 3 derived classes PingTest, Pop3Test, SMTPTest. I want to create a big list of all the tests, like this:

[Code]...

View 12 Replies

Looping With List(of Objects)

Oct 15, 2009

I have a procedure in VB.net using VS.net 2008 which will get the list of Orders and build a XML file with the list of Orders as shown in the code below: As the number of Orders is getting huge, I want to build the XML file for every 500 Orders

[Code]....

Instead of building XML for all the records I want to create XML for each 500 records. I tried the following code and it is throwing an error saying Expression is of type Orders which is not a collection type.

[Code]....

View 4 Replies

Objects To Interface With The GUI Instead Of List(Of T)?

Mar 9, 2010

I have started using BindingList(Of T) for my generic collections whenever I need the objects to interface with the GUI instead of List(Of T). This has worked well for me so far but a few of my collections are stored in Dictionary(Of TKey, TValue) and there doesn't appear to be a corresponding BindingDictionary(Of T).

Has anyone else come across the necessity to use this, and how did they achieve it? Should I implement this myself? (How?) or is there a better solution already available?

View 1 Replies

Separate List Of Objects?

Apr 21, 2010

Why I couldn't have a separate list of objects of the same class?

This one works,

Dim list As New List(Of Address)
list.Add(New Address With { _
.Country = "USA", _

[Code]......

View 3 Replies

Sorting A List Of Objects?

Mar 16, 2012

Suppose I have:

Public Class myClass1
Dim foo As String
Dim bar As String

[code].....

View 23 Replies

Add Objects Into A Doubly Linked List?

Dec 7, 2011

I have a VB 2010 class like

Public Class cStar
Public Name As String
Public Magnitude As Single
End Class

I want to add stars into some doubly linked collection or list that is ordered by magnitude.

I tried to create my own list cList based on collection

Class cList Inherits collection error - collection not inheritable End class

I had hoped to enable things like

Dim Star1 as cStar
Dim Star2 as cStar
cList.AddFirst(Star1)
cList.AddLast(Star1)
Star2 = cList.Behead

[Code]...

View 4 Replies

C# - Create A List Or An Array Of Objects In PHP?

Jun 8, 2009

I am a .net programmer vb & c# but i can't seem to figure out how to get my objects into a list or array in php. var mylist = new List<myobject>();

mylist.add(myobject1);
mylist.add(myobject2);

what i have tried. Products being a property for a collection of orderitems

$this->Products = getOrderItems();
public function getOrderItems()
{
$items = array();

[Code]...

View 3 Replies

Create A Dynamic List Of Objects?

Mar 29, 2010

I have to ask my first question at some point, so here she goes.I am trying to create a dynamic list of objects. The objects will have several types (String, Integer) associated with them. Currently I am forming a Collection as I instantiate new objects.Is there a prefered to map this collection to, say, a Datagridview? Will I have to Iterate through the collection and add the rows at each iteration?Would I be better served using an ArrayList or something else over a Collection?

View 8 Replies

Dispose A List Of Disposable Objects?

Jul 18, 2010

I am implementing IDisposable for a class and while disposing there is a internal list of disposable objects. Should I be disposing those object by looping through them.

public Class MyDisposable
Implements IDisposable
private _disposbaleObjects as new List(of OtherDisposables)

[Code].....

View 3 Replies

Finding A Particular Item In A List Of Objects

Jul 5, 2011

I have a question about locating a particular object in a generic list. I have 2 lists, one contains a list of every song in a library and the other contains only copies of some the those elements that are added to a playlist. How would I locate and change a value of an particular item in a list by comparing one of their variables such as name? Or find it's index in the masterlist.

View 14 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

List Of Objects - How Does SyncLock Works

Apr 22, 2011

I have a List of objects shared by multiple threads, it sometimes generate IndexOutOfRangeException when trying to Clear. While searching for solution I found that I should use SyncLock while accessing the List. But my question if what is the importance of lockObject in SyncLock block
E.g. while clearing myList

Can I use
Synclock myList
myList.Clear
End SyncLock
or lockObject should be different from myList?

What I think about sysnclock is "lock is obtained for object specified as lockObject". What if I specify list to be cleared as lockObject, shouldn't the compiler supposed to obtain the exclusive access to list before clearing it ?

View 1 Replies







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