Get The Value Of An XML Element Using Linq Even When Empty?

May 13, 2010

I am using ASP.NET in VB.

I have an XML document which contains all the details of staff in my company...

<staff>
<staffName>Test Staff</staffName>
<staffTitle>Slave</staffTitle>
<staffDepartmentName>Finance</staffDepartmentName>
<staffOffice>London</staffOffice>
<staffEmail>t.staff@company.co.uk</staffEmail>
<staffPhone>0207 123 456</staffPhone>
<staffNotes>Working hours Mon to Thurs 9.15 - 5.15</staffNotes>
<staffBio></staffBio>
</staff>

As you can see, some nodes do not always contain data for ever member of staff; only Directors have biographies.

I access the values like this...

For Each staff In ( _
From matches In myXMLFile.Descendants("staff").Descendants("staffName") _
Where matches.Nodes(0).ToString.ToLower.Contains(LCase(search)) _
Order By matches.Value _
Select matches)......

Once it gets to staffBio I get an error saying "Object reference not set to an instance of an object." obviously because that node does not exist.

My question is how can I assign the value to a variable even when it is empty without having to do a conditional check before each assignment?

View 2 Replies


Similar Messages:

Insert Element With Empty String For Null Values

Jan 30, 2010

For coonverting Linq to DataTable I am using the following Extension Method(Taken from Stackoverflow)

L[code]....

The Extension Method creates XML file.But for null values no element is created in XML file.Say if Commission field is null then commission element is missing in Xml generation.

I want to insert element with empty string for null values (ref type) and (0.00) for decimals and (0) for integers. where do i need to make change?

View 1 Replies

ADO.NET :: Linq To Xml To Retrieve Element Value By Its Attribute?

Sep 9, 2010

how to select the mac element value. Here is my code that not working.

[Code]....

View 2 Replies

C# - Reading XML Using XDocument & Linq - Check If Element Is NULL?

Apr 7, 2010

I'm using LINQ together with XDocument to read a XML File. This is the code:XDocument xml = XDocument.Load(filename);

var q = from b in xml.Descendants("product")
select new
{

[code]...

View 3 Replies

ADO.NET :: SP From Linq Returns Empty Or Null Value

Feb 15, 2011

I have a class library which has my LINQ doc in it. I added a stored procedure and I get the following in my .dbml.layout :

[Code]....

I include a reference to the dll of the class library to my web project and I get an error about value being returned as int where I am trying to put contents into a datalist or similar.

Code in class that calls this SP :

[Code]....

So I switched code to the following in my dbml.layout document :

[Function(Name="dbo.sp_newsSearch")]public IEnumerable<news_search_result> sp_newsSearch([Parameter(DbType="VarChar(200)")] string searchVal){IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())), searchVal);return ((IEnumerable<news_search_result>)(result.ReturnValue));}

And included the following in an external file news_search_result.cs

[Code]....

But now I just get nothing returned. Is this wrong way of calling a SP via LINQ? or have I just put the wrong return type on my LINQ class?

View 2 Replies

Insert An Empty Record Using LINQ Query?

Apr 10, 2010

I have a LINQ query like this:

var query1 = from x in db.FaqCategories select new { x.CategoryId, x.Category };

What I would like to get is a query with an empty record

var empty = new {CategoryId="", Category=""};

on the very top of query1. I think this can be accomplished by using the union operator, just don't know how.

View 1 Replies

DataSource Controls :: While Adding LINQ To SQL Class - Empty Use Option

Feb 4, 2010

I am new to LINQ but not >net. I do understand SQLDataSource, etc. I was just told by a coworker not to use a LINQ to SQL Class for my new project (Bank.dbml). I was told to use instead the ADO.Net Entity Data Model (bank.edmx).

BankModel.edmxBank.dbml

When only using ADO.Net Entity Data Model I try to associate a GridView with a new LinqDataSource I get no options. When I add a LINQ to SQL Class I get the option to use it but it is empty. Is this because all my LINQ classes are mapped in the ADO.Net Entity Data Model (bank.edmx)? Can someone tell me (or point me to) what the differences are in these two?

View 4 Replies

ADO.NET :: Linq To Xml - Get The Element "question" From The XML

Dec 15, 2010

I have an XML file of the following kind:

<Root>
<question QuestionIndex="0">
<QuestionTitle>What is the meaning of life?</QuestionTitle>
<UserChoice>1</UserChoice>
<question QuestionIndex="1">
<QuestionTitle>How much is 1+1?</QuestionTitle>
<UserChoice>3</UserChoice>
</Root>

I want to get the element "question" from the XML, if given the "QuestionIndex" attribute. I tried the following code:

XElement q = (XElement)from question in doc.Descendants("Root")
where (int)question.Attribute("QuestionIndex") == index
select question;

but it throws InvalidCastException.

View 2 Replies

What Is Difference Between Web.config Assemblies Element And Project File Reference Element

Sep 29, 2010

I'm looking at an asp.net application, i notice that there are assemblies defined into two places. In web.config there is configuration/system.web/compilation/assemblies/add elements. In the project file there are references setup under the Project/ItemGroup/Reference elements.

I was wondering, what is the difference between assemblies/references added in either location?

View 1 Replies

Web Forms :: Retrieve Values From The Form Object Using The Id Element Instead Of The Name Element?

Feb 19, 2010

Is there a way to retrieve values from the form object using the id element instead of the name element?

View 3 Replies

How To Give Border Line To Single Td Element In The Table Tr Element

Jan 7, 2011

I have a table in ASP.Net like this.

[code]....

I want to give border line to first td element which contains the colspan and rowspan. Not to the entire row.

View 3 Replies

AJAX :: Element 'ToolkitScriptManager' Is Not A Known Element - For Network Drive Websites

Feb 2, 2011

I have noticed that when I create a website in a network drive and use the Ajax toolkit I get :

Element 'ToolkitScriptManager' is not a known element

I also noticed that after adding the ToolkitScriptManager it doesn't add the ID in the source code, it looks like this:

<asp:ToolkitScriptManager runat="server"></asp:ToolkisScriptManager>

Is missing the ID="ToolkitScriptManager1" part.

This doesn't happen when I create the site in my local drive. Is there a workaround to this. Even if I add the missing parts, I keep getting the same error.

View 5 Replies

JQuery :: Find Dom Element Starting From Found Element In Same TR

Dec 13, 2010

I would like to select an element that is in the same TR as another element I found with a selector. The selector itself: $("input[name='sMessageValue']","#messageTable") Now I have this element and got its value I would like to find a checkbox located in the same TR, i tried this as starting point : $(this).(':parent').val(). But seems not the right thing to do.

View 9 Replies

Why Doesn't The Rendered <div> Element Act Like A Normal Block Element

Aug 22, 2010

You're making a website with ASP.NET 4.0/C#, although xml alone is suitable for this example. The site will have a site map and a default page with a menu control, as follows:Web.sitemap

<?xml version="1.0" encoding="utf-8" ?>
<siteMap xmlns="http://schemas.microsoft.com/AspNet/SiteMap-File-1.0" >
<siteMapNode url="~/default.aspx" title="Home" description="">
<siteMapNode url="~/1.aspx" title="Link 1" description="" />
<siteMapNode url="~/2.aspx" title="Link 2" description="" />
<siteMapNode url="~/3.aspx" title="Link 3" description="" />
[code]...

View 1 Replies

Visual Studio :: Element 'content' Is Not A Known Element?

Nov 3, 2010

Element 'content' is not a known element. this can occur if there is a compilation error in the website, or the web.config file is missing.

<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
<asp:Content --- showed a green wavy line , and on hover displayed the above error.

Now I am having certain problems.

1. Visual Studio 2010 hangs when I try to use ToolBox.

2. Intellisense for asp.net controls is not working.

I have tried replacing web.config file (frm backup) , tried to debug - it doesnt show anything.

All other websites are working alright. Have problem with only one of the websites.

View 6 Replies

AJAX :: Element UpdatePanel Is Not A Known Element - VS 2010

Jan 25, 2011

I upgraded from VS 2008 to VS 2010 and now the AJAX elements are not recognised by the source code editor, e.g. UpdatePanel, ScriptManager, etc. I get warnings in VS and no intellisense for those elements. When I run the site, all the AJAX controls work OK though.

View 6 Replies

Using LINQ To Surround All "group" Elements With The New Element "groups" In C#?

Mar 1, 2011

I'm new to LINQ and C# but I have an xml file generated from a database table. Within the XML document is a element called "group", I would like to wrap all group elements with the element called "groups".

An extract of the XML document is:

[Code]....

View 2 Replies

Web Forms :: Element 'LengthValidator' Is Not A Known Element?

Aug 30, 2010

I got this errors while trying to use an example from the ASP.NET 3.5 Unleashed book.

Webform1.aspx

[Code]....

LengthValidator.cs

[Code]....

As from the book's note, I think I added this line correctly:

[Code]....

However, the compiler kept complaining that:

Warning 1 Element 'LengthValidator' is not a known element. This can occur if there is a compilation error in the Web site, or the web.config file is missing. C:Visual Studio 2010 ASP.NET ProjectsWebApplicationFourWebApplicationFourWebForm1.aspx 16 17 WebApplicationFour

View 7 Replies

Element 'Chart' Is Not A Known Element - DotnetCHARTING?

May 9, 2010

I am using dotnetCHARTING: the dll is installed in the GAC and referenced in my web.config (all versions appear to match). The project has a reference to the dll.

web.config:

<add assembly="dotnetCHARTING, Version=5.3.3540.17054, Culture=neutral, PublicKeyToken=af2cd47db69d93bd"/>

The site code compiles ok, but all aspx pages using the charting library complain that the Chart tag does not exist (warning that it might be a compile error). The aspx pages do not render the charts.

Each page has a reference to the assembly:

<%@ Register Assembly="dotnetCHARTING" Namespace="dotnetCHARTING" TagPrefix="dotnetCHARTING" %>

View 1 Replies

AJAX :: Element AsyncPostBackTrigger Is Not A Known Element

Jun 30, 2013

What does that means below warning:

Element 'AsyncPostBackTrigger' is not a known element. This can occur if there is a compilation error in the Web site, or the web.config file is missing.

My app is working properly but visual studio showing warning like that.

View 1 Replies

Web Forms :: Element UpdatePanel Is Not Known Element

Apr 4, 2013

Element 'ScriptManager' is not a known element. This can occur if there is a compilation error in the Web site. 

 Element 'UpdatePanel' is not a known element. This can occur if there is a compilation error in the Web site.

tried many thingschecked web config filereinstalled ajaxtoolkit

but nothing is working

getting error in the whole projectalong with this getting error for other asp,net controls also

Element 'TextBox' is not a known element. This can occur if there is a compilation error in the Web site.

View 1 Replies

Forms Data Controls :: Getting Text As Empty String When Gridview Cell Is Empty?

Feb 19, 2010

I have a gridview with two bound fields. On clicking a button i want to display the values in first row of gridview in two textboxes. But if gridview cell is empty i am getting the text in textbox to which the value of cell is given as -' 'i know my problem will be solved if i use the template fields instead. But i want a solution while maintaining the bound fields ,if any.

View 2 Replies

Empty Field In SQL Database, Using A Datalist Do Not Display The Empty Fields?

Jan 15, 2010

I have a sql database that on some field will have a empty string/field. I am using a Datalist to display my results. How do I not make the labels that are empty not display? Currently if the field is empty it will leave a space there which my goal is if the field is empty do not leave a white space instead move the other colunms up.

View 2 Replies

C# - Hide Empty Columns In A Gridview Without Knowing Which Will Be Empty?

Mar 4, 2011

I am working with a gridview that pulls data from a SQL database based on selections in dropdown lists. The source table has six columns for attributes of the selection, but depending on what is chosen, there could be anywhere from one to six of those that are empty (all null values). When the column is empty, I would like to have it hidden so the page is less clunky and confusing.

I've searched around for an answer for the past couple days, but what I have found so far is either related to hiding columns that you know are empty which I will not know or removing them in the SQL code which I think doesn't work if the column is called for in the gridview code and doesn't exist in the query.

View 3 Replies

Empty String - Check If Textbox Empty?

Sep 5, 2010

I have this code, how will I write the code so I can check if a textbox i empty? This way want work. Now it goes in if cellPhone != null all the time.

[Code]....

View 5 Replies







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