LINQ To SQL To XML (using XML Literals In C#)
Oct 2, 2010
Is it possible to use variables like <%=person.LastName %> in XML string this way?
XElement letters = new XElement("Letters");
XElement xperson = XElement.Parse("<Table><Row><Cell><Text>
<Segment>Dear <%=person.Title%> <%=person.FirstName%> <%=person.LastName%>,
[Code]....
If it's possible, it would be a lifesaver since I can't use XElement and XAttribute to add the nodes manually. We have multiple templates and they frequently change (edit on the fly).
If this is not doable, can you think of another way so that I can use templates for the XML?
[URL]
View 1 Replies
ADVERTISEMENT
Jul 28, 2009
I have a class called Profile that has some simple properties and then it can have a collection of ProfileItem that again has some simple properties and then it can have a collection of ProfileItem (RECURSION). Now I am trying to generated a very simple save function using XML Literals that come with VB.NET (3.5).
[Code]....
View 1 Replies
Sep 2, 2009
is there a way to enable IntelliSense for XML literals in VB9 (VS 2008)?The ideal source of IntelliSense is an XSD document, but I can use anything else format to do it.
View 2 Replies
Feb 26, 2012
How do I use character literals in VB?I get error for following code:
op as Char
op = '+'
[code].....
View 1 Replies
Aug 30, 2010
I am using XML Literals and Linq to XML to read/write data to an external system.[code]The client now wants to put the url in a parameter table so the table can change to point to a test server or a real server. I assume that I cannot put a variable in my Imports statement.So how to I access the correct URL from a variable?url...
View 13 Replies
Dec 7, 2009
I'm using the following function to brighten up color values (it's a lambda in my code, but that shouldn't make a differende):
Function ReduceDistanceTo255(ByVal i As Byte) As Byte
Return i + (255 - i) 2
End Function
It won't compile, since the compiler interprets 255 and 2 as integers rather than bytes, making the result of type Integer. Unfortunately, there is no Byte type character, so I cannot just write 255B or something like that.There are a few obvious workarounds to the problem:
Function ReduceDistanceTo255(ByVal i As Byte) As Byte
Return i + (CByte(255) - i) CByte(2)
End Function
and
Function ReduceDistanceTo255(ByVal i As Byte) As Byte
Return CByte(i + (255 - i) 2)
End Function
[code]....
The first one is just plain ugly and hard to read, because every literal needs to be CByted. The second one performs calculations in integers and then converts the result to Byte, which is OK, but not as elegant as a pure-Byte operation. The third workaround doesn't require CBytes, but it's drawbacks are obvious.
View 3 Replies
Jul 26, 2010
In VB.NET I can easily embed strings into XML literals using <xml><%= "my string" %></xml>. How can I embed an XElement instance? I know I can use methods on the XElement, XNode, etc classes, but I'd like to do it in the XML literals if possible.
View 2 Replies
Nov 6, 2009
I am constructing some XML using XML literals. I have a function which returns an XElement.
Function RootElementFormattingFunction() as XElement
Return <Root Data="foo"/>
End Function
In reality it is a bit more complicated than that, but it is called from several places. Now I have linq sequence which generates a set of nodes which I want to make children of the XElement returns
[Code]...
View 1 Replies
May 3, 2011
I'm trying to use the builtin XML literals feature to create/read xml files using my own schemas, but I don't see a way to cast an abstract XElement from a base type to a more derived type.The schema/xml below shows in general what I'm working with, but using XML literals only allows me to use the base type in the IDE, so the xml below is treated as a collection of elements of the base type, instead one of the base type and one of the derived type.
<schema targetNamespace="Test" xmlns="Test">
<xs:complexType name="Base" abstract="true">
<xs:attribute name="Id" type="xs:int">
[code]....
View 1 Replies
Jul 16, 2009
Is there any other way of removing a specific tag other than looping through every tag and checking a certain value? I would assume this could become of timely process if there are many tags.
[Code]...
View 3 Replies
Jun 5, 2009
As basic as this is, it took me a few minutes to figure out, so wanted to share with the rest of the community to avoid anyone else from wasting their time.
I am attempting to generate the following XML string using VB.NET XML Literals
<Books>
<Book Name="The First Book" />
<Book Name="The Second Book" />
</Books>
[Code]....
But the compiler is complaining about the quotes that are supposed to surround the attribute value. I tried using single quotes, two double quotes, nothing works.
View 1 Replies
May 4, 2009
My problem is that I want to include control structures in the embedded XML. Specifically, I want to include or exclude an entire element (not just its contents) based on a boolean expression. The question extends to other control structures as well though.
I'd expect the <% %> syntax to support inling of code but that doesn't seem to function in VB.net's implementation (as opposed to the <%= %> for inlining the result of an evaluated expression, which does).
Here's some very simple code by way of example only.
Public Class Foo
Private bar As String = Nothing
Private baz As String = Nothing
[code]....
I'd much prefer to use the format of getXMLBad() if possible. In this short example it doesn't seem critical, but in much larger examples, the inlining of the logic is more readable and maintainable than the "assembly" style in getXML(). This especially true when the logic is in the middle of large block of static XML and when coding to a very strict or complex schemas.I'd be interested in the capability to extend this to Looping constructs as well.
View 1 Replies
Mar 23, 2012
Currently am working on a project that requires me to create some XML for use with a graphing plugin. I'm using XML literals and LINQ to SQL as follows
Dim x As XElement = _
<chart caption='Aantal aanvragen' xAxisName='Dag' yAxisName='Aantal'>
<%= From d In dailies Select _
[code].....
View 1 Replies
Nov 22, 2011
Dim task As XElement = <task>
<body>body</body>
<optional><%= myVar %></optional>
[code].....
View 1 Replies
Sep 2, 2009
I have a masked textbox on my form for a phone number. I want to store its value in my Database without the literals as the database field for that phone is only 10 characters long. How do I store this value in the database field without any literals.
View 3 Replies
Apr 22, 2009
been working on a large scale project and Iow looking into the document print engine for the application. been a while since Ie built an app that retrieves data from the database and outputs to Word. I generally always used the mail merge feature of Word but after reading the link above this seems far easier.
View 2 Replies
Feb 5, 2010
I have an XElement that I need to create via dynamic xml literals/embedded expressions and I need it to inherit the default namespace. This doesn't appear possible though through everything I've tried. how to make this work?
For example
Imports <xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation">
Sub CreateXAML()
Dim obj = "Rectangle"
[Code]....
View 1 Replies
Apr 28, 2011
I'm experimenting with xml literals in vb.net and there's something I don't get. Here's a small sample that illustrates the problem. I'm adding two PropertyGroup nodes to an empty Visual Studio project. The first one is added as xml literal, the second as new XElement:
Imports <xmlns="[URL]">
Module MyModule
Sub Main()
Dim vbproj = <?xml version="1.0" encoding="utf-8"?>
<Project ToolsVersion="4.0" DefaultTargets="Build" xmlns="[URL]">
[Code] .....
This code writes the following output:
<Project ToolsVersion="4.0" DefaultTargets="Build" xmlns="[URL]">
<PropertyGroup xmlns="[URL]"></PropertyGroup>
<PropertyGroup />
</Project>
As you can see, the first PropertyGroup node contains a redundant xmlns declaration. Why is that, and can it be avoided?
View 1 Replies
Mar 26, 2010
How can I get the variable My.Application.Info.Version.ToString to populate in the comments section?[code]..
View 2 Replies
Sep 4, 2009
If I have a text stored in db, file, resource does not matter:
<code><%= Integer.MaxValue %></code>
Is there a way to do this: Dim el As XElement = XElement.Parse({variable containing text above}) and to have it evaluate the expression Integer.MaxValue?
View 3 Replies
Oct 23, 2008
What I need to do is create comboboxes populated with values from a CSV for each class object selected from an Active Directory schema.
So lets say twelve classes are selected, the next form will display the class names in a checkedlistbox and will require twelve comboboxes for associating AD classes to CSV fields. Since the number of AD classes selected will always vary, is there a practical way to code it so that the objects can be instantiated from values stored in a variable?
Other languages support macro substitution, where the variable's value is interpreted as a literal at runtime. Developing in Visual Studio 2005, VB version 8 .netFramework 2.0xxx
View 2 Replies
Jan 28, 2010
In a nutshell, I am selecting values from a checked box column in a grid view. After checking the boxes I have a function that concatenates each customer number into a string called @CusList to use a parameter for a stored procedure Public Function SelectCusList()
Dim CusShow As String
Dim CusStr As String
Dim CusList As String
CusStr = ""
[Code]...
View 1 Replies
Mar 31, 2010
I have a form which will display general data about a branch. Once you select contacts - then the form will display specific into about that branch. I am trying to add a phone number display to the page, but am having a hard time.
[Code]...
View 1 Replies
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
Aug 6, 2009
if there is that much of a performance gain in running a LINQ stored procedure versus a LINQ query?
View 1 Replies
Apr 20, 2011
I have a listbox on my xaml form that I bound to a List(Of MyType) property. I populated this list like so:
Dim fields As List(Of CheckableFields) = New List(Of CheckableFields)
Using context As ITIPEntities = New ITIPEntities()
Try[code]....
Now I'm at the point where the user selects the fields they want included in a report and I need to iterate over the required fields. This is my linq query:
For Each checkedField In _requiredFields
If checkedField.IsChecked Then
If checkedField.FieldData IsNot Nothing AndAlso checkedField.FieldData.Trim IsNot String.Empty Then[code].....
View 1 Replies
Sep 10, 2009
Example-I have a person class
Public Class Person
Private _fname As String
Public Property Fname() As String
[Code]...
View 2 Replies
Mar 31, 2011
Forgive my ignorance on this.I have this LINQ Query:Dim ngBikersDataContext As New CarBikeWalkDataContext
bikersList = (From c In ngBikersDataContext.Reg_Bikers _
Order By c.L_Name _
Select New Bikers() With { _
.BikerID = c.BikerID, _
.F_Name = c.F_Name, _
[Code]...
with the error "Overload resolution failed because no accesible 'Select' accepts this number of arguments."
Over the "NEW" I get an error " ')'expected."
View 1 Replies
Jan 27, 2011
We are doing a query against an in-memory collection of LINQ data objects. The wrinkle is that we are ordering by a column in a related table whose records have not necessarily been loaded yet (deferred loading:)
Dim oPkgProducts = _
From b In oBillPkg.BillProducts _
Where b.Successful.GetValueOrDefault(Common.X_INDETERMINATE) = _
[code]....
View 1 Replies
Feb 28, 2012
The pattern I'm trying to avoid is checking if a string (normally a control's text value) is null/empty, and if it is, comparing it using Contains to a field in my data. Obviously the field isn't hard-coded into my extension, neither is the object type.What I've got works perfectly in Linq to Objects, but I get the generic run-time error "LINQ to Entities does not recognize the method 'System.String Invoke(GenericQueryHelper.Customer)' method, and this method cannot be translated into a store expression." when using an entity framework model.
Here's what I have:
<System.Runtime.CompilerServices.Extension()>
Public Function CompareAndFilter(Of T)(source As System.Linq.IQueryable(Of T), expressionField As System.Linq.Expressions.Expression(Of System.Func(Of T, String)), compareTo As String)
[code]....
I want my usage to look something like this:
Dim results = repository.Customers.CompareAndFilter(Function(c) c.FirstName, searchText)
I do need to get this running against a SQL database really, as it is filtering results, so I don't want to be doing that in memory.
View 2 Replies
