Xml - Can't Get XPath Query To Return The Right Nodeset?

Jun 2, 2011

I've got an xml file that looks like this:

<Records>
<Record>
<table>[code].....

What I need is to select all the ROW nodes, across all records, so I'm using something like this:

rowiterator = Me.XMLDocument.CreateNavigator.Evaluate("//table/Row")

which is working, but it returns a NodeIterator that only contains the first Row node in the first record!? As far as I can tell, that's the proper syntax for an xpath expression of "return all Row nodes with a parent table name anywhere in the document".

ADVERTISEMENT

Xpath Query On An XML Returns 0 Results

Nov 13, 2011

I've converted an html to XML and now i want to get all the child nodes nested
within a DIV element with a specific attribute (class="itemInfo").

Because the html that the XML is based on changes from time to time i want to use a more "safe" relative root,[code...]

Problem is that i always get 0 nodes ...I'm sure that something is wrong with my Xpath syntax, just don't know what it is. Here is my code'[code...]

View 7 Replies View Related

VS 2010 : Xpath Query On A XML Returns 0 Results?

Nov 13, 2011

I've converted an html to XML and now i want to get all the child nodes nested within a DIV element with a specific attribute (class="itemInfo").Because the html that the XML is based on changes from time to time i want to use a more "safe" relative root,
(something like : "//div[@class='itemInfo']").Problem is that i always get 0 nodes ...

Dim doc As New System.Xml.XmlDocument()
doc.Load("products.xml")
Dim root As System.Xml.XmlElement = doc.DocumentElement

[code]....

View 6 Replies View Related

[VB 2010] Return Alert Message If SQL Query Return No Records

Dec 12, 2011

I use this code to return records in a DataGridView:

[Code]....

View 3 Replies View Related

Access Database And Using A Parameter Query With The LIKE Operator To Return All Rows That Match Query?

Apr 28, 2010

I am connecting to an Access database and using a parameter query with the LIKE operator to return all rows that match query. The string to search for is taken from a Textbox

sql =

"Select * FROM Allview WHERE Info Like" &
"*" &
CStr(TextBox1.Text) &
"*"
The query does not return any data in vb, but when run from access with same string, there is data returned.The connection to the database is done correctly, as I am able to return data with various other queries.

Partial code :
Dim
con As
New OleDb.OleDbConnection[code]....

View 8 Replies View Related

Return Max Value With LINQ Query?

Nov 3, 2011

I have a method that takes in an id, a start date, and and end date as parameters. It will return rows of data each corresponding to the day of the week that fall between the date range. The rows are all doubles. After returning it into a DataTable, I need to be able to use LINQ in VB.NET to return the maximum value. How can I achieve this? Here is the initial setup?

[Code]...

View 1 Replies View Related

Sql - How To Use A Query That May Return Zero Records

Apr 8, 2012

I have a query that I am running and it will on occasion return zero records.

This is perfectly fine for me, but how do I handle this to avoid throwing an exception?

View 6 Replies View Related

DB/Reporting :: SQL Query Doesn't Return Right Value

Mar 2, 2011

it seems that this query doesnt read the begindate and only displays record with enddate.

Code:
str = ""
str = str & "Select sum(quantity) as totalpurchase from purchaseorder where itemcode='" & itmcode & "' and"
str = str & " category='Consumables' and company='" & company & "' and (datereceive >= '" & datebegin & "' and datereceive <= '" & dateend & "')"
str = str & " and (postatus='received' or postatus='oh-hand')"

i am using vb2010 and mysql community server.

View 3 Replies View Related

Query A Database And Return The Results?

Jul 22, 2011

I would like to create a vb form with a combo box (with song title), a text box (for song lyrics), and a button (to submit or refresh). It is linked with an access database. The combo box is populated with the songTitle field in the db (this part works fine). The text box is populated with the lyrics that go to that song The first updates fine but I can not figure out how to run a query to pass to the text box's text property. I want the user to be able to select a song from the combo box, click the button, and have the text box populated with the new song's lyrics.

Any suggestions on how to accomplish this, or a good place for a tutorial that explains the necessary elements for having vb query a database and return the results?

View 3 Replies View Related

Return A List From A Compiled Query?

May 8, 2009

I was speeding up my app by using compiled queries for queries which were getting hit over and over.I tried to implement it like this:

Function Select(ByVal fk_id As Integer) As List(SomeEntity)
Using db As New DataContext()
db.ObjectTrackingEnabled = False

[code].....

View 1 Replies View Related

Return Multiple Values From A Query .net?

Apr 10, 2012

how to store or return multiple queries result values into multiple variables.. I'm using a query that return 4 columns but how to.. individual store those results into 4 separate variables.. here is my code

Private Sub FrmAlumnos_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
txtCurrentUser.Text = Login.txtUser.Text
Dim strsql As String

[code]....

View 3 Replies View Related

Return The Count From Scalar Query?

Apr 1, 2009

When I type in cntrows. I get all my table variables except the one I want which is TotalComments. How do I return the Count from my scalar query? I have a Table Adapter named :

[Code]...

View 1 Replies View Related

SNMP Query Does Not Return Any Results

Jun 24, 2012

I have been trying to get the Alert Code from my printer at work to see what exactly is happening however each time I send an SNMP query it doesn't return any results. I am using SimpleSNMP references. The printer is a Canon iR-ADV C5045.

This is how I call the function:
Dim strAlertCode As String = SNMPQueryGet("1.3.6.1.2.1.43.18.1.1.7")
This is the function:
Private Function SNMPQueryGet(ByVal OID As String)
Dim strResult As String = "True"
Dim host As String = "192.168.1.202"
[Code] .....

View 1 Replies View Related

Why Can't Return A List From A Compiled Query

Mar 9, 2010

I was speeding up my app by using compiled queries for queries which were getting hit over and over.

I tried to implement it like this:

Function Select(ByVal fk_id As Integer) As List(SomeEntity)
Using db As New DataContext()
db.ObjectTrackingEnabled = False

[Code].....

View 1 Replies View Related

Handle Return Value Of Sql Query And Store In Database?

Aug 22, 2010

How to handle the return value of the sql query and store in the database?

View 1 Replies View Related

Query In An Application Is Return Date Of 1/1/0001?

Oct 27, 2010

I am building an application where a button click runs a sql query and shows a user the next available date that they can process from. The problem was that it needed to be the following Sunday and not the following day.That code looked like this:

Public Class Form1
Dim ReturnValue As Object = Nothing
Private Sub Button1_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim connectionString As String

[code]....

"select payrolldate from payroll where(payrolldate <= getdate())and payrollran <> 'yes'")but when I add that query it just returns a value of 1/1/0001 as the date.

View 39 Replies View Related

Return Result Of A TSQL Query In Program?

May 14, 2011

I have a VB.Net program that will basically make a query to a remote MS-SQL DB using TSQL, return two columns (normally 4 rows/records), 1 is a datetime and 1 is a double. I will then need to return the average of the doubles (which is easy in VB.NET).

As I will need to run this query perhaps 1000 times an hour (programmatically with different input parameters for the query), I am looking for the most efficient way to code this up so that it will take the shortest time to run. I tried SQLDataAdapter and then using dataAdapter.Fill and sometimes it returns an empty set although the raw select query has values returned.

View 2 Replies View Related

Return Type For Collection From LINQ Query?

Oct 15, 2010

I have a method, that returns a group of accounts

Public Shared Function GetAllNotesByUser(ByVal UserID As Guid) As Account (??)
Using db As New MyEntity
Dim query= (From A In db.Account _

[Code].....

I would then like to pass this to another function to calculate the totals for all the accounts in the collection. Is it best practice to return an Ienumerable, a generic list, I'm just not sure what works best with LINQ and the entity framework.

View 4 Replies View Related

Sql Query Doesn't Return Any Results On Datagrid

Jul 7, 2010

I'm using Visual Studio 2005, and I have a datagrid connected to a table from an Access database.

I added 4 textboxes so the user can type search filters to search within the table and a "search" button.

Then, I created a query using the "add query" tool on the datagrid. I wrote it like: select field1, field2, field3, field4, field5, field6 from table where field1=? and field2 like "%"+?+"%" and field3 like "%"+?+"%"
and field4 like "%"+?+"%"

Both field5 and field6 aren't search criterias, so I didn't add them to the query. Once the query was created, I replaced the parameters inside the procedure with my textbox1.text, textbox2.text, textbox3.text, textbox4.text and then cut and pasted the whole thing inside my SEARCH button click event, so the query is executed when the user clicks on the button.

Now the problem is: when I search using the first field it goes ok, but when I try to search by any of the other fields it returns zero results, even though I double-checked I had written the words correctly. I don't know why it does this. I already tried deleting the datagrid and creating it again.[code]...

View 6 Replies View Related

Using Access Cases To Return Query Into Datagridview

Feb 10, 2012

I have an access table and I want to write a query that has a case in it, but it gives me an error message when running the query Error "Syntax Error missing operator in query expression"

[Code]...

View 8 Replies View Related

Asp.net - Query/return Records With Dates Between Sunday And Saturday?

Mar 18, 2012

I need to add a gridview to my page where the sqldatasource is based on a query that returns records that fall between Sunday and Saturday of the current week. (Each record has one date field) The records are for payroll purposes and the payroll week runs from Sunday to Saturday. I need to find all records that fall in the current pay week.

View 2 Replies View Related

LDAP Query To Return All Users In A Specific Group?

Feb 24, 2010

how i can get a list of users who are members of a group in Active Directory. A vb.net example would be great. I can list all users in AD, but cannot get just the users in a group.

Also do anybody know of a really easy tutorial on LDAP queries with vb.net examples.

View 1 Replies View Related

MS Access Function To Return Conditional Column For Query?

May 21, 2009

I'm working on an access database  and there is a problem I can solve in a circumvented way but I was wondering if it can be done by using a function in query.The case: I have a main data table and 2 other tables joined to it.

maintable
country | city...... | postalcode [code].....

From one of the tables I select the respective zone for the postal codes in the main datatable, ie. if the row's postal code column contains 1000 (just an exmple) then the postal code is searched in the "zone" table "from" & "to" columns using "between", and it results in for example "zone1" (zone column). This is a clear thing, it works okay.However I need to select the respective rate column (based on the rows' weight column) from the rates table selecting the appropriate zone.

