.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Linq to xml to retrieve element value by its attribute

Posted By:      Posted Date: September 09, 2010    Points: 0   Category :ASP.Net
Can someone please tell me how to select the mac element value.  Here is my code that not working.  Thanks. Attempt1:        '* from string        Dim xdoc As XDocument = XDocument.Parse(xmlString)        Dim LQElements = From xe In xdoc.Elements("mac") _                         Where xe.Attribute("type").Value = "eth" _                            Select xe.Value        For Each LQElement In LQElements            Dim mytype As String = LQElement.ToString        Next Attempt2: '* from string Dim xdoc As XDocument = XDocument.Parse(xmlString) Dim LQElements = (From xe In xdoc.XPathSelectElements("//mac") _ Where xe.Attribute("type") = "eth" _ Select New With { _ .type = xe.Attribute("type").Value, _

View Complete Post

More Related Resource Links

How to retrieve image from DB with Linq and diplay in Image Control


Hi all-


I'm using the file upload to let the user upload a single file.  Here's the code I'm using to then upload to the DB.  How do I reverse this process and dowload the image into the control for it to display on a different page?

Here's my code for the upload - which I think works but can't confirm until I can see the download since all I see in the DB is "binary data"

'update DB with new Image 
        If FileUpload1.HasFile AndAlso FileUpload1.PostedFile.ContentLength > 0 Then
            'Read the file in to a byte Array.
            Dim filebyte As Byte() = FileUpload1.FileBytes
            Dim fileBinary As New System.Data.Linq.Binary(filebyte)
                Dim c3 = (From c In dc.ProductImages _
                          Where c.userID = userGuid _
                          Select c).FirstOrDefault

                c3.productImage = fileBinary

            Catch ex As Exception
                Throw ex
            End Try
Here's my attempt at the retrieval, which isn't working:
                    Dim currentImage = F

'Unspecified error' doing sp_xml_preparedocument on XML element with a long attribute

In SQL Management Studio 2008 (connected to SQL 2005 database), I get this:The XML parse error 0x80004005 occurred on line number 2, near the XML text "<item value="&#xD;&#xA;libname...Msg 6602, Level 16, State 2, Procedure sp_xml_preparedocument, Line 1The error description is 'Unspecified error'.When I do this declare @doc nvarchar(max), @idoc int set @doc = '<item value="&#xD;&#xA;libname..." />' EXEC sp_xml_preparedocument @idoc OUTPUT, @doc when the value of the @value attribute is actually a string of somewhat over 830000 characters.If I truncate the string somewhat, the statements execute successfully.Anyone know how to fix this?  (and "use shorter attributes" is not an acceptable answer :-)I would use XQuery except that I can't figure out how to get the equivalent of @mp:id and @mpparentid to give me the hierarchical structure information I need.  If anyone knows how to do that, I'd appreciate a hand there too!  

Validation(): Attribute 'Factory' is not a valid attribute of element 'ServiceHost'

Hi, I'm using REST WCF3.5. In my .svc file, the Factory attribute is giving me Warning in the Visual Studio Team Suite saying "Validation(): Attribute 'Factory' is not a valid attribute of element 'ServiceHost'." <%@ ServiceHost Language="C#" Debug="true" Service="RestService" CodeBehind="~/App_Code/RestService.cs" Factory="AppServiceHostFactory" %> using System; using System.ServiceModel; using System.ServiceModel.Activation; using Microsoft.ServiceModel.Web; class AppServiceHostFactory : ServiceHostFactory {  protected override ServiceHost CreateServiceHost(Type serviceType, Uri[] baseAddresses)  {   WebServiceHost2 host = new WebServiceHost2(serviceType, true, baseAddresses);                 // Add the basic authenticator interceptor   host.Interceptors.Add(new BasicAuthenticationInterceptor(    System.Web.Security.Membership.Provider, "foo"));   return host;  } } I've added the reference as well & Everything works fine but I was wondering why am I getting this warning?? Thanks!  

A general validation attribute for checking uniqueness in a linq to sql data context

I've been programming asp.net for, oh, a couple of days now. Here's a question I can't even begin to figure out for myself. I hope it's obvious from the code what I want to accomplish, and I have, but it's not pretty. Furthermore I'd like to use it on whatever table, whatever field, i.e. check the uniqueness of a value against a table and field I specify, passing it all into the attribute constructor. public class UniqueEmailAttribute : ValidationAttribute{    public UniqueEmailAttribute()    {    }    public override Boolean IsValid(Object value)    {        //not pretty. todo: do away with this.        var db = new CoinDataContext();        int c = db.Emails.Count(e => e.Email1 == value.ToString());        return (Boolean) (c == 0);    }}

Retrieve attribute with property name

What is the best way to obtain an attribute such as the DisplayNameAttribute of a model's property using the property's name. I am using the following method currently:((System.ComponentModel.DisplayNameAttribute)typeof(MyApp.Models.ModelFoo).GetProperty("Foo").GetCustomAttributes(typeof(System.ComponentModel.DisplayNameAttribute), true)[0]).DisplayName Looking at this long statement, I cannot help wondering if there is a better way to do it.

New appliesTo attribute on assemblyBinding element in web.config after upgrading website for Visual


We just upgraded from Visual Studio 2008 to Visual Studio 2010. We had to convert our projects and solutions, but we thought no changes were need for regular ASP.net websites. However, Visual Studio 2010 modified the assemblyBinding element in the web.config file to include the appliesTo attribute. The website is still targeting .net 3.5 and will be for a little while until we upgrade everything to 4.0.

So, is this attribute necessary? If so, why? We had hoped we didn't need to update all our websites solely for the purpose of using Visual Studio 2010 as we have a lot of them. We'll take the effort to upgrade them when we finally change them to target .net 4.0. Until then, is the web.config change necessary?

Here is what we had in web.config before the upgrade to Visual Studio 2010:

    <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">

How do I retrieve a new row ID immediately upon insert with LINQ?


Hi everyone-

How can I retrieve the row ID immediately as I insert a new record with LINQ? 

I  need to refer back to it to update the row since it will be the only unique data in this particular table ( it's the primary key and the ID  number is auto generated)


Validation (ASP.Net): Attribute 'onchange' is not a valid attribute of element 'TextBox'.



I'm new to ASP.NET, C# and Visual Studio.  I do not have an IIS Server on my computer.  I do not have a registered version of Windows XP on my computer.  I got the above message after opening one of my .aspx files (someone else created it using an older version of ASP.Net) referring to the line below:


<asp:textbox id="txtOrderNumber" Runat="server" onchange="ClientOnChange();" ontextchanged="txtOrderNumber_TextChanged"></asp:textbox>

LINQ to XML: Exclude creating an element if NULL???


I'm creating my first xml file via linq to xml however I'm encountering an issue.  I need to be able to exclude a set of elements when a certain element is NULL.

My xml file contains info on customer orders.  If the customer entered their phone number info, then there are several xml elements that need to be filled in (phone number, number type, phone extension, etc).  If they left their phone number blank however, then the xml elements should be suppressed.

So the xml should either look like this:






Linq to xml get certain element value


Sorry for the long XML sample below. The XML sample below has two records and each record has three similar Nodes (<datafield tag="500" >) What  I want to accomplish is get the value of the second Node <datafield tag = “5000”>. The fallowing code I gets the value for all three nodes but I want something like get elementat(1). Appreciate your help.

I tried this but it didn’t worked MsgBox(xEle.Elements.ElementAt(1).Value)


         Dim xd As XDocument = XDocument.Load("C:\Users\stopete\Desktop\Marc_convertxml.xml")

        If xd IsNot Nothing Then

            Dim datafields = From datafield In xd.Descendants("datafield")

                             Where (datafield.Attribute("tag").Value = "500")

                             Select datafield

             For Each xEle In datafields


Using SPWebConfigModification to conditionally modify an element's attribute or add the element if



I have a question about using SPWebConfigModification along with FeatureReceiver to make a change to my SharePoint web application's web.config when my feature installs.  I have a scenario where there is an element in my web.config that may or may not exist.  If it exists, it has an attribute with a value, and possibly child elements, e.g.:

<myelement myattr="myvalue">

  <mychild />



If the element exists, I need to change the value "myvalue", otherwise I need to add the element itself.  "mychild" child elements may or may not exist.  When my feature is uninstalled, I need the web.config to revert back to exactly its original state (restore the original value of "myvalue" and preserve "mychild" elements, if they existed previously, or remove the whole element if they did not).

Is this possible using the SPWebConfigModifications within the FeatureReceiver framework?  If so, if someone could point me to a simple example, that would be perfect, as all of the examples I can find seem to be quite simple.



Playing with Linq grouping: GroupByMany?

One of its features is grouping. Many people understand grouping like it is defined in Sql. Linq is implementing grouping quite the same way. Let's discover this syntax and how to make consecutive groups easier.

LINQ : Implementing IN and NOT IN

I got tried of typing

var result = from s in source
where items.Contains(s)
select s;and so I implemented the IN and NOT IN methods as extension methods:

101 LINQ Samples Tutorials

101 LINQ Example with sample code snippets....This sample prints each element of an input integer array whose value is less than 5. The sample uses a query expression to create a new sequence of integers and then iterates over each element in the sequence, printing its value

Linq: how to share parameters between lambda expressions ?

When using Linq to objects, you will quickly feel the need to pass some parameters from a method to another but it's not so easy because each Linq method is not calling the following one. In a Linq sequence, each method is using the result computed by the previous one. So, local contexts are not visible from one method to another.
The compiler is using two technical different ways to let parameters go out of a method.

Linq to Sql CompiledQuery container

Ok now let's go. Here is just a little trick but with some interesting patterns that could be useful in some other contexts not connected to Linq to Sql.

When using Linq expressions, like with Linq to Sql, translating the expression into something else (sql for example) is taking time and resources. Sometimes it's negligible, sometimes not...

LINQ to SQL Paging using GridView in C# and ASP.NET 3.5

This tutorial will show you how we can extend the LINQ to SQL Class and create methods that will allow us to page data from a SQL database. C# version.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend