Syntax Trouble Building Xml From Linq

Jan 24, 2012

I am building an xml file with the help of Linq queries and I'm not sure why the code below doesn't work.[code]

View 1 Replies


ADVERTISEMENT

.net - ActiveRecord Linq/NHibernate Linq Not Building Query Completely?

Jul 14, 2011

given this function:

Public Function Search(ByVal StartIndex As Integer, _
ByVal MaxResults As Integer, _
ByVal AccountNumber As String, _
ByVal LastName As String, _

[Code]....

instead of what I expected:

Select count(*) from remitline where lastname = "smith"

What am I doing wrong building up the where clause? I'm using Castle ActiveRecord 2.1

View 1 Replies

Building A DNN Module Using Linq To SQL

Oct 26, 2009

I am building a module using linq to SQL and I am running into some problems. I have been following Michal Washington's tutorial on [URL]. The problem is that VB does not recognize my Complaint Class when I try to create new Complaint object. why I am unable to Dim a Complaint object? Here is my code:

[Code]...

View 2 Replies

Building A Dynamic LINQ Query

Mar 16, 2011

I have a listbox which users can select from a list if Towns, I want to be able to build a LINQ query based on the selected items in the list e.g.

[Code]...

View 2 Replies

Dynamically Building LINQ Query Using OR Operator In VB

May 22, 2009

I need to build a dynamic linq query with or operators. I have seen PredicateBuilder but that is in C# and my project is in VB. Basically I need to build a WHERE clause similar to this:

Where((this = 1 AND that = 2) OR (this = 1 AND that = 4) OR (this = 2 AND that = 4))

but the problem is the number will have to be determined dynamically at runtime, and added using a loop, like

for each item in myItems
query = query.OR (this = item.a AND this = item.b)
next

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

.net - Building A LINQ Expression To Find Items Related To All Descendants Of A Tree Node?

Mar 7, 2011

I have built a database structure that represents a category tree to help classify some of the data we have stored. The implementation is that each record in the Category table has a nullable foreign key back into the Category table to represent the parent Category of this category (one-to-many), essentially allowing for subcategories within a broader parent level. There is a CategoryMembership table that links a record in the Item table to its respective Category (many-to-many). I have created the DBML for this database, and it has a member access structure that includes the following:

[Code]...

View 2 Replies

Linq Syntax For .net?

Jul 14, 2009

tell me the equivalent syntax for the following code in VB.net?

Static Class TestList
{
static void Main()
{

[code].....

View 3 Replies

C# - Triple Dot Syntax For Linq To Xml

May 4, 2011

I ran into this answer which had a triple dot syntax in VB.NET that I have never seen before. The query looks like this

[Code]...

View 3 Replies

Differences In LINQ Syntax Between .Net And C#?

Jun 29, 2011

After I have programmed several projects in VB.Net I to my surprise discovered that there are some more than subtle differences between C# and VB.NET LINQ usage.For example, if we want to group elements by multiple properties (columns) we need to create a new anonymous type explicitly:

var procs = from c in Process.GetProcesses()
group c by new {c.BasePriority, c.Id} into d
select d;

whereas in VB.NET more straightforward syntax will already do:

Dim b = From c In Process.GetProcesses()
Group c By c.BasePriority, c.Id Into Group
Select Group

So, one does not need to create a type with "new" here. What are the other differences? good comparison between the LINQ syntax in C# and VB.NET?

View 2 Replies

Exclusionary Set Syntax With Linq, VB

May 5, 2009

I'd like to do a subtraction of sets based on criteria. A pseudo-query would look like:

select table1.columnn1
,table1.column2
from table1, table2

[Code]....

I can make it to about here:

dim list = From tbl1 In table1 Where tt.column1 ...

View 1 Replies

Linq Syntax In Program?

May 28, 2009

What I really want is to select these two tables in to an anon type like in Scott Gu's blog: here However, I would settle for this created type "ActiveLots" I am joining two tables together and want to be able to reference columns from each in my result set. [code]...

View 1 Replies

LINQ To XML Syntax For XML Element With Attributes?

May 13, 2009

I'm a bit of a LINQ newbie and I was having some trouble with the following. I'm trying to perform a query using LINQ on an XML file and store the results in a list of DataClass objects that match the XML.I've got an XML file that is defined like this:

<NewDataSet>
<NewDataTable>
<Field>Accepted ASNs</Field>
<Val>59</Val>[code]....

I have created a Data class to support this XML format. What I would like to do is create a LINQ Query to grab these 3 records and store them into a List of my DataClass. In order to support multiple Order elements, I have my class defined with a generic list of "Order" structs... It looks like this:

Public Class ASNData
Private _field As String
Private _value As String[code].....

how to grab the 3 order elements and store them into my list of Order structs.

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 Syntax For Documents With Xml Namespace?

Aug 6, 2010

I'm trying to grasp the linq to xml 'inline query syntax' features of VB.Net First I tried with this simple xml file:

<?xml version="1.0" encoding="utf-8" ?>
<Root>
<Child Name="somename">

[code]....

This xml, when loaded in an XDocument, can be loaded and queried as follows:

Dim xdoc = XDocument.Load("sample.xml")
Console.WriteLine(xml.Root.<Child>.@Name)

Then I change the <Root> element in the sample xml file to:

<Root xmlns="http://SomeNamespace">

Now I can't seem to use the convenient 'Axis Properties' syntax anymore... I can only get it to work with the explicit XElement syntax:

Dim ns As XNamespace = "http://SomeNamespace"
' works, but I would like to use the same syntax as above...
Console.WriteLine(xdoc.Descendants(ns + "Child").First().Attribute("Name").Value)

View 1 Replies

VB Syntax For LINQ Query That Creates A New Set?

Dec 3, 2009

I am trying to AVERAGE 6 different fields on a DataTable, but without grouping. Just the AVERAGE. I have found a couple of examples in C#, but can't find any examples for how to do this in VB.Here is what I have so far:

Dim query = From dtRow In dtIn.AsEnumerable _
Where dtRow.Field(Of String)("FOLLOWUP") = "Alert" _
Select New With { _
.Brand_Functional_Avg = XXX.Average(Function(f) f("Brand_Functional")), _
.Brand_Personal_Avg = XXX.Average(Function(f) f("Brand_Personal")) _
}

What should I use for XXX? I tried all of the options that I could think of and nothing is compiling.

Trust me, if I could write this in C#, I would, but the project requires VB.

View 1 Replies

Linq Expression Chain Syntax For In Query?

Feb 25, 2011

I have a query that I cannot seem to replicate in expression method chain syntax. I have two tables "User" and "UserPayment". User and UserPayment have a one to many relation i.e. One User can have many UserPayments.

View 1 Replies

Syntax For Order By Clause In Linq To Sql That Has Select New With

May 25, 2011

I have a LINQ to sql statement that joins 2 tables. I would like to add a order by clause on one of the columns. However the order by clause does not seem to take effect at all. right syntax in VB.net to achieve order by in the following:

Dim query = From dtIt In dbsomecontext.mytable
Join dtIl In dbsomecontext.anothertable On dtIt.ItemID Equals dtIl.ItemID
Where dtIl.IsAvailable = True
Order By dtIt.manufacturer

[Code]...

View 2 Replies

.net - Proper Syntax For LINQ Query Selecting Only Certain Columns?

Sep 13, 2011

What is the proper syntax for this:

Dim qry As <??> = From f In dirInfo.GetFiles("*.QBW") Select File = f.FullName, Include = True
Dim dt As DataTable = qry.CopyToDataTable()

I tried as "IEnumerable(Of DataRow)" but that didn't work. At runtime it said:

Unable to cast object of type
'WhereSelectArrayIterator2[System.IO.FileInfo,VB$AnonymousType_02[System.String,System.Boolean]]'
to type
'System.Collections.Generic.IEnumerable`1[System.Data.DataRow]'.

View 5 Replies

LINQ - Syntax - Snippet Code In VB - Receiving An Error

Jul 14, 2009

I've been trying to write this snippet of code in VB, can anyone see what is wrong with it? I am recieving an error on line 5.

Dim a1 = From rows In db.tPDMLinkUsages _
Where (rows.ACCESSDATE >= DateTime.Today.AddDays(-90)) _
Select New With _
{ _

[CODE]...

View 5 Replies

What's Equivalent Syntax For Anonymous Types In A LINQ Statement

Jun 29, 2010

I'm trying to translate some C# LINQ code into VB.NET and am stuck on how to declare an anonymous type in VB.NET.[code]How do you translate C#'s new { ... } syntax into VB.NET?

View 2 Replies

Exception When Building LINQ Query With Multiple Levels Of Delegates Or Lambdas ("Value Cannot Be Null. Parameter Name: Instance")?

Jun 22, 2011

've got a function that takes two parameters (a delegate and an integer) and then creates a LINQ MethodCallExpression, which it uses to gets the results:

Public Delegate Function CompareTwoIntegerFunction(ByVal i1 As Integer, ByVal i2 As Integer) As Boolean
Public Function Test(ByVal pFunc As CompareTwoIntegerFunction, ByVal i1 As Integer, ByVal

[code].....

View 1 Replies

Trouble With Classes And Functons

Oct 10, 2011

I thought I was beginning to grasp this function and class business, but it's still giving me a lot of trouble. I created a class for the character, with a function to randomly generate a number for damage, but I'm having trouble calling the function with a button click on the main form to test display a random number in my rich text box.[code]

View 5 Replies

Multiplication Game In VB Trouble Shoot

Feb 16, 2011

This is my assignment for tonight. If anyone can enlighten me as to why it doesn't work. I

know I haven't finished the timer, I trying to get results in the labels.[code...]

View 3 Replies

Trouble Splitting Comma In Array

Nov 29, 2009

So I'm trying to split a "," from an array that I parsed after the xml file is loaded. I tried several things.[code]

View 10 Replies

WPF Trouble Updating A Textbox From A Variable

Jun 15, 2012

Using WPF, and VB.net, I want to update a textbox in a textblock with the current date and time. I use a timer, and it seems to be firing, and setting an object property to "Now".And I am using iNotifyPropertyChanged.All I get is an empty textbox with no data in it. Can you help? Maybe my context is off? [code]

View 4 Replies

VS 2008 Trouble With Emailing And Then Deleting Emailed Files

Aug 12, 2010

My app looks in a folder for all the pdf files and then emails it to an address.If the email was sent successfully, the file in the folder must be moved to a new folder called "Sent". Or the approach you will see in my code where I copy the file to the new location and then delete the old one. [code]

View 4 Replies

VS 2008 Trouble With Multidimensional Structure Based Array

May 27, 2010

I currently for the life of me can not get this to work.[code]Days(num).openTime(0) = New Date() 'Which gives the same error as openTime @ 0 has not been created as an array object (I'm assuming)Which leaves me completely lost because I've never had issues assigning initializing 1-dimensional arrays but this i just confusing the heck outta me. If anyone knows how I can initialize the 2nd part of the array (Days(num).openTime(0)) I would love to learn from you.

View 1 Replies

VS 2008 Application To Send E-mail - Trouble Making It Use Both Office 2010 And 2007?

Dec 14, 2010

I have written an application which uses the Outlook object library to send an e-mail with information from a textbox. I programmed this on Windows 7 and Office 2010, which was a mistake as most of the clients will be using Windows XP and Office 2007. I am getting an error when running the application on Windows XP/2007:

Could not load file or assembly 'Microsoft.Office.Interop.Outlook, Version=14.0.0.0 .... etc
I understand that this is because I have not loaded the Outlook 12.0 assemblies, however I am having trouble adding the assemblies on my Win7/2010 programming machine. I have downloaded the standalone Office 2007 PIAs however the Outlook 12.0 doesnt appear on the list, and when I try and add just the Office 12.0 I get an error.

is there a way to standardise and make the application work with both 2007 and 2010 outlook machines? I think it is possible, I have read some articles making the application choose the correct version, however cannot figure out how to.

View 4 Replies

Can Retrieve Records From Database Fine / Having Trouble Updating Records

May 17, 2006

I can retrieve records from my Database fine, but I'm having trouble updating records. I am getting a syntax error on [code] I get this error when I change the Last Name (Row 0, Column 1). [code]

View 4 Replies







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