I can solve this by a switch statment (select country, city.... switch( zone="1", [1], zone="2", [2] etc.) but it gets very tedious when for example I have a rate table with 15 columns, you can imagine that.My question is if I could create a custom function which returned the respective column based on the result of the zone column.is there some way to get the function's return value to be translated in the select statement? for example select country, city....getzone("rates",[zone]) .....

I know that the rates table do not follow the relational database's main principle and it should look like fromkg | tokg | zone | rate and it would work like a charm with "where"but these tables are changed regularly and I receive them in excel...but maybe transforming the tables each time by unions would easily solve my problem doesnt it?I'm still interested if VBA custom function could be used for such a purpose.

View 3 Replies View Related

Vb 2010 Query Database And Return Values To Textboxes

Oct 14, 2011

how do i simply query the database and return values to my textboxes etc? all i can fiqure out is the default views but that is not what im after, also how to add data as well (lets say i have a text box with data and i wish to add it to the database)im sure its simple but i cant figure it out, in vba i just used the current sheets or tables but this is beyond me. i will admit it.

View 23 Replies View Related

VS 2008 Query SQL, Return Result To Multiple Textboxes

May 21, 2012

I am creating an application for a friend and have no issue inserting or updating the table, but I am having trouble relaying the information from the query back to the corresponding textbox when searching for an entry.

This is the closest thing I've got to a working model, but I'm still getting and "array out of index error".

[Code].....

View 3 Replies View Related

VS 2008 Return Dataset From Access Stored Query

Feb 7, 2010

I am trying to call a SELECT query (with parameters) in Access from VB.Net 2008. I am able to call queries without parameters using the code below. The problems are (1) how to apply the parameters to procName and (2) how to get a dataset returned. I have looked around the net for hours and have found some examples. However, they are all for ms access action (update, delete, etc) queries using ExecuteNonQuery which does not return a dataset.

[Code]...

View 1 Replies View Related

Query That Will Return All Of Column Names In A Microsoft Access Table?

Aug 17, 2010

I have a Microsoft Access database that I connect to with the Jet Database Engine, using VB.NET. I want to programmatically get all of the column names for a particular table [code]...

Is this possible in Access? If not, what are my options for getting the column names?

View 1 Replies View Related

T-SQL Query Return All Rows From TableA And Where Clause Based On TableB?

Sep 15, 2010

I've got two tables:

tClient:
ClientID    Name=============1           John2           Sally3           Joe4           Nick
tInvoice:
InvoiceID   ClientID    DateAdded==========================1           1           2010/09/012           1           2010/09/023           3           2010/09/01

I'm trying to write sproc where I need the following info:

[Code]...

View 6 Replies View Related

Using LINQ To Query XML And Return Empty String If No Data Is Present?

Mar 8, 2011

What I'm trying to do is to write a generic rss reader that I plug in any URL into without worry if the feed has all the common properties. For instance in my example below I'm looking for pubDate, however if no pubDate exists in the xml I'd like to return the current Date. I cannot seem to get the syntax right though.

Dim xmldoc As New XDocument
xmldoc = XDocument.Load(url)
Dim feeds = From feed In xmldoc.Descendants("item") Select New With { _

[code].....

View 2 Replies View Related

VB - User Substitutes Name On Query - Get The Data Set To Return Different Output Given A Variety Of Inputs

Nov 19, 2009

So, I run a select statement in SQL and then it has something like " where clientName = 'John Doe' " I can generate a datagrid or dataset off the SQL statement, but it will only be good fro one client...... I would like to be able to populate a dataset/grid using the select satement and then having something like a combo box of names the USER can choose. Then the user selects the name and the datagrid is populated with that clients info or w/e........

[Code]....

View 2 Replies View Related

VS 2008 - LINQ Query Against A Typed Datatable That Will Return Me Duplicated Data?

Jan 25, 2010

I'm trying to do a LINQ Query against a typed datatable that will return me duplicated data.With out going into too much detail, here's the basic setup:

strCode1 - string type
intCode1 - int32 type
intAdjustor - int32

There are more fields but these are the ones that are important.I'm going to do my best to describe this, as it's kind of confusing.In theory intCode1 is a key for strCode1 (hence the names). So each time intCode1 is duplicated, the same strCode1 should appear. Example:

[code]...

Ultimately I'd like to get a List(Of T) - where T is my typed data row. In SQL, I would simply use a sub query, to get a distinct list of strCode1 and intCode1, then do a count, grouped by strCode1 where I get more than one row.I'm not sure how to translate that into LINQ, AND get the original types data rows returned in a list.

View 7 Replies View Related

(VB 2008) Login System Using A Database And Query Builder To Return The Correct Values

May 10, 2011

I've created a log in system using a database and query builder to return the correct values, however, once the users signed in I need to bring up the rest of their data from the same table in the database. How'd be the best way of going about this? I'm not sure whether the log in should be changed to use the primary key as well.

View 2 Replies View Related

Return The Number Of Records Processed From An Sql Procedure Whether It Is A Select Or Update/insert Query?

Nov 25, 2009

how can i return the number of records processed from an sql procedure whether it is a select or update/insert query and how can i receive it in the calling method in vb .net.

View 4 Replies View Related

Date Filter Query - Fetch Only The Date Within The Current And Return How Many Rows

Jul 19, 2011

I'm trying the fetch only the date within the current and return how many rows Dim dc as new dataclassesdatacontext dim q=from p in dc.worktime where p.name.equals(session("name") and p.date ).count what I should I put after "p.date" ? And if I want to search for the record which there are record that are insert five days earlier, how to do that ? use (datetime.now - 5) ?

View 3 Replies View Related

Query Return Value - Getting An Error In Runtime That Is "Invalid Attempt To Call Read When Reader Is Closed" ?

Aug 31, 2009

I have an error that is during the query to a database ExecuteReader 'phase' of my program, i am assigning an .OleDbDataReader to a variable RetVal and then, i am giving this RetVal = Query.ExecuteReader, and then in the while the query is being read loop(While RetVal.Read) i am getting an error in runtime that is "Invalid attempt to call Read when reader is closed." I know this means i have to open the reader, but i don't know how to do this, as i have been using this process for a few weeks and haven't had this error pop up. (and i have managed to use the while loop)If you're not living on the edge, you're taking up too much room

View 7 Replies View Related

XML XPath Not Working

Oct 17, 2011

I have the following 2 lines of code:[code]I'm looking to get the value for first instance of lastWriteTime which should be 2011-10-13T10: 48: 48. 3833771-04:00 but the code just pops up an empty string. Sorry for the big post but here is the entire XML file for reference. Can anyone see why this isn't working, or give me an example of how to make it work some other way? [code]

View 2 Replies View Related

XElement And An XPath Expression ?

Feb 1, 2010

I have an XElement and an XPath expression that selects a node from it. It works fine in the original program that I wrote it in but doesnt work if I paste it to another program. I've checked the references and import statements.

I think the problem might be that the original program had the code within the class of a wpf window while it was moved to a abstract class where it doesnt work.[code...]

View 1 Replies View Related

.net - XPath, XPathNodeIterator To Be Exact?

Feb 7, 2012

Basically I have an XML file that looks like this:

<?xml version="1.0" encoding="UTF-8"?>
<data>
<sender sndid="FT">

[code].....

View 1 Replies View Related

Asp.net - Why Is This XPath Expression Getting Too Much Data

Nov 3, 2011

I have a XPath expression that is supposed to return/get only one node out of the XML document. But it is getting more than the one. I don't understand why.

Code-behind:

Dim xmlNameTbl As XmlNameTable = rootDoc.NameTable
Dim xmlNS As XmlNamespaceManager = New XmlNamespaceManager(xmlNameTbl)
xmlNS.AddNamespace("asp", "http://test.com/asp")

[code]....

View 1 Replies View Related

Reading A XML File - XPath?

Apr 24, 2009

There are multiple occurances of the PLUS_BORROWER data. For each occurence of PLUS_BORROWER, I want to save the CREDIT_SCORE and DAYTIME_PHONE_NBR when the Type= And SOCIAL_SECURITY_NBR are certain values. Then I want to execute a loop and extract the Credit_Score and Daytime_Phone_Nbrs.

<PLUS_BORROWER Type="Primary">        <SOCIAL_SECURITY_NBR>123459999</SOCIAL_SECURITY_NBR>        <CREDIT_SCORE ModelName="Emperica">793</CREDIT_SCORE> <DAYTIME_PHONE_NBR>4077889999</DAYTIME_PHONE_NBR>        <DAYTIME_PHONE_EXT>101</DAYTIME_PHONE_EXT></PLUS_BORROWER>

I have the following code that will pull off the first PLUS_BORROWER if the Type='Primary', but I am having trouble expanding it.

oExtraData.Load(myXMLFile)         'only select nod with type attribute equal primary        Dim oNode As Xml.XmlNode = oExtraData.SelectSingleNode("//PLUS_BORROWER[@Type='Primary']")        'get credit score node        Dim scoreNode As Xml.XmlNode = oNode.SelectSingleNode("CREDIT_SCORE")        MsgBox("I have the Primary")        MsgBox("Credit score is " & scoreNode.InnerText)

View 5 Replies View Related

Reading An XML File XPath

Apr 24, 2009

There are multiple occurances of the PLUS_BORROWER data. For each occurence of PLUS_BORROWER, I want to save the CREDIT_SCORE and DAYTIME_PHONE_NBR when the Type= And SOCIAL_SECURITY_NBR are certain values.Then I want to execute a loop and extract the Credit_Score and Daytime_Phone_Nbrs.[code]

View 3 Replies View Related

VS 2008 XPath Items In For Each?

Sep 13, 2009

I have successfully loaded my .xml file into a listview using the

vb.net
'// Create an instance of the XML
Dim XMLItem As New Xml.XmlDocument

[Code]....

This load the "name" of the city into the listview, but i also need to load the "code" into the next column in the listview

View 4 Replies View Related

XPath - How To Get Value Of Specific DIV From HTML

Oct 28, 2011

I'm trying to get the value of a specific <div> from an html. This div has a class attribute of "itemPrice6", but problem is that this class appears few more times for other <div>s in which i'm not interested in. Best thing for me is if I am able to access the needed <div> using something like XPATH so I can target only those I need.

My Code:
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim web As New HtmlAgilityPack.HtmlWeb
Dim doc As HtmlAgilityPack.HtmlDocument = web.Load("[URL]")
Dim prices As HtmlAgilityPack.HtmlNodeCollection =
[Code] .....

View 3 Replies View Related

Xpath With Xml String And Not Xml File

May 18, 2009

I am using the httplistener to grab xml off a POST.. so I dont have a file.. I just take the xml string and put to string.. but I tried to use this code..

[Code]...

View 5 Replies View Related

C# - Xpath Expression To Loop Through Xmldocument?

Feb 19, 2012

trying to parse this:

<?xml version="1.0" encoding="UTF-8"?>
<directoryresponse xmlns="https://www.sisow.nl/Sisow/REST" version="1.0.0">
<directory>[code]......

Here's my code:

XPath = "//directoryresponse/directory/issuer/issuerid"
Dim nodeList As XmlNodeList = XML.SelectNodes(XPath)

but nodelist.count=0...why?

View 3 Replies View Related

ADVERTISEMENT